CARwash: Data cleaning in Excel
Dirty data lurk everywhere: in text files, spreadsheets, databases and PDFs. We'll walk you through some examples of the most common types of dirty data, point out telltale signs of data illness and explain how you can whip data into shape using some simple tools and methods.
This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers.
Mark Nichols is data journalist on the national desk of USA TODAY. He has worked as a data specialist for the digital reporting team at WCPO-TV in Cincinnati, OH, and was the computer-assisted reporting coordinator for The Indianapolis Star for nearly 20 years. @nicholsmarkc
No tipsheets have yet been uploaded for this event.