Get table wikipedia

import requests
from bs4 import BeautifulSoup

URL = "https://en.wikipedia.org/wiki/List_of_current_heads_of_state_and_government"

res = requests.get(URL).text
soup = BeautifulSoup(res,'lxml')
for items in soup.find('table', class_='wikitable').find_all('tr')[1::1]:
    data = items.find_all(['th','td'])
    try:
        country = data[0].a.text
        title = data[1].a.text
        name = data[1].a.find_next_sibling().text
    except IndexError:pass
    print("{}|{}|{}".format(country,title,name))

Source: stackoverflow.com

Similar codes

1 vote181 views1 answer
Pandas pad method
Python
0 vote195 views1 answer
Convert excel file to csv with pandas
Python
0 vote203 views1 answer
Create dataframe pyspark
Python
0 vote202 views1 answer
Compress image pillow
Python
0 vote183 views1 answer
Loaves
Python
0 vote189 views4 answers
New line in jupyter notebook markdown
Python
0 vote201 views1 answer
Get os info in python
Python
1 vote192 views1 answer
Pandas read csv unamed:o
Python
0 vote187 views1 answer
Who is bayceee roblox id
Python
0 vote203 views2 answers
Print out python
Python