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