Spaces:
Runtime error
Runtime error
| import streamlit as st | |
| import pandas as pd | |
| def generate_hospital_data(): | |
| # Generate hospital data | |
| hospitals = { | |
| "city": ["New York", "Los Angeles", "Chicago", "Houston", "Phoenix"], | |
| "state": ["NY", "CA", "IL", "TX", "AZ"], | |
| "bed_count": [1200, 1500, 1100, 1300, 1400], | |
| } | |
| df = pd.DataFrame(hospitals) | |
| return df | |
| def generate_state_data(): | |
| # Generate state data | |
| states = { | |
| "state": ["NY", "CA", "IL", "TX", "AZ"], | |
| "population": [20000000, 40000000, 13000000, 29000000, 7000000], | |
| "square_miles": [54556, 163696, 57914, 268596, 113990], | |
| } | |
| df = pd.DataFrame(states) | |
| return df | |
| def merge_datasets(hospitals_df, states_df): | |
| # Merge hospital and state data | |
| merged_df = pd.merge(hospitals_df, states_df, on="state") | |
| return merged_df | |
| def calculate_beds_per_capita(merged_df): | |
| # Calculate beds per capita | |
| merged_df["beds_per_capita"] = merged_df["bed_count"] / merged_df["population"] | |
| return merged_df | |
| def main(): | |
| # Generate data | |
| hospitals_df = generate_hospital_data() | |
| states_df = generate_state_data() # Merge datasets | |
| merged_df = merge_datasets(hospitals_df, states_df) # Calculate beds per capita | |
| merged_df = calculate_beds_per_capita(merged_df) # Show merged and calculated data | |
| st.write(merged_df) | |
| if __name__ == "__main__": | |
| main() | |