search

mindsdb / mindsdb_native

Machine Learning in one line of code
http://mindsdb.com
GNU General Public License v3.0
37 stars 28 forks source link

Failed to `order_by` date error #471

Closed ZoranPandovski closed 3 years ago

ZoranPandovski commented 3 years ago
Link to download dataset https://www.kaggle.com/datasnaek/youtube-new
Steps to Reproduce Upload the Dataset, target variable is Views, order by trending date

Error stack trace:

C:\PROGRA~1\MindsDB\python\lib\site-packages\mindsdb_native\libs\phases\model_interface\lightwood_backend.py", line 
125, in _ts_reshape row[col] = float(row[col]) ValueError: could not convert string to float: '17.01.12' During handling of the
 above exception, another exception occurred: Traceback (most recent call last): File "C:\PROGRA~1\MindsDB\python\lib\site-packages\mindsdb_native\libs\controllers\transaction.py", line 246, in _run self._call_phase_module(module_name='ModelInterface', mode='train') File "C:\PROGRA~1\MindsDB\python\lib\site-
packages\mindsdb_native\libs\controllers\transaction.py", line 178, in _call_phase_module ret = module(self.session, self)
(**kwargs) File "C:\PROGRA~1\MindsDB\python\lib\site-packages\mindsdb_native\libs\phases\base_module.py", line 53, in
 __call__ ret = self.run(**kwargs) File "C:\PROGRA~1\MindsDB\python\lib\site-
packages\mindsdb_native\libs\phases\model_interface\model_interface.py", line 18, in run self.transaction.model_backend.train()
 File "C:\PROGRA~1\MindsDB\python\lib\site-packages\mindsdb_native\libs\phases\model_interface\lightwood_backend.py", line 337, in train train_df, secondary_type_dict, _, train_df_gb_map = self._ts_reshape(self.transaction.input_data.train_df) File 
"C:\PROGRA~1\MindsDB\python\lib\site-packages\mindsdb_native\libs\phases\model_interface\lightwood_backend.py", line 
127, in _ts_reshape raise ValueError(f'Failed to order based on column: "{col}" due to faulty value: {row[col]}') ValueError: Failed 
to order based on column: "trending_date" due to faulty value: 17.01.12