Using Python to develop a simple data analysis system (). The students are required to use Python to develop a simple data analysis system according to the following guidelines:

The system should read a CSV (Comma-Separated Values) file which stores the data for four variables: students ID (id), name (name), number of hours of study (hours) and students final score (score). The first raw of the file contains the variable names. When the system starts, it should show a welcome screen, then it shows the menu of options.

The menu of options should include the following tasks:

1. Read Data: the system should ask for a file name, then it reads this file and stores its content to variables (4 list variables). The system should print a message showing that reading data was successful.

2. List Data: To show the content of the data file to the user (in a nice and readable way).

3. Compute and Show Grades: the system should compute and print students ID, name and grade for each student according to the following rule: A: for 100>=score >=90 B: for 90> score>=75 C: for 75> score>=60 D: for 60> score>=50 F: for 50>

4. Search by Name: the system should ask for students name or part of the name, then it prints the data for all students with names containing the given name/part.

5. Descriptive Statistics: To calculate and show the mean, variance and standard deviation of the two variables: hours and score.

6. Regression Analysis: To calculate the simple regression parameters b0 and b1 of the regression equation (score = b0 + b1*hours), and print the regression equation. 2

7. Prediction: The regression equation can be used to predict the score of a student for a specific number of hours of study. The system should ask for hours and print the predicted score. 8. Exit: to print a good-bye message and exit the system. The system should keep showing the menu to the user until he/she selects the Exit option. The code should include enough documentation (using comments # ), to explain the purpose of the variables, function and hard-to-understand parts of the code.

the file

A1 fx id D E F G 1 lid score 2 6 95 3 10 90 4 8 97 5 99 B name hours 1 Ahmed Aly 2 Yasser Moh 3 Faten Yous 4 Manar Kha 5 Jana Moha 6 Salma Salal 7 Aziz Atef 8 Malak Wah 9 Noha Ahme 10 Mayar Oma 7 5 6 80 7 4 70 8 9 92 9 6 90 10 2 60 3 50 11 12 . 13 14 15 16