方法
df['列名'].isin([指定值])
csv内容
测试
import pandas as pd
if __name__=="__main__":
path = "./test.csv"
df = pd.read_csv(path, header=0, names=
["DEVICE_ID","LNG","LAT","TEN_GROUP","WEEKDAY","FLOW"])
df1=df[df['LAT'].isin([0])]
print("选取某列含有指定值的行:\n%s\n\n" % df1)
df2=df[~df['LAT'].isin([0])]
print("删除某列含有指定值的行:\n%s\n\n" % df2)
#运行结果
选取某列含有指定值的行:
DEVICE_ID LNG LAT TEN_GROUP WEEKDAY FLOW
14 4 124.0 0.0 0 1 20
删除某列含有指定值的行:
DEVICE_ID LNG LAT TEN_GROUP WEEKDAY FLOW
0 1 121.5 41.6 100 1 10
1 1 121.5 41.6 101 1 20
2 2 122.5 42.6 100 1 10
3 2 122.5 42.6 101 1 20
4 1 121.5 41.6 100 2 10
5 1 121.5 41.6 101 2 20
6 2 122.5 42.6 100 2 10
7 2 122.5 42.6 101 2 20
8 1 121.5 41.6 100 3 10
9 1 121.5 41.6 101 3 20
10 2 122.5 42.6 100 3 10
11 2 122.5 42.6 101 3 20
12 1 121.5 41.6 100 1 10
13 3 123.0 43.0 102 1 29