pydqc
pydqc copied to clipboard
Error on data_summary: expected <class 'int'>
This is a great tool! But I am facing some errors: I think the openpyxl is causing issues. How to fix this?
Details:
File "
File "C:/Users/pydqc\pydqc\data_summary.py", line 468, in data_summary _insert_numeric_results(numeric_results, ws, 35, img_dir)
File "C:/Users/pydqc\pydqc\dqc_utils.py", line 259, in _insert_numeric_results _style_range(ws, 'A%d:C%d'%(head_row, head_row+result_df.shape[0]-1), border=border)
File "C:/Users/pydqc\pydqc\dqc_utils.py", line 50, in _style_range cell.border += top
File "C:\Users\6\AppData\Local\Continuum\Anaconda3\lib\site-packages\openpyxl\styles\proxy.py", line 46, in add return self.__target + other
File "C:\Users\6\AppData\Local\Continuum\Anaconda3\lib\site-packages\openpyxl\descriptors\serialisable.py", line 203, in add vals[el] = a + b
File "C:\Users\6\AppData\Local\Continuum\Anaconda3\lib\site-packages\openpyxl\descriptors\serialisable.py", line 203, in add vals[el] = a + b
File "C:\Users\6\AppData\Local\Continuum\Anaconda3\lib\site-packages\openpyxl\descriptors\serialisable.py", line 206, in add return self.class(**vals)
File "C:\Users\6\AppData\Local\Continuum\Anaconda3\lib\site-packages\openpyxl\styles\colors.py", line 86, in init self.indexed = indexed
File "C:\Users\6\AppData\Local\Continuum\Anaconda3\lib\site-packages\openpyxl\descriptors\base.py", line 69, in set value = _convert(self.expected_type, value)
File "C:\Users\6\AppData\Local\Continuum\Anaconda3\lib\site-packages\openpyxl\descriptors\base.py", line 59, in _convert raise TypeError('expected ' + str(expected_type))
TypeError: expected <class 'int'>
python 3.6 and openpyxl 2.4.1