Skip to content
Advertisement

How to divide two columns element-wise in a pandas dataframe

I have two columns in my pandas dataframe. I’d like to divide column A by column B, value by value, and show it as follows:

import pandas as pd

csv1 = pd.read_csv('auto$0$0.csv')
csv2 = pd.read_csv('auto$0$8.csv')

df1 = pd.DataFrame(csv1, columns=['Column A', 'Column B'])
df2 = pd.DataFrame(csv2, columns=['Column A', 'Column B'])

dfnew = pd.concat([df1, df2])

The columns:

Column A  Column B
12        2
14        7
16        8
20        5

And the expected result:

Result
6
2
2
4

How do I do this?

Advertisement

Answer

Just divide the columns:

In [158]:
df['Result'] = df['Column A']/df['Column B']
df

Out[158]:
   Column A  Column B  Result
0        12         2     6.0
1        14         7     2.0
2        16         8     2.0
3        20         5     4.0
User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement