-
Notifications
You must be signed in to change notification settings - Fork 2
/
colnames_dtypes_work.py
136 lines (132 loc) · 4.28 KB
/
colnames_dtypes_work.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
# REMOVED UNNEEDED ONES:
from collections import OrderedDict
# Version 4
COLNAMES_DTYPES_DICT = OrderedDict([('MMSI', np.int32),
('Message_ID', np.int32),
('Repeat_indicator', np.int32),
('Time', np.object),
('Millisecond', np.int32),
('Region', np.float32),
('Country', np.int32),
('Base_station', np.int32),
('Vessel_Name', np.float32),
('Call_sign', np.float32),
('IMO_ee', np.float32),
('Ship_Type', np.float32),
('Destination', np.float32),
('ROT', np.float32),
('SOG', np.float32),
('Longitude', np.float32),
('Latitude', np.float32),
('COG', np.float32),
('Heading', np.float32),
('IMO_ihs', np.int32),
('ShipName', np.object),
('PortofRegistryCode', np.int32),
('ShiptypeLevel2', np.object),
('Voyage', np.object),
('Direction', np.float32),
('simple_direction', np.object)] )
# Version 3
colnames_dtypes_dict = OrderedDict([('MMSI', np.int32),
('Message_ID', np.int32),
('Repeat_indicator', np.int32),
('Time', np.object),
('Millisecond', np.int32),
('Region', np.float32),
('Country', np.int32),
('Base_station', np.int32),
('Online_data', np.object),
('Group_code', np.object),
('Vessel_Name', np.float32),
('Call_sign', np.float32),
('IMO_ee', np.float32),
('Ship_Type', np.float32),
('Destination', np.float32),
('ROT', np.float32),
('SOG', np.float32),
('Longitude', np.float32),
('Latitude', np.float32),
('COG', np.float32),
('Heading', np.float32),
('IMO_ihs', np.int32),
('ShipName', np.object),
('PortofRegistryCode', np.int32),
('ShiptypeLevel2', np.object),
('unique_trips', np.object),
('unique_trips_dest', np.object),
('time_modified', np.float32),
('day_breaks', np.int16),
('clusters', np.object),
('Voyage', np.object),
('Direction', np.float32),
('simple_direction', np.object),
('Distance', np.float32) ] )
# Version 2
colnames_dtypes_dict = OrderedDict( [ ('MMSI',np.int32),
('Repeat_indicator',np.int32),
('Time',np.object),
('Millisecond',np.int32),
('Region',np.float32),
('Country',np.int32),
('Base_station',np.int32),
('Online_data',np.object),
('Vessel_Name',np.float32),
('Call_sign',np.float32),
('IMO_ee',np.float32),
('Ship_Type',np.float32),
('Destination',np.float32),
('ROT',np.object),
('SOG',np.float32),
('Longitude',np.float32),
('Latitude',np.float32),
('COG',np.object),
('Heading',np.object),
('IMO_ihs',np.int32),
('ShipName',np.object),
('PortofRegistryCode',np.int32),
('ShiptypeLevel2',np.object),
('day_breaks',np.bool),
('Voyage',np.object),
('Direction',np.float32),
('simple_direction',np.object),
('Distance',np.float32),
('akalb_lon', np.float64),
('akalb_lat', np.float64) ] )
# Version 1
colnames_dtypes_dict = {'MMSI':np.int32,
'Unnamed: 1':np.int32,
'MMSI.1':np.int32,
'Message_ID':np.int32,
'Repeat_indicator':np.int32,
'Time':np.object,
'Millisecond':np.int32,
'Region':np.float16,
'Country':np.int32,
'Base_station':np.int32,
'Online_data':np.object,
'Group_code':np.object,
'Vessel_Name':np.float16,
'Call_sign':np.float16,
'IMO_ee':np.float16,
'Ship_Type':np.float16,
'Destination':np.float16,
'ROT':np.object,
'SOG':np.float16,
'Longitude':np.float16,
'Latitude':np.float16,
'COG':np.object,
'Heading':np.object,
'IMO_ihs':np.int32,
'ShipName':np.object,
'PortofRegistryCode':np.int32,
'ShiptypeLevel2':np.object,
'unique_trips':np.object,
'unique_trips_dest':np.object,
'time_modified':np.float16,
'day_breaks':np.bool,
'clusters':np.object,
'Voyage':np.object,
'Direction':np.float16,
'simple_direction':np.object,
'Distance':np.float16}