fossildata.py 579 B

1234567891011121314151617
  1. import pandas as pd
  2. dataset_fossil_fuels_gdp = pd.read_csv("./per-capita-fossil-energy-vs-gdp.csv")
  3. country_codes = pd.read_csv("./country_codes.csv")
  4. dataset_fossil_fuels_gdp = dataset_fossil_fuels_gdp.merge(
  5. country_codes[["alpha-3", "region"]], how="left", left_on="Code", right_on="alpha-3"
  6. )
  7. dataset_fossil_fuels_gdp = dataset_fossil_fuels_gdp[
  8. ~dataset_fossil_fuels_gdp["Fossil fuels per capita (kWh)"].isnull()
  9. ].reset_index()
  10. dataset_fossil_fuels_gdp["Fossil fuels per capita (kWh)"] = (
  11. dataset_fossil_fuels_gdp["Fossil fuels per capita (kWh)"] * 1000
  12. )