Using python to solve the problem

Problem: Data Processing An acquaintance of yours, a librarian at an elementary school in a rural area who is still maintaining the library holdings manually on paper, has contacted you for assistance. They have acquired a computer and knowing that you are taking CMPUT 175, they have asked you to help write a program to automate some of the processes. Using a spreadsheet, they have already started collecting data that they can provide you in text-formatted files. Your python program would use these text-formatted files as input and produce as output lists that can be printed. The files that you have as input are as follows: The first file, books.txt, contains the list of all the books in the library. Each line of the file contains information about a book: Book ID followed by a pound (#), followed by a title, followed by a pound, followed by the author names, followed again by a pound and finally followed by a value in dollars. For example, the content of the file could look like this: B123456#The mouse and the motorcycle#Beverly Cleary#10.5 B234587#Charlotte's Web#Elwyn Brooks White#15 B354759#Matilda#Roald Dahl#15 B654190#Harry Potter and the prisoner of Azkaban#Joanne Rowling#25 B58256#James and the giant peach#Roald Dahl#13 B246511#The witches#Roald Dahl#22 B998135#Pipi Longstocking#Astrid Lindgren#8.75 B100952#The battle of the labyrinth#Rick Riordan#25 The second file, students.txt, contains the list of students. Each line concerns one student and is formatted as follows: StudentID, student name, class, all separated by a comma (). For example, the content of the file could look like this: 5983342, Suzanne Foster, 2B 5981123, Eric Xu, 2B 5980127, Hua Li, 3A 5986654, Myriam Salah, 2A 5982234, Ali Rabbany, 3B 5987654, Kevin Kelly, 3A The third file, borrowers.txt, contains the history of all loans. Each line has a Book ID followed by a Student ID, followed by a date the book was borrowed, followed by the expected date the book is supposed to be returned. The dates are formatted in strings of 6 characters, the year followed by the month followed by the day. For instance the 5th of January 2022 would be "220105". This way dates can be compared. Indeed 220105