38- Pandas DataFrames: How to Replace Values

Visit my personal web-page for the Python code:

[tankgirl]

Dude, you saved me a lot of time and strife! Thank you for that!

[guanyangzhang]

hi, could you tell me how to show the function's grammar in jupyter directly .

[SweetPeachannel]

how about to replace all data in all rows/ column?

[chrisber]

You are such a legend bro, finally I understand what I've been doing wrong this whole weekend. THANK YOU

[drizzle]

Great video. How can i set up my Jupyter so i can see function's documentation like you did?

[rizkikurniawan]

how to show the documentation of the method/function in jupyter?

[smallap]

Bro I love you! Thank you much I was struggling with this for an entire afternoon.

[arpanshrestha]

my_df=pd.DataFrame(Data=[4, 5, 6, 7], index=range(0, 4), columns=['A'])
print(pd.DataFrame(my_df))

TypeError: __init__() got an unexpected keyword argument 'Data'
it shows like this please help me sir

[BibleSamurai]

doesn't seem to work with str.replace

[ajaykushwaha-jemw]

dict = {'growth':['10%', '34%', '5%', '52%']}
z=pd.Series(dict)

How can we remove % from growth column ?

[mravshan]

how do I replace only one value from duplicates? i.e. dataframe has duplicates across the columns and I need to replace only one of the duplicates ?

[abhishekfnu]

How to replace a value using substring in pandas column?
For example:- If I have two values 'ECommerce Website Creation SAAS platform'
'ECommerce platform solutions' and I want to replace them with 'Ecommerce' but with using substring 'ECommerce'.

Could you please find the solution for this in pandas?

[pbeeby]

Thanks. Great video and clear explanation. How would you search through an entire frame and replace specific specific values?

[Eddyyc]

Hi, thanks for the video, I have been searching with a solution but no success,   so you showed how to replace values with a list:df['City'].replace(['Paris', 'London'], 'Mexico City') but how would do something like this:  previous argument but adding more list and a value to replace: df['City'].replace(['Paris', 'London'], 'Mexico City'), df['City'].replace(['Amsterdam', 'Tokyo'], looking to have both arguments in the same equation, how can I accomplish this?

[mohammedrashidakhtaransari]

Hello sir. I have a question. If I have a excel file in cell A1 = 12 25 11 26. And i have a text file which is also contain same value. How to use excel cell data into .replace('a1', 'new value from another excel cell data')

[yahyahamid]

how to replace all above 40 in Score2 and get the whole dataframe and then export to csv?

[studywithrobin]

Question for the data scientists out there--
How would I replace the characters "/\" with a string like "E:\IMAGES\ITEMS\product\"?

I tried this and it doesn't work, and I'm certain the "Image" column name is correct:
df['Image'] = df['Image'].replace("/\\",

[AkarshBalaji]

How do i replace all values in one column with a single value. Say, column ['timestamp'] has a bunch of values like 2019-03-20, etc. but i want to replace all of these with '1'?

[tintintintin]

Thank you so much.. it was really helpful (:

[moali]

How do you replace part of a string within a column