In Excel's Python, when running a double for loop, it shows "timeout".

原 田 0 Reputation points
2024-04-23T01:36:19.53+00:00

import pandas as pd

for index, row in df1.iterrows():

invoice_num = row['num']

for index2, row2 in df2.iterrows():

    if row2['num'] == invoice_num:

        receivable_balance =  df1.loc[index, 'rece‘] - row2['come']

        df1.loc[index, 'rece'] = receivable_balance.round(2)
```In Excel, running the above Python code works when there are 500 records, but times out when there are over 2000 records.

This issue will be improved later on? Or is there a limit to the amount of data Excel's Python can handle?

thanks

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,896 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.