Проблема с моим кодом:
Это не конкретный праздник для каждого штата, в некоторых штатах разные праздники, и во всех штатах праздники одинаковые..< /p>
Мне нужно, чтобы все праздники для каждого штата были объединены в один кадр данных.
У вас есть предложения?
import holidays
import pandas as pd
# Define start and end dates
start_date = "2023-01-01"
end_date = "2027-12-31"
# Create a US holidays object
us_holidays = holidays.US(years=range(2023, 2028))
# Initialize an empty list to store holiday information
holiday_data = []
# List of US state abbreviations (replace with desired states)
us_states = ["AK", "AL", "AR", "AS", "AZ", "CA", "CO", "CT", "DC", "DE", "FL", "GA", "GU", "HI", "IA", "ID", "IL",
"IN", "KS", "KY", "LA", "MA", "MD", "ME", "MI", "MN", "MO", "MP", "MS", "MT", "NC", "ND", "NE", "NH", "NJ",
"NM", "NV", "NY", "OH", "OK", "OR", "PA","PR","RI", "SC", "SD","TN",
"TX", "UM", "UT","VA", "VI","VT","WA","WI","WV","WY"] # Add all desired states
# Iterate through each day in the specified range
for date in pd.date_range(start_date, end_date):
# Check if the date is a holiday in the US holidays object
if date in us_holidays:
# Get the holiday object for the date
holiday_obj = us_holidays.get(date)
# Extract holiday name
holiday_name = holiday_obj[0] if isinstance(holiday_obj, list) else holiday_obj
# Extract country code
country_code = "US"
# Iterate through each state
for state in us_states:
# Create a dictionary to store holiday information
holiday_dict = {
"date": date.strftime("%Y-%m-%d"),
"holiday_name": holiday_name,
"country_code": country_code,
"state": state # Assign specific state in each iteration
}
# Append the dictionary to the holiday data list
holiday_data.append(holiday_dict)
# Create a Pandas DataFrame from the holiday data list
holidays_us = pd.DataFrame(holiday_data)
Подробнее здесь: https://stackoverflow.com/questions/784 ... ate-in-usa
