Skip to Content
Head First Data Analysis
book

Head First Data Analysis

by Michael Milton
July 2009
Intermediate to advanced
483 pages
10h 38m
English
O'Reilly Media, Inc.
Content preview from Head First Data Analysis

Chapter 13. Cleaning Data: Impose order

image with no caption

Your data is useless...

...if it has messy structure. And a lot of people who collect data do a crummy job of maintaining a neat structure. If your data’s not neat, you can’t slice it or dice it, run formulas on it, or even really see it. You might as well just ignore it completely, right? Actually, you can do better. With a clear vision of how you need it to look and a few text manipulation tools, you can take the funkiest, craziest mess of data and whip it into something useful.

Just got a client list from a defunct competitor

Your newest client, Head First Head Hunters, just received a list of job seekers from a defunct competitor. They had to spend big bucks to get it, but it’s hugely valuable. The people on this list are the best of the best, the most employable people around.

This list could be a gold mine...

image with no caption

...too bad the data is a mess! In its current form, there’s not much they can do with this data. That’s why they called you. Can you help?

The dirty secret of data analysis

The dirty secret of data analysis is that as analyst you might spend more time cleaning data than analyzing it. Data often doesn’t arrive perfectly organized, so you’ll have to do some heavy text manipulation ...

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

Statistics for Data Science and Business Analysis

Statistics for Data Science and Business Analysis

365 Careers Ltd.
Head First Statistics

Head First Statistics

Dawn Griffiths

Publisher Resources

ISBN: 9780596806224Errata Page