Articles related to CSV files from the team that helps B2C companies build and defend revenue with AI.
This post is part of our data science series. The U.S. Census and American Community Survey (ACS) are the crown jewels of open data (bother your Representative today to make sure they stay that way), but working with data from the Census API isn't always intuitive. Here's an example
This post is part of our practical cartography and data science series. The problem: you want to split up a few million U.S. address records into equally-sized chunks that retain spatial hierarchy. You want to do this without anything other than a street address (geocoding is expensive!). Maybe you
This is part of our series on data science because it belongs in your toolchain. If you work with data long enough - actually scratch that; if you work with data for more than a week - you'll run into the dreaded multi sheet (or tab) excel workbook. Sometimes the
This is part of our series on data science because it belongs in your toolchain. Happy Null Removal! The latest version of scrubcsv has built-in null value removal: $ cat a.csv name,breed,age jerry,beagle,n/a tater,null,1 $ scrubcsv -n 'null|n/a' a.csv name,breed,
This post is part of our data science hacks series At Faraday, we've long used csvkit to understand, transform, and beat senseless our many streams of data. However, even this inimitable swiss army knife can be improved on - we've switched to xsv. xsv is a fast CSV-parsing toolkit written
This is part of our series on things that are obvious once you see them - and our data science series because it belongs in your toolchain. Lies, damn lies, and commercial CSV export modules. Who wrote these things? On what planet would this be acceptable? Whatever. Name,What's wrong