内部結合の実装

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

Q1:「PRE」を Key として変数 df_1、df_2 を内部結合し変数 INNER に代入してください.

import numpy as np
import pandas as pd

dict_1 = {“PRE” : [“Tokyo”, “Osaka”, “Aichi”, “Fukuoka”, “Hokkaido”],
“PRE_CAPI” : [“Shinjuku”, “Osaka”, “Nagoya”, “Fukuoka”, “Sapporo”],
“POP_RANK” : [ 1, 3, 4, 9, 8]}
df_1 = pd.DataFrame(dict_1)

dict_2 = {“PRE” : [“Tokyo”, “Osaka”, “Aichi”, “Fukuoka”, “Hokkaido”],
“PRE_CAPI” : [“Shinjuku”, “Osaka”, “Nagoya”, “Fukuoka”, “Sapporo”],
“AREA_RANK” : [ 45, 46, 27, 29, 1]}
df_2 = pd.DataFrame(dict_2)

# Q1
INNER = ##########
print(INNER)

[Q1の選択肢]
1. pd.merge(df_1, df_2, on=”inner”, how=”PRE”)
2. pd.merge(df_1, df_2, on=”PRE”, how=”inner”)
3. pd.join(df_1, df_2, on=”inner”, how=”PRE”)
4. pd.join(df_1, df_2, on=”PRE”, how=”inner”)

Leave a comment

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