Week 128 – Intermediate

As you may have seen, the 2025 Data Superheroes have been announced. The alter egos of your hosts – Christopher Marland, Mike Droog and Sofia Pierini are honoured to be named!

In celebration, your challenge is to get the list of data superheroes into Snowflake!

Here is your started code:

import requests
from bs4 import BeautifulSoup
import pandas as pd
import re

# URL to scrape
url = "https://medium.com/snowflake/celebrating-the-2025-data-superheroes-the-innovators-trailblazers-and-changemakers-8e219e48587a"

response = requests.get(url)
response.raise_for_status()
html_content = response.text

# Parse the HTML content using BeautifulSoup
soup = BeautifulSoup(html_content, 'html.parser')

# Find the section starting from the "Americas" header
start_section = soup.find(lambda tag: tag.name in ["h1", "h2", "h3"] and "Americas" in tag.text)
content = ""

Here is where you need to get to:

Happy Deving!