本文介绍了如何在 Pandas DataFrame 中使用 inside/in 运算符?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想从我的 CSV 文件中选择数据.
I want to select data from my CSV file.
虽然我可以得到数据在哪一列
Though I can get a data in which column
"House" == 1 (any single number)
如下,我不知道如何获取数据
as following, I don't know how to get the data where
"House" in [1, 2, 3, 4, 6, 7, 8, 9, 10, 13, 17, 18, 20, 21, 23, 26, 28, 30, 34, 46, 57, 58, 61, 86, 89, 102, 121, 156].
df = pd.read_csv('../../data/training_dataset_500.csv')
df[df['House']==1]
推荐答案
使用 Series.isin()
方法来检查系列值是否在值列表中.在你的情况下 -
Use the Series.isin()
method to check if a series value is in a list of values. In your case -
df[df['House'].isin([1, 2, 3, 4, 6, 7, 8, 9, 10, 13, 17, 18, 20, 21, 23, 26, 28, 30, 34, 46, 57, 58, 61, 86, 89, 102, 121, 156])]
示例 -
In [77]: df
Out[77]:
A B
0 1 5
1 2 6
2 3 7
3 4 8
In [78]: df[df['A'].isin([1,2])]
Out[78]:
A B
0 1 5
1 2 6
这篇关于如何在 Pandas DataFrame 中使用 inside/in 运算符?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!