How to create a map?

Caravani

Hello Rapid-Miner Community!

I am a complete newbie to rapid miner and started learning to use the plattform in university for a business case. 

I have a big excel sheet with 2 columns - Colum A longitude - Column B latitude. Now I have to create a map of europe/germany and to create dots with the geographical position of each row. The aim is to see then, where the most dots are cause this gives me the information I need later

I already searched for solutions online, but if I understand it correctly this is not an easy task... 
Do you have any ideas?

Thanks in advance!

- Cara

Marco_Boeck

Hi,

The data is expected to be in a numerical column each, so one numerical column for longitude, and another one for latitude. 53.344813 is a perfectly fine numerical value for lat/lon and you should see them appear if you choose a map that actually is in that range (you could try a worldmap first).
If you have them in nominal columns, you can use a Parse Numbers operator to convert them before using the visualizations.

Regards,
Marco

Marco_Boeck

Hi,

Check out our 9.4 BETA here which is a preview of our upcoming 9.4 release: https://s3.amazonaws.com/static.rapidminer.com/rnd/html/rapidminer-9.4-preview.html#
This conveniently adds map visualizations when exploring results.

See the attached image. You just have to select Germany as a map, and set Lat and Lon.

Regards,
Marco

BalazsBarany

Oh @Marco_Boeck, you're putting my blog out of work! ;-)

Marco_Boeck

@BalazsBarany Hehe thanks, but I don't think so Your use of OpenStreetMaps will continue to offer more advanced functionality
But for some basic needs like Choropleth world/country maps, or bubble/point maps, RM  will now indeed offer a quick way to visualize geospatial data.

Caravani

Hello,

thanks a lot for your help so far! This is exactly what I need. 
But I am currently struggling with the import of the coordinates. I don't know how to format my data so RapidMiner can read it. E.g. I have one column with the latitude where the data is written like "53.344813" and the other column with the longitude

"7.166511". In one version I combined both to "53.344813°, 7.166511°" - but sadly it doesn't work with the visualization. So which format does the coordinates have to be? Thanks in advance!

Caravani

Ah, it worked. Thanks a lot!