Answer 1

This is 2 months old you must’ve found the answer. however, If I were you, I would convert it into CSV using any tool online then use read_csv function.
Here's some links that might help too:

https://libraries.io/pypi/pandas-ods-reader

https://stackoverflow.com/questions/17834995/how-to-convert-opendocument-spreadsheets-to-a-pandas-dataframe