The goal is to create a map that shows the actual per capita CO2 emissions. It will highlight countries in the world that have the largest impact on global emissions:
We will use data from the amazing website âOur World in Dataâ: https://ourworldindata.org/co2-emissions. I will download the âper capita emissionsâ data as CSV and modify it.
The file contains one row per year and per country. But as we want to depict countries, we need to ensure that the file contains only one row per country.
So we can filter out every year except the most recent one, 2022. You can download the exact data from this Google Sheet.
Now, letâs open the MapFast app and select âWorldâ for the map area:
Once the preview map has loaded, we can upload our data by clicking the âImport Excel/CSV fileâ button. Once the upload is complete, you should be able to see the data in the table view on the right:
This view enables you to check that you have one row per location. This is a very important requirement. It doesnât matter what the column names are in the imported file, but there must be a clear column containing the location, and only the location.
At this point, MapFast will try to associate each row of the CSV file with a country from its database. Once finished, we need to review the matches, to be sure that everything will be displayed correctly.
After clicking âNextâ, youâll see a table with 2 columns: the first column contains locations from the CSV file we imported. The second one contains the country that was matched with the row. Thatâs what we need to check.
Most of the lines appear green, but some may show up red because no match has been found.. In our case, thatâs normal : it is because our dataset contains aggregated values for âAsiaâ, âEuropeâ, etc.
We also need to check green lines, because it might not be associated with the correct country. I found two cases :
To remove both associations, we can click on âRepublic of Chinaâ and remove the association by selecting the blank option. We do the same for âTokelauâ.
The map on the right shows the completeness of our data. If the map is entirely green, it means weâve covered the entire world. Good!
The last step is really straightforward: we just need to pick the data column. In our case, itâs âAnnual CO2 emissions (per capita)â.
The map will show a preview of the data. We will customize its appearance afterward.
Click âLoad mapâ when you are ready!
Once our map is loaded, we only need to customize it the way we want.
The basics are:
Thatâs it! You now have a beautiful world map. đ
You can export it using the âDownloadâ button as a PNG or SVG with the resolution that you need.
Happy mapping đ€©