Solve it using python

The aim of the Movie Recommendation System is to provide information$/$recommendations to interested users for a set of movies. You are required to write a Python program that stores, processes, and retrieves information as specified below Specifications:

The program should display the following menu:

Movies Recommendation System

$1.$ Add new Movie information

$2.$ Update Movie information

$3.$ Display information for all Movie

$4.$ Display specific information

$5.$ Save specific gen

re in new files

$6.$ Exit

$$

$1.$ Adding new movies: This option allows the user to add movie information to the system. The fields for each movie are described in Table $1.$ Data should be stored in a file called $$movie$.$txt$.$

The program should accept only valid names and values. Each Movie should have one record per year. The system should display an appropriate error message if the MovieID already has been reviewed for the same Year. For example, the data presented in Table $3$ is not valid. This is because each movie should be reviewed once per a year. You should ask the user to enter the number corresponding to the movie Genre, then write it in letters. For instance, if the user entered $0,$ this means the genre is sport and this is how it should be saved in the file. A movie can have up to $5$ Genres, so you should ask the user how many Genres he will enter, if he entered a value larger than $5,$ then you should print an error message, then ask again. When adding the new movie the MovieID should be automatically assigned. You should check the Movie Name, if the movie has the same name, then you should check the movie year, if the movie name and year are the same you should display an error and not add the movie, get the user back to the main menu. If the movie has the same name but not the same year, then the new id is the old id $+$ the date. For instance, movie $1$ is created in $2012$ and the ID is $12012.$ The second review for the same movie is in $2013,$ then the ID should be $12013.$ The first number $1$ is just a sequential number. The second number is the date of Review. So$,$ to create the movieID you should check if the movie already exist, if it does use the same sequential number $($ex; $1),$ else add one to the last existing sequential number and use that $($ex; $2).($check Table $2)$ Note that when the user Enter the MovieName, they may use upper or lower case letters, your code should be able to recognize if the same name is entered but with different letters $($check table $3)$

$$

$2.$ Updating Movie information: this option allows the user to update UserRating, NumOfReviews, and Revenue. Once this option is selected, the program should ask for MovieName and Year, then retrieve Movie information based on MovieName and Year. For each field, the program should ask whether it needs to be updated or not. If it needs to be updated, the program asks for the new information. Once all information is entered, the program updates them and displays an appropriate message. The updated movie should be changed in the file as well.

$$

$3.$ Displaying information about all Movies: this option allows the user to display Movies$$ information in a nicely formatted table. It has the following sub$-$options $($select only $3$ of the following sub$-$options$)$

o Sort by MovieID

o Sort by MovieName

o Sort by Genre

o Sort by Revenue

o Sorted by Year

$$

$4.$ Displaying specific information: this feature allows the user to display Movies$$ information based on some specified criteria. It has the following sub$-$options: $($select only $4$ of the following sub$-$options$)$

$$ View the top $5$ selling movies in the last $10$ years $($sorted based on Year and UserRating$).$

$$ Print the Total revenue for all movies per Year.

$$ Print the Average revenue of all movies per Year.

$$ Print the Total number of all $($unique$)$ movies per Author.

$$ Print the Average revenue of all $($unique$)$ movies per Author.

$$ View a sorted list of movies $($by movieName$)$ for a given Year $($In alphabetical order$).$

$$ View a sorted list of movies $($by movieID$)$ for a given year for a given Genre $($in alphabetical order$)($ask the user for Genre first$).$

$$

$5.$ Saving movie information for a certain Genre in a new file. The program should ask the user for the Genre, then it should write the retrieved information for that Genre in the new file. For instance, create a new file containing all the fiction movies.

$$

$6.$ Terminating the program: Remember, your program should be always running until the user closes it with this option. For example, press $$Q$$ to exit.

$$

$7.$ Otherwise: the program should display an appropriate error message and inform the user to enter a valid option. After each menu item is terminated the code should return the user to the main menu.

$$

$8.$ Testing: You should create a text file with $10-20$ movie entries, so that your code can be tested for part $4.$ You are recommended to create test cases and check that all the parts are working correctly before submission.