Skip to content

Instantly share code, notes, and snippets.

View LuizArmesto's full-sized avatar

Luiz Armesto LuizArmesto

  • Gympass
  • São Paulo, SP, Brazil
View GitHub Profile
import os, os.path
import sys
import re
import requests
import lxml.html
class Scraper(object):
import itertools
import pandas as pd
anos = range(2003, 2015)
planilhas = {ano: pd.read_excel('basedadosexecucao{}.xls'.format(ano)) for ano in anos}
colunas = {ano: [col for col in planilha.columns] for ano, planilha in planilhas.iteritems()}
colunas_novas = sorted(list(set(list(itertools.chain(*[[col.upper() for col in cols] for _, cols in colunas.items()])))))
@LuizArmesto
LuizArmesto / datapackage2sqlalchemy.py
Created April 13, 2015 20:26
Create SQLAlchemy models and populate using DataPackage
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import unicodedata
import sqlalchemy
import sqlalchemy.orm
from datapackage import DataPackage
from datetime import date, timedelta
import os, os.path
import sys
import requests
import lxml.html
class DateIterator(object):
def __init__(self, start_date, end_date):
@LuizArmesto
LuizArmesto / map.preview.js
Created December 10, 2012 14:50
komoo_map preview
/**** Parte html ****/
<!-- Só criar quantos containers precisar //-->
<div id="preview1"></div>
<div id="preview2"></div>
<div id="preview3"></div>
/**** Parte javascript ****/
require(['jquery', 'map.jquery'], function($) {
/* Nao precisa criar esses objetos, soh criei para ter onde armazenar mais organizadamente algumas referencias */
var preview1 = {};
@LuizArmesto
LuizArmesto / exemplo-deferred.js
Created September 23, 2012 22:32
Exemplo simples de $.Deferred e $.when
// Funcao sincrona que devolve uma string
var devolveTextoSincrono = function ( valor ) {
return 'Devolve um texto concatenado com ' + valor;
};
// Funcao assincrona que devolve uma "promessa" de uma string
var devolveTextoAssincrono = function ( valor ) {
// Cria o objeto "deferred"
var dfd = $.Deferred();
@LuizArmesto
LuizArmesto / entry_personalizado_dinamicamente.py
Created April 18, 2012 19:28
Gtk.Entry personalizado dinamicamente
#!/usr/bin/env python
# -*- coding: utf-8 -*-
########################################################################
# #
# Licença: Este código é de uso livre, exceto para criar interfaces #
# horríveis que destoem e comprometam a coerência visual do ambiente #
# de trabalho do usuário ;) #
# #
########################################################################
@LuizArmesto
LuizArmesto / entry_personalizado.py
Created April 4, 2012 17:41
Gtk.Entry personalizado
#!/usr/bin/env python
# -*- coding: utf-8 -*-
########################################################################
# #
# Licença: Este código é de uso livre, exceto para criar interfaces #
# horríveis que destoem e comprometam a coerência visual do ambiente #
# de trabalho do usuário ;) #
# #
########################################################################