回答編集履歴
3
追記
test
CHANGED
@@ -98,6 +98,24 @@
|
|
98
98
|
|
99
99
|
"""
|
100
100
|
|
101
|
+
|
102
|
+
|
103
|
+
ids = [100, 101, 102]
|
104
|
+
|
105
|
+
print(df[df["ids"].isin(ids)])
|
106
|
+
|
107
|
+
"""
|
108
|
+
|
109
|
+
user ids
|
110
|
+
|
111
|
+
0 Alice 100
|
112
|
+
|
113
|
+
1 Bob 101
|
114
|
+
|
115
|
+
2 Mike 102
|
116
|
+
|
117
|
+
"""
|
118
|
+
|
101
119
|
```
|
102
120
|
|
103
121
|
|
2
追記
test
CHANGED
@@ -82,6 +82,22 @@
|
|
82
82
|
|
83
83
|
"""
|
84
84
|
|
85
|
+
|
86
|
+
|
87
|
+
print(df.query("100 <= ids <= 102"))
|
88
|
+
|
89
|
+
"""
|
90
|
+
|
91
|
+
user ids
|
92
|
+
|
93
|
+
0 Alice 100
|
94
|
+
|
95
|
+
1 Bob 101
|
96
|
+
|
97
|
+
2 Mike 102
|
98
|
+
|
99
|
+
"""
|
100
|
+
|
85
101
|
```
|
86
102
|
|
87
103
|
|
1
追記
test
CHANGED
@@ -60,6 +60,32 @@
|
|
60
60
|
|
61
61
|
```
|
62
62
|
|
63
|
+
|
64
|
+
|
65
|
+
> IDインデックスが100 or 101 or 102であるものを抽出したいと思いこのコードを書いたのですが、何が間違っているのでしょうか?
|
66
|
+
|
67
|
+
|
68
|
+
|
69
|
+
```python
|
70
|
+
|
71
|
+
print(df.query("ids == 100 or ids == 101 or ids == 102"))
|
72
|
+
|
73
|
+
"""
|
74
|
+
|
75
|
+
user ids
|
76
|
+
|
77
|
+
0 Alice 100
|
78
|
+
|
79
|
+
1 Bob 101
|
80
|
+
|
81
|
+
2 Mike 102
|
82
|
+
|
83
|
+
"""
|
84
|
+
|
85
|
+
```
|
86
|
+
|
87
|
+
|
88
|
+
|
63
89
|
### 参考
|
64
90
|
|
65
91
|
[note.nkmk.me - pandas.DataFrameの行を条件で抽出するquery](https://note.nkmk.me/python-pandas-query/)
|