Please see attached files - include challenge question.

13
CP5805 ASSIGNMENT 2
Main Task Specifications - DataFrame Manipulation & Visualization
To design and implement a data analysis program in Python using pandas.
Program allows users to load a DataFrame from a CSV file, clean the data in various ways, display statistics and create visualizations. An introductory message will be displayed when the program is loaded. After the welcome message, user will be presented with following menu:
Please choose from the following options:
1 - Load data from the file
2 - View data
3 - Clean data
4 - Analyse Data
5 - Visualise Date
6 - Save data to a file
7 - Quit
Option 7 exits the program; every other option performs some task and displays the menu, until the user chooses Option 7 from the menu. An error message (Invalid Selection!) will be displayed if value other than a value between 1 and 7 is entered.
Menu Option 1: Load data from the file
On choosing this option, a filename will be asked, which is expected to be in the same directory as the program. In case if file not found or data inappropriate, corresponding error message is displayed. After file loads successfully, program displays names of the columns and asks if user wants to set any of the columns as index.
Menu Option 2: View data
This option prints DataFrame to the screen, with the proper index.
Menu Option 3: Clean data
This option will provide a submenu offering various cleaning options
Cleaning data:
    1 – Drop rows with missing values
    2 – Fill missing values
    3 – Drop duplicate rows
    4 – Drop column
    5 – Rename column
    6 – Finish cleaning
Menu Option 4:...