How to create a map?

CaravaniCaravani Member Posts: 3 Newbie
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 :smile:

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
Tagged:

Best Answer

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Oh @Marco_Boeck, you're putting my blog out of work! ;-)
  • CaravaniCaravani Member Posts: 3 Newbie
    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!

  • CaravaniCaravani Member Posts: 3 Newbie
    Ah, it worked. Thanks a lot!
Sign In or Register to comment.