Month 3 of 7 · 20–23 hours
Python for Data Analysis
Python is the most popular programming language for data work. This course starts from zero: variables, data structures, decisions and loops. Then you will write your own functions and move on to the two libraries analysts use most, NumPy and pandas, to load, clean and reshape real datasets.
Weeks
- Week 1Python BasicsRun Python code and understand variables and the basic data types.4–5 hours · 2 videosDone
- Week 2Data Structures, Conditional Statements and LoopsStore collections of data and process them automatically.5–6 hours · 4 videosDone
- Week 3Functions and NumPy BasicsPackage your code into reusable functions and calculate quickly on arrays.5 hours · 2 videosDone
- Week 4Pandas, DataFrames, Data Cleaning and Data ManipulationLoad a real dataset into pandas, clean it and answer questions with it.6–7 hours · 4 videosDone
- FinalClean and Analyze a Dataset in PythonGraded project with a rubric.
What you will be able to do
- Create variables and work with numbers, strings and booleans.
- Store data in lists and dictionaries and loop through it.
- Write if/elif/else statements and reusable functions.
- Do fast calculations on arrays with NumPy.
- Load a CSV into a pandas DataFrame, inspect it and select data.
- Clean and manipulate data: handle missing values, fix types, filter, sort, group and merge.
Before you start
Prerequisites: None. Comfort with Excel (Course 1) helps you picture what a DataFrame is.
Tools: Google Colab (free, runs in the browser with a Google account, nothing to install) is recommended. Alternatively install Anaconda, which includes Python, Jupyter Notebook, NumPy and pandas.
Schedule
| Week | Topics | Time |
|---|---|---|
| Week 1 | Python Basics | 4 to 5 hrs |
| Week 2 | Data Structures, Conditional Statements and Loops | 5 to 6 hrs |
| Week 3 | Functions and NumPy Basics | 5 hrs |
| Week 4 | Pandas, DataFrames, Data Cleaning and Data Manipulation | 6 to 7 hrs |
Each week includes learning objectives, plain-language lessons with examples, beginner videos, a practice activity, a self-check quiz with answers and a graded assignment.