![]() ![]() You can do that by just supplying a list of the columns of interest as an index (shown below.#!python Traceback (most recent call last): File "/usr/local/lib/python3.5/site-packages/openpyxl/descriptors/base.py", line 57, in _convert value = expected_type(value) ValueError: could not convert string to float: '$K$6' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "extract_test.py", line 37, in text = n_until_complete(coro) File "/usr/local/lib/python3.5/asyncio/base_events.py", line 387, in run_until_complete return future.result() File "/usr/local/lib/python3.5/asyncio/futures.py", line 274, in result raise self._exception File "/usr/local/lib/python3.5/asyncio/tasks.py", line 239, in _step result = nd(None) File "/home/southclaw/work/hcc_extract_worker_py/textract/api.py", line 65, in process result = await parser(filename, **kwargs) File "/home/southclaw/work/hcc_extract_worker_py/textract/utils/parser.py", line 49, in _call_ data = await self.extract(filename, encoding=encoding, **kw) File "/home/southclaw/work/hcc_extract_worker_py/textract/parsers/xlsx.py", line 14, in extract wb = load_workbook(filename, data_only=True) File "/usr/local/lib/python3.5/site-packages/openpyxl/reader/excel.py", line 225, in load_workbook ws_parser.parse() File "/usr/local/lib/python3.5/site-packages/openpyxl/reader/worksheet.py", line 122, in parse dispatcher(element) File "/usr/local/lib/python3.5/site-packages/openpyxl/reader/worksheet.py", line 281, in parser_conditional_formatting cf = om_tree(element) File "/usr/local/lib/python3.5/site-packages/openpyxl/descriptors/serialisable.py", line 76, in from_tree obj = desc.expected_om_tree(el) File "/usr/local/lib/python3.5/site-packages/openpyxl/descriptors/serialisable.py", line 76, in from_tree obj = desc.expected_om_tree(el) File "/usr/local/lib/python3.5/site-packages/openpyxl/descriptors/serialisable.py", line 76, in from_tree obj = desc.expected_om_tree(el) File "/usr/local/lib/python3.5/site-packages/openpyxl/descriptors/serialisable.py", line 89, in from_tree return cls(**attrib) File "/usr/local/lib/python3.5/site-packages/openpyxl/formatting/rule.py", line 53, in _init_ self.val = val File "/usr/local/lib/python3.5/site-packages/openpyxl/formatting/rule.py", line 32, in _set_ super(ValueDescriptor, self)._set_(instance, value) File "/usr/local/lib/python3.5/site-packages/openpyxl/descriptors/base.py", line 69, in _set_ value = _convert(self.expected_type, value) File "/usr/local/lib/python3.5/site-packages/openpyxl/descriptors/base.py", line 59, in _convert raise TypeError('expected ' str(expected_type)) TypeError: expected You may need to just specify which columns to use-which is actually a better way to do it rather than rely on pd to do this for you. ![]() When I try to replicate this behavior, the corr() method works OK but spits out a warning (shown below) that warns that the ignoring of non-numeric columns will be removed in the future. ValueError: could not convert string to float: 'Avery Bradley' Result = self._mgr.as_array(dtype=dtype, copy=copy, na_value=na_value)įile "C:\Users\d.o\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\internals\managers.py", line 1732, in as_arrayĪrr = self._interleave(dtype=dtype, na_value=na_value)įile "C:\Users\d.o\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\internals\managers.py", line 1794, in _interleave Mat = data.to_numpy(dtype=float, na_value=np.nan, copy=False)įile "C:\Users\d.o\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\frame.py", line 1838, in to_numpy Traceback (most recent call last):įile "C:\Users\d.o\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\frame.py", line 10059, in corr I thought the corr() method was supposed to automatically ignore strings and empty values etc. Specifically, when I try to run the following code: df.corr(method ='pearson') ![]() I'm getting this very strange error when trying to follow the following exercise on using the corr() method in Python ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |