I have a 2 dataframes as follow:
df1 = pd.DataFrame({'Barcode':[1,2,3,4],'Store':['s1','s2','s3','s4']})
df2 = pd.DataFrame({'Date':['2020-10-10','2020-10-09','2020-10-08','2020-10-07','2020-10-06']})
如何创建一个数据框,其中df1为行,df2为列,从而生成具有空值的单元格。像下面这样:
![enter image description here](https://istack.dev59.com/I14Yk.webp)
df4 = pd.DataFrame({'Barcode':[1,2,3,4],'Store':['s1','s2','s3','s4'],'2020-10-10':[1,2,5,np.nan],'2020-10-09':[np.nan,2,3,0],'2020-10-08':[0,0,2,3],'2020-10-07':[np.nan,1,np.nan,2]})
最终数据框应该如下所示:
非常感谢您的帮助。