DataFrame カラムの名称が異なるが意味が同じデータを繋げる

pandas.merge(左側DF, 右側DF, left_on=”左側DFのカラム”,

right_on=”右側DFのカラム”, how=”結合方法”)

import pandas as pd

# 注文情報
order_df = pd.DataFrame([[1000, 2546, 103],
                         [1001, 4352, 101],
                         [1002, 342, 101]],
                         columns=["id", "item_id", "customer_id"])
# 顧客情報
customer_df = pd.DataFrame([[101, "Tanaka"],
                           [102, "Suzuki"],
                           [103, "Kato"]],
                           columns=["id", "name"])

# customer_dfを元に"name"をorder_dfに結合してorder_dfに代入してください
order_df = pd.merge(order_df,customer_df,left_on="customer_id",right_on="id",how="inner")

print(order_df)

import pandas as pd

# 注文情報

order_df = pd.DataFrame([[1000, 2546, 103],

[1001, 4352, 101],

[1002, 342, 101]],

columns=["id", "item_id", "customer_id"])

# 顧客情報

customer_df = pd.DataFrame([[101, "Tanaka"],

[102, "Suzuki"],

[103, "Kato"]],

columns=["id", "name"])

# customer_dfを元に"name"をorder_dfに結合してorder_dfに代入してください

order_df = pd.merge(order_df,customer_df,left_on="customer_id",right_on="id",how="inner")

print(order_df)

   id_x  item_id  customer_id  id_y    name
0  1000     2546          103   103    Kato
1  1001     4352          101   101  Tanaka
2  1002      342          101   101  Tanaka