Write a Python program to solve the following problem. The data is stored in a file called inventory.txt$.$ Each line in this file begins with the day of the week $($Sunday$,$ Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday$),$ followed by a comma $(,),$ followed by the item name $($apples$,$ bananas, meat, or fish$),$ followed by another comma $(,),$ followed by the amount of kilograms displayed for that item on that day $($a positive floating$-$point number$),$ followed by another comma $(,),$ followed by the quantity of kilograms purchased by customers for that item on that day $($a positive floating$-$point number$).$

Any line that deviates from this format is considered an error, including lines with extra spaces between the comma$-$separated values. Additionally, each unique day$-$item pair should appear only once in the file; repeated day$-$item pairs are also errors. Missing day$-$item pairs are not considered errors, as some days the store may be closed or certain items may not be available. It's also important to check that the purchased kilograms for an item on a specific day are less than the displayed kilograms for that item on that day; if this rule is unmet, this should be considered yet another error in the data file.

Task

Your task is to read the data from inventory.txt$.$ If there are no errors when reading the data, the program should prompt the user to provide the desired maximum ratio of unsold items on display $($call it max$\_$ratio$).$ This value should be a floating$-$point number between $0$ and $1.$ For each day$-$item pair, your program should calculate the ratio of unsold items on display. If this computed ratio is higher than the value in max$\_$ratio, your program should retain the available and computed information for this day$-$item pair.

To extract the data from inventory.txt$,$ your program should have a function named read$\_$inventory$\_$data, which takes a single parameter $$ the name of the file containing the data. This function should return a list of dictionaries. Each dictionary should contain the keys day$\_$of$\_$week, item$\_$name, unsold$\_$kg $($calculated by subtracting the purchased kilograms from the displayed kilograms$),$ and ratio$\_$unsold $($calculated by dividing unsold$\_$kg by the displayed kilograms$),$ but only if the data read from inventory.txt is valid. If there are any errors while reading data from the file, this function should raise an exception. Your main program should call this function and handle any exceptions, ensuring that the application does not crash but rather prints error messages and exits gracefully $($see examples of interactions below$).$

To determine which day$-$item pair would benefit most from reviewing displayed quantities, you should sort the day$-$item pairs with ratio$\_$unsold values above the max$\_$ratio threshold value. Your program should have a function sort$\_$inventory$\_$data that sorts the identified day$-$item pairs based on the their corresponding value of ratio$\_$unsold from highest to lowest ratio$\_$unsold value. Day$-$item pairs having same ratio$\_$unsold values should be sorted first by the day of the week $($Sunday being the first day and Saturday the last$)$ and then by item in ascending alphabetical order $($i$.$e$.$ apples, bananas, fish, and then finally meat$).$

Note: Your solution must include the two functions specified above, and can include any other functions, if you need so$.$ There is no requirement to use any particular sorting algorithm for this assignment. Any algorithm that gives the correct result $($without excessively slowing down or halting the computation$)$ can be used.