回答編集履歴
2
Update
answer
CHANGED
|
@@ -3,4 +3,13 @@
|
|
|
3
3
|
places = ("H-442", "A-721", "S-50", "E-001", "Q-009")
|
|
4
4
|
|
|
5
5
|
df_and = df[(df["【発生時刻(時)】"]>=1)&(df["【発生時刻(時)】"]<=3)&(df["【場所ID】"].isin(places))]
|
|
6
|
+
```
|
|
7
|
+
|
|
8
|
+
ちなみにですが、発生時刻の範囲を `between` を使って指定することができます。`both` というのは両端の値を含むという意味です(`1 <= hour <= 3`)。
|
|
9
|
+
|
|
10
|
+
```python
|
|
11
|
+
hour_range = (1, 3)
|
|
12
|
+
places = ("H-442", "A-721", "S-50", "E-001", "Q-009")
|
|
13
|
+
|
|
14
|
+
df_and = df[(df["【発生時刻(時)】"].between(*hour_range, 'both'))&(df["【場所ID】"] in places)]
|
|
6
15
|
```
|
1
Update
answer
CHANGED
|
@@ -1,6 +1,6 @@
|
|
|
1
|
-
`
|
|
1
|
+
`isin` を使うと良いかと思います
|
|
2
2
|
```
|
|
3
3
|
places = ("H-442", "A-721", "S-50", "E-001", "Q-009")
|
|
4
4
|
|
|
5
|
-
df_and = df[(df["【発生時刻(時)】"]>=1)&(df["【発生時刻(時)】"]<=3)&(df["【場所ID】"]
|
|
5
|
+
df_and = df[(df["【発生時刻(時)】"]>=1)&(df["【発生時刻(時)】"]<=3)&(df["【場所ID】"].isin(places))]
|
|
6
6
|
```
|