Python Final UFO Reporting Database IT & Computer Science Essay (Essay Sample)

# -*- coding: utf-8 -*-
"""
Created on Sun May 10 15:57:53 2020
@author: Anonymous
"""
from bs4 import BeautifulSoup
import urllib.request
url = "http://www.nuforc.org/webreports.html"
urlpage = url
urlpageStates = "http://www.nuforc.org/webreports/ndxloc.html"
print(urlpage)
page = urllib.request.urlopen(urlpageStates)
# parse the html using beautiful soup and store in variable 'soup'
soup = BeautifulSoup(page, 'html.parser')
mydict = {}#store sightings by state and their tally
datatable = soup.find("table")
#print(datatable)
trs = datatable.find("tbody").find_all("tr")
for tr in trs:
a = tr.find("a") #find the links
link = a["href"]
location = a.text
page = urllib.request.urlopen("http://www.nuforc.org/webreports/"+str(link))
soupCity = BeautifulSoup(page,"html.parser")
#get the table rows in the second link
dt = soupCity.find("table")
trows = dt.find("tbody").find_all("tr")
for row in trows:
#get the city name
fonttag = row.find_all("td")[1].find("font")
city = fonttag.text
print("city tag: ",city)
#look for the location tag in dict
if location not in mydict:
mydict[location] = {city:1} #assign a count of 1
else:
mydict2 = mydict[location]
if city not in mydict2:
mydict2[city] = 1
else:
mydict[location][city] = mydict[location][city] +1 #add 1 to the city count
else:
print("done.....................\n",mydict)
def part_2():
url = "http://open.mapquestapi.com/geocoding/v1/address?key=KEY&location=Washington,DC"
page = urllib.request.urlopen(url)
soup = BeautifulSoup(page,"html.parser")
#based on database assumptions
trs = soup.find("table").find("tbody").find_all("tr")
mydict = {}
for tr in trs:
longitude = tr['long']