Pandas Functions: Apply vs. Map vs. Applymap

[@misraturp]

👉 All you need to know about Pandas in one place! Download my Pandas Cheat Sheet (free) misraturp.gumroad.com/l/pandascs

[@GregThatcher]

Thanks!

[@hoow_j]

The best explanation for novice!

[@misraturp]

Thank you!

[@ahmadsaeed9954]

good to see you after a long time

[@misraturp]

Haha yes, I took a big break :) Thank you.

[@KellenBegin]

thanks, your videos are very helpful for pandas/python/datascience

[@misraturp]

Great to hear, thank you Kellen!

[@AhmedMostafa-so2jp]

Is it possible for me to only use .apply( ) method because I think it can do pretty much everything?

[@LuffyD-lv1lr]

well explained thanks a lot even the paid resources i have didn't explain how the operations working behind the scene this is exactly what i needed

[@beloaded3736]

Miss Turp, you are really a marvel, your knowledge is so deep and you are excellent teacher. Thanks for knowledge you are sharing so selflessly 🌹

[@karrostrachan5321]

Very good tutorial of the map, apply and applymap functions

[@misraturp]

Thank you!

[@mhathunggeorge8082]

Simple yet very easy to understand...Thank you

[@misraturp]

You are welcome!

[@stanTrX]

Teşekkürler Mısra hanım

[@misraturp]

Rica ederim!

[@giri41]

Super .. more videos please

[@Kidpambi]

Definitly following this channel! this really helped with something im working at. Thanks

[@misraturp]

That's amazing to hear, welcome to the channel Alejandro!

[@areal935]

for the first exemple why using pd.Series.str.capitalize woldnt work??

[@srikanthamigo]

Great Turp! really nice. Could u make a series on numpy

[@kaifahmed316]

Keep it up 👍

[@misraturp]

Thanks!

[@shekharanalytics9337]

Great Explanation . Consider me your fan for really making this simple . May I have a question please ? I have two dataframes (df1,df2) . df1 has two columns key,overide_value. df2 has key,region,calculated_value. in order to replace values in df2['calculated_value'] with df1['overide_value'] ; if key of df2 has matching value in key of df1 ? I dont want to use joins though . As per my understanding through your vedio . I believe , in order to use map , i will have to convert df1 into dictionary . Is that viable ?

[@a.5214]

amazing as always

[@misraturp]

Thank you!

[@JoshMelodyMusic]

Nice class, your animation about topic are great

[@misraturp]

Thanks a lot

[@AbdelrahmanMohamed-ic7sl]

I love your codes

[@misraturp]

Awesome!

[@damienbates]

Thank you! I really appreciate your videos.

[@misraturp]

You're very welcome Damien!

[@muhammadsalar8905]

First like, first view and first comment 👍

[@misraturp]

Legend!

[@behradio]

Thanks, that's very helpful👍

[@misraturp]

Great to hear!

[@hemarun09]

When I key in the code- a.applymap(function, na_action='ignore') I am getting this error - 'Series' object has no attribute 'applymap'

[@bay-bicerdover]

correct

[@KitAjoc]

thanks for lessons! this is great

[@misraturp]

You're very welcome!

[@ingluissantana]

Thanks for the video!!!

[@misraturp]

You're very welcome :)

[@pubgdoremongamer8823]

love your videos and you are so beautiful teacher 😍😍

[@misraturp]

Thanks!

[@osoriomatucurane9511]

Awesome tutorial, the best by far on the matter. Mastering user defined functions is a great skill and it separates newbies from power users. I am aware that functions are always handy specially when you have a repetitive task where you could get he job done without hassles. I got the same result without apply(), just using data['Civil Service Title'].str.lower().str.capitalize(). Not sure if it always works. Could someone kindly explain me why and when is advised or recommended to opt for apply(), map(). I mean, is there any reason other than performance related where we should rely on apply ()and map() with in-built or user defined functions when applying a function or method to an object? Thank you in advance for the hint.

[@elastvd7503]

Thanks ❤

[@aleman12345]

thanks for this!

[@misraturp]

You're welcome!

[@Virtualexist]

apply: 3:00 applymap: 3:51 map: 5:40

[@misraturp]

Thank you!

[@Virtualexist]

@@misraturp Thanks to you ma'am for making to the point tutorials. ✨ 🤌

[@ابوعبدالآلهالحربي-ص2ذ]

U are butifule teatcher❤ thank you

[@sachin-b8c4m]

thank you

[@ammaralamin-z4l]

thanks

[@stansuen8072]

Thanks for a great video. If I want to create a new column by formula that takes in data from different rows, can we use apply? For example, I want to calculate the Rate of Change of stock price from say 5 days ago, how do I pass the value of the closing price of current row and of 5th previous rows? I know how to do it by looping / iterrows but just wonder if there is a faster way to do it by apply (or even vactor).

[@bay-bicerdover]

you can use apply

[@TGR_MAYANK]

Thnks for providing this... i m from india by the way, can u make some videos on machine learning it would be helpful

[@misraturp]

You're very welcome :)

[@TGR_MAYANK]

@@misraturp 🥰🥰

[@caiyu538]

Great

[@misraturp]

Thank you!

[@sumanlama6138]

When you used s.map({"cat":"kitten","dog":"puppy"}), it changed cat to kitten and dog to puppy but also changed rabbit to NAN is there a way to keep rabbit to rabbit without putting that in dictionary?

[@misraturp]

Not by using this option. You can achieve that by using conditional applys.

[@himanshupandey9902]

Thanks so much. when you deal with data as a beginner. These pandas fuctions seem little tricky. You made them easier to understand. I learnt pandas in practice by your pandas playlist. If you can, I request to make some new videos of complete Eda with data cleaning , and then into a model deployment. Thanks again.

[@misraturp]

You are very welcome Himanshu! And thank you for the suggestion, added to my ideas list!

[@Day_Dream_Believer788]

You’re probably going to say no, but will you Mary me?

[@zzye553]

Wow I admired your accent If you are not married please tell me I want my kids to speak fluent english like this! Anyways great job