回答編集履歴
1
修正
answer
CHANGED
|
@@ -9,10 +9,10 @@
|
|
|
9
9
|
# 2つめのデータフレーム「住所」を作成
|
|
10
10
|
addres = pd.DataFrame({"unified_id":[1,2,3,4,5,6],"last_name":['suzuki','kojima', 'nakamura','huruta', 'sato','sasaki'],"addres":['saitama', 'oosaka', 'tokyo', 'kagawa', 'kobe', 'hokkaido']})
|
|
11
11
|
|
|
12
|
-
data_merge = pd.merge(name, addres, on='unified_id', how='inner')
|
|
12
|
+
data_merge = pd.merge(name, addres, on=['unified_id', 'last_name'], how='inner')
|
|
13
13
|
print(data_merge)
|
|
14
|
-
# unified_id
|
|
14
|
+
# unified_id last_name first_name addres
|
|
15
|
-
# 0 1
|
|
15
|
+
# 0 1 suzuki tarou saitama
|
|
16
|
-
# 1 3
|
|
16
|
+
# 1 3 nakamura hanako tokyo
|
|
17
|
-
# 2 5
|
|
17
|
+
# 2 5 sato yuuki kobe
|
|
18
18
|
```
|