1、pd.merge合并时后缀设置
pd.merge(left, right, how='inner', on=None, left_on=None, right_on=None,left_index=False, right_index=False, sort=True,suffixes=('_x', '_y'), copy=True, indicator=False)
https://blog.csdn.net/qq_38923076/article/details/83017310 (可参考此篇)
2、index重置
import pandas as pd
import numpy as np
df = pd.DataFrame(np.arange(20).reshape(5,4),index=[1,3,4,6,8])
print(df.reset_index(drop=True))
https://blog.csdn.net/qq_36523839/article/details/80640139