Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Data Services Class Descriptions

Information, materials, and schedules for all currently offered Data Services classes
Do you have unstructured geographic data and need to make a map? This class introduces essential strategies for cleaning data in preparation for visualization and analysis with GIS software platforms. We will use data scraped from a personal CitiBike user account as a test case for learning data remediation strategies for GIS analysis.
Software:

Google Sheets and Geocode by AwesomeTable (note: Data Services does not support this add-on, but you are encouraged to add it to your Sheets account in advance of the class)

Duration: 60 min

Room description:

During the Fall 2021 semester, some tutorials are held remotely and require NYU sign on to access, while others are held in person, without a remote component. Please note the correct modality and location of the tutorial when registering

Prerequisites: Basic familiarity with Google Sheets formulas
Skills Taught / Learning Outcomes:
  • Identify meaningful units of analysis in order to structure data for mapping
  • Manipulate data in order to visualize and process it within various GIS platforms
  • Deploy essential formulas like CONCAT, COUNTIF, WEEKDAY, and others in order to clean up unwieldy data
  • Ascertain the value of establishing date, number, and categorical string variable types of data
  • Structure data to maximize the success rate of existing cloud-based geocoding APIs
Class Materials:
Related Classes:

Data Cleaning Using OpenRefine
Introduction to ArcGIS (ArcMap)
Data Cleaning and Management with Python

Additional Training Materials: Cleaning up your Excel 2013 data via LinkedIn Learning (NYU NetID required)
Feedback: bit.ly/feedbackds

Upcoming sessions for this tutorial