Skip to content

Instantly share code, notes, and snippets.

View 201513139's full-sized avatar
🏠
Working from home

Sebastian Acosta Alzate 201513139

🏠
Working from home
View GitHub Profile
@201513139
201513139 / Desplazamiento1999-2014.csv
Created February 1, 2016 17:40
Modulo2 ejercicio 1 Desplazamiento1999-2014
DEPARTAMENTO MUNICIPIO 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
ANTIOQUIA MEDELLIN 10040 4500 21000 23033 7436 19346 10043 16294 17301 26847 27284 17642 29460 16096 9952 2637
ANTIOQUIA ABEJORRAL 0 0 91 56 6 129 42 26 58 35 15 53 28 45 11 17
ANTIOQUIA ABRIAQUI 0 0 0 0 0 0 0 6 0 3 9 0 7 0 3
ANTIOQUIA ALEJANDRIA 0 0 860 0 0 0 10 12 13 37 7 11 3 0
ANTIOQUIA AMAGA 0 0 0 8 0 10 51 24 37 16 15 40 10 71 131 47
ANTIOQUIA AMALFI 0 0 50 0 4 21 0 22 39 48 31 149 5941 274 286 51
ANTIOQUIA ANDES 20 0 0 15 1 48 0 16 24 19 209 46 152 147 71
ANTIOQUIA ANGELOPOLIS 120 0 135 0 0 7 0 0 0 14 27 11 12 68 1
ANTIOQUIA ANGOSTURA 0 0 0 0 0 0 0 7 1 61 6 34 75 32
@201513139
201513139 / Desplazamiento1999-2014.csv
Last active February 1, 2016 17:08
Final Módulo 2 Ejercicio 1 Desplazamiento
ANTIOQUIA MEDELLIN 10040 4500 21000 23033 7436 19346 10043 16294 17301 26847 27284 17642 29460 16096 9952 2637
ANTIOQUIA ABEJORRAL 0 0 91 56 6 129 42 26 58 35 15 53 28 45 11 17
ANTIOQUIA ABRIAQUI 0 0 0 0 0 0 0 6 0 3 9 0 7 0 3
ANTIOQUIA ALEJANDRIA 0 0 860 0 0 0 10 12 13 37 7 11 3 0
ANTIOQUIA AMAGA 0 0 0 8 0 10 51 24 37 16 15 40 10 71 131 47
ANTIOQUIA AMALFI 0 0 50 0 4 21 0 22 39 48 31 149 5941 274 286 51
ANTIOQUIA ANDES 20 0 0 15 1 48 0 16 24 19 209 46 152 147 71
ANTIOQUIA ANGELOPOLIS 120 0 135 0 0 7 0 0 0 14 27 11 12 68 1
ANTIOQUIA ANGOSTURA 0 0 0 0 0 0 0 7 1 61 6 34 75 32
2014 / Zona Tabaco Alcohol Marihuana Cocaina Heroina Solventes Dicloruro de Metileno
AMAZONAS 3.368225 34.595886 4.607375 1.543694 0 0.586294 0
ANTIOQUIA 10.886005 47.329022 10.972273 2.865957 0.497533 1.688591 3.101438
ARAUCA 9.659589 33.332181 3.152234 1.283603 0 0.611541 0.510675
ATĹNTICO 4.483909 29.018518 1.825309 0.883011 0.31862 0.938537 0.756662
BOLIVAR 4.324339 29.763488 0.722897 0.227371 0.174698 0.815112 0.473296
BOYAĆ 8.899044 45.568031 2.280498 0.562468 0.103671 0.449074 0.738644
CALDAS 13.161194 48.560935 9.367684 2.213916 0.272056 2.483416 6.618303
CAQUET́ 5.258466 35.946157 3.146492 1.738705 0.672907 1.430933 1.475463
CASANARE 10.860631 40.087089 5.803023 0.929377 0.302526 1.057512 0.679221
@201513139
201513139 / Desplazamiento 1999-2014.csv
Created January 28, 2016 14:55
Módulo 2 ejercicio 1
ANTIOQUIA MEDELLIN 10040 4500 21000 23033 7436 19346 10043 16294 17301 26847 27284 17642 29460 16096 9952 2637
ANTIOQUIA ABEJORRAL 0 0 91 56 6 129 42 26 58 35 15 53 28 45 11 17
ANTIOQUIA ABRIAQUI 0 0 0 0 0 0 0 6 0 3 9 0 7 0 3
ANTIOQUIA ALEJANDRIA 0 0 860 0 0 0 10 12 13 37 7 11 3 0
ANTIOQUIA AMAGA 0 0 0 8 0 10 51 24 37 16 15 40 10 71 131 47
ANTIOQUIA AMALFI 0 0 50 0 4 21 0 22 39 48 31 149 5941 274 286 51
ANTIOQUIA ANDES 20 0 0 15 1 48 0 16 24 19 209 46 152 147 71
ANTIOQUIA ANGELOPOLIS 120 0 135 0 0 7 0 0 0 14 27 11 12 68 1
ANTIOQUIA ANGOSTURA 0 0 0 0 0 0 0 7 1 61 6 34 75 32
@201513139
201513139 / Desplazamiento 1999-2014.csv
Created January 27, 2016 20:01
ejemplo video 7 de gist para blocks
ANTIOQUIA MEDELLIN 10040 4500 21000 23033 7436 19346 10043 16294 17301 26847 27284 17642 29460 16096 9952 2637
ANTIOQUIA ABEJORRAL 0 0 91 56 6 129 42 26 58 35 15 53 28 45 11 17
ANTIOQUIA ABRIAQUI 0 0 0 0 0 0 0 6 0 3 9 0 7 0 3
ANTIOQUIA ALEJANDRIA 0 0 860 0 0 0 10 12 13 37 7 11 3 0
ANTIOQUIA AMAGA 0 0 0 8 0 10 51 24 37 16 15 40 10 71 131 47
ANTIOQUIA AMALFI 0 0 50 0 4 21 0 22 39 48 31 149 5941 274 286 51
ANTIOQUIA ANDES 20 0 0 15 1 48 0 16 24 19 209 46 152 147 71
ANTIOQUIA ANGELOPOLIS 120 0 135 0 0 7 0 0 0 14 27 11 12 68 1
ANTIOQUIA ANGOSTURA 0 0 0 0 0 0 0 7 1 61 6 34 75 32
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Ejercicio 1 Módulo 2</title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js" charset="utf-8">
<script src="https://gist.github.com/201513139/0f0358e2a87cbfc681df" charset="utf-8">
</script>
@201513139
201513139 / desplazamiento-1999-2014.xlsx - Desplazamiento 1999-2014.csv
Created January 25, 2016 20:47
Número de casos por desplazamiento a nivel municipal y departamental entre 1999 y 2014
DEPARTAMENTO MUNICIPIO 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
ANTIOQUIA MEDELLIN 10040 4500 21000 23033 7436 19346 10043 16294 17301 26847 27284 17642 29460 16096 9952 2637
ANTIOQUIA ABEJORRAL 0 0 91 56 6 129 42 26 58 35 15 53 28 45 11 17
ANTIOQUIA ABRIAQUI 0 0 0 0 0 0 0 6 0 3 9 0 7 0 3
ANTIOQUIA ALEJANDRIA 0 0 860 0 0 0 10 12 13 37 7 11 3 0
ANTIOQUIA AMAGA 0 0 0 8 0 10 51 24 37 16 15 40 10 71 131 47
ANTIOQUIA AMALFI 0 0 50 0 4 21 0 22 39 48 31 149 5941 274 286 51
ANTIOQUIA ANDES 20 0 0 15 1 48 0 16 24 19 209 46 152 147 71
ANTIOQUIA ANGELOPOLIS 120 0 135 0 0 7 0 0 0 14 27 11 12 68 1
ANTIOQUIA ANGOSTURA 0 0 0 0 0 0 0 7 1 61 6 34 75 32
@201513139
201513139 / Ministerio_de_Justicia_prevalencia_consumo_ultimo_ano_estudiantes - Ministerio_de_Justicia.prevalenciaconsumoultimoanoestudiantes.xls.csv
Created January 21, 2016 16:13
Número de casos sobre consumo de sustancias psicoactivas en Colombia por parte de la población estudiantil
2014 / Zona Tabaco Alcohol Marihuana Cocaina Heroina Solventes Dicloruro de Metileno
AMAZONAS 3.368225 34.595886 4.607375 1.543694 0 0.586294 0
ANTIOQUIA 10.886005 47.329022 10.972273 2.865957 0.497533 1.688591 3.101438
ARAUCA 9.659589 33.332181 3.152234 1.283603 0 0.611541 0.510675
ATLÁNTICO 4.483909 29.018518 1.825309 0.883011 0.31862 0.938537 0.756662
BOLIVAR 4.324339 29.763488 0.722897 0.227371 0.174698 0.815112 0.473296
BOYACÁ 8.899044 45.568031 2.280498 0.562468 0.103671 0.449074 0.738644
CALDAS 13.161194 48.560935 9.367684 2.213916 0.272056 2.483416 6.618303
CAQUETÁ 5.258466 35.946157 3.146492 1.738705 0.672907 1.430933 1.475463
CASANARE 10.860631 40.087089 5.803023 0.929377 0.302526 1.057512 0.679221
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 17 columns, instead of 5. in line 4.
the_geom,Business_N,Business_T,Business_A,Business_C,Business_S,Business_Z,Business_B,Business_O,Permitting,Location_T,Neighborho,Number_o_3,CV_for_N_1,SqMi,ZIP,ID_2
POINT (-122.41941327978273 37.78662965327916),Grass Roots,Medical Cannabis Dispensary,1077 Post St,San Francisco,California,94109,693017,"""Grass Roots Nonprofit Collective"," Inc.""",SFDPH,Fixed,Tenderloin,"532,593,654",2.7%,0.39280575812,94109
POINT (-122.42987786420763 37.771891944364775),Good Fellows Cannabis Club,Medical Cannabis Dispensary,473 Haight St,San Francisco,California,94117,859038,Mohamed Khatib,SFDPH,Fixed,Hayes Valley,"332,407,882",3.0%,0.49039175549,94117,2
POINT (-122.43852349455584 37.776067021942126),BASA,Medical Cannabis Dispensary,1328 Grove St,San Francisco,California,94117,1182005,"""Bay Area Safe Alternatives Collective"," Inc.""",SFDPH,Fixed,Hayes Valley,"332,407,882",3.0%,0.49039175549,94117
POINT (-122.47113174292065 37.780400497045804),Hemp Center (aka Patient Place),Medical Cannabis Dispensary,4811 Geary Blvd,San F
Lugar tabaco alcohol marihuana
ATLÁNTICO 853,141,000 3,023,728,800 127,047,200
BOLÍVAR 1,063,255,700 3,261,114,700 123,996,400
BOYACÁ 1,758,898,000 4,679,122,800 0.37303800
CALDAS 2,289,703,800 3,877,321,800 195,053,500
CAUCA 1,571,243,500 2,847,919,400 296,907,400
CESAR 1,045,895,900 2,619,613,800 0.61025400
CHOCO 978,844,900 2,782,513,300 153,740,100
CÓRDOBA 870,910,800 3,087,820,000 0.46424000
HUILA 905,660,100 2,580,005,200 0.05966200