異なる列を Key として結合

下記の設問に対する答えとして相応しものを選択肢から選び、次のコードの空欄(##########)を埋めてください.

Q1:以下の行列が得られるように、変数 df_room 、df_owner を結合してください.

####################
room_num tenant_num owner_name age
0 201 4 Yamakawa 38
1 301 3 Yamakawa 38
2 202 2 Akiyama 88
3 505 6 Mori 62
####################

import pandas as pd
df_room = pd.DataFrame([[201, 4, “Yamakawa”],
[202, 2, “Akiyama”],
[301, 3, “Yamakawa”],
[505, 6, “Mori”]],
columns=[“room_num”, “tenant_num”, “owner_name”])
df_owner = pd.DataFrame([[38, “Yamakawa”],
[22, “Nakamura”],
[62, “Mori”],
[88, “Akiyama”]],
columns=[“age”, “name”])
# Q1
df_client = ##########
print(df_client)

[Q1の選択肢]
1. pd.merge(df_room, df_orner, left_on=”name”, right_on=”owner_name”, how=”inner”)
2. pd.merge(df_room, df_orner, left_on=”owner_name”, right_on=”name”, how=”inner”)
3. pd.merge(df_room, df_orner, left_on=”name”, right_on=”owner_name”, how=”outer”)
4. pd.merge(df_room, df_orner, left_on=”owner_name”, right_on=”name”, how=”outer”)

Leave a comment

Your email address will not be published. Required fields are marked *