Paris WiFi Services¶

Read local data from a JSON file

In [1]:

import requests

data_json = requests.get('https://libs.cartocdn.com/cartoframes/samples/paris_wifi_services.json').json()

Normalize the json data and build a DataFrame

In [2]:

from pandas import DataFrame, json_normalize

df = DataFrame(json_normalize(data_json['records']))
df.head()

Out[2]:

	datasetid	recordid	record_timestamp	fields.cp	fields.nom_site	fields.arc_adresse	fields.geo_point_2d	fields.nombre_de_borne_wifi	fields.idpw	fields.geo_shape.type	fields.geo_shape.coordinates	fields.etat2	geometry.type	geometry.coordinates
0	sites-disposant-du-service-paris-wi-fi	31c3bfd9ad944ec1bea07cbeb28dc6bb0653e530	2019-10-08T07:01:10.494000+00:00	75010	MEDIATHEQUE FRANCOISE SAGAN	8 RUE LEON SCHWARTZENBERG	[48.8754298708, 2.35366677297]	11	PW0147	Point	[2.353666772968424, 48.87542987081135]	Opérationnel	Point	[2.35366677297, 48.8754298708]
1	sites-disposant-du-service-paris-wi-fi	322b5836dd2af4413728e67dc4432cf83dde06b1	2019-10-08T07:01:10.494000+00:00	75020	PARC DE BELLEVILLE (PARIS NATURE MAISON DE L'AIR)	27 RUE PIAT	[48.8716051488, 2.38492475051]	1	PW0168	Point	[2.384924750509342, 48.87160514880642]	Opérationnel	Point	[2.38492475051, 48.8716051488]
2	sites-disposant-du-service-paris-wi-fi	ec66708cf6e56caced0ae6485f68c0a44167636d	2019-10-08T07:01:10.494000+00:00	75013	JARDIN BRASSAI	59 BOULEVARD AUGUSTE BLANQUI	[48.8292152156, 2.34951229427]	1	NaN	Point	[2.349512294267843, 48.82921521555871]	En étude	Point	[2.34951229427, 48.8292152156]
3	sites-disposant-du-service-paris-wi-fi	6f37d419ab91b1d9b2972eafe2f5585c4d51f358	2019-10-08T07:01:10.494000+00:00	75007	BERGES RIVE GAUCHE - JARDIN FLOTTANT	PORT DU GROS CAILLOU	[48.8629641751, 2.30452468194]	3	PW0189	Point	[2.30452468193794, 48.86296417505911]	Opérationnel	Point	[2.30452468194, 48.8629641751]
4	sites-disposant-du-service-paris-wi-fi	76280ce4b86872e0c0696c047c1d140b66c6868f	2019-10-08T07:01:10.494000+00:00	75016	BIBLIOTHEQUE GERMAINE TILLION	6 RUE DU COMMANDANT SCHLOESING	[48.8618363826, 2.28427079122]	2	PW0113	Point	[2.284270791218422, 48.86183638257241]	Opérationnel	Point	[2.28427079122, 48.8618363826]

Clean the dataframe and save lat and lon columns

In [3]:

df.columns = df.columns.str.replace('.', '_')
df[['lon','lat']] = DataFrame(df['geometry_coordinates'].values.tolist(), index=df.index)
df.head()

Out[3]:

	datasetid	recordid	record_timestamp	fields_cp	fields_nom_site	fields_arc_adresse	fields_geo_point_2d	fields_nombre_de_borne_wifi	fields_idpw	fields_geo_shape_type	fields_geo_shape_coordinates	fields_etat2	geometry_type	geometry_coordinates	lon	lat
0	sites-disposant-du-service-paris-wi-fi	31c3bfd9ad944ec1bea07cbeb28dc6bb0653e530	2019-10-08T07:01:10.494000+00:00	75010	MEDIATHEQUE FRANCOISE SAGAN	8 RUE LEON SCHWARTZENBERG	[48.8754298708, 2.35366677297]	11	PW0147	Point	[2.353666772968424, 48.87542987081135]	Opérationnel	Point	[2.35366677297, 48.8754298708]	2.353667	48.875430
1	sites-disposant-du-service-paris-wi-fi	322b5836dd2af4413728e67dc4432cf83dde06b1	2019-10-08T07:01:10.494000+00:00	75020	PARC DE BELLEVILLE (PARIS NATURE MAISON DE L'AIR)	27 RUE PIAT	[48.8716051488, 2.38492475051]	1	PW0168	Point	[2.384924750509342, 48.87160514880642]	Opérationnel	Point	[2.38492475051, 48.8716051488]	2.384925	48.871605
2	sites-disposant-du-service-paris-wi-fi	ec66708cf6e56caced0ae6485f68c0a44167636d	2019-10-08T07:01:10.494000+00:00	75013	JARDIN BRASSAI	59 BOULEVARD AUGUSTE BLANQUI	[48.8292152156, 2.34951229427]	1	NaN	Point	[2.349512294267843, 48.82921521555871]	En étude	Point	[2.34951229427, 48.8292152156]	2.349512	48.829215
3	sites-disposant-du-service-paris-wi-fi	6f37d419ab91b1d9b2972eafe2f5585c4d51f358	2019-10-08T07:01:10.494000+00:00	75007	BERGES RIVE GAUCHE - JARDIN FLOTTANT	PORT DU GROS CAILLOU	[48.8629641751, 2.30452468194]	3	PW0189	Point	[2.30452468193794, 48.86296417505911]	Opérationnel	Point	[2.30452468194, 48.8629641751]	2.304525	48.862964
4	sites-disposant-du-service-paris-wi-fi	76280ce4b86872e0c0696c047c1d140b66c6868f	2019-10-08T07:01:10.494000+00:00	75016	BIBLIOTHEQUE GERMAINE TILLION	6 RUE DU COMMANDANT SCHLOESING	[48.8618363826, 2.28427079122]	2	PW0113	Point	[2.284270791218422, 48.86183638257241]	Opérationnel	Point	[2.28427079122, 48.8618363826]	2.284271	48.861836

Generate a GeoDataFrame using lat and lon columns

In [4]:

from geopandas import GeoDataFrame, points_from_xy

gdf = GeoDataFrame(df, geometry=points_from_xy(df['lon'], df['lat']))
gdf.head()

Out[4]:

	datasetid	recordid	record_timestamp	fields_cp	fields_nom_site	fields_arc_adresse	fields_geo_point_2d	fields_nombre_de_borne_wifi	fields_idpw	fields_geo_shape_type	fields_geo_shape_coordinates	fields_etat2	geometry_type	geometry_coordinates	lon	lat	geometry
0	sites-disposant-du-service-paris-wi-fi	31c3bfd9ad944ec1bea07cbeb28dc6bb0653e530	2019-10-08T07:01:10.494000+00:00	75010	MEDIATHEQUE FRANCOISE SAGAN	8 RUE LEON SCHWARTZENBERG	[48.8754298708, 2.35366677297]	11	PW0147	Point	[2.353666772968424, 48.87542987081135]	Opérationnel	Point	[2.35366677297, 48.8754298708]	2.353667	48.875430	POINT (2.35367 48.87543)
1	sites-disposant-du-service-paris-wi-fi	322b5836dd2af4413728e67dc4432cf83dde06b1	2019-10-08T07:01:10.494000+00:00	75020	PARC DE BELLEVILLE (PARIS NATURE MAISON DE L'AIR)	27 RUE PIAT	[48.8716051488, 2.38492475051]	1	PW0168	Point	[2.384924750509342, 48.87160514880642]	Opérationnel	Point	[2.38492475051, 48.8716051488]	2.384925	48.871605	POINT (2.38492 48.87161)
2	sites-disposant-du-service-paris-wi-fi	ec66708cf6e56caced0ae6485f68c0a44167636d	2019-10-08T07:01:10.494000+00:00	75013	JARDIN BRASSAI	59 BOULEVARD AUGUSTE BLANQUI	[48.8292152156, 2.34951229427]	1	NaN	Point	[2.349512294267843, 48.82921521555871]	En étude	Point	[2.34951229427, 48.8292152156]	2.349512	48.829215	POINT (2.34951 48.82922)
3	sites-disposant-du-service-paris-wi-fi	6f37d419ab91b1d9b2972eafe2f5585c4d51f358	2019-10-08T07:01:10.494000+00:00	75007	BERGES RIVE GAUCHE - JARDIN FLOTTANT	PORT DU GROS CAILLOU	[48.8629641751, 2.30452468194]	3	PW0189	Point	[2.30452468193794, 48.86296417505911]	Opérationnel	Point	[2.30452468194, 48.8629641751]	2.304525	48.862964	POINT (2.30452 48.86296)
4	sites-disposant-du-service-paris-wi-fi	76280ce4b86872e0c0696c047c1d140b66c6868f	2019-10-08T07:01:10.494000+00:00	75016	BIBLIOTHEQUE GERMAINE TILLION	6 RUE DU COMMANDANT SCHLOESING	[48.8618363826, 2.28427079122]	2	PW0113	Point	[2.284270791218422, 48.86183638257241]	Opérationnel	Point	[2.28427079122, 48.8618363826]	2.284271	48.861836	POINT (2.28427 48.86184)

Visualize the data

In [5]:

from cartoframes.viz import Layer, color_category_style, basic_legend

Layer(
    gdf,
    color_category_style(
        'fields_etat2', 
        palette='[green, yellow, red, silver]',
    ),
    legends=basic_legend(
        title='WiFi Services in Paris',
        footer='Source: <a href="https://opendata.paris.fr" target="_blank">Open Data Paris</a>'
    )
)

Out[5]: