Advanced Pandas & Real-World Projects | Full Course
Make your Python Data Science skills to the professional level in Part 2 of the Pandas Course!
Moving beyond the basics, this video dives into advanced techniques used by real-world Data Scientists. We cover complex data merging (Joins), advanced filtering, time-series manipulation, and even how to prepare data for Machine Learning with Scikit-Learn. Finally, we build a complete end-to-end project: crawling, cleaning, and visualizing data to create a stunning infographic.
What you will learn in Part 2:
-Advanced Merging: Inner/Outer Joins, Concatenation, and reshaping.
-Power Filtering: Using boolean operations and custom functions to clean data.
-Aggregation: Master groupby, pivoting, and stacking/unstacking.
-Visualization: Creating professional Histograms, Bar Plots, and Faceting.
Real-World Project: From crawling raw data to building a final Infographic.
Module 5: Combining Data
00:00:00 Concat With Rows
00:03:06 Concat With Cols
00:04:48 Inner Join
00:07:09 Outer Join
00:10:36 Left Join
00:13:22 Right Join
00:14:44 Join On Index
Module 6: Filtering & Cleaning
00:16:31 Filtering Columns
00:19:16 Boolean Arrays
00:20:18 Filtering Rows
00:21:21 Using Functions To Filter
00:25:30 Boolean Operations For Filtering
00:28:06 Dealing With Nan
Module 7: Aggregation & Reshaping
00:31:48 Basic Grouping
00:35:02 More Grouping
00:38:58 Pivoting
00:43:00 Stacking/Unstacking
Module 8: File I/O
00:45:48 CSV Reading And Writing
00:53:05 JSON
00:58:29 Pickle
00:59:58 Numpy
01:02:29 Excel
Module 9: Visualization
01:05:59 Basic Plotting
01:11:17 Histograms
01:17:18 Bar Plots
01:20:00 Line Plots
01:23:07 Faceting
Module 10: Advanced Topics
01:28:28 Date Manipulation
01:33:33 Window Functions
01:39:02 Plotting
01:40:38 Using Pandas With Scikit-Learn
01:46:16 Sample Regression
Module 11: Final Project
01:50:51 Crawling Data
01:58:13 Crawling Data - Part 2
02:03:43 Munging Data
02:07:24 Munging Data - Part 2
02:14:14 Plotting Data
02:23:22 Creating An Infographic
02:28:56 Creating An Infographic - Part 2
02:34:54 Final Conclusion
-Subscribe + Hit the Bell for weekly TECH tutorials that fast-track your IT career and help you land high-paying tech jobs!
-Drop a comment below about your current networking knowledge level - We read every single one!
Show your Love & Support:
/ alphabrains
☕️ Buy us a coffee! (https://www.buymeacoffee.com/alphabrains)
Would Help me make more content like this one :)
```
If you are involved in ANY form of online collaboration, then have I got the all-in-one solution for you! Try it here (it's completely free) - https://www.taskade.com/?via=taskade
🌟*Join Our Brainers Community! *
Are you passionate about learning, tech, and courses? Join us at Discord to dive into a vibrant community where enthusiasts like you come together to share knowledge, resources, and inspiration.
🚀*Telegram*: https://t.me/+pIXV6rmfKbU5YmRk
✨*WhatsApp Channel:* https://whatsapp.Com/channel/0029V51Y...
🔥*Discord Channel:* / discord
💎*YouTube Channel:* / @alphabrainscourses