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

16 votes134 views1 answer
Python reimport py file
Python
24 votes122 views17 answers
Palindrome in python
Python
2 votes147 views1 answer
Django flush database
Python
0 vote145 views1 answer
Python string to list without split
Python
0 vote151 views1 answer
Python inline web server
Python
0 vote134 views1 answer
Merge namedtuple python
Python
3 votes136 views3 answers
List sort by key python
Python
7 votes146 views3 answers
Pandas replace nonetype with empty string
Python
1 vote135 views1 answer
Inverse list python
Python
0 vote141 views2 answers
Python how to extract a string from another string
Python