Python Pandas Tutorial (Part 5): Updating Rows and Columns - Modifying Data Within DataFrames

[@coreyms]

Hey everyone! I hope everyone finds this video helpful. I wanted to make this video shorter, but I really wanted to highlight all the different ways we can update our rows and cover the apply, map, and applymap methods in as much detail as I could. In the next video, we'll be learning how to add and remove rows/columns. It will be much shorter. I should have that video out next week. I hope you all have a great weekend!

[@IslamIncredible]

Thank you, Corey, for all your Python videos. They really helps me a lot. You're definitely best python teacher on KZbin. Much appreciated. Greetings from Chechnya.

[@coreyms]

@wise guy I would like to, yes. It will take a while to put those videos together, but hopefully I can tackle that soon.

[@navidmohammadzadeh2141]

@@coreyms yessssss pleaseeeeeee we need these videos

[@GamerDra]

@@coreyms yes we really want ml course from u.

[@ajitesh764]

I think u should ask that in the community section, like which topic your subscribers would like to see videos on next, is it AI/ML/DL etc? Also I don't think a video of 40 min is a long video, as long as the video explains the necessary relevant topics in a single video. Love your videos, God bless you.

[@tanle7509]

At this time (beginning of 2023), your videos are still worth more than all paid courses I have studied on Udemy and Coursera (IBM courses included). Thank you for your work, it is much appreciated!

[@knowledgeseeker2452]

I am currently doing IBM's Data Analyst Specialization and have completed the first course. Is that specialization worth it?

[@RAJASEKARCMR]

Can confirm

[@jovanmampusti4025]

zero to mastery is trash. Corey Schafer's courses are much clearer and smoother. Kudos to this man.

[@ftronkoso]

Fully agreed! I have been searching training everywhere and have the same perception here. Thanks Corey!

[@khaled-dz8357]

I am planing to study IBM data analysis Course, do you think its does, worth its cost, have learnt from it. Do think Corey teach you more than this course.?!

[@alexanderkozhukhov4235]

I can't believe I am watching this for free. I admire people like you, Corey Schafer. Thanks a lot!

[@fahadshoaib8735]

updating column names 1:50 updating data in row 6:20 updating data in multiple rows 15:40 apply() with series 17:51 apply() with data frames 22:33 applymap() (used only with df) 28:11 map() (used only with series) 30:00 replace() 31:32

[@pinkymonika5619]

the goat

[@endangeredcreator5050]

Thanks mate !

[@shivamd23]

thanks bro 😊

[@pro_fessor.]

Most helpful comment

[@stressfreetrading1341]

Do press a like so that this comes first in the suggestion whenever anyone searches for Pandas. coz this is better than all other courses available.

[@contrevaloir]

These are, hands down, the most well explained tutorial videos on pandas, and programming, that I've seen, in or out of university. This guy is an amazing teacher. Thank you!

[@anthonyerdenetuguldur5609]

Thanks @Corey Schafer for putting this great Panda's Tutorials together. on 11:00, regarding .at indexer vs .loc, I found that the .at indexer is more optimal than .loc if you need to change a variable in a particular (single) index location. The .loc method enables change in multiple rows and columns (more versatile) hence a little slower than .at method.

[@saiakhil4751]

I've never seen a more organized and compact way of teaching. Kudos Corey, you are the king.

[@pawangulia0]

Your videos are pure gold, Mr Corey. This is a gift of knowledge to people all over the world. Thank,you sir!

[@abhinav9561]

She: Let's do it tonight Corey: Well, there's a couple of different ways that we could do this :-) Btw, Thanks Corey for your effort. These tutorials are gold :)

[@kapibara2440]

That was a stunner 😂

[@atienograce2520]

😂😂😂

[@jerrywang3225]

Your tutorial is invaluable. There is no better place to learn pandas on KZbin. Please keep updating your channel.

[@daviskipchirchir1357]

This is the end of 2023 and I am glad I found your videos. Our century really literally has information at our fingertips. We are just warping through information. Throughout history, such well-curated educational content has never been so easily accessible to anyone.

[@rauberhozenplotz7009]

Insane work! Nice flow of talking and explaining. You have got great talent in teaching.

[@SandeepChaudhary-vx9zy]

Great teacher is the one who known how to deliver content probably you are the one among many... thanks

[@expat2010]

Every single video you do is perfect. Pacing, structure, content.. everything.

[@patrickbarry4276]

These are the best Pandas tutorials on KZbin. It would be great to see a tutorial on vectorisation. Covering numpy functions, including np.where and np.select and explaining the time benefits. There are very few good resources for this.

[@shivakumarpendem7871]

Brilliant is seared into my brain after watching Matplotlib series and Pandas Series XD.

[@balabunat]

I am not new in pandas, but anyway, this videos are worth watching because your explanation is just wonderful

[@ravipandey7488]

Hi @coreyms, thank you for making these videos and that too for free. These videos are way better than the paid videos. You are a good tutor and good human.

[@Sureshezhumalai]

Great explanation about apply, applymap, map and replace method. As always great video. Thank you for your efforts.

[@abdulkadirguven1173]

I didn't even finish all series about pandas but i learnt already so interesting features in pandas. Thank you very much Corey.

[@GeoPoly55]

sir you're doing really great job.keep going sir.don't stop,soon i'll make some contribution through patreon to your channel. when i'll get my salary .because i love your teaching method. i'm currently learning from your @t you sir, thank you.god bless you.

[@coreyms]

Thanks!

[@vagelisilias]

Corey Schafer I have seen loads o videos on how to change a specific value in a specific row and no one really no one demonstrated how you can to do that only the columns head and index rows Thank you for that video really i was struggling to find how to change values inside the rows and not only the indexes. You are explained better than my university

[@kishansindhi5181]

from last 2-3 days i was finding how to change the multiple columns. and i was not able to find it but i find it in this video : )❣❣

[@aegystierone8505]

I really appreciate how you explain it in detail Corey, I will support you in any way I can!

[@oluwadamilaretijani1777]

Thank you so much Corey for this amazing series, the world is blessed to have you in the group of Pythonista. I really missed you on KZbin.

[@blushandrush9584]

hey corey, you're such an awesome teacher. I've been enjoying your pandas tutorials so far and have learnt so much. Thank you!!

[@adams_mathclass]

The way you simplify and explain complicated concept is simply magical. Thank you!

[@elnazdehkharghani6121]

Undoubtedly one of the best instructors. I eagerly wait for your new videos in the scope of data science.

[@shaanshah3270]

The Tutorials are great and they are set at a perfect pace

[@finncollins5696]

thanks so much. i started from the first video. now in the fifth video. thanks a lot. you are a good teacher. thanks. this is the best course ever.

[@arpitagec9]

Hey Corey!! Thanks for the amazing series on Pandas :) It's the best sequential and easy to follow series I have come across.

[@prashanttripathi7545]

Awesome Tutorial , Completed till 5th chapter , 6 more are left , which I believe will take 15 more days

[@fuzzywuzzy318]

I am your chinese audiant ,i feel your video is really helpful! i am now study at singapore management university !!!!business analytics major, so use python to do data analytics is really important ,and your video is focus on use python to deal data!

[@joachimhofmann5416]

Hi Corey! My English and my grammar ist not best but I do my very best. First of all I would like to say that I am very enthusiastic about your videos. I had a really really big Excel sheet to evaluate and wanted to clean up the data first. I used .loc as you recommended. ... that took over an hour. Then I tried the same with .at ... and the whole thing didn't even take a minute. So your assumption was correct that .at was the better method in this case for performance reasons.

[@yousefmedhat56]

I'm really learning much from this series, no word would suffice to express my appreciation

[@LearningIsHere]

11:00 if you used (.loc) with a new column name it will add this new column, but with (.at) it will throw an error

[@easydatascience2508]

You can watch mine too.

[@work-clementchan3319]

learns a lot from your videos, which you always point out the confusing parts in python

[@karthikudupa5475]

Thanks a lot Corey Difference between series method and Dataframe methods... nicely explained.

[@sundarpandey3147]

As always you are great explainer. I am following you from python. Now we are in pandas. I would be glad if machine learning videos will be next. That would be awesome. Thank you for your time to keep us making coder days in and out.

[@samanjafarii]

As i have understood while we pass df[filt]['last'] we are actually calling a dataframe not a series that which in this case is a dtaframe with just one row that is cuz we can't pass new value to it cuz if our filter had more than one result we didn't sepcify what row are we calling to pass value.Thank u so much for your vast knowledge which after 4years still your tutorials are worthy even so many updates has been released and so many things have been changed it is stiil useful.❤

[@CriticalThinker0890]

Man, your "Hi there, how is it going , everybody", is executed in less than half a second man, :-D, thanks for nice tutorials man

[@muntadher8087]

Thank you so much, I've been follwing along this playlist, this video got stretched more than how it should be. This is a feedback for your future videos. Thank you so much again!!

[@salimbo4577]

i don't know if i have thanked you before or not, if i did it means you saved multiple times and i thank you ones again

[@mr.b6101]

You are an angel more power to you for creating content in future and helping the community.

[@vishalprajapati1004]

Corey sir No words like better videos I don't believe have a free thank you so much for effort

[@pratikkawalgikar4839]

Simply superb Corey. Thanks a lot. You are a good teacher. Can you please upload a video on lambda functions and numpy series, it will be really great.

[@himanshuparmar8264]

YOU ARE MAKING THE LIVES OF MANY,SIMPLER. GREAT WORK MAN!

[@MoinulHossain-rw2ry]

Hopefully we can get more of these from you. Your videos are very detailed and intuitive, in my opinion. I can't help expressing my heartfelt gratitude to you for putting out these tutorials in such a comprehensible manner. You once said you plan on doing Pandas plotting tutorials sometime in the future. I do not know whether you actually will do it but I will be eagerly waiting for those too. Lots of respect and love from Bangladesh.

[@bharathbanala]

Hey Corey, Could you please make a small video on lambda for better understanding of it. Thanks.

[@AMA_RILDO]

Corey, all your subscribers are absolutely deserved 👍

[@anuragshukla7813]

Great work man...I really like the ways you are helping people to learn python

[@shashwatdev2371]

If someone is having doubt that they should watch these video or not I would suggest just see like to dislike ratio. 1.5K likes and 7 dislike. Such a good ratio is not anywhere else on youtube. Thanks Corey :).

[@MonaJalal]

you own the 5/5 in RateMyProfessor!! Thank you

[@ishanpand3y]

5th day, 5th lecture. Thank you, sir.🧡🤍💚

[@rohitvishwakarma2871]

Whenever he says 'you might be wondering' you know that your doubts are going to get solved.

[@juanmanuelhuete8909]

You are incredible. You explain very well and simple. Thank you a lot. From Argentina

[@saiyedali561]

ekdam badhiya batawa taaresh bhai , chal badhiya baa

[@vishakp89]

Learnt a lot of Python, thanks to you. You make it very straightforward and simple. Thanks!

[@nathaniellivingston4497]

Thank you. Ive been creating the craziest functions trying to get this to work. now im laughing at the simplicity. Again thank you

[@ayaqz3144]

please take your time in your explaining, I am learning from yours video so thankyou

[@arunrajan1979]

Thank you so much for these amazing videos corey. you are doing a wonderful job and may i know when will you finish this pandas series completely?

[@vilaspatil-r3q]

I really appreciate your effort for sharing some worth of knowledge.

[@burakcelik3752]

Thank you for your great effort. I've been watching your video for refreshing a long time no use situation and would like to say that accessing a single variable with df.at method is faster by around 50x than regular df.loc method. Similarly df.iloc method has a rapid counterpart called df.iat also.

[@zhenpan2048]

The videos are quite helpful and understandable. Thank you for your brilliant work.

[@corben3348]

Thank you so much for your tutorials Corey ! You are for sure a brilliant teacher ;)

[@emilyma6905]

1:57 change column names df.columns=['first_name', 'last_name', 'email'] 2:27 list comprehension df.columns = [x.upper() for x in df.columns] 4:49 change some names(not all) df.rename(columns={'first_name': 'first', 'last_name' : 'last', inplace= true}

[@cybersphere]

I took a course previously that included pandas, but it didn't include 90% of what you've included in this series. Thank-you.

[@zohebkhan2122]

No one teaches better than @Corey.

[@maddipatiin]

Super explained, it is easy to understand for DB developers. Thanks

[@lilitpetrosyan6029]

Just found you by accident and this is just amazing! Thank you very much for these videos!

[@KernelKudos]

Another great video = thanks for sharing these Corey .

[@mas7850]

Thanks for your generosity for sharing your skills with us. A truly comprehensive tutorial.

[@TheSardOz]

You are a great teacher, Corey! thank you, very much!

[@Al-Ahdal]

Sir, your videos are awesome. Great work indeed.

[@nimaabed6729]

Thank you so much Corey..i've learned a lot from your videos

[@yikee4500]

Thanks for the tutorial sir! I am totally grateful to have stumble across your videos, because it is a pretty daunting process to go through the documentation alone.

[@daviskipchirchir1357]

Brilliant work man. Just adding that the method df.at() is inherited from C++ vector container. This seems to be true because Numpy, the base class for Pandas, was written in C++ for speed purposes. So as Pandas is a layer on top of Numpy, which is a layer on top of C++ containers, then the method must have been transferred from the containers all the way up the stack to Pandas.

[@touhidislamTOUHID498]

Best video series on python. Thanks a lot.

[@GOLDDAR]

You are an awesome Instructor !

[@yadavchitra9832]

Thank you, Corey, This tutorial is very useful and cleared all my doubts,

[@ManzoorHussain-gz1vk]

Thank you so much, Sir. These lectures are gold.

[@sanjeevaus]

Hi Corey, Thanks for informative video, making python learning easy. I have one question, @20:14 while creating update_email method you used "return email.lower()" function without str. prefix and it went through while other places example @29:48 while doing applymap it was "df.applymap(str.lower)" So, my question is when does str. prefix becomes mandatory when using lower() function?

[@modernmistyk4341]

Keep them coming please! I love you Corey!

[@PerspectivePassport]

I am no Madara, but I declare this the srongest KZbin series on pandas! :)

[@gaberuth2500]

Straight to the point and super helpful. Thanks!

[@RalphAlberg]

Thank you for these videos - they really are excellent

[@YeekyYeeky]

great great great . thank you Corey Schafer very much

[@milenkamoschella2891]

I had many problems to learn how manipulate DataFrames. This tutorial explained very clearly a lot of things. I have a note: df.applymap(), when applying it triggers a Warning. FutureWarning: DataFrame.applymap has been deprecated. Use DataFrame.map instead. df.applymap(str.lower)

[@kameshinipillay4587]

Great video thank you, learning a lot from you!

[@the-ghost-in-the-machine1108]

Appreciate your work sir. Very clear.

[@golden_smiles]

Use .at when you need to quickly access or modify a single value in a DataFrame. Performance here is better for single value, it is optimized for that. Use .loc when you need to work with a range of data, whether it be multiple rows, columns, or both.

[@camilomartinezcampos9574]

You're goat bro'. Thanks from Colombia!!!!

[@shivanshsingh5555]

Your teaching is amazing. Thank You

[@GeolEnergiser]

Fantastic, thank you so much for your clarity

[@chukwuemekaeneh1136]

All I can say is God bless you.

[@tireldenamse5854]

Thanks so much for the series! That's great

[@dude789d]

Thank you Corey.,,,you are the best

[@shikharsaxena9989]

wowwww very useful lecture

[@АлексейЕрохин-м8ъ]

For reading Python's documentation press "Shift+Tab" at edit mode