我正在使用pandasql从df1获取数据.
import pandasql as ps
df1=pd.DataFrame({"min":[10,10,21],
"max":[20, 20, 30],
"grade":['low', 'medium', "high"],
"class":['english', 'math', "english"]})
df2=pd.DataFrame({"score":([15, 16, 25]),
"class":['english', 'math', "english"]})
import pandasql as ps
sqlcode = '''
select
df1.grade
from df2
inner join df1
on df2.score between df1.min and df1.max and df1.class = df2.class
'''
newdf = ps.sqldf(sqlcode,locals())
newdf