回答編集履歴
2
Update
answer
CHANGED
|
@@ -2,6 +2,7 @@
|
|
|
2
2
|
|
|
3
3
|
```python
|
|
4
4
|
import pandas as pd
|
|
5
|
+
import numpy as np
|
|
5
6
|
from io import StringIO
|
|
6
7
|
|
|
7
8
|
pd.set_option('display.unicode.east_asian_width', True)
|
|
@@ -35,7 +36,9 @@
|
|
|
35
36
|
|
|
36
37
|
# 抽出
|
|
37
38
|
df1['データ'] = df1['時間'].apply(lambda t:
|
|
39
|
+
np.nan
|
|
38
|
-
df2[(t>=df2['開始時間'])&(t<df2['終了時間'])]
|
|
40
|
+
if (x:=df2[(t>=df2['開始時間'])&(t<df2['終了時間'])]).empty
|
|
41
|
+
else x['データ'].values[0])
|
|
39
42
|
|
|
40
43
|
print(df1)
|
|
41
44
|
|
1
Update
answer
CHANGED
|
@@ -28,7 +28,7 @@
|
|
|
28
28
|
2021/12/10 16:00:00,2021/12/10 17:00:00,q
|
|
29
29
|
2021/12/10 17:00:00,2021/12/10 18:00:00,r
|
|
30
30
|
2021/12/10 18:00:00,2021/12/10 19:00:00,s
|
|
31
|
-
'''
|
|
31
|
+
'''.strip()
|
|
32
32
|
|
|
33
33
|
df1 = pd.read_csv(StringIO(data1), parse_dates=[0])
|
|
34
34
|
df2 = pd.read_csv(StringIO(data2), parse_dates=[0, 1])
|