Convert R Data Analysis Script to Python

I need an R script that performs data analysis converted to Python. The current R script uses the dplyr package and outputs results in CSV format.

Requirements:
- Convert dplyr functions to equivalent Python code, preferably using pandas
- Ensure the output is in CSV format
- Maintain the integrity and accuracy of the data analysis

Ideal Skills:
- Proficiency in R and Python
- Strong experience with data manipulation in pandas
- Familiarity with data analysis concepts and practices