|
各位大佬,我想merge两张表,结果出现报错:
TypeError: Can only merge Series or DataFrame objects, a <class 'str'> was passed
主要代码如下:
sql = "select zt_lang.value as Source_Name, zt_lang.key as Sources from zt_lang where zt_lang.section = 'sourceList'"
cursor.execute(sql)
result = cursor.fetchall()
Sourcelist=pd.DataFrame(result)
print(Sourcelist.dtypes)
sql = "select zt_story.id as ID, zt_story.title as Title, zt_story.source as Sources, zt_story.openedBy as Account from zt_story order by ID desc"
cursor.execute(sql)
result = cursor.fetchall()
Story=pd.DataFrame(result)
print(Story.dtypes)
Summary=pd.merge("Sourcelist","Story", on ="Sources",how="right")
两张表的部分内容:
Sourcelist:
| Source_Name | Sources | 0 | 训练中心 | xlzx | 1 | 车品-美容 | cpmr | 2 | 钣喷及事故件 | bpsgj | Story:
| ID | Title | Sources | 0 | 34728 | T-C:供应商全称修改 | qipeilong_1 | 1 | 34727 | C【到店记录】跨店搜索手机号码验证 | yanfa_shangye | 2 | 34726 | B-任务类型新增 | ptcp | 3 | 34725 | B-登录注册页UI改版 | ptcp |
由于是部分截图,Sources看起来没有对应,但是肯定是能对应上的。
求助,感谢!
|
|