text_html_output_1.png
import pandas as pd

df_medal = pd.read_csv('../input/beijing-2022-olympics/medals.csv')
df_total_medals = pd.read_csv('../input/beijing-2022-olympics/medals_total.csv')
df_events = pd.read_csv('../input/beijing-2022-olympics/events.csv')
df_athletes = pd.read_csv('../input/beijing-2022-olympics/athletes.csv')
s_athletes = pd.read_excel('../input/2021-olympics-in-tokyo/Athletes.xlsx')

columns = ['Order', 'Country', 'Bronze', 'Silver', 'Gold', 'Total', 'Order by Total', 'Country Code', 'Discipline']
df_total_medals = df_total_medals.reindex(columns=columns)

for i in range(len(df_total_medals)):
    df_total_medals['Country'][i] = '#' + str(df_total_medals['Order'][i]) + ' ' + df_total_medals['Country'][i]