import pandas as pd
#with pandas version 1.0.0 and later
df = pd.read_excel('path_to_file.xlsb', engine='pyxlsb')
Here is what the above code is Doing:
1. The engine=’pyxlsb’ parameter tells pandas to use the pyxlsb engine to read the file.
2. The read_excel() function returns a pandas DataFrame object.