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

3 votes135 views1 answer
Python ftp upload file
Python
0 vote159 views1 answer
Pydrive list folders
Python
1 vote177 views2 answers
Python character list to string
Python
-1 vote145 views1 answer
Como agregar elementos a un array en python
Python
12 votes137 views1 answer
Python range for float
Python
0 vote147 views1 answer
How to add base map in pyqgis
Python
0 vote144 views1 answer
Chi square test contingency table python
Python
1 vote177 views1 answer
Access-Control-Allow-Origin django
Python Django
2 votes141 views2 answers
How to get dummies in a dataframe pandas
Python
0 vote123 views1 answer
Read api from django
Python