Subtract specific values in dataframe

Question

I'm trying to extract objects from a dataframe via the .iloc function and convert those to int to perform some operations on them. Specifically, I want to subtract two values V3 = V1 - V2.

d = {'col1': [1, 2], 'col2': [3, 4]}
df = pd.DataFrame(data=d)

V1 = df.iloc[[0],[0]]
V2 = df.iloc[[1],[1]]

I've tried some solutions that convert the whole column but they don't seem to be working.

`df['col3'] = df['col1'] - df['col2']` ... is that what you are trying to do? — Alex, Jan 21 '18 at 15:54
Hey, no I can't subtract the whole column unfortunately. It has to be only those two specific values. ... — F.D, Jan 21 '18 at 15:56

score 0 · Accepted Answer · answered Jan 21 '18 at 16:02

0

I guess you are looking for

v3 = df.iloc[0, 0] - df.iloc[1, 1]

which will return -3.

answered Jan 21 '18 at 16:02

Cleb

25,102
20
116
151

Subtract specific values in dataframe

1 Answers1