This repository contains exercises designed to help participants practice the basics of Python and Pandas. The exercises cover various data manipulation and analysis tasks, including importing data, inspecting data structures, filtering data, and more.
To get started, clone this repository and open it in GitHub Codespaces. When you first run it in Codespaces, the intent is to run the command python in the terminal to start a Python interactive shell, then copy and paste your written code into the shell.
The exercises are provided in the exercises.py file. Follow the instructions and complete each exercise step-by-step.
If you need help or want to check your work, you can refer to the wb_with_code.py file, which contains the solutions to the exercises.
- Import necessary libraries and load data from a CSV file into a Pandas DataFrame.
- Inspect the DataFrame to understand its structure and content.
- Filter data based on specific conditions.
- Select specific columns and rename them.
- Identify and handle missing data in the DataFrame.
- Translate a SQL query into Pandas code.
- Perform grouping and aggregation operations.
- Export data from a DataFrame to a CSV or Excel file.