python-pandas-数据分析-merge合并-rename重命名-concat拼接

import numpy as np
import pandas as pd

读取数据

df = pd.read_csv("./h5score_samples.csv")
df = df[['0-25','25-50','50-75','75-100']]
df

 重命名一列数据

df1 = df[['0-25']]
df1 = df1.rename(columns={'0-25':'userid'})

读取另一组数据，并取交集

df_ = pd.read_csv("./data15w.csv")
df1_ = pd.merge(df1, df_,on='userid', how='inner')
#df1_

拼接所有数据

df_res = pd.concat([df1_, df2_,df3_,df4_], keys=['0-25', '25-50','50-75','75-100'])
df_res