3

I need to divide each column of the matrix df1 into a single column of the matrix df2. To get a matrix with dimension df1 (3*2).

I need a result: dataframe[[1/6, 2/7, 3/8], [3/6, 4/7, 5,8]] 

df1 = pd.DataFrame(data = [[1,2,3],[3,4,5]], index = ['a','b'], columns = ['i','ii','iii'])
df2 = pd.DataFrame(data = [[6],[7],[8]], index = ['a','b','c'], columns = ['i'])

df1.div(df2, axis = 'columns')
=> does not work

for i in range(0,2)
    a = df1[df1.columns[i]] / df2
=> summarizes the result in one column

Thanks for your help

KrDan Rod
  • 91
  • 6

3 Answers3

1

You can divide by Series converted to array by Series.values or Series.to_numpy for pandas 0.24+:

df = df1.div(df2['i'].values)
#pandas 0.24+
#df = df1.div(df2['i'].to_numpy())
print (df)
          i        ii    iii
a  0.166667  0.285714  0.375
b  0.500000  0.571429  0.625
jezrael
  • 822,522
  • 95
  • 1,334
  • 1,252
1

Here's one way:

pd.DataFrame(df1.values/ df2.values.T, columns=df1.columns)

       i        ii      iii
0  0.166667  0.285714  0.375
1  0.500000  0.571429  0.625
yatu
  • 86,083
  • 12
  • 84
  • 139
0

with Series : 

s = pd.Series(df2.values.flatten().tolist(), index=df1.columns)
print(df1.div(s))

output : 

          i        ii    iii
a  0.166667  0.285714  0.375
b  0.500000  0.571429  0.625
nassim
  • 1,547
  • 1
  • 14
  • 26