About one in five graph readers categorically misinterpreted bar graphs that depicted averages. "These readers sketched all, or nearly all, of the data points below the average," said Wilmer.

A psychology study found that bar graphs representing averages were prone to misinterpretation. Plus, how to improve your data literacy.

And that’s how we can manipulate XLS, JSON, and CSV files with csvkit. This tool might not be used very often, but when you need it, you’ll be happy it’s around.