I am having some trouble with reading a table in excel and then extracting specific rows.
I first use:
filenameEGI='Copy of EGI Yield Data July 2020 7_30_20.xlsx'
In effort to read rows 2056 to 2098. However in certain columns NaN is bein displayed and I would like whatever was in that excel cell to display instead.
Where the NaN displayed, in the excel cell it displayed words and file folder links.
Any suggestions or application of corrections?