题解 | #合并用户信息表与用户活跃表#

import pandas as pd

# 设置pandas显示配置,以显示完整的数据框
pd.set_option("display.width", 300)
pd.set_option("display.max_rows", None)
pd.set_option("display.max_columns", None)

users = pd.read_csv("Nowcoder1.csv", sep=",")
user_active = pd.read_csv("Nowcoder2.csv", sep=",")

mergered_table = pd.merge(users, user_active, on="Nowcoder_ID", how="left")
print(mergered_table)