CODEWITHSUNDEEP
pythonpandasdataframe
netbug
netbug

Reputation: 47

Dividing two columns in a dataframe based on condition

I have the below dataframe:

|module     | name  |value |
|-----------|-------|------|
|node[11]   | x     |4.0   |
|node[11]   | y     |1.0   |
|node[2]    | x     |2.0   |
|node[2]    | y     |3.0   |
|node[21]   | x     |6.0   |
|node[21]   | y     |6.0   |

and would like to create a new dataframe that contains the value (x/y) for each module. so the expected output would be

|module     | out   |
|-----------|-------|
|node[11]   | 4.0   |
|node[2]    | 0.66  |
|node[21]   | 1.0   |

Upvotes: 1

Views: 58

Answers (1)

BENY
BENY

Reputation: 323226

You can just do pivot then calculated what your need

out = df.pivot(*df).eval('x/y').to_frame('out').reset_index()
Out[23]: 
     module       out
0  node[11]  4.000000
1  node[21]  1.000000
2   node[2]  0.666667

Upvotes: 5

Related Questions