1. install odfpy:
pip install odfpy
2. use odf engine in read_excel method
df = pd.read_excel("file.ods" engine="odf")