Save time by discovering effortless strategies for cleaning, organizing, and manipulating your data
Is much of your time spent doing tedious tasks such as cleaning dirty data, accounting for lost data, and preparing data to be used by others? If so, then having the right tools makes a critical difference, and will be a great investment as you grow your data science expertise.
The book starts by highlighting the importance of data cleaning in data science, and will show you how to reap rewards from reforming your cleaning process. Next, you will cement your knowledge of the basic concepts that the rest of the book relies on: file formats, data types, and character encodings. You will also learn how to extract and clean data stored in RDBMS, web files, and PDF documents, through practical examples.
At the end of the book, you will be given a chance to tackle a couple of real-world projects.
What You Will Learn
Understand the role of data cleaning in the overall data science process
Learn the basics of file formats, data types, and character encodings to clean data properly
Master critical features of the spreadsheet and text editor for organizing and manipulating data
Convert data from one common format to another, including JSON, CSV, and some special-purpose formats
Implement three different strategies for parsing and cleaning data found in HTML files on the Web
Reveal the mysteries of PDF documents and learn how to pull out just the data you want
Develop a range of solutions for detecting and cleaning bad data stored in an RDBMS
Create your own clean data sets that can be packaged, licensed, and shared with others
Use the tools from this book to complete two real-world projects using data from Twitter and Stack Overflow
Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.