我正在使用 pandasql 從 df1 獲取資料。我可以將查詢的輸出分配給新列df2嗎？我試過(df2['grade']=ps.sqldf(sqlcode,locals()))了，但這沒有用，這是意料之中的，因為查詢輸出不是直接系列的。有沒有辦法做到這一點？先感謝您！
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
uj5u.com熱心網友回復：
無需分配新列，您可以通過稍微調整 sql 查詢直接獲得所需的輸出：
select df2.*, df1.grade -- Notice the change
from df2
left join df1 -- Notice the change
on (df2.score between df1.min and df1.max) and (df1.class = df2.class)
score class grade
0 15 english low
1 16 math medium
2 25 english high
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/474774.html