Python熊猫;使用pivot_table填充数据帧。-Pythonpandas;fillindataframewithpivot_table

I have a large python script, which makes two dataframes A and B, and at the end, I want to fill in dataframe A with the values of dataframe B, and keep the columns of dataframe A, but it is not going well.

我有一个大的python脚本，它使两个dataframes a和B，在最后，我想用dataframe B的值填充dataframe a，并保留dataframe a的列，但是它不太顺利。

Dataframe A is like this

Dataframe A就像这样。

A   B    C    D    
1   ab
2   bc
3   cd

Dataframe B:
A  BB  CC 
1  C   10
2  C   11 
3  D   12

My output must be:

我的输出必须:

new dataframe

新dataframe

A   B    C   D  
1   ab   10
2   bc   11
3   cd       12  

But my output is

但我的输出是

A   B    C   D  
1   ab   
2   bc   
3   cd        

Why is it not filling in the values of dataframe B? My command is

为什么不填充dataframe B的值?我的命令是

dfnew = dfB.pivot_table(index='A', columns='BB', values='CC').reindex(index=dfA.index, columns=dfA.columns).fillna(dfA)

1 个解决方案

dfA = pd.DataFrame({'A':[1,2,3], 'B':['ab','bc','cd'], 'C':[np.nan] * 3,'D':[np.nan] * 3})
print (dfA)
   A   B   C   D
0  1  ab NaN NaN
1  2  bc NaN NaN
2  3  cd NaN NaN

dfB = pd.DataFrame({'A':[1,2,3], 'BB':['C','C','D'], 'CC':[10,11,12]})
print (dfB)
   A BB  CC
0  1  C  10
1  2  C  11
2  3  D  12

df = dfB.pivot_table(index='A', columns='BB', values='CC')
print (df)
BB     C     D
A             
1   10.0   NaN
2   11.0   NaN
3    NaN  12.0

dfA = dfA.set_index('A').fillna(df).reset_index()
#dfA = dfA.set_index('A').combine_first(df).reset_index() 
print (dfA)
   A   B     C     D
0  1  ab  10.0   NaN
1  2  bc  11.0   NaN
2  3  cd   NaN  12.0