Question

pythin: Write a function named "computed_column" that takes a string as a parameter representing the name of a CSV file with 5 columns in the format ",,,," and writes a file named "blank.csv" containing all the data from the input file but with a sixth column containing the sum of the values from the second and fourth columns

Answer 1

def computed_column(filename):
    f = open(filename, 'r')
    w = open('blank.csv', 'w')
    for line in f:
        words = line.strip().split()
        w.write(line.strip() + "," + str(int(words[1]) + int(words[3])) + "\n")
    f.close()
    w.close()