如何将dataframe中的每一行乘以不同dataframe的不同列，并将所有行的总和作为Python中的新列？

import pandas as pd

df1 = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]})
df2 = pd.DataFrame({'D': [10, 11, 12], 'E': [13, 14, 15], 'F': [16, 17, 18]})

df1['New Column'] = df1.apply(lambda row: row['A'] * df2.loc[row.name, 'D'] + row['B'] * df2.loc[row.name, 'E'] + row['C'] * df2.loc[row.name, 'F'], axis=1)

print(df1)

import pandas as pd

df1 = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]})
df2 = pd.DataFrame({'D': [10, 11, 12], 'E': [13, 14, 15], 'F': [16, 17, 18]})

df1['New Column'] = df1.apply(lambda row: row['A'] * df2.loc[row.name, 'D'] + row['B'] * df2.loc[row.name, 'E'] + row['C'] * df2.loc[row.name, 'F'], axis=1)

print(df1)