The following below is a not entirely trivial algorithm for students that creates a Python dictionary when scanning text according to the conditions of the problem, which is then processed as Pandas Dataframe to provide the output required

Source: LXer – Exersing Python 3.10 on Fedora 25 via sorting Pandas DataFrame