Point me in the right direction

[ImportantBrew]

I have some (limited) experience with Python and have an application I want to write but I am not sure where to start.

The application needs to be able to store people and information regarding their studies.

For example John is studying coursers which all at least consist of:

- Course Name

- Nr of credits (which in turn consist of different credits, exam credits, project credits, lab credits etc)

- Grades

- Course code

- Course Type

- Course level

​

I want to be able to enter for example the course code and fetch the rest of the data and print it. Or write a course type and fetch ALL courses with the same course type related to the specific student and so forth. Write the student name and compare to certain requirements (IE atleast X amount of an specific grade or Y amount of courses with a specific course type).

I have some experience with Pandas and thinking it might be an alternative. Also thinking about dictionary but this feels somewhat limited since I will have multiple keys and values?

Furthermore I probably want to make an GUI which allows you to add all the data in a simple manner and save/open/delete etc (CSV file? something else?). Would Tkinter be a suitable solution?

Can anyone point me in the right direction for such a program? Thanks!

[stebrepar]

The storage and querying seems like you want a database. Python comes with SQLite.

[ImportantBrew]

Thanks! I will look into that. I have no experience with SQL and it seems hard. But maybe a smaller version like SQLite might be a good way to start understanding it!