Problem Manipulating data in a Pandas dataframe.
Program: To import an Excel sheet detailing a student timetable then convert it to a timetable with images to represent the subjects. (for students who can't read)
I have a excel document containing rows of data detailing the student, period, class, subject etc for each lesson in the timetable.
I have imported this data into a pandas dataframes, and I've begun to design a tkinter based UI, all successfully with the plan to use PIL and other image libraries to create the timetable.
However I'm struggling to proceed from this point, I'd like some general advice.
I want to edit be able to manipulate the data and then save it again to the dataframes. So for example, the user selects an image for the subject, so I want the image file name is saved to the individual row for that subject.
Do I edit it directly in pandas cell by cell, or load the dataframe into an data structure, like a nested list, edit the list and then replace it into the dataframe.
Alternatively I've thought about using SQLlite instead of pandas.
What would be your approach to manipulating the data.
Aucun commentaire:
Enregistrer un commentaire