[GDCBDE][2017-11-15 13:14:44] [SQLHLP] INIT [AZURE SQL HELPER v1.3.3]
[GDCBDE][2017-11-15 13:14:44] [SQLHLP] Creating data folder:ition_v2\api\_godrive_data\db_cache
[GDCBDE][2017-11-15 13:14:44] [SQLHLP] ODBC Conn: DRIVER={ODBC Driver 13 for SQL Serv...
[GDCBDE][2017-11-15 13:14:45] [SQLHLP] Connection created on carbox.database.windows.net
[GDCBDE][2017-11-15 13:14:45] LOGfile: C:\Users\AndreiS\Dropbox\21. G
[GDCBDE][2017-11-15 13:14:45] Work folder: [C:\Users\AndreiS\Dropbox\21. GODRIVE_WORK\01_work\WORK\iot_acquisition_v2\api\_godrive_data]
[GDCBDE][2017-11-15 13:14:45] INIT DATA EXPLORER v0.1.1
[GDCBDE][2017-11-15 13:14:45] Setup predictors and raw data repo...
[GDCBDE][2017-11-15 13:14:45] [SQLHLP] Downloading data [SELECT * FROM [Codes]..] ...
[GDCBDE][2017-11-15 13:14:46] [SQLHLP] Saving to [..ata\db_cache\SELECT_FROM_Codes_.csv]...
[GDCBDE][2017-11-15 13:14:46] [SQLHLP] Dataset loaded: 0.01MB in 0.5s(0.0m) 134 rows
[GDCBDE][2017-11-15 13:14:46] Loaded 134 predictors
[GDCBDE][2017-11-15 13:14:46] [SQLHLP] Downloading data [SELECT TOP (1) * FROM [RawData..] ...
[GDCBDE][2017-11-15 13:14:46] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 1 rows
[GDCBDE][2017-11-15 13:14:47] RawData: ['CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp']
[GDCBDE][2017-11-15 13:14:47] [SQLHLP] Downloading data [SELECT * FROM [Cars]..] ...
[GDCBDE][2017-11-15 13:14:47] [SQLHLP] Saving to [..data\db_cache\SELECT_FROM_Cars_.csv]...
[GDCBDE][2017-11-15 13:14:47] [SQLHLP] Dataset loaded: 0.00MB in 0.2s(0.0m) 56 rows
[GDCBDE][2017-11-15 13:14:47] Loaded 56 cars
[GDCBDE][2017-11-15 13:14:47] [SQLHLP] Downloading data [SELECT * FROM [RawData]..] ...
[GDCBDE][2017-11-15 13:14:48] [SQLHLP] Saving to [..a\db_cache\SELECT_FROM_RawData_.csv]...
[GDCBDE][2017-11-15 13:14:49] [SQLHLP] Dataset loaded: 1.07MB in 2.1s(0.0m) 17504 rows
[GDCBDE][2017-11-15 13:14:49] Rawdata copy: ['ID', 'CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp']
[GDCBDE][2017-11-15 13:14:49] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2017-11-15 13:14:49] [SQLHLP] Saving to [..\db_cache\SELECT_FROM_Accounts_.csv]...
[GDCBDE][2017-11-15 13:14:49] [SQLHLP] Dataset loaded: 0.00MB in 0.2s(0.0m) 3 rows
[GDCBDE][2017-11-15 13:14:49] Loaded 3 accounts
[GDCBDE][2017-11-15 13:14:49] [SQLHLP] Downloading data [SELECT c.ID Masina, f.Name Flo..] ...
[GDCBDE][2017-11-15 13:14:49] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 56 rows
[GDCBDE][2017-11-15 13:14:49] CarsxAccounts copy: ['Masina', 'Flota', 'FlotaID']
[GDCBDE][2017-11-15 13:14:49] Done data preparation.
[GDCBDE][2017-11-15 13:14:49] [SQLHLP] Downloading data [SELECT * FROM [RawData]..] ...
[GDCBDE][2017-11-15 13:14:50] [SQLHLP] Dataset loaded: 1.07MB in 1.0s(0.0m) 17504 rows
[GDCBDE][2017-11-15 13:14:50] [SQLHLP] Downloading data [SELECT * FROM [Accounts]..] ...
[GDCBDE][2017-11-15 13:14:50] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 3 rows
[GDCBDE][2017-11-15 13:14:50] [SQLHLP] Downloading data [SELECT * FROM [Cars]..] ...
[GDCBDE][2017-11-15 13:14:51] [SQLHLP] Dataset loaded: 0.00MB in 0.1s(0.0m) 56 rows
[GDCBDE][2017-11-15 13:14:51] [SQLHLP] Downloading data [SELECT * FROM [Codes]..] ...
[GDCBDE][2017-11-15 13:14:51] [SQLHLP] Dataset loaded: 0.01MB in 0.1s(0.0m) 134 rows
[GDCBDE][2017-11-15 13:14:51] [SQLHLP] Downloading data [SELECT * FROM [CarsXCodes_v2]..] ...
[GDCBDE][2017-11-15 13:14:51] [SQLHLP] Dataset loaded: 0.23MB in 0.2s(0.0m) 7504 rows
[GDCBDE][2017-11-15 13:14:51] ....Trying to associate code and description columns to df_rawdata_toshow
[GDCBDE][2017-11-15 13:14:51] Finished associating columns
[GDCBDE][2017-11-15 13:14:51] Rawdata copy: ['ID', 'CarID', 'CodeID', 'StrValue', 'Value', 'ViewVal', 'ViewStr', 'TimeStamp', 'Description', 'Code']