Write a program that reads a file containing two columns of floating-point numbers. Prompt the user for the file name. Print the average of each column. Be sure to look at the test cases to see how the output is formatted.

In Python:

file = input("File name: ")

f=open(file,"r")

lines=f.readlines()

col1=[]  

col2=[]

for x in lines:

col1.append(float(x.split(' ')[0]))

for x in lines:

col2.append(float(x.split(' ')[1].rstrip('\n')))

f.close()

sum1 = 0.0

sum2 = 0.0

for i in range(len(col1)):

sum1+=col1[i]

sum2+=col2[i]

print("Average of Column 1: %.2f" %(sum1/len(col1)))

print("Average of Column 2: %.2f" %(sum2/len(col2)))

Explanation:

This prompts the user for file name

file = input("File name: ")

This opens the file

f=open(file,"r")

This reads the lines of the file

lines=f.readlines()

This creates an empty list for column 1

col1=[]  

This creates an empty list for column 2

col2=[]

The following iterations iterate through the lines and puts them in the respective column list

for x in lines:

col1.append(float(x.split(' ')[0]))

for x in lines:

col2.append(float(x.split(' ')[1].rstrip('\n')))

This closes the file

f.close()

This initializes the sum of column 1 to 0

sum1 = 0.0

This initializes the sum of column 2 to 0

sum2 = 0.0

This iterates through each list and adds up the list contents

for i in range(len(col1)):

sum1+=col1[i]

sum2+=col2[i]

This calculates prints the average of the first column to 2 d.p

print("Average of Column 1: %.2f" %(sum1/len(col1)))

This calculates prints the average of the second column to 2 d.p

print("Average of Column 2: %.2f" %(sum2/len(col2)))