Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,088 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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