This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.
To capture the video (filesize: 19MB), using the free "QuickTime Player" application:
/** | |
* Retrieves all the rows in the active spreadsheet that contain data and logs the | |
* values for each row. | |
* For more information on using the Spreadsheet API, see | |
* https://developers.google.com/apps-script/service_spreadsheet | |
*/ | |
function readRows() { | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var rows = sheet.getDataRange(); | |
var numRows = rows.getNumRows(); |
jQuery( document ).ready( function($) { | |
var csv = "data:text/csv;charset=utf-8,"; | |
var csvData = []; | |
$('#content .post').each(function() { | |
$this = $(this); | |
csvData.push( [this.href, $this.find('h2').text(), $this.find('.meta span:last-of-type').text() ] ); | |
}); | |
for( i=0; i < csvData.length; i++ ) { | |
var row = '"' + csvData[i].join('","') + '"'; |
A personal diary of DataFrame munging over the years.
Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)