Towards Data Science: How to Download a Specific Sheet by Name from a Google Spreadsheet as a CSV File. “In the past two tutorials on Google Drive API with Python, we have covered how to obtain credentials here and search for a specific file in Google Drive by its name here. In this tutorial, we are going to learn how to download a specific Sheet by name from a Google Spreadsheet into a csv file. A use case for this: you need to generate a report, which data are stored in a Google Spreadsheet that has many Sheets, but you only need one or two of them. So, instead of downloading the whole Google Spreadsheet, you can handpick the Sheets that you need.”
From Twitter: the recently-released Russian Facebook ads are now available as a CSV file. From the Tweet: “The recently released Russian Facebook ads dataset was all in PDF format. One of our volunteers, @scottcame, has extracted the content and made it available as a CSV on @datadotworld.”
From a gentleman named Simon Willison, and this looks delicious: Datasette Publish: a web app for publishing CSV files as an online database. “I’ve just released Datasette Publish, a web tool for turning one or more CSV files into an online database with a JSON API. Here’s a demo application I built using Datasette Publish, showing Californian campaign finance data using CSV files released by the California Civic Data Coalition. And here’s an animated screencast showing exactly how I built it…” Are there are enough hours in the day? Find out in our next episode, THERE ARE NOT ENOUGH HOURS IN THE DAY.
BetaNews: Tad is a smarter CSV and data viewer. “Tad is a free cross-platform tool for viewing and analyzing CSV files and tabular data. Open a CSV file and it’s displayed in a simple table. Clicking column headers quickly sorts the data by that field, and you can drag and drop headers to reorder them. “