pandas选择数据df[df["A"] == "a"]] 列A等于a的数据
筛选列A等于a的数据
import numpy as npimport pandas as pddf = pd.DataFrame(data=[{"A":"1", "B":"3", "C":"4"}, {"A":"1", "B":"2", "C":"5"}, {"A":"2", "B":"1", "C":"6"}])df = pd.DataFrame(data=[{"A":1, "B":3, "C":4}, {"A":1, "B":2, "C":5}, {"A":2, "B":1, "C":6}])
|
A |
B |
C |
| 0 |
1 |
3 |
4 |
| 1 |
1 |
2 |
5 |
| 2 |
2 |
1 |
6 |
## A列的值是a的全部数据df[df["A"] == 1]
## pandas取出包含某个值的所有行df = df[df["from_account"].str.contains("fcwhx")]## pandas取出不包含某个值的所有行df = df[~df["from_account"].str.contains("不要的文字1", "不要的文字2")]或df = df[df["from_account"].str.contains("fcwhx")==False]
## 如果有空值，报错：TypeError: bad operand type for unary ~: 'float' 则用这个方法df.other_group = df.other_group.fillna('####@')df2 = df[~df['other_group'].str.contains('####@')]
![选择数据 - df[df["A"] == "a"]] - 列A等于a的数据](/_next/image?url=https%3A%2F%2Fbookchips.com%2Fchips%2F6850eb130b9569655f1202d2%2F%E9%80%89%E6%8B%A9%E6%95%B0%E6%8D%AE-df%5Bdf%5B_A_%5D%3D%3D_a_%5D%5D-%E5%88%97A%E7%AD%89%E4%BA%8Ea%E7%9A%84%E6%95%B0%E6%8D%AE.png&w=3840&q=85)