我想要使用对象(Object)
和区间(Interval)
类别(Category)
列来筛选一个 dataframe
。我想要根据多个条件进行筛选。如何在区间(Interval)
类别(Category)
数据下实现?
query
函数返回多个区间。
>>> my_df
vtype velocity_bin
0 car (-0.001, 5.0]
1 car (5.0, 10.0]
2 car (10.0, inf]
3 motorcycle (-0.001, 5.0]
4 motorcycle (5.0, 10.0]
>>> my_df.dtypes
vtype object
velocity_bin category
dtype: object
>>> my_df.query('vtype == "car" & velocity_bin == (5, 10)')
vtype velocity_bin
0 car (-0.001, 5.0]
1 car (5.0, 10.0]
我希望您能够输出以下内容:
vtype velocity_bin
1 car (5.0, 10.0]
query()
中调用astype()
,这是一个很好的技巧 :) - anky