Intermediate18 hrsEnglish + हिन्दीComing soon
Python Data Analysis
Prerequisites: Foundations, Analysis & Visualization
- Go beyond Excel limits — clean, analyse and automate data with pandas.
- Modules
- 5
- Lessons
- 20
- Duration
- 18 hrs
This track’s lessons are still being written.
Module roadmap
Why Python when you already know ExcelSoon
Setup: Anaconda, Jupyter, VS Code, Google ColabSoon
Variables, lists, dicts, loops — the essentialsSoon
Python in Excel (=PY) — a first lookSoon
DataFrame and Series vs a worksheetSoon
Reading and writing Excel and CSV filesSoon
Selecting and filtering (loc, iloc, query)Soon
Sorting and calculated columnsSoon
Handling blanks and missing valuesSoon
Text cleaning: trim, split, replace, regexSoon
Dates, data types and duplicatesSoon
Combine 100 Excel files in secondsSoon
groupby — SUMIFS on steroidsSoon
pivot_table and crosstabSoon
merge and join — the XLOOKUP replacementSoon
Time series: resample, rolling, period comparisonsSoon
Formatted Excel reports with openpyxlSoon
Descriptive statistics and outliersSoon
Schedule your report to run automaticallySoon
Project: monthly sales analysis end-to-endSoon