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)
- Pandas for Absolute Beginners 2023 : Master the Basics of Data Analysis with Pandas ( Download)
- Pandas & Python for Data Analysis by Example – Full Course for Beginners ( Download)
- Learn how to use PANDAS in Python in 15 minutes - with 10 real examples ( Download)
- Python Pandas for Data Analysis: The Fundamentals ( Download)
- Data Analysis with Python - Full Course for Beginners (Numpy, Pandas, Matplotlib, Seaborn) ( Download)
- Learn Pandas For Data Analysis | Data Analysis With Hands-on Pandas Python | Simplilearn ( Download)
- Python 🐍 Vs. R 🏴☠️ ( Download)
- Mastering Pandas DataFrames for Data Analysis: A Complete Mini-Course ( Download)
- Exploratory Data Analysis in Pandas | Python Pandas Tutorials ( Download)
- Learn Python Pandas: 1-Hour Pandas Course for Beginners ( Download)
- Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby) ( Download)
- LEARN PANDAS in about 10 minutes! A great python module for Data Science! ( Download)
- Clean MESSY String Data in Pandas ( Download)
- Pandas for Data Science in 20 Minutes | Python Crash Course ( Download)
