Write a Python program that reads a CSV file and prints the sum of the numbers in the third column. The program should handle exceptions for scenarios like a missing file, missing columns, or non-numeric values in the third column.
Example 1:
Input: CSV file content: "Name","Age","Salary" "John",25,4000 "Jane",30,5000 "Mike",28,6000
Output: 15000
Example 2:
Input: CSV file content: "Name","Age","Salary" "John",25,4000 "Jane",30,"Five Thousand" "Mike",28,6000 Output: Exception: Non-numeric value in the third column
Use Python’s built-in csv module to read the CSV file. For handling exceptions, use try-except blocks.
import csv
def sum_third_column(file_name):
try:
with open(file_name, 'r') as file:
reader = csv.reader(file)
next(reader) # Skip header
sum = 0
for row in reader:
try:
sum += int(row[2])
except ValueError:
return "Exception: Non-numeric value in the third column"
return sum
except FileNotFoundError:
return "Exception: File not found"
except IndexError:
return "Exception: Less than three columns in the file"
Unlock AI & Data Science treasures. Log in!