pandas.query应该做,您可以看一下包
pandasql(与
sqldfR中的一样)
import pandas as pdimport pandasql as psdf = pd.Dataframe([[1234, 'Customer A', '123 Street', np.nan], [1234, 'Customer A', np.nan, '333 Street'], [1233, 'Customer B', '444 Street', '333 Street'], [1233, 'Customer B', '444 Street', '666 Street']], columns=['ID', 'Customer', 'Billing Address', 'Shipping Address'])q1 = """SELECt ID FROM df """print(ps.sqldf(q1, locals())) ID0 12341 12342 12333 1233
更新2020-07-10
pandasql
ps.sqldf("select * from df")
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)