Jul-18-2021, 11:13 AM
My advice depends largely on how many times you plan to run this. If once, it will take you more time to learn and rewrite the code than it will to just let this run for the 33 minutes in the estimate you quote. However, if this is to be done multiple times I would use Pandas. Not a bad idea to learn Pandas anyway, lots of Youtubes and other sources on the net. Pandas is not only fast but also opens a range of functions to make things (relatively) easy.
Pandas supports an object called a Dataframe. Think of this as a spreadsheet or table where you can then reference entire columns by name. Won't eliminate the need for For loops but close.
Pandas supports an object called a Dataframe. Think of this as a spreadsheet or table where you can then reference entire columns by name. Won't eliminate the need for For loops but close.