我需要将矩阵df1
的每一列分成一个矩阵df2
的单独列。以获得一个维度为df1
(3*2)的矩阵。
我需要一个结果: 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
感谢您的帮助。