Using Area Map to Visualize US State Data Geographically

Visualizing geographical data using Map gives you a better and more intuitive understanding of the data rather than having the data on a table or bar chart. This article explains how to visualize geographical data using Map step by step.

Import Data

Here we use the US population data by States. The data originally comes from the List of U.S. states and territories by population on Wikipedia. I did a Web Scraping on that page with Exploratory and created simple CSV data already.

You can visit here, and choose ‘Download CSV’ to download the data.

Once you download the CSV data, go to Exploratory, open a project (or create a new project), clikc the ‘+’ icon next to the ‘Data Frames’ and choose ‘File Data’.

It will open up the File Data Source dialog. Choose ‘Text File (CSV, delimited)’.

Once you choose the CSV file you downloaded, then you see ‘Import Local Data’ dialog. You will see the preview of the data in the Preview Table. Make sure there are 3 columns (‘state’, ‘pop’, and ‘state_code’. and click the ‘Save’ button.

Once the import is done, you will see the summary of the data. You can see the detail of each column.

If you click ‘Table’ tab, you can see the actual data.

Plot the Data on Map

Now the data is ready. Let’s plot the data on the Map. You can go to the Chart view, choose ‘Map - Area’ chart type, and choose ‘US States’ for the Area Type. If you click the ‘Key Properties’, you will see a list of properties with sample values. Those are the properties you can bind with your data. If you look at ‘STUSPS’ property, it contains the US State 2-letter codes. We have a ‘state_code’ column that contains the same data, so we can bind those values together.

You can select ‘state_code’ to ‘Key Column’ to bind the data, and you select ‘pop’ to ‘Color By’ to show colors for each State based on its population. Once you select those, you will see a Map with States colored.

If you don’t have Exploratory Desktop yet, you can sign up from here for a 30 days free trial. If you are currently a student or teacher, then it’s free!