February 2019
Beginner to intermediate
284 pages
6h 20m
English
Scatter charts are great to reveal hidden patterns in large datasets. In the following example, we will use a huge file obtained from a public database (geonames.org) to plot a scatter chart showing the position of cities based on their latitude and longitude. The file contains a list of locations with populations above 15,000 (Data/cities_15000.csv). It contains over 100,000 entries (and because of this, it will take a few seconds to load). This is the general structure of the CSV file:
geonameid;asciiname;latitude;longitude;country_code;population;timezone14256;Azadshahr;34.79049;48.57011;IR;514102;Asia/Tehran18918;Protaras;35.0125;34.05833;CY;20230;Asia/Nicosia23814;Kahriz;34.3838;47.0553;IR;766706;Asia/Tehran ...
Read now
Unlock full access