Python 3.7

File LabpH.txt

File Turbidity.txt

You are a volunteer member of an organization called the Friends of the Shenandoah River, which monitors water-quality issues in the Shenandoah Valley. Water quality data is gathered weekly at a number of sites along the river by various volunteers and the data is then uploaded to their website You have been asked to create a computer program that can read the data files that have been uploaded to the site, and then display statistical calculations based on that data. You'd like to implement the following functionality 1. You want to give the user a choice of one of two files. Turbiditytxt" and "LabpH.txt" which you will find attached. Each file has in the first row the name of the item being measured and then an unknown number of readings. If you ask the user to enter the name of the file, be sure upper or lower case doesn't matter. (Note: the lowerl) and upper() method converts the case of a string, eg. if you print turbidity.txt'upper() you will get TURBIDITY.TXT as output) Also, be sure you give a good message if the program can't find the file that the user requests. 2. You want to be able to read a file with any number of rows. but you won't know ahead of time how many rows of data will be in the file. You do know, however, that there will be no missing values, i.e. empty cells, in the data tables. (Hint: See chapter 6, or the lecture slides, on how to read from the file until the end of the file is reached. Which kind of loop will you need?) Your code may algorithmically look something like this: # input name of file # open the file # get all input from file (NOTE: first row is data header) while not the end of the file: read a line of data and convert it numerical value #keep a running total increment loop counter t close file file object.close () NOTE: You can also use a for-loop (which may be easier) to do the same thing. The choice is yours! 3. Your program should calculate the average value in the column that gets read in and then display the column title and average value in an easy-to-read format in your output 4. Make your application as user-friendly as you can.Your program should NOT crash unexpectedly (i.e. input validation and exception handling should be used) and it should look professional. 5. Your program should present the output in SENTENCE form telling what was measured and the average reading