get_disney_ride_ratings.py

# Get Disney Attractiveness Ratings
import requests
from bs4 import BeautifulSoup

r = requests.get("https://touringplans.com/disneyland/attractions")
soup = BeautifulSoup(r.text)

rows = []
table = soup.find("table")
for idx, tr in enumerate(table.findAll("tr")):
    if idx % 2 == 0:
        row = []
        row.append(tr.findAll("td")[0].find("a").text.strip())
        row.append(tr.findAll("td")[1].text.strip())
        row.append(tr.findAll("td")[2].text.strip())
        row.append(tr.findAll("td")[3].text.strip())
        row.append(tr.findAll("td")[4].text.strip())
        row.append(tr.findAll("td")[5].text.strip())
        row.append(tr.findAll("td")[6].text.strip())
        rows.append(row)

appeal = pd.DataFrame(rows, columns=["Ride", "Pre-K", "Grade School", "Teens", "Young Adults", "Over 30", "Seniors"])
for column in appeal.columns[1:]:
    appeal[column] = pd.to_numeric(appeal[column])

rides = df.merge(appeal, on="Ride", how="left").sort_values("Seniors")