sql 转化pandas 有奖励的哦 谢谢各位

SELECT * FROM bsr,xl WHERE bsr.asin=xl.asin and bsr.local_at=xl.local_at 用pandas 怎么写。

pandas 有merge函数
pd.merge(bsr, xl, how='inner', on=['asin', 'local_at'])

pandas有自带的方法可以做到的
mysql_cn= pymysql.connect(host='localhost', port=3306,user='root', passwd='', db='database')
tb_zhbs_orig = pd.read_sql('select * from table_name;', con=mysql_cn)

import pandas as pd
import pymysql
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='123456', db='xl')
sql = "SELECT * FROM bsr.xl WHERE bsr.asin=xl.asin and bsr.local_at=xl.local_at"
df = pd.read_sql(sql, conn)
print(df)