Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
python memory
#1
HI Friends ,

Processing table number: 67 and table name is: bp_dealer_tbl
Fetching query results.

Error:
Error while getting the result from query: Unable to allocate 153. MiB for an array with shape (272899, 147) and data type object 'NoneType' object has no attribute 'columns' Traceback (most recent call last): File "C:\Sup\Python\get_delta_records_branch_plus.py", line 265, in <module> obj1.connect() File "C:\Sup\Python\get_delta_records_branch_plus.py", line 254, in connect auditDf = pd.DataFrame(data) File "C:\Python\lib\site-packages\pandas\core\frame.py", line 468, in __init__ mgr = init_dict(data, index, columns, dtype=dtype) File "C:\Python\lib\site-packages\pandas\core\internals\construction.py", line 283, in init_dict return arrays_to_mgr(arrays, data_names, index, columns, dtype=dtype) File "C:\Python\lib\site-packages\pandas\core\internals\construction.py", line 78, in arrays_to_mgr index = extract_index(arrays) File "C:\Python\lib\site-packages\pandas\core\internals\construction.py", line 397, in extract_index raise ValueError("arrays must all be same length") ValueError: arrays must all be same length
i am getting this error while i am extracting the data from the database tables. there are 100+ tables . but i am getting the error only this table . Please help
Yoriz write Jul-14-2021, 06:33 AM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Reply
#2
Not nearly enough information to be of help. It appears you are using Pandas, and if you are having the error only in one file the problem is probably in the data in that file. The error message says arrays must all be the same length. Start there.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  python list out top 10 Memory utilisation mg24 0 785 Nov-20-2022, 10:51 PM
Last Post: mg24
Bug Embedded Python Memory Leaks Alexei 1 1,003 Sep-16-2022, 01:15 PM
Last Post: Alexei
  Windows Python Memory Scanner Awesometech 1 19,055 Oct-14-2020, 07:44 AM
Last Post: badengagen
  memory leak on embedded python in c++ asdf3721 3 3,333 Jul-16-2020, 06:33 AM
Last Post: Gribouillis
  How to get memory usage and execution time of each line in python SriRajesh 2 3,046 Mar-07-2019, 12:59 PM
Last Post: SriRajesh
  How to reallocating memory space in multithreading program in python ? siva 2 3,357 Mar-08-2018, 03:49 AM
Last Post: siva
  python call c library (about memory copy) vgy 0 2,905 Jul-07-2017, 02:32 PM
Last Post: vgy

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020