import requests
from bs4 import BeautifulSoup
import pandas as pd
url = 'https://simple.wikipedia.org/wiki/List_of_U.S._states'
url_get = requests.get(url)
soup = BeautifulSoup(url_get.content, 'html.parser')
table = soup.find('div', id="mw-content-text")
table = table.find('table')
with open('table.html', 'w', encoding='utf-8') as f:
f.write(str(table))
states = pd.read_html('table.html', header=0)
states[0]
Abbreviation | State Name | Capital | Became a State | |
---|---|---|---|---|
0 | AL | Alabama | Montgomery | December 14, 1819 |
1 | AK | Alaska | Juneau | January 3, 1959 |
2 | AZ | Arizona | Phoenix | February 14, 1912 |
3 | AR | Arkansas | Little Rock | June 15, 1836 |
4 | CA | California | Sacramento | September 9, 1850 |
5 | CO | Colorado | Denver | August 1, 1876 |
6 | CT | Connecticut | Hartford | January 9, 1788 |
7 | DE | Delaware | Dover | December 7, 1787 |
8 | FL | Florida | Tallahassee | March 3, 1845 |
9 | GA | Georgia | Atlanta | January 2, 1788 |
10 | HI | Hawaii | Honolulu | August 21, 1959 |
11 | ID | Idaho | Boise | July 3, 1890 |
12 | IL | Illinois | Springfield | December 3, 1818 |
13 | IN | Indiana | Indianapolis | December 11, 1816 |
14 | IA | Iowa | Des Moines | December 28, 1846 |
15 | KS | Kansas | Topeka | January 29, 1861 |
16 | KY | Kentucky | Frankfort | June 1, 1792 |
17 | LA | Louisiana | Baton Rouge | April 30, 1812 |
18 | ME | Maine | Augusta | March 15, 1820 |
19 | MD | Maryland | Annapolis | April 28, 1788 |
20 | MA | Massachusetts | Boston | February 6, 1788 |
21 | MI | Michigan | Lansing | January 26, 1837 |
22 | MN | Minnesota | Saint Paul | May 11, 1858 |
23 | MS | Mississippi | Jackson | December 10, 1817 |
24 | MO | Missouri | Jefferson City | August 10, 1821 |
25 | MT | Montana | Helena | November 8, 1889 |
26 | NE | Nebraska | Lincoln | March 1, 1867 |
27 | NV | Nevada | Carson City | October 31, 1864 |
28 | NH | New Hampshire | Concord | June 21, 1788 |
29 | NJ | New Jersey | Trenton | December 18, 1787 |
30 | NM | New Mexico | Santa Fe | January 6, 1912 |
31 | NY | New York | Albany | July 26, 1788 |
32 | NC | North Carolina | Raleigh | November 21, 1789 |
33 | ND | North Dakota | Bismarck | November 2, 1889 |
34 | OH | Ohio | Columbus | March 1, 1803 |
35 | OK | Oklahoma | Oklahoma City | November 16, 1907 |
36 | OR | Oregon | Salem | February 14, 1859 |
37 | PA | Pennsylvania | Harrisburg | December 12, 1787 |
38 | RI | Rhode Island | Providence | May 19, 1790 |
39 | SC | South Carolina | Columbia | May 23, 1788 |
40 | SD | South Dakota | Pierre | November 2, 1889 |
41 | TN | Tennessee | Nashville | June 1, 1796 |
42 | TX | Texas | Austin | December 29, 1845 |
43 | UT | Utah | Salt Lake City | January 4, 1896 |
44 | VT | Vermont | Montpelier | March 4, 1791 |
45 | VA | Virginia | Richmond | June 25, 1788 |
46 | WA | Washington | Olympia | November 11, 1889 |
47 | WV | West Virginia | Charleston | June 20, 1863 |
48 | WI | Wisconsin | Madison | May 29, 1848 |
49 | WY | Wyoming | Cheyenne | July 10, 1890 |