import pandas as pd link = "https://id.wikipedia.org/wiki/Demografi_Indonesia" df = pd.read_html(link, header=0)[2] df = df.rename(columns={'Populasi[4]':'Populasi', 'Luas (km²)[5]':'Luas'}) df = df[['Kode BPS', 'Nama', 'Ibu kota', 'Populasi', 'Luas', 'Pulau']] df.to_csv("Indonesia.csv", sep=',')
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter