🛑 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: app.wayscript.com
⭐ Clone Complete Lesson Code: ⭐
app.wayscript.com/lairs/61300d18-58e7-4b8d-8889-74e22d70fe59/public
⭐ Wayscript X QuickStart Guide ⭐
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:
youtu.be/Ohj-CqALrwk
⭐ Pandas Read HTML Web Scraping Method:
youtu.be/oF-EMiPZQGA
⭐ Make graphs with Pandas:
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: flaticon.com
- Basic Guide to Pandas! Tricks, Shortcuts, Must Know Commands! Python for Beginners ( Download)
- 4 Pandas Functions That I Wish I Knew Earlier ( Download)
- Learn Python in Less than 10 Minutes for Beginners (Fast & Easy) ( Download)
- Learning Pandas for Data Analysis Start Here. ( Download)
- 25 Nooby Pandas Coding Mistakes You Should NEVER make. ( Download)
- Learn PANDAS in 5 minutes | Pandas Ultraquick Tutorial ( Download)
- Will Polars replace Pandas for Data Science ( Download)
- My top 25 pandas tricks ( Download)
- Complete Python Pandas Tutorial 2023 For Absolute Beginners: Learn Pandas for Data Analysis ( Download)
- Learn how to use PANDAS in Python in 15 minutes - with 10 real examples ( Download)
- Pandas Dataframe Tutorial | Dataframe In Pandas | Python Pandas Tutorial | Python Basics|Simplilearn ( Download)
- Getting Started With Pandas Sort Methods ( Download)
- Clean MESSY String Data in Pandas ( Download)
- Learn Python Pandas: 1-Hour Pandas Course for Beginners ( Download)
- NumPy vs Pandas ( Download)
