In [14]:
import pandas as pd
In [16]:
!head AportesDiario_2004.csv
"head" no se reconoce como un comando interno o externo,
programa o archivo por lotes ejecutable.
In [15]:
pd.read_csv('AportesDiario_2004.csv', sep=';', decimal=',', thousands='.', skiprows=3)
Out[15]:
01/01/2004
ANTIOQUIA
A. SAN LORENZO
17,56
3.910.000,00
72,27%
0
01/01/2004
ANTIOQUIA
CONCEPCION
6.15
1385300.0
123,69%
1
01/01/2004
ANTIOQUIA
DESV. EEPPM (NEC,PAJ,DOL)
11.43
2574700.0
147,13%
2
01/01/2004
ANTIOQUIA
GRANDE
18.65
4563500.0
79,23%
3
01/01/2004
ANTIOQUIA
GUADALUPE
11.28
2540900.0
80,15%
4
01/01/2004
ANTIOQUIA
GUATAPE
32.71
5405100.0
141,49%
5
01/01/2004
ANTIOQUIA
MIEL I
50.63
2214100.0
63,99%
6
01/01/2004
ANTIOQUIA
NARE
20.16
7057000.0
56,73%
7
01/01/2004
ANTIOQUIA
PORCE II
64.61
3242100.0
120,97%
8
01/01/2004
ANTIOQUIA
SAN CARLOS
12.80
1588700.0
70,92%
9
01/01/2004
ANTIOQUIA
TENCHE
1.81
407700.0
66,84%
10
01/01/2004
CARIBE
SINU URRA
152.23
1694100.0
86,88%
11
01/01/2004
CENTRO
BOGOTA N.R.
9.56
4152000.0
109,55%
12
01/01/2004
CENTRO
MAGDALENA BETANIA
194.95
2906000.0
68,54%
13
01/01/2004
CENTRO
PRADO
3.84
42100.0
8,10%
14
01/01/2004
ORIENTE
BATA
18.31
3013500.0
116,35%
15
01/01/2004
ORIENTE
CHUZA
1.96
851300.0
62,14%
16
01/01/2004
ORIENTE
GUAVIO
17.62
4231400.0
93,62%
17
01/01/2004
RIOS ESTIMADOS
OTROS RIOS (ESTIMADOS)
NaN
2755400.0
83,24%
18
01/01/2004
VALLE
ALTOANCHICAYA
29.75
3164200.0
72,41%
19
01/01/2004
VALLE
CALIMA
13.89
647800.0
124,58%
20
01/01/2004
VALLE
CAUCA SALVAJINA
122.69
2724000.0
73,42%
21
01/01/2004
VALLE
DIGUA
22.45
350800.0
85,56%
22
01/01/2004
VALLE
FLORIDA II
13.51
270200.0
207,85%
23
02/01/2004
ANTIOQUIA
A. SAN LORENZO
17.18
3825300.0
70,71%
24
02/01/2004
ANTIOQUIA
CONCEPCION
6.13
1380800.0
123,29%
25
02/01/2004
ANTIOQUIA
DESV. EEPPM (NEC,PAJ,DOL)
11.39
2565700.0
146,61%
26
02/01/2004
ANTIOQUIA
GRANDE
17.73
4338400.0
75,32%
27
02/01/2004
ANTIOQUIA
GUADALUPE
20.30
4572800.0
144,25%
28
02/01/2004
ANTIOQUIA
GUATAPE
18.00
2974400.0
77,86%
29
02/01/2004
ANTIOQUIA
MIEL I
70.57
3086100.0
89,19%
...
...
...
...
...
...
...
8753
30/12/2004
RIOS ESTIMADOS
OTROS RIOS (ESTIMADOS)
NaN
2604500.0
63,52%
8754
30/12/2004
VALLE
ALTOANCHICAYA
36.49
3859200.0
70,55%
8755
30/12/2004
VALLE
CALIMA
10.85
505900.0
69,30%
8756
30/12/2004
VALLE
CAUCA SALVAJINA
152.63
3381400.0
71,64%
8757
30/12/2004
VALLE
DIGUA
26.12
406600.0
71,33%
8758
30/12/2004
VALLE
FLORIDA II
8.23
164600.0
91,44%
8759
31/12/2004
ANTIOQUIA
A. SAN LORENZO
18.82
4112600.0
60,13%
8760
31/12/2004
ANTIOQUIA
CONCEPCION
5.16
1161900.0
77,46%
8761
31/12/2004
ANTIOQUIA
DESV. EEPPM (NEC,PAJ,DOL)
9.57
2154900.0
94,10%
8762
31/12/2004
ANTIOQUIA
GRANDE
23.37
5699700.0
71,25%
8763
31/12/2004
ANTIOQUIA
GUADALUPE
9.92
2233700.0
52,68%
8764
31/12/2004
ANTIOQUIA
GUATAPE
18.18
2939300.0
58,20%
8765
31/12/2004
ANTIOQUIA
MIEL I
76.67
3356700.0
72,66%
8766
31/12/2004
ANTIOQUIA
NARE
29.37
10178000.0
59,42%
8767
31/12/2004
ANTIOQUIA
PORCE II
74.85
3701300.0
105,15%
8768
31/12/2004
ANTIOQUIA
SAN CARLOS
14.26
1717800.0
51,28%
8769
31/12/2004
ANTIOQUIA
TENCHE
2.34
526900.0
61,99%
8770
31/12/2004
CARIBE
SINU URRA
163.31
1813900.0
56,68%
8771
31/12/2004
CENTRO
BOGOTA N.R.
3.81
1654700.0
16,97%
8772
31/12/2004
CENTRO
MAGDALENA BETANIA
253.18
3760000.0
67,75%
8773
31/12/2004
CENTRO
PRADO
30.68
329100.0
45,08%
8774
31/12/2004
ORIENTE
BATA
23.01
3783700.0
67,57%
8775
31/12/2004
ORIENTE
CHUZA
0.00
NaN
NaN
8776
31/12/2004
ORIENTE
GUAVIO
16.72
4013800.0
52,61%
8777
31/12/2004
RIOS ESTIMADOS
OTROS RIOS (ESTIMADOS)
NaN
2358400.0
57,52%
8778
31/12/2004
VALLE
ALTOANCHICAYA
23.50
2485400.0
45,44%
8779
31/12/2004
VALLE
CALIMA
9.16
427100.0
58,51%
8780
31/12/2004
VALLE
CAUCA SALVAJINA
151.79
3362800.0
71,25%
8781
31/12/2004
VALLE
DIGUA
20.79
323600.0
56,77%
8782
31/12/2004
VALLE
FLORIDA II
7.20
144000.0
80,00%
8783 rows × 6 columns
In [ ]:
Content source: sjmartin2228/diplomado2017
Similar notebooks: