Raw Data to Interactive Maps in the Blink of an Eye with GPT4 Prompting

Author(s): John Loewen, PhD

Originally published on Towards AI.

Interactive UN population projection mapping with Python Plotly
Dall-E 2 image: impressionist style painting of a global choropleth map with deep-blue oceans.

ChatGPT is a terrific tool for generating data cleaning and visualization code in Python.

In combination with the right libraries — Pandas and Plotly — you can create fantastically pleasing and interactive maps.

Let’s test this all out by loading up some awesome and interesting UN population projection data for GPT-4 to work its magic with.

To better understand how to prompt engineer GPT-4 to create Python code, we can break it down to:

cleaning a datasetcreating a choropleth mapcreating an animated choropleth map that illustrates data over time

As always, the best way to learn is to give it a go! Here’s how!

For this exercise, we will be using a newly updated dataset from the UN Department of Economic and Social Affairs website (HERE).

This dataset models population growth projections from 2022 to 2100.

After a cursory view, I can see that some data cleaning is in order. The actual data headers start on Row 17. So we can remove the first 16 Rows of data (or just start our data retrieval at this row).

Now, if we want to do a choropleth map to show each country over time (by heat map), then… Read the full blog for free on Medium.

Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming a sponsor.

Published via Towards AI