Aug-20-2020, 11:12 PM
(Aug-20-2020, 07:46 PM)ndc85430 Wrote: Of course it does - "insert" means to insert a row. Should You be really using "update"? You don't have any constraints I the table either, so it guess you don't care about having duplicate rows? It might help if you said what the data are and what your end goal is.
Hi ndc85430,
Thanks for the help!
The whole idea is to take the information I am sent (in the form of roughly 50 .csv files) and output the bits I need to a GUI (probably in Tkinter). It will need to update from the csv file so that when it appears in the interface it only shows the new data (currently being handled in the spreadsheet) that I need. I have to do this every 24 hours or so (currently manually) and it is a very boring task that I hope to automate.
The above code is literally my first attempt to learn how python works that isn't just a "copy someone else" type deal. It is also a pared down version of the first step, second step being to place it in the GUI and actually figure out how to lay it out so it is readable! I guess I will also try to write all the equations, currently handled by the speadsheets, into the program soon.
Next last step will be to import this all from a couple of seperate APIs but that is a bit more complex as this is my first go at coding anything at all and 3 days or youtube "training" is not going to get me there quite yet but everyone has to start somewhere, right?
Cheers,
Mort