· intermediate
Data Analysis with pandas
Work with tables in Python. Selecting, filtering, transforming, grouping and joining, with the DataFrame idioms that replace the loops you would otherwise write.
Written in house, from the work rather than from a syllabus. Every example is one we would use ourselves, and every exercise is checked against the same engine that grades your answer.
What you’ll learn
- Explain what a Series and a DataFrame are
- Select columns and rows with loc and iloc deliberately
- Filter with boolean masks and combine conditions correctly
- Add and transform columns without mutating unexpectedly
- Group and aggregate with named outputs
- Merge DataFrames and check that the row count is what you expected
Before you start
- · Data Structures in Python, and Files, CSV and JSON
- · Familiarity with GROUP BY is helpful but not required