One - One Code All

Blog Content

pandas根据列的值选取所有行isin

Python 统计学-科学计算   2010-12-28 22:27:05

df.isin(list)

# 选取等于某些值的行记录 用 == 
df.loc[df['column_name'] == some_value]

# 选取某列是否是某一类型的数值 用 isin
df.loc[df['column_name'].isin(some_values)]

# 多种条件的选取 用 &
df.loc[(df['column'] == some_value) & df['other_column'].isin(some_values)]

# 选取不等于某些值的行记录 用 !=
df.loc[df['column_name'] != some_value]

# isin返回一系列的数值,如果要选择不符合这个条件的数值使用~
df.loc[~df['column_name'].isin(some_values)]



上一篇:pandas中dataframe数据转为列表list
下一篇:python中pandas索引数据ix ,iloc ,loc 的区别

The minute you think of giving up, think of the reason why you held on so long.