Pandas dataframe divide column depending on value of other column

user_2896120 0
Viewed 185

I have a DataFrame that looks like this:

Currency   AmountInUSD
FR         100
US         200
JP         1000

What I'd like to do is, whenever we have rows where "Currency" is equal to "JP", divide its AmountInUSD by 100. So the result should look like this:

Currency   AmountInUSD
FR         100
US         200
JP         10

How do I achieve this?

pandas dataframe python
2 Answers

If Currency is your index, you can use iloc to find the rows that you want to apply a transformation to :

import pandas as pd
df = pd.DataFrame({'AmountInUSD':[100,200,1000]}, index = ['FR','US', 'JP'])

df['AmountInUSD'].iloc[df.index == 'JP']/=100

else just select the rows where df.Currency == 'JP'

df = pd.DataFrame({'AmountInUSD':[100,200,1000], 'Currency': ['FR','US', 'JP']}, index = [1,2,3])
df['AmountInUSD'].loc[df.Currency == 'JP']/=100
print(df)
user_159482400

You could mask the Amounts corresponding to "JP" currency and replace:

df['AmountInUSD'] = df['AmountInUSD'].mask(df['Currency'].eq('JP'), df['AmountInUSD']/100)

Output:

  Currency  AmountInUSD
0       FR          100
1       US          200
2       JP           10
Admin1
Related