Jupyter-html table

import pandas as pd

df = pd.read_html('https://en.wikipedia.org/wiki/All-time_Olympic_Games_medal_table')

print(df)

df[1]

 

import pandas as pd

df = pd.read_html('https://en.wikipedia.org/wiki/All-time_Olympic_Games_medal_table', header=0, index_col=0)

print(df)

df[1]

 

summer = df[1].iloc1:,:5]

summer

summer.colums = ['경기수', '금', '은', '동', '계']

summer.sort_values('금', ascending=False)

summer.to_excel('하계올림픽메달.xlsx')

 

df2 = df[df['B']>0.4]

df2