Python Forum
Excel cell(non uniform) to Database
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel cell(non uniform) to Database
#6
(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 ?
Reply


Messages In This Thread
Excel cell(non uniform) to Database - by Vinci141 - Nov-27-2018, 04:20 AM
RE: Excel cell(non uniform) to Database - by buran - Nov-27-2018, 09:14 AM
RE: Excel cell(non uniform) to Database - by Vinci141 - Nov-29-2018, 01:13 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python read Excel cell data validation anantpatil 0 4,198 Jan-31-2020, 04:57 PM
Last Post: anantpatil
  Slicing String cell by cell Vigneshkumarsakthivel 0 2,424 Sep-02-2018, 05:59 PM
Last Post: Vigneshkumarsakthivel

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020