Nov-29-2018, 01:13 PM
(Nov-29-2018, 06:57 AM)thatIsTheCase Wrote: What will you be doing with the data? What are the downstream requirements?
There are many approaches but without having more context or an understanding of the ultimate objective, I am not sure which way to direct you. I would recommend using pandas’ read_excel. This you will have a dataframe. If you give some more details of data and objective of your project I will try to help.
Objective: validate data provided in excel sheet.
Approach: read the excel and send required data to SQL database, then run pre-composed SQL on that data to identify if the excel that has this data passed or fail .
Any other approach to achieve this and technical requirement ?