Answers for "merge more than two dataframes based on column"

merge more than two dataframes based on column

df_2017.merge(df_2018, left_on = 'Textbook?', right_on = 'Textbook?', how = 'inner', suffixes = ('_2017', '_2018'))\
.merge(df_2019, left_on = 'Textbook?', right_on = 'Textbook?', how = 'inner')\
.merge(df_2020, left_on = 'Textbook?', right_on = 'Textbook?', how = 'inner', suffixes = ('_2019', '_2020'))\
.merge(df_2021, left_on = 'Textbook?', right_on = 'Textbook?', how = 'inner')\
.merge(df_2022, left_on = 'Textbook?', right_on = 'Textbook?', how = 'inner', suffixes = ('_2021', '_2022'))\