Assignment Overview

This lab exercise provides practice with file processing.

You will work with a partner on this exercise during your lab session. Two people should work at one computer. Occasionally switch the person who is typing. Talk to each other about what you are doing and why so that both of you understand each step.

Part A: Data Processing Given a data file, find the max, min, and average values of columns. Also, create an addition column that is based on the other columns. There will be no error checking required for this lab You are provided with a data file named (surprise!) data.txt. Data is arranged in columns where each item of data is twelve columns wide (so it is easy to extract data items using slicing) Name Joe Mary Dion Kayla Jose Sofia Erik Sara Height (m) 1.82 1.60 1.90 1.72 1.78 1.63 1.98 1.57 Weight (kg) 72.57 63.50 90.71 66.31 70.23 65.12 92.21 65.77 Your task is read the file data.txt and calculate the max, min, and average of the height and weight columns and to add an additional column that has the BMI calculated based on each height and weight Your output will look like this (and needs to be formatted like this). To match the testing on Mirmir here is the format string:"{: