You're reading from Python Data Cleaning and Preparation Best Practices A practical guide to organizing and handling data from various sources and formats using Python

Product type Paperback

Published in Sep 2024

Publisher Packt

ISBN-13 9781837634743

Length 456 pages

Edition 1st Edition

Languages

Python

Concepts

Data Analysis

Author (1):

Maria Zervou

View More author details

Table of Contents (19) Chapters

Preface

1. Part 1: Upstream Data Ingestion and Cleaning

2. Chapter 1: Data Ingestion Techniques FREE CHAPTER

3. Chapter 2: Importance of Data Quality

4. Chapter 3: Data Profiling – Understanding Data Structure, Quality, and Distribution

5. Chapter 4: Cleaning Messy Data and Data Manipulation

6. Chapter 5: Data Transformation – Merging and Concatenating

7. Chapter 6: Data Grouping, Aggregation, Filtering, and Applying Functions

8. Chapter 7: Data Sinks

9. Part 2: Downstream Data Cleaning – Consuming Structured Data

10. Chapter 8: Detecting and Handling Missing Values and Outliers

11. Chapter 9: Normalization and Standardization

12. Chapter 10: Handling Categorical Features

13. Chapter 11: Consuming Time Series Data

14. Part 3: Downstream Data Cleaning – Consuming Unstructured Data

15. Chapter 12: Text Preprocessing in the Era of LLMs

16. Chapter 13: Image and Audio Preprocessing with LLMs

17. Index

Why subscribe?

18. Other Books You May Enjoy

Performance tricks for merging

When working with large datasets, the performance of merge operations can significantly impact the overall efficiency of data processing tasks. Merging is a common and often necessary step in data analysis, but it can be computationally intensive, especially when dealing with big data. Therefore, employing performance optimization techniques is crucial to ensure that merges are executed as quickly and efficiently as possible.

Optimizing merge operations can lead to reduced execution time, lower memory consumption, and an overall smoother data-handling experience. In the following sections, we will explore various performance tricks that can be applied to merge operations in pandas, such as utilizing indexes, sorting indexes, choosing the right merge method, and reducing memory usage.

Set indexes

Utilizing indexes in pandas is a critical aspect of data manipulation and analysis, particularly when dealing with large datasets or performing frequent...