
Explore filtering dataframes in Python by selecting specific rows and columns, using explicit and implicit indexing, reindexing, and boolean conditions to shape data.
Learn practical data cleaning and preparation techniques for analysis, including dropping missing values with thresholds, handling columns, and mapping categories with dictionary-based and lambda functions in a data frame.
Master group by, pivot, and melt operations to wrangle and reshape data, and apply joins and unions to prepare clean data for analysis.
Explore data analysis with Python by building and manipulating data frames, performing joins across tables, selecting columns, filtering by location, and applying group by to summarize by site type.
Learn to extract and convert date and time from strings using Python's datetime, use list comprehensions to parse dates, and compute time deltas for series with monthly or quarterly frequencies.
Explore time series construction, date ranges, and frequency adjustments, including shifting data, sampling by hours and minutes, and computing last-day and last-month statistics.
Learn to create simple charts from data, exploring plotting concepts, the time axis, and a dataset with an index and columns, including subplots and bar graphs for visualization.
Data Science 101: Python Pandas Bootcamp Data Analytics Course
This course is based on my classes taken in NYC for introducing basics of Data Analytics in Python using Pandas.
The course is not intended to make your expert in Python Analytics but rather introduce you to simple code and give you basic intro of all topics in Data Analytics in Python to launch you into a career in Data Science.
Topics:
Learn Python for Analytics: Pandas
Pandas Objects are Series, DataFrames and comparison with Excel VBA
Creating DataFrames from scratch using dictionary or list
Data Cleaning & Preparation for Analysis - Missing Values, Data imputation
Aggregation, Wrangling Rearranging and reshaping data : Join, Combine, Pivot, Melt and Reshape
Data Manipulating DataFrames with Pandas
Time Series Data - String to Datetime
Visualizations with Matplotlib
This course is build based on my classes taken in NYC, New York
This introductory course is designed for beginners interested in learning the foundations of Data Analytics using Python and the powerful Pandas library. Based on my in-person classes conducted in New York City, it emphasizes hands-on practice and real-world application. You’ll explore Python essentials for analytics, focusing on Pandas data structures like Series and DataFrames, with comparisons to Excel and VBA. Key topics include data cleaning, handling missing values, aggregation, reshaping datasets, and time series manipulation. You'll also learn visualization using Matplotlib. This bootcamp serves as a foundational step toward a career in data science—no prior experience needed.