df1型
index id name 0 24 'Samy' 1 53 'Sara'
df2型
index id hobby 0 53 'reading' 1 53 'swimming' 2 24 'running'
index id hobby 0 24 'running' 1 53 'reading' 1 53 'swimming'
让我们来吧
df2.index=df2.id.map(dict(zip(df1.id,df1.index))) df2=df2.sort_index() df2 id hobby id 0 24 'running' 1 53 'reading' 1 53 'swimming'