Skip to Content
Python for Geospatial Data Analysis
book

Python for Geospatial Data Analysis

by Bonny P. McClain
October 2022
Beginner to intermediate
279 pages
6h 51m
English
O'Reilly Media, Inc.
Content preview from Python for Geospatial Data Analysis

Chapter 8. Data Cleaning

A universal problem when working with data is understanding the completeness of your data. Data engineering depends on the ability to clean, process, and visualize data. Now that you’re familiar with the basic functionality of and integration of data with notebook-based code editors, either locally in a Jupyter Notebook or in the cloud with Google Colab, it’s time to learn how to clean your data. Data is frequently incomplete (missing), inconsistently formatted, or otherwise inaccurate—problems often called messy data. Data cleaning is the process of addressing these problems and preparing the data for analysis.

In this chapter, we’ll explore some publicly available datasets, finding and cleaning up messes with a few packages that you can load into a Colab notebook. You’re going to work with NYPD_Complaint_Data_Historic, a dataset from the open data portal for New York City, NYC Open Data, updated on July 7, 2021. I filtered the data for 2020 to make it a little more manageable for viewing and manipulating. You can filter the data based on your data question and export it as a CSV file. This chapter will show you how to manage, remove, update, and consolidate data and process it with a few useful Python packages. Data analysis is only as accurate as the quality of the dataset or database, and this chapter will provide tools to assess and address common inconsistencies.

Checking for Missing Data

If you’ve ever participated in a data competition, like those ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Python for Data Science

Python for Data Science

Yuli Vasiliev
Python Data Analysis - Third Edition

Python Data Analysis - Third Edition

Avinash Navlani, Ivan Idris

Publisher Resources

ISBN: 9781098104788Errata Page