Modify column data based on other column in pandas

Question

Im new to python and pandas I have a csv with data which im able to read and extract data using pandas as shown below

data = pd.read_csv("train.csv")

I have many columns below is the columns in question

Here i want to convert the price column into USD equivalent for all the entries. following is the code which i tried

currencyToUSD = {
"USD": 1,
"AUD": 0.7,
"EUR": 1.12,
"HKD": 0.13,
"INR": 0.014,
"KRW": 0.00085
}
for row in data.itertuples():
   data[row.index]['price'] = row.price*currencyToUSD[row.currency]

It throws errors, what i want to achieve is to modify the 'price' column based on the value of 'currency' column. Guide me with the right way to achieve this

Thanks in advance

jezrael · Accepted Answer · 2019-06-24 05:43:06Z

1

Here itertuples should be omit for improve performance, use Series.map for new Series for multiple column price:

data['price'] = data.price*data.currency.map(currencyToUSD)

answered Jun 24, 2019 at 5:43

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Modify column data based on other column in pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related