Skip to content

Instantly share code, notes, and snippets.

View vikjam's full-sized avatar
💭
👨🏾‍💻

vikjam

💭
👨🏾‍💻
View GitHub Profile
import xlrd
import os
import gzip
workbook = xlrd.open_workbook("example.xlsx")
worksheet = workbook.sheet_by_index(0)
for row_num in range(0, worksheet.nrows):
row_values = [v.value for v in worksheet.row(row_num) if v.value]
@vikjam
vikjam / memory-leaders.sh
Created June 29, 2015 14:19
Check top memory usage
ps -eo pmem,pcpu, vsize, user, pid, cmd | sort -k 1 -nr | head -15
@vikjam
vikjam / gSee.r
Last active August 29, 2015 14:22
Data viewer in R via gvisTable
library(googleVis)
gSee <- function(df) {
return(plot(gvisTable(df, options = list(showRowNumber = TRUE,
page = 'enable',
pageSize = 30))))
}
@vikjam
vikjam / quick_replace.py
Last active October 10, 2015 22:18
Quick replacement of colored pins by school attributes
#!/usr/local/bin/env python
"""
Assign colors to each school's pin
"""
from BeautifulSoup import BeautifulSoup
# Hash to store style values
styles = {}