Python for Data Analysis
Data manipulation, visualization, and analysis using Python, Pandas, NumPy, and Matplotlib.
Python Basics
(3 lessons)Python Basics Part 1
Introduction to Python: syntax, variables, data types, and basic operations.
Python Basics Part 2
Control flow, functions, lists, dictionaries, and file operations in Python.
Python Practice
Practice exercises covering Python fundamentals.
Pandas
(8 lessons)Pandas Introduction
Introduction to Pandas: DataFrames, Series, and basic data loading.
Pandas Filtering & Operations
Filtering rows, selecting columns, and performing operations on DataFrames.
Pandas GroupBy & Merge
Grouping data with groupby and combining DataFrames with merge/join.
Pandas Practice
Practice exercises for Pandas data manipulation.
NumPy & Statistics
NumPy arrays and basic statistical analysis with Python.
Data Cleaning
Handling missing values, duplicates, and data type conversions.
Data Cleaning Practice
Practice exercises for data cleaning techniques.
Pandas Full Pipeline Practice
End-to-end data processing pipeline practice with Pandas.
Assignment 5
(3 lessons)Charts + Visualization
(5 lessons)Matplotlib Introduction
Introduction to Matplotlib: creating basic plots and charts.
Seaborn & Chart Types
Advanced chart types with Seaborn: histograms, scatter plots, heatmaps.
Charts Practice Part 1
Practice creating various chart types with Matplotlib and Seaborn.
Charts Practice Part 2
Advanced visualization practice and chart customization.
Written Conclusions
Writing data-driven conclusions and interpreting visualization results.
Assignment 6
(3 lessons)SQL + Python
(3 lessons)Psycopg2: SQL + Python
Connecting Python to PostgreSQL using psycopg2 library.
Full Pipeline Practice
End-to-end pipeline: SQL query, data processing, and visualization.
Python Capstone Practice
Capstone practice combining all Python data analysis skills.
Final Project
(7 lessons)Final Project Introduction
Final project requirements, topic selection, and planning.
Final Project Work 1
First work session for the final project.
Final Project Work 2 & Dry Run
Second work session with dry run presentation practice.
Final Project Defense Part 1
Final project defense presentations: first group.
Final Project Defense Part 2
Final project defense presentations: second group.
Buffer & Retakes
Buffer session for retakes and additional defense slots.
Closing
Course wrap-up, feedback, and final remarks.