-2

I have written a python program to find and interpolate values for 4 variables as inputs from a an excel file.

I have to run this function in loop more than 1000 times. So, each time I call the function in loop it has to open and read this excel file. Is there a faster way solve this such that the excel file can be stored within the function as pandas dataframe or numpy array and the excel file doesn't have to be called each time whilst iteration?

Durlabh
  • 9

1 Answers1

-1

Your coding knowledge will increase a lot just by googling your question and reading documentation/other Stack Overflow posts that already exist.

To answer your question, you can read your entire CSV at once and save it as a variable to use for the rest of your code. From the pandas docs (https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html or https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html)

They show

pd.read_csv('data.csv')

or

pd.read_excel('data.xlsx')
Kunal Shah
  • 610
  • 6
  • 17