Basic Guide to Pandas: Essential Tricks, Shortcuts, and Commands for Beginners

🛑 Quick Correction to DATA MANIPULATION 🛑 data["bmi"] = data["weight"]/(data["height"]**2) No need for a "for" loop! it's slower and wastes resources - while the above example is perfect! Hi everyone! Today we will talk about all the useful things we can do with Pandas! 🐼🐼🐼 Pandas is a Python library that's all about data structures and tables. In this video we will cover its important methods as well as all the tricks and shortcuts to get you to pro level within 20 minutes! 💪🤩 If you're curious about my IDE - I'm using Wayscript which is now available for the wide public! you no longer need an invitation, you can simply sign up with the following link: https://app.wayscript.com ⭐ Clone Complete Lesson Code: ⭐ https://app.wayscript.com/lairs/61300d18-58e7-4b8d-8889-74e22d70fe59/public ⭐ Wayscript X QuickStart Guide ⭐ https://wsxdocs.wayscript.com/quickstart ⏰ TIME STAMPS ⏰ ********************************** 00:00 - intro 00:24 - install and import Pandas 00:38 - create a Data Frame 02:00 - add column name 02:37 - add new columns 03:52 - select column in Data Frame 04:17 - select value in Data Frame 04:37 - select row in Data Frame 05:30 - manipulate data 07:30 - save Data Frame to csv file 07:58 - comma delimited vs tab delimited 08:49 - save Data Frame to text file 09:11 - load Data Frame from file 10:33 - load SQL database to Data Frame 11:57 - head and tail methods 12:53 - filter data entries 14:00 - replace data entries 14:48 - remove columns 16:20 - add new rows to Data Frame 18:00 - remove duplicates 20:33 - thanks for watching! ********************************** 💻 IMPORTANT VIDEOS 💻 ********************************** ⭐ Make SQLite Database of GTA games: https://youtu.be/Ohj-CqALrwk ⭐ Pandas Read HTML Web Scraping Method: https://youtu.be/oF-EMiPZQGA ⭐ Make graphs with Pandas: https://youtu.be/P4F3PzCMrtk 🙏 THANK YOU 🙏 ********************************** Thank you so much for watching! 😀 Thank you to Zapsplat for the "swoosh" sound effect: zapsplat.com Thank you to Flaticon for the thumbnail icon: www.flaticon.com