-
Notifications
You must be signed in to change notification settings - Fork 0
/
column_dict.py
367 lines (350 loc) · 22.3 KB
/
column_dict.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
# declarations of useful variables
# english translation dictionnary
import json
import os
import pandas as pd
column_dict_reptiles = {
'catalog_number': {'type': int, 'file_name': 'NumeroDeCatalogo', 'selected': True},
'cataloged_date':{'type': str, 'file_name': 'DataDeEntrada', 'selected': False},
'determined_date':{'type': str, 'file_name': 'DataDaDeterminacao', 'selected': False},
'collected_date':{'type': str, 'file_name': 'DataColetaInicial', 'selected': False},
'year_cataloged':{'type': int, 'file_name': 'ano_entrada', 'selected': True},
'month_cataloged':{'type': int, 'file_name': 'mes_entrada', 'selected': True},
'month_determined':{'type': int, 'file_name': 'mes_determinacao', 'selected': True},
'year_collected':{'type': int, 'file_name': 'ano_coleta', 'selected': True},
'month_collected':{'type': int, 'file_name': 'mes_coleta', 'selected': True},
'class':{'type': str, 'file_name': 'Class', 'selected': True},
'kingdom':{'type': str, 'file_name': 'Kingdom', 'selected': True},
'genus_old':{'type': str, 'file_name': 'Genero_ent', 'selected': False},
'genus':{'type': str, 'file_name': 'Genero_atual', 'selected': True},
'species_old':{'type': str, 'file_name': 'Especie_ent', 'selected': True},
'species':{'type': str, 'file_name': 'Especie_atual', 'selected': True},
'subspecies':{'type': str, 'file_name': 'Subespecie_atual', 'selected': True},
'subspecies_old':{'type': str, 'file_name': 'Subespecie_ent', 'selected': True},
'type_status':{'type': str, 'file_name': 'type_status', 'selected': True},
'determinator_full_name':{'type': str, 'file_name': 'DeterminatorFirst_and_LastName1', 'selected': True},
'collector_full_name':{'type': str, 'file_name': 'CollectorFirst_and_LastName1', 'selected': True},
'altitude':{'type': float, 'file_name': 'altitude', 'selected': True},
'max_altitude':{'type': float, 'file_name': 'max_altitude', 'selected': True},
'order':{'type': str, 'file_name': 'Ordem', 'selected': True},
'suborder':{'type': str, 'file_name': 'Subordem', 'selected': True},
'family':{'type': str, 'file_name': 'Familia', 'selected': True},
'phylum':{'type': str, 'file_name': 'Phylum', 'selected': True},
'qualifier':{'type': str, 'file_name': 'Qualificador_atual', 'selected': True},
'lat':{'type': float, 'file_name': 'Lat', 'selected': True},
'long':{'type': float, 'file_name': 'Long', 'selected': True},
'municipio':{'type': str, 'file_name': 'Municipio', 'selected': True},
'state':{'type': str, 'file_name': 'EstadoOuProvincia', 'selected': True},
'country':{'type': str, 'file_name': 'Pais', 'selected': True},
'continent':{'type': str, 'file_name': 'Continente', 'selected': True},
'region':{'type': str, 'file_name': 'region', 'selected': True},
'lost_in_fire':{'type': int, 'file_name': 'lost_in_fire', 'selected': True},
'year_determined':{'type': int, 'file_name': 'year_determined', 'selected': True},
'author_full':{'type': str, 'file_name': 'author_full', 'selected': True},
'first_author':{'type': str, 'file_name': 'first_author', 'selected': False},
'locality':{'type': str, 'file_name': 'NomeDaLocalidade', 'selected': True},
'min_depth':{'type': float, 'file_name': 'altitude', 'selected': True}, ####
'max_depth':{'type': float, 'file_name': 'max_altitude', 'selected': True}, ###
}
column_dict_crustacea = {
# Catalogo
'catalog_number': {'type': int, 'file_name': 'CatalogNumber', 'selected': True},
'cataloged_date':{'type': str, 'file_name': 'Cataloged Date', 'selected': False},
'determined_date':{'type': str, 'file_name': '', 'selected': False},
'collected_date':{'type': str, 'file_name': 'Start Date', 'selected': False},
'year_cataloged':{'type': int, 'file_name': '', 'selected': True},
'month_cataloged':{'type': int, 'file_name': '', 'selected': True},
# Taxons
'kingdom':{'type': str, 'file_name': 'Kingdom', 'selected': True},
'phylum':{'type': str, 'file_name': 'Phylum1', 'selected': True},
'class':{'type': str, 'file_name': 'Class1', 'selected': True},
'order':{'type': str, 'file_name': 'Order1', 'selected': True},
'suborder':{'type': str, 'file_name': 'Suborder1', 'selected': True},
'infraorder':{'type': str, 'file_name': 'Infraorder1', 'selected': True},
'family':{'type': str, 'file_name': 'Family1', 'selected': True},
'genus_old':{'type': str, 'file_name': '', 'selected': False},
'genus':{'type': str, 'file_name': 'Genus1', 'selected': True},
'species_old':{'type': str, 'file_name': '', 'selected': False},
'species':{'type': str, 'file_name': 'Species1', 'selected': True},
'subspecies':{'type': str, 'file_name': '', 'selected': False},
'subspecies_old':{'type': str, 'file_name': '', 'selected': False},
# Identificador
'month_determined':{'type': int, 'file_name': '', 'selected': True},
'year_determined':{'type': int, 'file_name': '', 'selected': True},
'qualifier':{'type': str, 'file_name': 'Qualifier1', 'selected': True},
'type_status':{'type': str, 'file_name': 'Type Status1', 'selected': True},
'determinator_full_name':{'type': str, 'file_name': 'determinator_full_name1', 'selected': True},
'author_full':{'type': str, 'file_name': 'Species Author1', 'selected': True},
'first_author':{'type': str, 'file_name': '', 'selected': False},
# Coletores
'year_collected':{'type': int, 'file_name': '', 'selected': True},
'month_collected':{'type': int, 'file_name': '', 'selected': True},
'collector_full_name':{'type': str, 'file_name': 'collector_full_name1', 'selected': True},
'collector_full_name2':{'type': str, 'file_name': 'collector_full_name2', 'selected': True},
'collector_full_name3':{'type': str, 'file_name': 'collector_full_name3', 'selected': True},
'collector_full_name4':{'type': str, 'file_name': 'collector_full_name4', 'selected': True},
'collector_full_name5':{'type': str, 'file_name': 'collector_full_name5', 'selected': True},
'collector_full_name6':{'type': str, 'file_name': 'collector_full_name6', 'selected': True},
'collector_full_name7':{'type': str, 'file_name': 'collector_full_name7', 'selected': True},
# Profundidade e Localização
'min_depth':{'type': float, 'file_name': 'StartDepth', 'selected': True},
'max_depth':{'type': float, 'file_name': 'EndDepth', 'selected': True},
'lat':{'type': float, 'file_name': 'Latitude1', 'selected': True},
'long':{'type': float, 'file_name': 'Longitude1', 'selected': True},
'municipio':{'type': str, 'file_name': '', 'selected': False},
'state':{'type': str, 'file_name': 'State', 'selected': True},
'country':{'type': str, 'file_name': 'Country', 'selected': True},
'continent':{'type': str, 'file_name': 'Continent', 'selected': True},
'region':{'type': str, 'file_name': 'County', 'selected': True},
'locality':{'type': str, 'file_name': 'Locality Name', 'selected': True},
'lost_in_fire':{'type': int, 'file_name': '', 'selected': False},
}
# column_dict_crustacea_old = {
# 'catalog_number': {'type': int, 'file_name': 'CatalogNumber', 'selected': True},
# 'cataloged_date':{'type': str, 'file_name': 'Cataloged Date', 'selected': False},
# 'determined_date':{'type': str, 'file_name': '', 'selected': False},
# 'collected_date':{'type': str, 'file_name': 'Start Date', 'selected': False},
# 'year_cataloged':{'type': int, 'file_name': '', 'selected': True},
# 'month_cataloged':{'type': int, 'file_name': '', 'selected': True},
# 'month_determined':{'type': int, 'file_name': '', 'selected': True},
# 'year_collected':{'type': int, 'file_name': '', 'selected': True},
# 'month_collected':{'type': int, 'file_name': '', 'selected': True},
# 'class':{'type': str, 'file_name': 'Class1', 'selected': True},
# 'kingdom':{'type': str, 'file_name': 'Kingdom', 'selected': True},
# 'genus_old':{'type': str, 'file_name': '', 'selected': False},
# 'genus':{'type': str, 'file_name': 'Genus1', 'selected': True},
# 'species_old':{'type': str, 'file_name': '', 'selected': False},
# 'species':{'type': str, 'file_name': 'Species1', 'selected': True},
# 'subspecies':{'type': str, 'file_name': '', 'selected': False},
# 'subspecies_old':{'type': str, 'file_name': '', 'selected': False},
# 'type_status':{'type': str, 'file_name': 'Type Status1', 'selected': True},
# 'determinator_full_name':{'type': str, 'file_name': 'determinator_full_name1', 'selected': True},
# 'collector_full_name':{'type': str, 'file_name': 'collector_full_name1', 'selected': True},
# 'min_depth':{'type': float, 'file_name': 'StartDepth', 'selected': True},
# 'max_depth':{'type': float, 'file_name': 'EndDepth', 'selected': True},
# 'order':{'type': str, 'file_name': 'Order1', 'selected': True},
# 'suborder':{'type': str, 'file_name': 'Suborder1', 'selected': True},
# 'family':{'type': str, 'file_name': 'Family1', 'selected': True},
# 'phylum':{'type': str, 'file_name': 'Phylum1', 'selected': True},
# 'qualifier':{'type': str, 'file_name': 'Qualifier1', 'selected': True},
# 'lat':{'type': float, 'file_name': 'Latitude1', 'selected': True},
# 'long':{'type': float, 'file_name': 'Longitude1', 'selected': True},
# 'municipio':{'type': str, 'file_name': '', 'selected': False},
# 'state':{'type': str, 'file_name': 'State', 'selected': True},
# 'country':{'type': str, 'file_name': 'Country', 'selected': True},
# 'continent':{'type': str, 'file_name': 'Continent', 'selected': True},
# 'region':{'type': str, 'file_name': 'County', 'selected': True},
# 'lost_in_fire':{'type': int, 'file_name': '', 'selected': False},
# 'year_determined':{'type': int, 'file_name': '', 'selected': True},
# 'author_full':{'type': str, 'file_name': 'Species Author Name 1', 'selected': True},
# 'first_author':{'type': str, 'file_name': '', 'selected': False},
# 'infraorder':{'type': str, 'file_name': 'Infraorder1', 'selected': True},
# 'locality':{'type': str, 'file_name': 'Locality Name', 'selected': True},
# }
column_dict_polychaete = {
# Dados Temporais
'catalog_number':{'type':str,'file_name':'Catalog Number','selected': True},
'cataloged_date':{'type': str, 'file_name': 'Cataloged Date', 'selected': False},
#'determined_date':{'type': str, 'file_name': 'Cataloged Date' , 'selected': False},#'Determined date 1', 'selected': False},
'collected_date':{'type': str, 'file_name': 'Start Date', 'selected': False},
'year_cataloged':{'type': int, 'file_name': '', 'selected': True},
'month_cataloged':{'type': int, 'file_name': '', 'selected': True},
#'year_determined':{'type': int, 'file_name': '', 'selected': True},
#'month_determined':{'type': int, 'file_name': '', 'selected': True},
'year_collected':{'type': int, 'file_name': '', 'selected': True},
'month_collected':{'type': int, 'file_name': '', 'selected': True},
# Dados Geograficos
'lat':{'type': float, 'file_name': 'Latitude', 'selected': True},
'long':{'type': float, 'file_name': 'Longitude', 'selected': True},
'municipio':{'type': str, 'file_name': '', 'selected': False},
'state':{'type': str, 'file_name': 'State', 'selected': True},
'country':{'type': str, 'file_name': 'Country', 'selected': True},
'continent':{'type': str, 'file_name': 'Continent', 'selected': True},
'region':{'type': str, 'file_name': 'County', 'selected': True},
'locality':{'type': str, 'file_name': 'Locality Name', 'selected': True},
# Profundidade
'min_depth':{'type': float, 'file_name': 'Min Depth', 'selected': True},
'max_depth':{'type': float, 'file_name': 'Max Depth', 'selected': True},
# Dados Cientificos
'kingdom':{'type': str, 'file_name': 'Kingdom', 'selected': True},
'phylum':{'type': str, 'file_name': 'Phylum 1', 'selected': True},
'class':{'type': str, 'file_name': 'Class 1', 'selected': True},
'order':{'type': str, 'file_name': 'Order 1', 'selected': True},
#'suborder':{'type': str, 'file_name': 'Suborder1', 'selected': True},
'family':{'type': str, 'file_name': 'Family 1', 'selected': True},
'genus_old':{'type': str, 'file_name': '', 'selected': False},
'genus':{'type': str, 'file_name': 'Genus 1', 'selected': True},
'species_old':{'type': str, 'file_name': '', 'selected': False},
'species':{'type': str, 'file_name': 'Species 1', 'selected': True},
'subspecies':{'type': str, 'file_name': '', 'selected': False},
'subspecies_old':{'type': str, 'file_name': '', 'selected': False},
'type_status':{'type': str, 'file_name': 'Type Status 1', 'selected': True},
'qualifier':{'type': str, 'file_name': 'Qualifier 1', 'selected': True},
# Dados dos Cientistas
'determinator_full_name':{'type': str, 'file_name': 'Determiner 1 complete name', 'selected': True},
'determinator_full_name2':{'type': str, 'file_name': 'Determiner 2 complete name', 'selected': True},
'determinator_full_name3':{'type': str, 'file_name': 'Determiner 3 complete name', 'selected': True},
'collector_full_name':{'type': str, 'file_name': 'collector complete name 1', 'selected': True},
'author_full':{'type': str, 'file_name': '', 'selected': False},
'first_author':{'type': str, 'file_name': '', 'selected': False},
'lost_in_fire':{'type': int, 'file_name': '', 'selected': False},
}
column_dict_polychaete_MN = {
# Dados Temporais
'catalog_number':{'type':str,'file_name':'Catalog Number','selected': True},
'cataloged_date':{'type': str, 'file_name': 'Cataloged Date', 'selected': False}, ###############
#'determined_date':{'type': str, 'file_name': 'Cataloged Date' , 'selected': False},#'Determined date 1', 'selected': False},
'collected_date':{'type': str, 'file_name': 'Start Date', 'selected': False},
'year_cataloged':{'type': int, 'file_name': '', 'selected': True},
'month_cataloged':{'type': int, 'file_name': '', 'selected': True},
#'year_determined':{'type': int, 'file_name': '', 'selected': True},
#'month_determined':{'type': int, 'file_name': '', 'selected': True},
'year_collected':{'type': int, 'file_name': '', 'selected': True},
'month_collected':{'type': int, 'file_name': '', 'selected': True},
# Dados Geograficos
'lat':{'type': float, 'file_name': 'Latitude1', 'selected': True},
'long':{'type': float, 'file_name': 'Longitude1', 'selected': True},
'municipio':{'type': str, 'file_name': '', 'selected': False},
'state':{'type': str, 'file_name': 'State', 'selected': True},
'country':{'type': str, 'file_name': 'Country', 'selected': True},
'continent':{'type': str, 'file_name': 'Continent', 'selected': True},
'region':{'type': str, 'file_name': 'County', 'selected': True},
'locality':{'type': str, 'file_name': 'Locality Name', 'selected': True},
# Profundidade
'min_depth':{'type': float, 'file_name': 'Min Depth', 'selected': True},
'max_depth':{'type': float, 'file_name': 'Max Depth', 'selected': True},
# Dados Cientificos
'kingdom':{'type': str, 'file_name': 'Kingdom', 'selected': True},
'phylum':{'type': str, 'file_name': 'Phylum 1', 'selected': True},
'class':{'type': str, 'file_name': 'Class 1', 'selected': True},
'order':{'type': str, 'file_name': 'Order 1', 'selected': True},
#'suborder':{'type': str, 'file_name': 'Suborder1', 'selected': True},
'family':{'type': str, 'file_name': 'Family 1', 'selected': True},
'genus_old':{'type': str, 'file_name': '', 'selected': False},
'genus':{'type': str, 'file_name': 'Genus 1', 'selected': True},
'species_old':{'type': str, 'file_name': '', 'selected': False},
'species':{'type': str, 'file_name': 'Species 1', 'selected': True},
'subspecies':{'type': str, 'file_name': '', 'selected': False},
'subspecies_old':{'type': str, 'file_name': '', 'selected': False},
'type_status':{'type': str, 'file_name': 'Type Status 1', 'selected': True},
'qualifier':{'type': str, 'file_name': 'Qualifier 1', 'selected': True},
# Dados dos Cientistas
'determinator_full_name':{'type': str, 'file_name': 'Determiner Complete Name', 'selected': True},
'collector_full_name':{'type': str, 'file_name': 'Collector 1 complete name', 'selected': True},
'author_full':{'type': str, 'file_name': '', 'selected': False},
'first_author':{'type': str, 'file_name': '', 'selected': False},
'lost_in_fire':{'type': int, 'file_name': '', 'selected': False},
}
column_dict_annelida = {
# Dados Temporais
'catalog_number':{'type':str,'file_name':'CatalogNumber','selected': True},
'cataloged_date':{'type': str, 'file_name': 'CatalogedDate', 'selected': False}, ###############
#'determined_date':{'type': str, 'file_name': 'Cataloged Date' , 'selected': False},#'Determined date 1', 'selected': False},
'collected_date':{'type': str, 'file_name': 'StartDate', 'selected': False},
'year_cataloged':{'type': int, 'file_name': '', 'selected': True},
'month_cataloged':{'type': int, 'file_name': '', 'selected': True},
#'year_determined':{'type': int, 'file_name': '', 'selected': True},
#'month_determined':{'type': int, 'file_name': '', 'selected': True},
'year_collected':{'type': int, 'file_name': '', 'selected': True},
'month_collected':{'type': int, 'file_name': '', 'selected': True},
# Dados Geograficos
'lat':{'type': float, 'file_name': 'Latitude1', 'selected': True},
'long':{'type': float, 'file_name': 'Longitude1', 'selected': True},
'municipio':{'type': str, 'file_name': '', 'selected': False},
'state':{'type': str, 'file_name': 'State', 'selected': True},
'country':{'type': str, 'file_name': 'Country', 'selected': True},
'continent':{'type': str, 'file_name': 'Continent', 'selected': True},
'region':{'type': str, 'file_name': 'County', 'selected': True},
'locality':{'type': str, 'file_name': 'LocalityName', 'selected': True},
# Profundidade
'min_depth':{'type': float, 'file_name': 'StartDepth', 'selected': True},
'max_depth':{'type': float, 'file_name': 'EndDepth', 'selected': True},
# Dados Cientificos
'kingdom':{'type': str, 'file_name': 'Kingdom', 'selected': True},
'phylum':{'type': str, 'file_name': 'Phylum', 'selected': True},
'class':{'type': str, 'file_name': 'Class', 'selected': True},
'order':{'type': str, 'file_name': 'Order', 'selected': True},
#'suborder':{'type': str, 'file_name': 'Suborder1', 'selected': True},
'family':{'type': str, 'file_name': 'Family', 'selected': True},
'genus_old':{'type': str, 'file_name': '', 'selected': False},
'genus':{'type': str, 'file_name': 'Genus', 'selected': True},
'species_old':{'type': str, 'file_name': '', 'selected': False},
'species':{'type': str, 'file_name': 'Species', 'selected': True},
'subspecies':{'type': str, 'file_name': '', 'selected': False},
'subspecies_old':{'type': str, 'file_name': '', 'selected': False},
'type_status':{'type': str, 'file_name': 'TypeStatus', 'selected': True},
'qualifier':{'type': str, 'file_name': 'Qualifier', 'selected': True},
# Dados dos Cientistas
'determinator_full_name':{'type': str, 'file_name': 'determinator_full_name', 'selected': True},
'collector_full_name':{'type': str, 'file_name': 'collector_full_name1', 'selected': True},
'collector_full_name2':{'type': str, 'file_name': 'collector_full_name2', 'selected': True},
'collector_full_name3':{'type': str, 'file_name': 'collector_full_name3', 'selected': True},
'author_full':{'type': str, 'file_name': 'SpeciesAuthor', 'selected': True},
'first_author':{'type': str, 'file_name': '', 'selected': False},
'lost_in_fire':{'type': int, 'file_name': '', 'selected': False},
}
column_dict_GBIF = {
'catalog_number': {'type': int, 'file_name': 'catalogNumber', 'selected': True},
'cataloged_date':{'type': str, 'file_name': '', 'selected': False},
'determined_date':{'type': str, 'file_name': 'dateIdentified', 'selected': False},
'collected_date':{'type': str, 'file_name': 'eventDate', 'selected': False},
'year_cataloged':{'type': int, 'file_name': '', 'selected': False},
'month_cataloged':{'type': int, 'file_name': '', 'selected': False},
'month_determined':{'type': int, 'file_name': '', 'selected': True},
'year_collected':{'type': int, 'file_name': '', 'selected': True},
'month_collected':{'type': int, 'file_name': '', 'selected': True},
'kingdom':{'type': str, 'file_name': 'kingdom', 'selected': True},
'phylum':{'type': str, 'file_name': 'Phylum1', 'selected': True},
'class':{'type': str, 'file_name': 'class', 'selected': True},
'order':{'type': str, 'file_name': 'order', 'selected': True},
'family':{'type': str, 'file_name': 'family', 'selected': True},
'genus_old':{'type': str, 'file_name': '', 'selected': False},
'genus':{'type': str, 'file_name': 'genus', 'selected': True},
'species_old':{'type': str, 'file_name': '', 'selected': False},
'species':{'type': str, 'file_name': 'species', 'selected': True},
'subspecies':{'type': str, 'file_name': '', 'selected': False},
'subspecies_old':{'type': str, 'file_name': '', 'selected': False},
'type_status':{'type': str, 'file_name': 'typeStatus', 'selected': True},
'determinator_full_name':{'type': str, 'file_name': 'identifiedBy', 'selected': True},
'collector_full_name':{'type': str, 'file_name': 'recordedBy', 'selected': True},
'min_depth':{'type': float, 'file_name': 'depth', 'selected': True},
'altitude':{'type': float, 'file_name': 'elevation', 'selected': True},
'qualifier':{'type': str, 'file_name': 'Qualifier1', 'selected': False},
'lat':{'type': float, 'file_name': 'decimalLatitude', 'selected': True},
'long':{'type': float, 'file_name': 'decimalLongitude', 'selected': True},
'municipio':{'type': str, 'file_name': '', 'selected': False},
'state':{'type': str, 'file_name': 'stateProvince', 'selected': True},
'country':{'type': str, 'file_name': 'countryCode', 'selected': True},
'continent':{'type': str, 'file_name': '', 'selected': False},
'region':{'type': str, 'file_name': '', 'selected': False},
'lost_in_fire':{'type': int, 'file_name': '', 'selected': False},
'year_determined':{'type': int, 'file_name': '', 'selected': True},
'author_full':{'type': str, 'file_name': '', 'selected': False},
'first_author':{'type': str, 'file_name': '', 'selected': False},
'locality':{'type': str, 'file_name': 'locality', 'selected': True},
}
def get_selected_columns():
return {
'catalog_number': True,
'year_collected': True,
'month_collected': True,
'class': True,
'order': True,
'family': True,
'genus': True,
'type_status': True,
'determinator_full_name': True,
'collector_full_name': True,
'min_depth': True,
'altitude': True,
'lat': True,
'long': True,
'state': True,
'country': True,
}
def get_custom_mapping():
root_dir = os.path.dirname(os.path.abspath(__file__))
json_path = os.path.join('ressources','custom_mapping.csv')
file_path = os.path.join(root_dir,json_path)
return pd.read_csv(file_path, index_col=False, header=0)
custom_mapping = get_custom_mapping()