CSV Fingerprint: Spot errors in your data at a glance

Posted to Apps  |  Tags: , ,  |  Nathan Yau

You get your CSV file, snuggle under your blanket with a glass of fine wine, all ready for the perfect Saturday night. Then — what the heck — there’s a bunch of missing data and poorly formatted entries. Don’t let this happen to you. CSV Fingerprint by Victor Powell provides a simple, wideout view of your CSV file, color-coded for quick quality control.

To make it easier to spot mistakes, I’ve made a “CSV Fingerprint” viewer (named after the “Fashion Fingerprints” from The New York Times’s “Front Row to Fashion Week” interactive ). The idea is to provide a birdseye view of the file without too much distracting detail. The idea is similar to Tufte’s Image Quilts…a qualitative view, as opposed to a rendering of the data in the file themselves. In this sense, the CSV Fingerprint is a sort of meta visualization.

Try it with your own CSV data. Never let a subpar CSV file ruin your Saturday night again.

Favorites

How to Spot Visualization Lies

Many charts don’t tell the truth. This is a simple guide to spotting them.

Years You Have Left to Live, Probably

The individual data points of life are much less predictable than the average. Here’s a simulation that shows you how much time is left on the clock.

10 Best Data Visualization Projects of 2017

It was a rough year, which brought about a lot of good work. Here are my favorite data visualization projects of the year.

Unemployment in America, Mapped Over Time

Watch the regional changes across the country from 1990 to 2016.