search

influxdata / influxdb-python

Python client for InfluxDB
MIT License
1.7k stars 521 forks source link

trying to use teradata database table to generate test data, getting error while trying to fit the model #862

Open altaafhussain opened 4 years ago

altaafhussain commented 4 years ago

data = DataFrame.from_query("select trim(Dept_Num) DNum , trim(Budget_Amount) Bgt_Amount from dept") data DNum Bgt_Amount 0 201 293800 1 302 226000 2 301 465600 model.fit(data) 2020-10-29 23:14:27,178 - sdv.metadata.table - INFO - Fitting table None metadata 2020-10-29 23:14:27,179 - teradata.udaexec - ERROR - Uncaught exception Traceback (most recent call last): File "", line 1, in File "C:\Users\ak186027\venv\Python 3.7\lib\site-packages\sdv\tabular\base.py", line 104, in fit self._metadata.fit(data) File "C:\Users\ak186027\venv\Python 3.7\lib\site-packages\sdv\metadata\table.py", line 473, in fit self._fields_metadata = self._build_fields_metadata(data) File "C:\Users\ak186027\venv\Python 3.7\lib\site-packages\sdv\metadata\table.py", line 277, in _build_fields_metadata if field_name not in data: File "C:\Users\ak186027\venv\Python 3.7\lib\site-packages\teradataml\dataframe\dataframe.py", line 555, in getitem raise KeyError('Unable to find key: %s' % str(key)) KeyError: 'Unable to find key: 0' Traceback (most recent call last): File "", line 1, in File "C:\Users\ak186027\venv\Python 3.7\lib\site-packages\sdv\tabular\base.py", line 104, in fit self._metadata.fit(data) File "C:\Users\ak186027\venv\Python 3.7\lib\site-packages\sdv\metadata\table.py", line 473, in fit self._fields_metadata = self._build_fields_metadata(data) File "C:\Users\ak186027\venv\Python 3.7\lib\site-packages\sdv\metadata\table.py", line 277, in _build_fields_metadata if field_name not in data: File "C:\Users\ak186027\venv\Python 3.7\lib\site-packages\teradataml\dataframe\dataframe.py", line 555, in getitem raise KeyError('Unable to find key: %s' % str(key)) KeyError: 'Unable to find key: 0'