Skip to content

Instantly share code, notes, and snippets.

View jazzido's full-sized avatar
💭
𝄢

Manuel Aristarán jazzido

💭
𝄢
View GitHub Profile
@jazzido
jazzido / presu_bb.ipynb
Last active November 8, 2017 14:59
Análisis ejecución presupuesto Municipio de Bahía blanca
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jazzido
jazzido / README.md
Last active August 16, 2017 18:24
PASO 2017: Mesas en las que un único partido obtuvo votos (Diputados Nacionales)

Aclaración anti-boludos: si van a hacer escándalo, asegúrense de no estar diciendo cualquier cosa. Chequeen contra los telegramas publicados en resultados.gob.ar

@jazzido
jazzido / tunombre.ipynb
Last active August 12, 2017 20:09
Matrices y nombres
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jazzido
jazzido / US Visas.ipynb
Last active March 16, 2017 14:51
US Visas Issued to Argentines
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.

REPLACEME: Movie Graph

Introduction

@jazzido
jazzido / LICENSE.md
Last active December 16, 2016 04:42
Linked Micromaps Plots

Copyright (C) 2012-2013 Manuel Aristarán jazzido@jazzido.com

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all

@jazzido
jazzido / README.md
Last active November 15, 2016 00:10
Convirtiendo CSVs geográficos de datos.gba.gob.ar a formatos apropiados

Los datasets con información geográfica publicados en http://datos.gba.gob.ar están formato CSV. Para poder usarlos hace falta convertirlos a un formato apropiado. Tomando como ejemplo el dataset Recorrido de colectivos de líneas provinciales:

  1. Renombrar el CSV al nombre cole.csv.

  2. Crear un archivo input.vrt con este contenido

    <OGRVRTDataSource>
    

Keybase proof

I hereby claim:

  • I am jazzido on github.
  • I am manuelaristaran (https://keybase.io/manuelaristaran) on keybase.
  • I have a public key whose fingerprint is 2794 80C8 5BE6 4EC6 4236 A76B 3AE4 55E9 7D81 3620

To claim this, I am signing this object:

# -*- coding: utf-8 -*-
# very old (1999?) code for syllabification of spanish words
# based on this thesis: http://www.fismat.umich.mx/~karina/tesisLicenciatura/capitulo2.html
# Author: Manuel Aristarán (jazzido.com)
# License: Creative Commons Atribución 2.5 Argentina -- http://creativecommons.org/licenses/by/2.5/ar/
# usage: determina_caso('cadena de entrada')
vocales = u'aeiouyáéíóúÁÉÍÓÚAEIOUY'
WITH votos_summary AS
(SELECT ve.mesa_desde,
ve.mesa_hasta,
SUM(total) AS total_parcodigo,
ve.vot_parcodigo,
ve.dne_distri,
ve.dne_seccio,
row_number() over(partition BY ve.mesa_desde,ve.mesa_hasta
ORDER BY sum(total) DESC) AS rk
FROM votos_establecimiento_octubre ve