- +在此添加单个AI新笔记
pandas isin
![选择数据 - df[][] - df[选择指定列][筛选条件]](/_next/image?url=https%3A%2F%2Fbookchips.com%2Fchips%2F6850eb130b9569655f1202b8%2F%E9%80%89%E6%8B%A9%E6%95%B0%E6%8D%AE-df%5B%5D%5B%5D-df%5B%E9%80%89%E6%8B%A9%E6%8C%87%E5%AE%9A%E5%88%97%5D%5B%E7%AD%9B%E9%80%89%E6%9D%A1%E4%BB%B6%5D.png&w=3840&q=85)
作用：有筛选条件
筛选df
import numpy as npimport pandas as pd## roles = ['R1', 'R2', 'R3', 'R4'] # 要显示的列，可以自定义roles = list(df) # 要显示的列，list()此方法可以获得df的全部列data = df[roles][(df['R0'] == "目标字符" )& (df['R0'] != "不要的目标字符" )& (df['R1'] < 20)& (df['R2'] > 20)& (df['R3'] < 1000)& (df['R4'] > 4000)& (df['R5'].isnull()) # 空的& (df["R6"].isin (["2","1"])) # 在列表& (~ df["R7"].isin (["2","1"])) # 不在列表&(df["R8"].str.contains("包含")) # 包含]print (data)
## 注意，这里筛选之后，index是不变的，要改变index的话就要reset_index()
时间筛选
# hour = datetime.time(now.hour, now.minute, now.second, 0)hour = datetime.time(12, 60, 60, 0)role = list(df)df = df[role][(df['start_time'] < hour)& (df['end_time'] > hour)]