As a GIS professional, you encounter many data types that you have to manage. Much of the data you will manage is commonly in a comma-separated value (CSV) format. Later, I will show you how to add a CSV as an item to your ArcGIS Online organization. In addition, if that CSV has a Lat/Long or X/Y, you can also add it as a spatial feature layer to you GIS.
To work with CSVs, we will be using an open source Python library called pandas. First, we import pandas and call it pd and then we build a data frame using the read_csv function from pandas. A data frame is a structured way of viewing data; you can think of it as a spreadsheet or an SQL table. In the next figure, you can see what a data frame looks like when we build it from our SFPF_2016.csv. For the purposes of this exercise, I have reduced SFPD_2016.csv from its original size of 150,000 records...