Spaces:
Runtime error
Runtime error
import pandas as pd | |
import streamlit as st | |
# Define the datasets as Python list dictionaries | |
natural_events = [ | |
{'location': 'Australia', 'type': 'Wildfires', 'year': 2019, 'effect': 'Temperature increase'}, | |
{'location': 'Brazil', 'type': 'Deforestation', 'year': 2020, 'effect': 'CO2 emissions'}, | |
{'location': 'Indonesia', 'type': 'Forest fires', 'year': 2015, 'effect': 'Air pollution'}, | |
{'location': 'USA', 'type': 'Heat waves', 'year': 2012, 'effect': 'Crop yield reduction'}, | |
{'location': 'Russia', 'type': 'Melting permafrost', 'year': 2016, 'effect': 'Methane emissions'} | |
] | |
population_growth = [ | |
{'year': 2019, 'country': 'India', 'growth_rate': 1.08}, | |
{'year': 2020, 'country': 'Nigeria', 'growth_rate': 2.58}, | |
{'year': 2015, 'country': 'China', 'growth_rate': 0.48}, | |
{'year': 2012, 'country': 'Ethiopia', 'growth_rate': 2.89}, | |
{'year': 2016, 'country': 'India', 'growth_rate': 1.18} | |
] | |
# Convert the datasets to Pandas DataFrames | |
natural_events_df = pd.DataFrame(natural_events) | |
population_growth_df = pd.DataFrame(population_growth) | |
# Merge the two DataFrames on the year column | |
merged_df = pd.merge(natural_events_df, population_growth_df, on='year') | |
# Calculate the total population growth for each event and add it to the merged DataFrame | |
merged_df['total_growth'] = merged_df['growth_rate'] * 1000000 | |
# Display the merged DataFrame in the Streamlit app | |
st.write(merged_df) | |