Data Cleaning 101

Описание: This lesson is an introduction to cleaning datasets obtained online or through public records requests. By completing this lesson, you will:

• Understand what data cleaning is and why it is necessary.
• Learn about free tools available to help clean data.
• Begin building your data cleaning skills.

REQUIREMENTS PRIOR TO CLASS

• Download OpenRefine (free) software:
https://openrefine.org/download.html

• Download a sample dataset:
http://www.nefac.org/files/2021/01/Di...

ABOUT YOUR INSTRUCTOR

Maggie Mulvihill is a veteran investigative and data journalist, journalism educator, news entrepreneur and impassioned defender of our right to know. Her data journalism students have been honored with 10 regional or national journalism awards since 2011 as well as being named finalists for the prestigious Livingston Award for Young Journalists. An attorney, Mulvihill is co-founder of the New England Center for Investigative Reporting. In 2014, Maggie founded BU’s summer workshops, Data + Narrative: Data-Driven Storytelling. She serves on the Steering Committee of the Reporter’s Committee for Freedom of the Press, the board of the New England First Amendment Coalition, was a 2004–2005 fellow at the Nieman Foundation for Journalism at Harvard University and was a 2014-2016 member of the Federal Freedom of Information Act Advisory Committee.

OTHER RESOURCES

• Using OpenRefine to Clean Your Data | Berkeley Graduate School of Journalism
https://multimedia.journalism.berkele...

• Clean Data with OpenRefine | Jack Dougherty & Ilya Ilyankou
https://handsondataviz.org/open-refin...

• Data Cleaning Part III: Open Refine | Matt Waite
http://mattwaite.github.io/datajourna...