I just lately got here throughout an older Towards Data Science article about ten methods to characterize knowledge on maps. Reading the article jogged my memory of one thing that I’ve tried to share with social research academics and college students through the years. That factor is that an important knowledge set can inform you numerous. An important map can inform you numerous. Putting them collectively can inform you much more. To that finish, listed here are 3 ways to shortly create a map of information contained in a spreadsheet.
Google’s My Maps device enables you to import a Google Sheet and have the information from that sheet displayed as placemarks on an interactive map. Watch this video that I created to study how one can create a map primarily based on knowledge in a Google Sheet.
Felt is a comparatively new multimedia mapping device. In your Felt account you’ll be able to add a CSV or Excel file and have the information throughout the spreadsheet distributed as placemarks and or polygons on a map. After the information is initially loaded you’ll be able to then customise the design of your map by altering the colour, dimension, and form of the placemarks and polygons. You also can customise the scale and coloration of the labels in your map after the spreadsheet knowledge has been imported onto your map. Watch my video beneath to study tips on how to show your spreadsheet knowledge on a Felt map.
Heat Map Tool is a device for simply creating warmth maps or incident maps from a CSV file. To create a warmth map all it’s worthwhile to do is add a CSV file then specify your required show attributes like scale, colours, and opacity. You can edit the show attributes of your map everytime you like. If you are questioning tips on how to create a CSV file you are able to do so by exporting from a spreadsheet in Google Documents or exporting from an Excel file. Click right here for instructions on exporting from Excel. The free model of Heat Map Tool permits you to have as much as 100 knowledge factors in your map and as much as 500 hits per day in your map.