Another Word For It Patrick Durusau on Topic Maps and Semantic Diversity

June 11, 2016

My Data Is Dirty! Basic Spreadsheet Cleaning Functions

Filed under: Data Quality,Journalism,News,Reporting,Spreadsheets — Patrick Durusau @ 8:59 am

My Data Is Dirty! Basic Spreadsheet Cleaning Functions by Paul Bradshaw.

A sample from Paul Bradshaw’s new book, Finding Stories in Spreadsheets.

Data is always dirty but you don’t always need a hazmat suit and supporting army of technicians.

Paul demonstrates Excel functions (sniff, other spreadsheet programs have the same functions), TRIM, SUBSTITUTE, CHAR, as easy ways to clean data.

Certainly makes me interested in what other techniques are lurking in Finding Stories in Spreadsheets.

Enjoy!

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress