Exercise: From GeoJSON to CSV to SHP using Pandas
In this exercise, you will explore Pandas using an example of addresses stored in a GeoJSON file. The address file is from openaddresses.io and represents a county in Pennsylvania. You will use the basic features of Pandas and Notebooks to transform data from the raw format supplied by OpenAddresses into a feature class. Along the way, you will create maps displaying the address data.
Pandas can be used in a standalone Python script, but for this example we will use a Notebook, a common method.
- Open ArcGIS Pro and start a new project, then add a new Notebook from the Insert tab. Rename the Notebook to
Chapter8
. - In the first cell, you will import
arcpy
andarcgis
, as well aspandas
. Type in the following:import arcgis, arcpy import pandas as pd
- In the same cell, you will read the
cameron-addresses-county.geojson
file into a Pandas DataFrame. You will open the file and assign it to a data...