Advertisement
aaaranes

Data scraping sovereign states

Mar 26th, 2025 (edited)
317
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.65 KB | Source Code | 0 0
  1. from bs4 import BeautifulSoup
  2. import requests
  3. import pandas as pd
  4.  
  5. URL = requests.get('https://en.wikipedia.org/wiki/List_of_sovereign_states')
  6.  
  7. soup = BeautifulSoup(URL.content, "html.parser")
  8.  
  9. tables = soup.find_all("table", {"class":"wikitable"})
  10.  
  11. state_arr = []
  12. for table in tables:
  13.     states = table.find_all("tr")[1:]
  14.  
  15.     for state in states:
  16.         row_info = state.find_all("td")
  17.         name = row_info[0].getText(strip=True)
  18.         membership = row_info[1].get_text()[2:-1]
  19.         state_arr.append([name, membership])
  20.  
  21. df = pd.DataFrame(state_arr, columns=["Name","Membership"])
  22. df.to_csv("sovereign_states.csv", index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement