Overview
-
Test your pandas knowledge with this edition of Code Challenges.
Syllabus
-
Introduction
- Stretch and test your knowledge with pandas code challenges
- What you should know
- Read data from CSV and Excel files
- Check DataFrame information and identify types of columns
- The summary statistics of numerical and categorical features
- Add new columns to a DataFrame
- Select specific columns in a DataFrame
- Subset the data from labels using .loc[] method
- Subset the data from indexing using .iloc[] method
- Check for missing values
- Correct the data type of a column
- Parse dates in time series data
- Write conditional statements to filter rows
- Chain multiple conditionals to narrow down the search
- Using bitwise operators to filter rows
- Filtering to find target demography
- Apply the three-step process to group and aggregate data
- Group and aggregate multiple columns
- Apply a custom aggregate function
- Calculate stock returns for every year since 2003
