Question

Python Basic

Lists, File IO, Exception Handling

1. Call createTable() to:

Read in the data from each of the input files (in order from scores1.txt to scores5.txt) and store the data in table. The table is a list of lists, where the scores of each input file is a column of data of the table.

By the end of the function, the table should have 5 columns of numbers, each column is from one input file. Here is the first 4 rows of the table:

                                [83, 93, 85, 89, 97]

                                [95, 88, 85, 93, 95]

                                [88, 95, 84, 90, 96]

                                [72, 93, 70, 77, 97] ...

If any file can't be successfully opened, print an error message and end the program

Part 1, of 4

Answer 1

def createTable():
    data = []
    for i in range(1, 6):
        filename = 'scores' + str(i) + '.txt'
        index = 0
        try:
            with open(filename, 'r') as f:
                for line in f:
                    for word in line.strip().split():
                        if index >= len(data):
                            data.append([])
                        data[index].append(int(word))
                        index += 1
        except:
            print('Failed to open ' + filename)
    print(data)

createTable()