In [1]:
xl = pd.ExcelFile('download/stats_clc_commune_niveau_3_RGF.xls')
In [2]:
xl.sheet_names
Out[2]:
[u'description',
u'nomenclature_clc_niveau_3',
u'CLC90',
u'CLC00',
u'CHANGEMENTS90_00',
u'CLC00_REVISE',
u'CHANGEMENTS00_06',
u'CLC06']
In [3]:
df = xl.parse('CLC06', index_col=None, na_values=['NA'])
df
Out[3]:
NUM_REG
NOM_REG
NUM_DEP
NOM_DEP
NUM_COM
NOM_COM
111
112
121
122
...
411
412
421
422
423
511
512
521
522
523
0
82
RHONE-ALPES
01
AIN
01001
L'ABERGEMENT-CLEMENCIAT
0.000000
62.289977
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
1
82
RHONE-ALPES
01
AIN
01002
L'ABERGEMENT-DE-VAREY
0.000000
0.000000
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
2
82
RHONE-ALPES
01
AIN
01004
AMBERIEU-EN-BUGEY
0.000000
446.603978
173.909504
67.156398
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
3
82
RHONE-ALPES
01
AIN
01005
AMBERIEUX-EN-DOMBES
0.000000
108.074041
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
184.330686
0
0
0
4
82
RHONE-ALPES
01
AIN
01006
AMBLEON
0.000000
33.098516
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
5
82
RHONE-ALPES
01
AIN
01007
AMBRONAY
0.000000
133.518241
103.907998
0.000000
...
0.000000
0
0
0
0
4.382519
60.398252
0
0
0
6
82
RHONE-ALPES
01
AIN
01008
AMBUTRIX
0.000000
56.151895
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
7
82
RHONE-ALPES
01
AIN
01009
ANDERT-ET-CONDON
0.000000
0.000000
0.000000
0.000000
...
32.187194
0
0
0
0
0.000000
0.000000
0
0
0
8
82
RHONE-ALPES
01
AIN
01010
ANGLEFORT
0.000000
25.344019
25.932470
91.419458
...
0.000000
0
0
0
0
106.960153
57.646582
0
0
0
9
82
RHONE-ALPES
01
AIN
01011
APREMONT
0.000000
26.230678
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
10
82
RHONE-ALPES
01
AIN
01012
ARANC
0.000000
0.000000
0.000000
0.000000
...
39.677836
0
0
0
0
0.000000
0.000000
0
0
0
11
82
RHONE-ALPES
01
AIN
01013
ARANDAS
0.000000
0.000000
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
12
82
RHONE-ALPES
01
AIN
01014
ARBENT
0.000000
174.208408
136.051309
0.000000
...
1.354706
0
0
0
0
0.000000
0.000000
0
0
0
13
82
RHONE-ALPES
01
AIN
01015
ARBIGNIEU
0.000000
33.936183
0.000000
0.000000
...
5.741270
0
0
0
0
0.000000
0.000000
0
0
0
14
82
RHONE-ALPES
01
AIN
01016
ARBIGNY
0.000000
61.065244
0.000000
0.000000
...
0.000000
0
0
0
0
22.293807
0.000000
0
0
0
15
82
RHONE-ALPES
01
AIN
01017
ARGIS
0.000000
0.000000
50.664508
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
16
82
RHONE-ALPES
01
AIN
01019
ARMIX
0.000000
0.000000
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
17
82
RHONE-ALPES
01
AIN
01021
ARS-SUR-FORMANS
0.000000
62.533236
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
18
82
RHONE-ALPES
01
AIN
01022
ARTEMARE
0.000000
66.514503
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
19
82
RHONE-ALPES
01
AIN
01023
ASNIERES-SUR-SAONE
0.000000
0.000000
0.000000
0.000000
...
0.000000
0
0
0
0
51.055690
0.000000
0
0
0
20
82
RHONE-ALPES
01
AIN
01024
ATTIGNAT
0.000000
228.586941
44.424691
0.000000
...
0.000000
0
0
0
0
0.000000
10.587362
0
0
0
21
82
RHONE-ALPES
01
AIN
01025
BAGE-LA-VILLE
0.000000
115.562081
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
22
82
RHONE-ALPES
01
AIN
01026
BAGE-LE-CHATEL
0.000000
43.958156
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
23
82
RHONE-ALPES
01
AIN
01027
BALAN
0.000000
87.599671
190.371342
0.000000
...
67.675817
0
0
0
0
38.710836
0.000000
0
0
0
24
82
RHONE-ALPES
01
AIN
01028
BANEINS
0.000000
26.755592
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
25
82
RHONE-ALPES
01
AIN
01029
BEAUPONT
0.000000
26.840613
0.000000
27.151095
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
26
82
RHONE-ALPES
01
AIN
01030
BEAUREGARD
0.000000
27.476847
0.000000
0.000000
...
0.000000
0
0
0
0
8.491665
0.000000
0
0
0
27
82
RHONE-ALPES
01
AIN
01031
BELLIGNAT
0.000000
74.090215
131.619739
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
28
82
RHONE-ALPES
01
AIN
01032
BELIGNEUX
0.000000
145.877895
24.521984
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
29
82
RHONE-ALPES
01
AIN
01033
BELLEGARDE-SUR-VALSERINE
33.948111
205.660111
67.404271
25.333752
...
0.000000
0
0
0
0
56.753338
0.000000
0
0
0
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
36560
11
ILE-DE-FRANCE
95
VAL-D'OISE
95574
SAINT-PRIX
0.000000
215.623292
0.051702
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36561
11
ILE-DE-FRANCE
95
VAL-D'OISE
95580
SAINT-WITZ
0.000000
107.947529
84.720491
0.229701
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36562
11
ILE-DE-FRANCE
95
VAL-D'OISE
95582
SANNOIS
0.000000
386.673888
0.007628
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36563
11
ILE-DE-FRANCE
95
VAL-D'OISE
95584
SANTEUIL
0.000000
34.108859
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36564
11
ILE-DE-FRANCE
95
VAL-D'OISE
95585
SARCELLES
0.000000
546.559864
80.406130
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36565
11
ILE-DE-FRANCE
95
VAL-D'OISE
95592
SERAINCOURT
0.000000
71.450254
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36566
11
ILE-DE-FRANCE
95
VAL-D'OISE
95594
SEUGY
0.000000
39.703132
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36567
11
ILE-DE-FRANCE
95
VAL-D'OISE
95598
SOISY-SOUS-MONTMORENCY
0.000000
343.319272
16.501671
0.000000
...
0.000000
0
0
0
0
0.000000
0.579585
0
0
0
36568
11
ILE-DE-FRANCE
95
VAL-D'OISE
95604
SURVILLIERS
0.000000
89.488817
33.740485
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36569
11
ILE-DE-FRANCE
95
VAL-D'OISE
95607
TAVERNY
0.000000
480.641376
51.139032
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36570
11
ILE-DE-FRANCE
95
VAL-D'OISE
95610
THEMERICOURT
0.000000
0.733049
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36571
11
ILE-DE-FRANCE
95
VAL-D'OISE
95611
THEUVILLE
0.000000
0.000000
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36572
11
ILE-DE-FRANCE
95
VAL-D'OISE
95612
LE THILLAY
0.000000
132.472279
54.469881
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36573
11
ILE-DE-FRANCE
95
VAL-D'OISE
95625
US
0.000000
68.694831
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36574
11
ILE-DE-FRANCE
95
VAL-D'OISE
95627
VALLANGOUJARD
0.000000
47.856298
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36575
11
ILE-DE-FRANCE
95
VAL-D'OISE
95628
VALMONDOIS
0.000000
84.703294
0.000000
0.000000
...
0.000000
0
0
0
0
1.122496
0.000000
0
0
0
36576
11
ILE-DE-FRANCE
95
VAL-D'OISE
95633
VAUDHERLAND
0.000000
0.000000
9.880173
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36577
11
ILE-DE-FRANCE
95
VAL-D'OISE
95637
VAUREAL
0.000000
250.478663
0.000000
0.000000
...
0.000000
0
0
0
0
7.454967
0.000000
0
0
0
36578
11
ILE-DE-FRANCE
95
VAL-D'OISE
95641
VEMARS
0.000000
58.119346
0.000000
75.480637
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36579
11
ILE-DE-FRANCE
95
VAL-D'OISE
95651
VETHEUIL
0.000000
57.689945
0.000000
0.000000
...
0.000000
0
0
0
0
17.733845
0.000000
0
0
0
36580
11
ILE-DE-FRANCE
95
VAL-D'OISE
95652
VIARMES
0.000000
179.420385
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36581
11
ILE-DE-FRANCE
95
VAL-D'OISE
95656
VIENNE-EN-ARTHIES
0.000000
31.692022
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36582
11
ILE-DE-FRANCE
95
VAL-D'OISE
95658
VIGNY
0.000000
112.796947
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36583
11
ILE-DE-FRANCE
95
VAL-D'OISE
95660
VILLAINES-SOUS-BOIS
0.000000
30.987645
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36584
11
ILE-DE-FRANCE
95
VAL-D'OISE
95675
VILLERON
0.000000
0.000000
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36585
11
ILE-DE-FRANCE
95
VAL-D'OISE
95676
VILLERS-EN-ARTHIES
0.000000
0.000000
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36586
11
ILE-DE-FRANCE
95
VAL-D'OISE
95678
VILLIERS-ADAM
0.000000
76.657485
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36587
11
ILE-DE-FRANCE
95
VAL-D'OISE
95680
VILLIERS-LE-BEL
0.000000
302.017264
23.754590
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36588
11
ILE-DE-FRANCE
95
VAL-D'OISE
95682
VILLIERS-LE-SEC
0.000000
29.645732
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36589
11
ILE-DE-FRANCE
95
VAL-D'OISE
95690
WY-DIT-JOLI-VILLAGE
0.000000
26.842348
0.000000
0.000000
...
0.000000
0
0
0
0
0.000000
0.000000
0
0
0
36590 rows × 50 columns
In [4]:
df.set_index('NUM_COM', inplace=True)
df.index.name = 'dc'
df.drop(['NUM_REG', 'NOM_REG', 'NUM_DEP', 'NOM_DEP', 'NOM_COM'], axis=1, inplace=True)
In [5]:
df.to_csv('data/clc2006.tsv', delimiter='\t')
In [6]:
#st = pd.HDFStore('data/data.h5')
#st['clc2006'] = df
#st.close()
In [7]:
df.to_hdf('data/data.h5','clc2006', format='f')
/home/philippe/anaconda/lib/python2.7/site-packages/pandas/io/pytables.py:2453: PerformanceWarning:
your performance may suffer as PyTables will pickle object types that it cannot
map directly to c-types [inferred_type->unicode,key->axis0] [items->None]
warnings.warn(ws, PerformanceWarning)
/home/philippe/anaconda/lib/python2.7/site-packages/pandas/io/pytables.py:2453: PerformanceWarning:
your performance may suffer as PyTables will pickle object types that it cannot
map directly to c-types [inferred_type->unicode,key->axis1] [items->None]
warnings.warn(ws, PerformanceWarning)
/home/philippe/anaconda/lib/python2.7/site-packages/pandas/io/pytables.py:2453: PerformanceWarning:
your performance may suffer as PyTables will pickle object types that it cannot
map directly to c-types [inferred_type->unicode,key->block0_items] [items->None]
warnings.warn(ws, PerformanceWarning)
/home/philippe/anaconda/lib/python2.7/site-packages/pandas/io/pytables.py:2453: PerformanceWarning:
your performance may suffer as PyTables will pickle object types that it cannot
map directly to c-types [inferred_type->unicode,key->block1_items] [items->None]
warnings.warn(ws, PerformanceWarning)
Content source: philippechataignon/notebook
Similar notebooks: