How to Replace Values of Dataframes | Replace, Where, Mask, Update and More

While cleaning up outliers, filling in missing values, or just doing some data maintenance we need to update the values in our Pandas dataframe. Sometimes you select a subset of the original dataframe, and sometimes it needs to be pinpointed with an index value. So in this video, I show you every way I know how to replace and/or modify values in your pandas dataframes.

00:00 Introduction
00:29 "fillna"
01:46 "replace"
03:09 "loc" and "at"
07:25 "mask"
08:30 "cut"
09:35 "update"
10:32 apply, map and applymap
10:54 Grab your Pandas Cheat Sheet!

👋 Keep in touch?
==========================

Courses & resources
============================
📙 Fundamentals of Deep Learning in 25 pages

👩‍💻 Hands-on Data Science: Complete your first portfolio project

📥 Streamlit template

🤖 Deep Learning 101 with Python and Keras (FREE)

🏃‍♀️ Data Science Kick-starter mini-course (FREE)

🐼 Pandas cheat sheet (FREE)

📝 NNs hyperparameters cheat sheet (FREE)

[misraturp]

👉 All you need to know about Pandas in one place!
Download my Pandas Cheat Sheet (free)

[himanshupandey]

Hey, again. You really make things simpler, so that a laymen also can understand.

[message]

hands down your videos are the best ressources I found to these kind of topics
thanks a lot for making these videos✌🏻😁

[maxinechantel]

Hi Misra, thank you for your videos they are helping me to learn Pandas. You explain so simple and it is really encouraging.

[saheedoyewole]

Thanks a lot Misra, you're doing a wonderful job.

[lucifer-kqsc]

you're making my life easier with these tuts :')

[burakceylan.]

Crystal clear speak and to the point infos. Thank you

[ArnauViaM]

pandas cut seems extremely useful! Thanks

[birsenbas]

Hi Mısra, you're really have great explanations. I have learned a lot of and useful things even a few days. I am really excited to continue listening your videos aas a new data scientist candidate. Also you make me very motivated. Thanks a lot again!

[chastippett]

super helpful. have never seen the pd.cut function - Thank you

[mjacfardk]

Thank you
Pls video of pd.cut and filling/imputing missing values

[barisbulut]

selam, thanks for the info. i have a probem in changing characters within the cells. in my dataframe, some of values are for instance: 12.4 and some of them are 12, 4, meaning some are seperated with comma, and some are seperated with dot. how can i change all the dots with commas without changing the values. thanks

[muriloambrozio]

Could I use a list in the loc. Method?

[vrbaac]

Hi, Thank you for this video... it is very clear and easy to follow... I also want to ask... In case of a data frame having negative numbers, is it possible to replace these negative numbers by its corresponding absolute value, using the same routine in the video? thank you ^^

[durgav]

Hai Mam....Can you please come with the videos for SQL in data

[curtisjackson]

Hey MIsra, thanks for another simple to understand video. Can you possibly make a similar thread on pandas dataframe Join/Merge? That would be great help. Thanks again.
Cheers
🍻

[e.t.]

Hey Misra, can you make a video about deciding under which conditions we should use normalization or standardization?

[ruytvgv]

Hi Misra,
If we have a column where we are having a message which is returned from the device, so from this message how can we create a new column by taking keyword from the existing column and display the status of it in the new column by using python?

[sakhachowdhury]

Can we use any function to replace a data.like normally we replace a data with tha mean of that column.is there any other method instead of mean.

[SlimPit]

Hi, i have a question that i dont know. I need to change a specific value in a specific line in my Dataframe. Example in your Dataframe in Column "Job ID" in the line (1), i want to change the value 379094 to another value, how can i do this? I tried to loc but not worked. Can someone help please, thank you. Sorry for the english, im brazilian.