質問編集履歴
1
ソースコードの追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -58,26 +58,30 @@
|
|
|
58
58
|
|
|
59
59
|
|
|
60
60
|
|
|
61
|
-
|
|
62
|
-
|
|
63
|
-
###
|
|
61
|
+
### 追記
|
|
64
62
|
|
|
65
63
|
|
|
66
64
|
|
|
67
|
-
|
|
65
|
+
```python
|
|
68
66
|
|
|
69
|
-
|
|
67
|
+
result_list = []
|
|
70
68
|
|
|
71
|
-
|
|
69
|
+
for index,row1 in df1.iterrows():
|
|
72
70
|
|
|
71
|
+
for index,row2 in df2.iterrows():
|
|
73
72
|
|
|
73
|
+
if row1["id"] == row2["id"] and row2["start_date"] <= row1["end_date"] and row2["end_date"] >= row1["start_date"]:
|
|
74
74
|
|
|
75
|
-
|
|
75
|
+
result_list.append(row1["id"])
|
|
76
76
|
|
|
77
|
-
|
|
77
|
+
result_list = list(set(result_list))
|
|
78
78
|
|
|
79
|
+
result_list
|
|
79
80
|
|
|
81
|
+
```
|
|
80
82
|
|
|
81
|
-
|
|
83
|
+
なんとか試行錯誤して、求める結果を得ることができました！！
|
|
82
84
|
|
|
83
|
-
|
|
85
|
+
しかし、効率が悪いような気がしてなりません…
|
|
86
|
+
|
|
87
|
+
アドバイス宜しくお願い致します！
|