Question

Write a PYTHON program that reads a comma delimited CSV file with four columns and returns the average of each column in the file. (Check the picture below for the expected output)

Answer 1

import csv

with open('employee_birthday.txt') as csv_file:

   csv_reader = csv.reader(csv_file, delimiter=',')

   line_count = 0

   for row in csv_reader:

       if line_count == 0:

           print(f'Column names are {", ".join(row)}')

           line_count += 1

       else:

           print(f'\t{row[0]} works in the {row[1]} department, and was born in {row[2]}.')

           line_count += 1

   print(f'Processed {line_count} lines.')