I am scraping an event site (event name, date and time). The output that I get in excel is the following:
I would like to change the names of the days to actual dates, e.g. Friday should be 12.03. and so on. Event date and time are in this variable:
dates_and_times = [] for container in containers: event_names.append(container.find('h2').getText()) date_time = container.find('p', class_='Typography_root__487rx #585163 Typography_body-md__487rx event-card__clamp-line--one Typography_align-match-parent__487rx').getText() if date_time.endswith("PM") or date_time.endswith("AM"): dates_and_times.append(date_time) I get that I need to replace it somehow using time but I don't know how to do it. Can somebody assist me with this? Thank you.
Here is the whole code:
from bs4 import BeautifulSoup import requests from datetime import datetime, timedelta import pandas as pd # Get the current date current_date = datetime.now().strftime("%Y-%m-%d") # Calculate the end date (current date + 7 days) end_date = (datetime.now() + timedelta(days=7)).strftime("%Y-%m-%d") # Construct the URL with dynamic start and end dates URL = f"https://www.eventbrite.com/d/canada--to ... ={end_date}" header = { "User-Agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36", "Accept-Language": "en-GB,en-US;q=0.9,en;q=0.8" } response = requests.get(URL, headers=header) response.raise_for_status() web_page = response.text soup = BeautifulSoup(web_page, 'html.parser') containers = soup.find_all('section', class_='event-card-details') event_names = [] dates_and_times = [] for container in containers: event_names.append(container.find('h2').getText()) date_time = container.find('p', class_='Typography_root__487rx #585163 Typography_body-md__487rx event-card__clamp-line--one Typography_align-match-parent__487rx').getText() if date_time.endswith("PM") or date_time.endswith("AM"): dates_and_times.append(date_time) event_names_clean = list(set(event_names)) data = {"Event Name": event_names_clean, "Event Date and Time": dates_and_times} df = pd.DataFrame(data) # Save the DataFrame to an Excel file df.to_excel("events_data.xlsx", index=False) print("Data saved to 'events_data.xlsx'")
Источник: https://stackoverflow.com/questions/781 ... -to-a-date
