loc选取数据,实际上是对index标注true和false,把true的留下来 #-*- coding: utf-8 -*- import pandas as pd df1 = pd.read_excel('testdf.xlsx') print(df1) df2 = df1 print(df2) df3 = df1.loc [df1['kemu2']>80] print(df3) df4 = df1.loc [df2['kemu2']>80] print(df4) print(df2['kemu2']>80)
C:\python\python.exe D:/用户/chenwei917/Desktop/test.py
name kemu1 kemu2
0 zhangsna 23 78
1 lisi 45 98
2 dfe 67 77
3 gddg 45 56
4 grfd 3 89
5 gedg 56 76
name kemu1 kemu2
0 zhangsna 23 78
1 lisi 45 98
2 dfe 67 77
3 gddg 45 56
4 grfd 3 89
5 gedg 56 76
name kemu1 kemu2
1 lisi 45 98
4 grfd 3 89
name kemu1 kemu2
1 lisi 45 98
4 grfd 3 89
0 False
1 True
2 False
3 False
4 True
5 False
Name: kemu2, dtype: bool
Process finished with exit code 0