Basic Guide to Pandas! Tricks, Shortcuts, Must Know Commands! Python for Beginners

Python for-loops are very slow so you should avoid them whenever possible. Luckily pandas supports doing math directly on columns. So to add the BMI column you just need

data['bmi'] = data['height']/data['weight']**2

For example, for a dataframe with 300000 rows this is over 1000 times faster on my machine than the video's method.

This is the tutorial I was after for some time. Thanks a million. Fantastic presentation (as always)

ur amazing always , can u do any video on stock market data manipulation using pandas and numpy ?

Good vid !

Continue the good work. Your help is unique and inspiring :)

Hey Maria, amazing job! very nice video..just a feedback the audio is out of sync with your lip movements

Good video. Let's us know how pandas works, generally.

Your for loop really helped me with some things that I couldn't do with standard pandas calculations! Thanks! Great video!

"There you go", another great tutorial ! Thx!

How am I just discovering you?! This is glorious!

You're the best mentor of all time 🎉

Great video. Makes me appreciate R so much more.

Hi Mariya,
This video helped me with creating a budgeting app for an assignment in a programming course. Pandas was used in my app for outputting tables of expense data. Thank you for posting videos.
- Henry

Dataframe 1 / Table 1
MaterialID |Unit Selling Price |Unit Cost
A | 100 | 80
B | 200 | 140
C | 150 | 100
D | 250 | 230
E | 225 | 215



Dataframe 2 / Table 2
Month | Quantity Sold | Material ID
Jan | 10 | A
Feb | 5 | E
Mar | 25 | C
Jan | 5 | D
Feb | 15 | B
Mar | 2 | A
Which month highest total sale amount achieved
Which month highest profit amount observed



Change Quantity Sold from 5 to 7 programatically and find out revised
Which month highest total sale amount achieved
Which month highest profit amount observed

keyboard is so loud

If i try to read the db file made in sqlite3, pandas returns an empty dataframe, i dont know why and Im having issues troubleshooting it

what os is this? looks like a linux distro? cool setup anyway and cool video

Your content is amazing. I really enjoy your channel.

I don’t know why but these heavy massive typing are felt pretty satisfying ))) maybe it is something wrong with me😅😊

how would you match user input to data in the pandas dataframe to see if its match

Super well explained video

Four years in university passed we learned only variables, 4 years in 45 minutes ❤❤

Amazing tutorial as usual. Thanks again Mariya

Great tutorial!

u teach super good keep uploading data science videos in your plaYLIST I LOVE IT

I Made a app to store my recipes in pdf . But I cannot figure out how to make the recipe save in to a format that I want to create. Really appreciate ❤

Thia was really helpful. I just joined an advanced deep learning course. But I found out i was missing some background.

Mariya, have you looked into the Polars library for Python? It's supposed to be much faster than Pandas? It might be helpful to do a comparison video on Pandas vs Polars - strengths and weaknesses. What do you think?

for someone new to pandas, this is not a clearly logic tutorial like iloc, loc, loop each row, they just show up suddenly and without explanation

love u baby

Great! Thank you!

Thanks for the tutorial. What terminal program are you using? Looks handy.

awesome shirt haha

Thanx and highly appreciate ❤
Create more content about ML and DL

Thank you for your video, but the loud background drum typing is very very distracting. So much so that I can not focus on what you are explaining. If you will, please fix your audio or whatever must be done to remove this distraction. Thank you.

Excellent! Clear, efficient, simple and well explained and demonstrated.

2 minutes into the video I realize we think alike when problem solving. Look forward to exploring your content!

Love your videos. Well presented and clear. Thanks for taking the time to make this.

algorithm

Hello, when I save my file using "to.csv " the file still gets saved in excel. what could be the problem

Nice keyboard drums!

Pandas is the best money making library I’ve seen so far.

I love you so much, I like a lot you're humor and you're sarcasms jajajaj

my doubt is why they kept all these as a library why cant't like built in function means without installing these library we shoud use thse library

Keep it up! 👍❤️

I appreciate you tutorials , honestly to start programming it was when I randomly found your video and from then I have got certificates in data science with python.Thank you so much!!!I am requesting if you can help make a tutorial about Taipy

Great shirt!

Great video, Mariya. Keep up the great work!!

Can you explain if you need to save data to excel file?