Hi, I converted the dataframe of 4063 rics into the chunks of 50. I used this code and added 2 time.sleep after one request and 5 sec sleep after one chunk. Still I'm getting the error . What is the best approch to resolve it.

import pandas as pd

# Initialize an empty DataFrame with column name 'split_ratio'

stock_split = pd.DataFrame(data=None)

try:

i = 0

for chunk in chunks:

for index, row in chunk.iterrows():

try:

df, err = ek.get_data(str(row['ric']), ['TR.CAAdjustmentFactor'], {'SDate': '2023-10-03', 'EDate': '2023-10-04'})

df.fillna(1, inplace=True)

df.rename(columns={'Adjustment Factor': 'split_ratio'}, inplace=True)

stock_split = pd.concat([stock_split, df], ignore_index=True)

except Exception as e:

print('Error:', e)

time.sleep(1)

i += 1

print(i, end=' ')

print('sleeping for 5 seconds before the next chunk...')

time.sleep(5)

except Exception as e:

print('Error:', e)

@vishnu01

Can you share RICs? Therefore, I can test the code on my machine.