search

cbrownley / foundations-for-analytics-with-python

459 stars 681 forks source link

pandas_sum_average_multiple_workbooks.py #7

Open Chengjingsilent opened 5 years ago

Chengjingsilent commented 5 years ago

I copied this code, but it couldn't run on my computer with showing: Traceback (most recent call last): File "pandas_sum_average_multiple_workbooks.py", line 32, in worksheet_data_frames.append(pd.DataFrame(data, columns=['workbook', 'worksheet', 'worksheet_total', 'worksheet_average'])) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\frame.py", line 392, in init mgr = init_dict(data, index, columns, dtype=dtype) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\internals\construction.py", line 212, in init_dict return arrays_to_mgr(arrays, data_names, index, columns, dtype=dtype) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\internals\construction.py", line 56, in arrays_to_mgr arrays = _homogenize(arrays, index, dtype) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\internals\construction.py", line 277, in _homogenize raise_cast_failure=False) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\internals\construction.py", line 660, in sanitize_array subarr = com.asarray_tuplesafe(data, dtype=dtype) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\common.py", line 240, in asarray_tuplesafe values = [tuple(x) for x in values] File "D:\Applications\Anaconda\lib\site-packages\pandas\core\common.py", line 240, in values = [tuple(x) for x in values] TypeError: 'int' object is not iterable

nardinmarcus commented 5 years ago

hello world

XinYunke6ke4 commented 4 years ago

I have the same question

caoweiyi2580 commented 3 years ago

I have something wrong with the same line as well. But the error is: ValueError: Data must be 1-dimensional

sian1989 commented 2 years ago

I have the same erorr as ValueError: Data must be 1-dimensional

xiaohongguoer commented 2 years ago

您好，邮件我已收到，Best wish for you！

sian1989 commented 2 years ago

I copied this code, but it couldn't run on my computer with showing: Traceback (most recent call last): File "pandas_sum_average_multiple_workbooks.py", line 32, in worksheet_data_frames.append(pd.DataFrame(data, columns=['workbook', 'worksheet', 'worksheet_total', 'worksheet_average'])) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\frame.py", line 392, in init mgr = init_dict(data, index, columns, dtype=dtype) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\internals\construction.py", line 212, in init_dict return arrays_to_mgr(arrays, data_names, index, columns, dtype=dtype) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\internals\construction.py", line 56, in arrays_to_mgr arrays = _homogenize(arrays, index, dtype) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\internals\construction.py", line 277, in _homogenize raise_cast_failure=False) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\internals\construction.py", line 660, in sanitize_array subarr = com.asarray_tuplesafe(data, dtype=dtype) File "D:\Applications\Anaconda\lib\site-packages\pandas\core\common.py", line 240, in asarray_tuplesafe values = [tuple(x) for x in values] File "D:\Applications\Anaconda\lib\site-packages\pandas\core\common.py", line 240, in values = [tuple(x) for x in values] TypeError: 'int' object is not iterable

Here are the correct one: https://blog.csdn.net/cici2013/article/details/86705172

NNNightglow commented 1 year ago

Here are the new correct one: https://blog.csdn.net/NNNightglow/article/details/133563881?spm=1001.2014.3001.5502

xiaohongguoer commented 1 year ago

您好，邮件我已收到，Best wish for you！