Summary

In this chapter, we have examined various techniques of tidying up data in Series or DataFrame. We've covered identifying missing data, replacing it with real data, or dropping it from the overall set of data. We also saw how to transform values into other values that may be better suited for further analysis.

However, the focus of this chapter was on working with individual values in Series or DataFrame, and made the assumption that the DataFrame is shaped properly for further usage, and can be aligned with data from other Series or DataFrame objects. In the next chapter, we will examine how to combine and restructure data in one or more DataFrame (and Series) objects through concatenation, merges, joins, and pivoting.

Get Learning pandas now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.