The Ellen Clarke Bertrand Library

Data: Data Cleaning

Tools and resources

The Quartz Guide to Bad Data

An exhaustive reference to problems seen in real-world data along with suggestions on how to resolve them.

Keep learning

Excel 2016: Cleaning Up Your Data (LinkedIn Learning)

An online course on LinkedIn Learning with transcripts, exercise files, and self-assessment quizzes. Explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert dates into the desired format, and prepare data for efficient analysis. Also covers adjusting column and row placement, transposing data with the REPLACE and SUBSTITUTE functions, the Text to Columns command, the Flash Fill feature, and more. 

Length: 2 hours, 20 minutes. (Free access with Bucknell login.)

Data Services Specialist

Agnes Jasinska's picture
Agnes Jasinska
chat loading...
Contact:
Bertrand Library Research Help
Area
ajj006@bucknell.edu
570.577.3309