Ditch Excel and format your data with csvkit

Posted to Software  |  Tags: ,  |  Nathan Yau

I thought I linked to csvkit a while ago, but apparently not. If you deal with CSV data at all, you should know about the utilities suite that helps you format and re-format in various ways. Christopher Groskopf posted a list of quick things you can do with csvkit.

Over the last several months there have been two major releases of csvkit. These releases have brought long-awaited features such as Python 3 support, a csvformat utility and a new csvkit tutorial—not to mention a slew of bug fixes. To celebrate the latest release, here are eleven of my favorite awesome things you can do with csvkit. If you aren’t using it yet, hopefully this will convince you.

Fun things include a quick one-liner to convert an Excel file to CSV, switching to JSON, and easy CSV export from a database.

Favorites

Graphical perception – learn the fundamentals first

Before you dive into the advanced stuff – like just about everything in your life – you have to learn the fundamentals before you know when you can break the rules.

Most popular porn searches, by state

We’ve seen that we can learn from what people search for, through the eyes of Google suggestions: state stereotypes, national …

Shifting Incomes for American Jobs

For various occupations, the difference between the person who makes the most and the one who makes the least can be significant.

Causes of Death

There are many ways to die. Cancer. Infection. Mental. External. This is how different groups of people died over the past 10 years, visualized by age.