Spaces:
Sleeping
Sleeping
| def true_code(): | |
| import pandas as pd | |
| main_data = pd.read_csv("raw_data/main_data.csv") | |
| main_data['Timestamp'] = pd.to_datetime(main_data['Timestamp']) | |
| states_data = pd.read_csv("raw_data/State_data.csv") | |
| ncap_funding_data = pd.read_csv("raw_data/NCAP_Funding.csv") | |
| station_counts = main_data.groupby('state')['station'].nunique().reset_index() | |
| station_counts.rename(columns={'station': 'num_stations'}, inplace=True) | |
| merged_df = station_counts.merge(states_data, on='state', how='inner') | |
| merged_df['stations_per_km2'] = merged_df['num_stations'] / merged_df['area (km2)'] | |
| highest_density_state = merged_df.loc[merged_df['stations_per_km2'].idxmax(), 'state'] | |
| print(highest_density_state) | |
| true_code() |