Example to analyse.xlsx file or SQL db data

[ieea]

Hi,
I was reading through the library as well searching the example folder, but not able to find any example where an .xlsx tables or SQL data is analysed, is it possible to analyse .xlsxs , please direct me to relevant example or doc link.

Regards,
Gaurav

[sidjha1]

Hey @ieea I think you should just be able to use pandas.read_excel, to load the .xlsx file into pandas. Then you can use any of the lotus operators as shown in the examples.