Pandas conditional calculation based on values in other column

Question

I need to calculate pct_change for Bitcoin (BTC) and Ether (ETH) prices from this data frame:

The formula I want to use is basically:

initial = df['Close'][0]
final = df.iloc[-1]['Close']

df['Performance'] = (100*(df[symbol] - initial)/initial)

The problem is, I can't figure out how to keep BTC and ETH calculations separate. How can I do this? I tried making two separate data frames, one for BTC and one for ETH and then using the formula, but I got this error:

A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead

What can I do instead?

try this `df2.groupby('level_1')['Close'].pct_change()` – Panda Kim Dec 23 '22 at 04:07 — Panda Kim, Dec 23 '22 at 04:07
and next time make example code or text not image – Panda Kim Dec 23 '22 at 04:08 — Panda Kim, Dec 23 '22 at 04:08

score 0 · Answer 1 · answered Dec 23 '22 at 04:07

0

Try with those lines. Read more about this.

import pandas as pd

pd.options.mode.chained_assignment = None  # default='warn'

answered Dec 23 '22 at 04:07

Nirodya Pussadeniya

31
5

Pandas conditional calculation based on values in other column

1 Answers1