bsweger

Useful Pandas Snippets

A personal diary of DataFrame munging over the years.

Data Types and Conversion

Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)

kingkool68

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('","') + '"';

chrislkeller

/**
 * 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();

dergachev

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application: