A high paced overview of many of the pandas core functionality. As one of the most popular libraries in all of programming, Pandas is an essential tool for learning data wrangling. Watch this video to get a good foundational understanding of what is possible.
Intro to Jupyter: youtu.be/5pf0_bpNbkw?si=iO0JhSeEpHc0btJF
Kaggle notebook made by a viewer! kaggle.com/code/lizhecheng/pandas-2-0-1-tutorial/notebook
Download the dataset here: kaggle.com/datasets/robikscube/flight-delay-dataset-20182022
Timeline:
00:00 Intro
00:57 Importing Pandas
01:26 Data I/O
01:51 Reading From Files
03:03 Writing to Files
03:36 DataFrame Basics
04:57 DataFrame Summary
06:12 Subsetting Columns
07:19 Select dtypes
07:34 Select as Series vs DataFrame
07:58 .loc and .iloc
09:37 .loc Filter Expressions
10:50 .query
11:31 Summary Statistics
12:10 .agg
12:53 Sumarizing Categoricals
13:43 rank, shift, cumsum
14:44 Rolling methods
15:21 Clip
15:41 Groupby
16:44 New Columns
17:33 Sorting
18:30 Missing Data
19:33 Combining Data
19:55 concat
21:01 Merge DataFrames
21:52 Merge Suffixes
22:34 Bonus
Check out my other videos:
Data Pipelines: Polars vs PySpark vs Pandas: youtube.com/watch?v=mi9f9zOaqM8&feature=shares
Polars for Data Science: youtube.com/watch?v=VHqn7ufiilE&feature=shares
Speed up Pandas Dataframes: youtube.com/watch?v=u4rsA5ZiTls&feature=shares
Avoid These Pandas Mistakes: youtube.com/watch?v=_gaAoJBMJ_Q&feature=shares
Links to my stuff:
* Youtube: youtube.com/@robmulla?sub_confirmation=1
* Discord: discord.gg/HZszek7DQc
* Twitch: twitch.tv/medallionstallion_
* Twitter: twitter.com/Rob_Mulla
* Kaggle: kaggle.com/robikscube
- Learning Pandas for Data Analysis Start Here. ( Download)
- LEARN PANDAS in about 10 minutes! A great python module for Data Science! ( Download)
- Pandas Dataframe Tutorial | Dataframe In Pandas | Python Pandas Tutorial | Python Basics|Simplilearn ( Download)
- Python Pandas Tutorial 2: Dataframe Basics ( Download)
- NumPy vs Pandas ( Download)
- Python Pandas Tutorial : Series and DataFrame Basics #2 ( Download)
- Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby) ( Download)
- Complete Python Pandas Data Science Tutorial! (2024 Updated Edition) ( Download)
- Nextmv ML/OR connectors: A price optimization example with Gurobipy, Gurobi ML, and Gurobipy Pandas ( Download)
- Polars: The Next Big Python Data Science Library... written in RUST ( Download)
- Merging DataFrames in Pandas | Python Pandas Tutorials ( Download)
- Python Pandas Tutorial (Part 2): DataFrame and Series Basics - Selecting Rows and Columns ( Download)
- Speed Up Your Pandas Dataframes ( Download)
- 🐼¿Qué es un DATAFRAME | Python PANDAS tutorial ESPAÑOL ( Download)
- Pandas Dataframes #4 - Data Aggregation and Column Manipulation ( Download)
