Problem in updating a column value of a dataframe using python

Question

import pandas as pd
GDP=pd.read_csv('world_bank.csv')
for i in GDP.index:
    if GDP.iloc[i]['Data Source']=="Korea, Rep.":
        GDP.iloc[i]['Data Source']="South Korea"

I tried to run the above code. But it does not update the string. And does not show any error. The "ABW" data point is present in the dataframe. I also have given the link of the dataset. https://github.com/pran9957/world-bank-data.git

Alternatively this might answer your question? [Set value for particular cell in pandas DataFrame with iloc](https://stackoverflow.com/questions/31569384/set-value-for-particular-cell-in-pandas-dataframe-with-iloc) — Bernardo stearns reisen, Apr 12 '20 at 18:41

score 1 · Answer 1 · answered Apr 12 '20 at 18:56

1

Use Series.replace:

GDP['Data Source'].replace({
    'Korea, Rep.': 'South Korea'
}, inplace=True)

answered Apr 12 '20 at 18:56

Code Different

73,850
14
125
146

Problem in updating a column value of a dataframe using python

1 Answers1