Cleaning in SQL

  • Event: 2018 CAR Conference
  • Speaker: Madi Alexander of Bloomberg Government
  • Date/Time: Sunday, Mar. 11 at 10:15am
  • Location: Northwestern/Ohio St
  • Audio file: No audio file available.

Spend enough time around databases and inevitably you’ll come across one that has an obnoxious number of variations on city names: New York City. New York. NYC. NY. And yes, even NY City. If you’re not sure how to handle that, this session is for you. Come to “Data cleaning in SQL” if you’ve had an introduction to SQL but want to move past the basics of “WHERE” and “ORDER BY.” We’ll cover how to deal with multiple spellings and misspellings, strange date formats and category codes, as well as a few other tricks and tips for using SQL to clean data.

This session will be most useful if: You are familiar with basic SQL statements.

Speaker Bios

  • Madi Alexander is a data reporter for Bloomberg Government in Washington D.C., where she covers Congress, elections and campaign finance. She is originally from Moore, Oklahoma, and has a master's degree in journalism from the University of Missouri. Madi keeps a database of the national parks and historical sites she's visited, which so far is 38. @MadiLAlexander

Related Tipsheets

No tipsheets have yet been uploaded for this event.