2020-05-01
阅读量:
1001
dataframe联合拼接，题目详情见正文
df表和df1表详情如下：
请将df和df1两个表合并成一个包含品名、销售额、单价的总表，效果如下：
参考代码：
d = {"品名":["A", "B", "C", "D", "E","F","G","H"],
"销售额":[900, "1000", np.nan, 730.60 ," 259.13",np.nan,502,"800"]}
df = pd.DataFrame(d)
df
dict1 = {"品名":["A", "B", "C", "D", "E","F","G","H"], "单价":np.random.randint(1,10,8)}
df1 = pd.DataFrame(dict1)
df1
pd.merge(df,df1)代码结果：
88.9195
1
3
关注作者
收藏
评论(0)
发表评论
暂无数据
推荐帖子
anranhui
2020-06-18
2条评论
PhilipLiang
2020-06-18
6条评论
PhilipLiang
2020-06-18
7条评论