Nicole-O-Meter

by 8BitsAndAByte in Workshop > 3D Printing

1592 Views, 3 Favorites, 0 Comments

Nicole-O-Meter

_DJEHR39ThK.jpg

On the website of the Belgian statistical office Statbel, you can find interesting data about the first names of the population. Let's use this data to make a cool data visualization!

Supplies

  • Autodesk Fusion 360
  • 3D Printer (generic)

Project Video

Nicole-O-Meter

Data Cleaning

nicoleometer_00_00_21_10_still005_0o5zNTCheN.jpg
nicoleometer_00_00_40_07_still006_ixEAPqxo4O.jpg

First, we need to clean the data so only the useful bits, the numbers we want to show, remain.

After attempting to make a Python script to do this, which took forever to filter the data, I ended up doing it manually using the sort & filter functions in Excel. I alphabetically sorted the data by name, and singled out all the Nicoles. After this, I sorted by ZIP code and summarized the number of Nicoles per province.

3D Map Making

nicoleometer_00_00_51_06_still007_Gde3JZqNxR.jpg

Now we have our numbers, we need to make it look pretty on a map!

I used a low-poly map of Belgium to create a nice-looking 2D map in Illustrator.

You can find some very neat free SVG maps of a lot of countries here on the amCharts website.

Once the 2D map was imported in Fusion360, I adjusted the heights of the provinces to match the amount of Nicoles living in that province.

For instance, there are 4832 Nicoles living in the province of Antwerp, so the height of the province is 48mm.

3D Printing

nicoleometer_00_00_57_14_still008_ZjFOJaQGse.jpg
nicoleometer_00_01_21_02_still010_FA8ReukfR4.jpg

Last but not least, it's time to 3D print the map. I ended up printing a number of different versions, and as it's a long print, it's best to start with a smaller version in draft printer settings (learned that the hard way...).

And there we have it, a cool, personalized 3D map!