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