Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from bs4 import BeautifulSoup
- import requests
- import pandas as pd
- URL = requests.get('https://en.wikipedia.org/wiki/List_of_sovereign_states')
- soup = BeautifulSoup(URL.content, "html.parser")
- tables = soup.find_all("table", {"class":"wikitable"})
- state_arr = []
- for table in tables:
- states = table.find_all("tr")[1:]
- for state in states:
- row_info = state.find_all("td")
- name = row_info[0].getText(strip=True)
- membership = row_info[1].get_text()[2:-1]
- state_arr.append([name, membership])
- df = pd.DataFrame(state_arr, columns=["Name","Membership"])
- df.to_csv("sovereign_states.csv", index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement