pydqc icon indicating copy to clipboard operation
pydqc copied to clipboard

Error on data_summary: expected <class 'int'>

Open LishuaiJing3 opened this issue 7 years ago • 1 comments
trafficstars

This is a great tool! But I am facing some errors: I think the openpyxl is causing issues. How to fix this?

Details:

File "", line 1, in data_summary.data_summary(table_schema=data_schema, table=df, fname='processed', sample_size=1.0, keep_images=False, n_jobs=2)

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'>

LishuaiJing3 avatar Jun 13 '18 21:06 LishuaiJing3

python 3.6 and openpyxl 2.4.1

LishuaiJing3 avatar Jun 13 '18 21:06 LishuaiJing3