30-Day Python Learning Roadmap
A Structured Curriculum Tailored Specifically for Data Analysts
Objective: Transition from spreadsheet-based analysis to programmatic data analysis. This roadmap avoids
software-engineering heavy topics (like building web apps) and focuses purely on data extraction, manipulation,
aggregation, visualization, and basic statistical scripting.
Phase 1: Python Fundamentals & Data Structures (Days 1–7)
Week 1:
Foundations
of Scripting
Day 01 Environment Setup & Variables Setup working environment; verify
Install Anaconda, launch Jupyter Notebooks. Understand installation.
dynamic typing, integers, floats, strings, and standard
output (`print`).
Day 02 Basic Mathematics & Complex Strings Build an automated text cleaner
Arithmetic operators, string manipulation methods script.
(`.strip()`, `.split()`, `.replace()`), and f-strings for dynamic
formatting.
Day 03 Control Flow & Logic Write a logic gate script to tag
Conditional statements (`if`, `elif`, `else`), logical transaction risks.
operators (`and`, `or`, `not`), and comparison
parameters.
Day 04 Python Lists & Loops Calculate basic metrics from a raw list
Creating lists, indexing, slicing, appending, and iterating of metrics.
through sequences using `for` and `while` loops.
Day 05 Dictionaries & Sets Develop a unique visitor tracker from
Key-value pairs, tracking frequencies, using sets to a simulated log.
extract unique values, and converting lists to dictionaries.
Day 06 User-Defined Functions Encapsulate financial conversion
Defining functions using `def`, positional vs. keyword metrics into functions.
arguments, `return` values, and clean documentation
habits.
Day 07 List Comprehensions & Error Handling Build a resilient multi-file parser
simulation.
Python for Data Analysis in 30 Days Page 1 of 5
Writing concise element transformations and protecting
scripts with `try-except` blocks to handle missing/corrupt
data.
Phase 2: Numerical Computing & Pandas Foundations (Days 8–15)
Week 2:
Entering
the Data
Ecosystem
Day 08 NumPy Basics for Data Elements Convert flat lists to matrices and
Introduction to multi-dimensional arrays, vectorization, perform dot products.
performance benefits over vanilla lists, and simple slicing.
Day 09 Pandas Architecture: Series & DataFrames Load a real-world dataset and profile
Understanding indices, structured columns, importing its initial dimensions.
CSV/XLSX files, and inspecting attributes using `.head()`
and `.info()`.
Day 10 Data Selection & Filtering Filter an e-commerce dataset for high-
Mastering `.loc[]` and `.iloc[]` indexing, boolean masks, value orders.
filtering columns, and querying datasets matching multi-
criteria conditions.
Day 11 Handling Missing Values & Structural Outliers Clean a dataset with missing metrics
Identifying null values using `.isnull()`, executing strategies and incorrect data types.
like `.fillna()`, `.dropna()`, and casting standard data types
via `.astype()`.
Day 12 Computed Columns & Feature Engineering Calculate unit margins and classify
Creating new columns derived from mathematical regions programmatically.
formulas, utilizing element-wise transformations, and
applying custom lambda functions via `.apply()`.
Day 13 Data Aggregation & Summarization Generate a regional sales summary
Mastering the split-apply-combine strategy with showing totals and averages.
`.groupby()`, computing counts, sums, means, and
generating hierarchical reports.
Day 14 Advanced Grouping & Multi-Aggregations Produce a operational dashboard table
Using `.agg()` to request different statistical summaries for with min/max/std metrics.
different columns concurrently, flattening MultiIndex
columns.
Mid-Course Milestone Review
Python for Data Analysis in 30 Days Page 2 of 5
Day 15 Consolidate Week 1 & Week 2 concepts. Focus on Refactor code from days 9–14 into
debugging typical pandas alignment errors and optimizing clear structured blocks.
filter pipelines.
Phase 3: Data Transformation, Merging & Wrangling (Days 16–22)
Week 3:
Advanced
Wrangling
& Joining
Day 16 Merging Datasets (SQL-like Joins) Combine user transaction logs with
Executing inner, left, right, and outer joins using customer profile files.
`[Link]()`. Resolving key mismatch issues and suffix
handling.
Day 17 Concatenation & Appending Consolidate 12 separate monthly sales
Combining multiple structurally identical DataFrames reports into a year-to-date view.
vertically and horizontally using `[Link]()`, aligning
matching columns.
Day 18 Reshaping: Pivoting & Melting Unpivot a cross-tabulated survey
Transforming long format datasets to wide format tables report into tidy tabular format.
using `.pivot_table()`, and wide back to long via `.melt()`.
Day 19 Time Series Manipulation Basics Analyze user activity trends based on
Converting strings to datetimes using `pd.to_datetime()`, specific day-of-week parameters.
extracting elements (year, month, day, weekday), and
setting datetime indices.
Day 20 Resampling & Rolling Windows Compute a 7-day rolling average for
Aggregating time-based metrics via `.resample()` (e.g., website conversion traffic.
converting daily data to monthly averages) and tracking
rolling averages.
Day 21 Working with Text (String Accessors) Extract tracking identifiers from
Applying specialized string functions inside DataFrames via cluttered unstructured SKU fields.
the `.str` accessor, including patterns, extracts, and case
adjustments.
Day 22 Categorical & Memory Optimization Optimize a large file to reduce memory
Using pandas `category` data types for highly repetitive consumption footprint by >50%.
text columns to reduce system memory usage and
accelerate processing speeds.
Python for Data Analysis in 30 Days Page 3 of 5
Phase 4: Visualization, Exploration & Projects (Days 23–30)
Week 4:
Insights,
Visuals
&
Portfolio
Building
Day 23 Matplotlib Structural Architecture Generate a clean, publication-ready
Understanding figures, axes, canvas controls, basic charts dual-axis metric chart.
(line, bar, scatter), modifying titles, legends, and axis
markers.
Day 24 Statistical Visualizations with Seaborn Build a correlation heatmap to highlight
Generating complex plots smoothly (box plots, histograms, interacting key metrics.
density curves, heatmaps) to uncover distributions and
matrix correlations.
Day 25 Exploratory Data Analysis (EDA) Framework Complete a comprehensive EDA
Combining computational rules and visualizations to notebook on an industry dataset.
systematically unpack a brand-new dataset, locating trends
and descriptive statistics.
Day 26 Automating SQL Queries via Python Write a python wrapper script to pull
Connecting to relational relational databases using `sqlite3` down data directly from SQL.
or `SQLAlchemy`, passing queries directly into
`pd.read_sql_query()`.
Day 27 Exporting Multi-tab Structured Reports Automate a dynamic monthly report
Configuring `[Link]` engines to output cleanly distribution system script.
formatted datasets across multiple specific targeted tabs
with meaningful index names.
Day 28 Introduction to Basic Stats Functions Compute a predictive trend line over
Leveraging `[Link]` to execute basic statistical formulas. business historical targets.
Calculate linear regressions (y = mx + c) and interpret basic
correlation significance.
Days 29– Capstone Project Execution Complete End-to-End Pipeline Project.
30 Synthesize all phases: Import multi-source data, clean
missing entries, merge databases, perform aggregation
analytics, and export an executive dashboard.
Python for Data Analysis in 30 Days Page 4 of 5
💡 Capstone Design Recommendation:
Pick a domain dataset matching your industry focus (e.g., E-commerce, Finance, Healthcare, or SaaS). Build
a robust, modular `.py` script or detailed Jupyter Notebook that imports dirty source files and outputs a
perfectly tailored multi-tab Excel dashboard accompanied by automated analytical charts. Document this
project on a public profile (like GitHub) to serve as a portfolio asset!
Python for Data Analysis in 30 Days Page 5 of 5