2.2. Create your first map with pinpoints

1. Read, clean, and prepare data to build maps

2. Problem & Solution

Inserting markers, showing them on a map, and coloring them according to their category

The next code helps to read the latitude and longitude coordinates of several countries from a CSV file.

import pandas as pd

import numpy as np

df_page_latlon = pd.read_html('https://developers.google.com/public-data/docs/canonical/countries_csv?hl=en')

data = df_page_latlon[0]

data

This will produce the following data frame:

The next code helps to eliminate rows whose country's data are empty with NaN.

data = data.dropna()

data

This will produce:

The command Marker from the library folium is useful to draw several pinpoints in a map according to latitude and longitude information:

# import the library

import folium

# Make an empty map

m = folium.Map(location=[20,0], tiles="OpenStreetMap", zoom_start=2)

# add marker one by one on the map

for i in range(0,len(data)):

folium.Marker(

location=[data.iloc[i]['latitude'], data.iloc[i]['longitude']],

popup=data.iloc[i]['name'],

lazy=True

).add_to(m)

# Show the map

The following map will be created:

The Python code with all the steps is summarized in this Google Colab (click on the link):

Page updated

Google Sites

Report abuse