Master Pandas for Data Analysis: Essential Skills You Need 🚀

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