Excel CARwash: Cleaning dirty data

  • Event: 2019 CAR Conference
  • Speaker: Jennifer Smith Richards of Chicago Tribune
  • Date/Time: Friday, Mar. 8 at 3:30pm
  • Location: Diamond Cove - conference level
  • Audio file: No audio file available.

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.

Speaker Bios

  • Jennifer Smith Richards has been a data reporter at the Chicago Tribune since 2015. Smith Richards previously covered schools and education for more than a decade at newspapers in Huntington, W.Va.; Utica, N.Y.; Savannah, Ga.; and Columbus, Ohio. Her work has touched on everything from sexual abuse in schools to police accountability to school choice. 

Related Tipsheets

No tipsheets have yet been uploaded for this event.