Lucio Villa luciovilla

Using the t and csvkit to quickly collect and analyze #migrahack tweets from the command-line

The t command-line Twitter tool is a great way to work with Twitter information in a spreadsheet.

Its homepage with good installation instructions is here:

And I've written some related instructions about how to get an authentication token from Twitter:

Quickly resize, convert, extract audio from videos and edit audio from the command line.

A complete, cross-platform solution to record, convert and stream audio and video. https://ffmpeg.org

Install Homebrew first

Quickly create, edit, compose or convert images from the command line.

www.imagemagick.org

$ brew install imagemagick

Quickly convert KML to GeoJSON or GeoJSON to SVG and concatenate multiple GeoJSON files via the terminal.

	gifify() {
	if [[ -n "$1" ]]; then
	if [[ $2 == '--good' ]]; then
	ffmpeg -i $1 -r 10 -vcodec png out-static-%05d.png
	time convert -verbose +dither -layers Optimize -resize 600x600\> out-static*.png GIF:- \| gifsicle --colors 128 --delay=5 --loop --optimize=3 --multifile - > $1.gif
	rm out-static*.png
	else
	ffmpeg -i $1 -s 600x400 -pix_fmt rgb24 -r 10 -f gif - \| gifsicle --optimize=3 --delay=3 > $1.gif
	fi
	else

	function getLat(address) {
	if (address == '') {
	Logger.log("Must provide an address");
	return;
	}
	var geocoder = Maps.newGeocoder();
	var location;
	// Geocode the address and plug the lat, lng pair into the
	// 2nd and 3rd elements of the current range row.
	location = geocoder.geocode(address);

	import csv
	import time
	from pygeocoder import Geocoder
	from pygeocoder import GeocoderError

	# We can only geocode up to 2500 properties a day (per IP Address)

	input_file = open('data.csv', 'r') # Opens the .csv file
	output_file = open('data_new.csv', 'w') # Make an empty .csv This is where your geocodes will end up.
	data = csv.reader(input_file)

	function dateConverter(timeStamp){
	var UNIX_timestamp = new Date(timeStamp.replace(/\s/, 'T')).getTime();
	var a = new Date(UNIX_timestamp);
	var months = ['Jan.','Feb.','March','April','May','June','July','Aug.','Sept.','Oct.','Nov.','Dec.'];
	var year = a.getFullYear();
	var month = months[a.getMonth()];
	var day = a.getDate();
	var time = month + ' ' + day + ', ' + year ;
	return time;
	}

	#!/usr/bin/node
	const { Octokit } = require('@octokit/rest')

	const octokit = new Octokit({
	auth: AUTH_TOKEN,
	})

	const addTeam2Repo = async () => {
	try {
	await octokit.teams.addOrUpdateRepoInOrg({