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: https://youtu.be/5pf0_bpNbkw?si=iO0JhSeEpHc0btJF
Kaggle notebook made by a viewer! https://www.kaggle.com/code/lizhecheng/pandas-2-0-1-tutorial/notebook
Download the dataset here: https://www.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: https://youtube.com/watch?v=mi9f9zOaqM8&feature=shares
Polars for Data Science: https://youtube.com/watch?v=VHqn7ufiilE&feature=shares
Speed up Pandas Dataframes: https://youtube.com/watch?v=u4rsA5ZiTls&feature=shares
Avoid These Pandas Mistakes: https://youtube.com/watch?v=_gaAoJBMJ_Q&feature=shares
Links to my stuff:
* Youtube: https://youtube.com/@robmulla?sub_confirmation=1
* Discord: https://discord.gg/HZszek7DQc
* Twitch: https://www.twitch.tv/medallionstallion_
* Twitter: https://twitter.com/Rob_Mulla
* Kaggle: https://www.kaggle.com/robikscube