Take your data preparation skills to the next level by converting any type of data asset into a structured, properly formatted, and readily usable datasetKey FeaturesMaximize the value of your data with effective data-cleaning methodsTransform your data skills with strategies for handling structured and unstructured dataLearn to elevate the quality of your data products by testing and validating your data pipelinesBook DescriptionData professionals face several challenges in effectively leveraging data in today’s data-driven world. One of the main challenges is the low quality of data products, caused by data that is inaccurate, incomplete, or inconsistent. Another significant challenge is the lack of skills among data professionals to analyze unstructured data, missing valuable insights that are difficult or impossible to obtain from structured data alone.To tackle these challenges, you will go on a journey to the upstream data pipeline, which includes the ingestion of data from various sources, validation and profiling of the data for high-quality end tables, and writing the data to different sinks. Subsequently, you will acquire knowledge on handling structured data by performing essential tasks like cleaning and encoding datasets and handling missing values and outliers. The journey concludes by demystifying the manipulation of unstructured data with simple techniques that unlock their potential. You will be introduced to a variety of natural language processing techniques, from tokenization to vector models, as well as techniques for structuring images, videos, and audio.By the end of the book, you will have achieved mastery of the techniques of data cleaning and preparation for both structured and unstructured data.What you will learnIngest data from different sources and write them to required sinksProfile and validate data pipelines for better quality controlMaster grouping, merging, and joining structured dataHandle missing values and outliers in structured datasetsImplement techniques to manipulate and transform time series dataApply structure to text, image, voice and other unstructured dataWho this book is forWhether you’re a Data Analyst, Data Engineer, Data Scientist, or any data professional who relishes the task of data preparation and cleaning, this book is for you. It’s an ideal resource for upskilling in data cleaning concepts and expanding your knowledge across all types of data, from tabular to audio and video.Working knowledge of Python programming is needed to get the most out of the bookTable of ContentsData Ingestion SourcesImportance of Data QualityData Profiling and ValidationCleaning of Messy data and Data ManipulationData Transformation, Aggregation and GroupingData Destination SinksDetecting and Handle Missing Values and OutliersFeature Scaling and NormalizationHandling Categorical FeaturesConsume Times Series DataFrom Raw Text to Full TokenizationFrom clean Tokens to Text Structuring and Vector ModelsFrom Image Preprocessing to Video HandlingConsume Audio Data and Extract Audio from Video

Python Data Cleaning and Preparation Best Practices: A practical guide to organizing and handling data from various sources and formats using Python PDF

The list of books you might like