Today we want to draw the choropleth map as shown above. So what do we need?
- A map of the countries of the world and the corresponding numbers of population.
Our dataset is the CSV file population2013.csv and it contains a list of 214 world countries with their corresponding population numbers as of 2013.
- Import a dataset from the KNIME input data table object to be used with the Google libraries
- Transform the dataset into a Google object, define a visualization.GeoChart object named “chart”, and draw the chart with the function chart.draw(). This part is encapsulated in the DrawChart() function, which is used as a callback function when loading the Google visualization module and its corechart package.
The getScript() method from jQuery is great to load a single JS library. However when more concurrent, possibly dependent, JS libraries are needed, other load methods might be more suitable. We will talk about those in another post. Stay tuned!
Also, note that we have defined a heat map going from light blue (least populated countries) to dark blue (most populated countries).
It is common practice to use a monochromatic color scale. We chose the scale from light blue to dark blue as recommended in the “Color Brewer 2.0” website.
The KNIME Workflow
In order to appreciate the differences in population a bit better, we could use a logarithmic scale. In this case a Math Formula node calculates log(2013) for each country to append to the original dataset.
<h1><font color="gray">Population in logarithmic numbers by world countries in 2013</font></h1>
Indeed, now, if we right-click the component and select its “Interactive View” item, we can see the same choropleth map with a gray title, exactly as in Figure 1. Also, if we execute the workflow from a KNIME WebPortal, the final web page will also contain this interactive view with choropleth and title.
Again if running on a KNIME WebPortal, this composite view translates into a web page with multiple choropleths and titles.
The final workflow is shown in Figure 5 and is also available on the KNIME Hub here. You will also find the Choropleth World Map component on the KNIME Hub which you can drag and drop to your installation of KNIME Analytics Platform.
Summary and Next Steps
Below is a quick video of how to drag and drop a component from the KNIME Hub (Figure 6).
- The workflow Choropleth on World Map using Google Charts and JQuery Library on the KNIME Hub
- The component Choropleth World Map on the KNIME Hub
- The video What's a component on the KNIMETV YouTube channel
- The blog article Time Series Analysis with Components by Daniele Tonini (Bocconi University), Maarit Widman (KNIME), Corey Weisinger (KNIME)