excel operation

"""
Marks sheet calculations from excel
Date: 27.01.2020
"""
import functions
import pandas as pd

# Read the file
data = pd.read_csv('test.csv')
# Calculate Total marks
data['Total'] = data['Bangla'] + data['English'] + data['Math'] + data['Science']
# Calculate grad for Bangla
data['Bangla_Grad'] = [functions.grad(row['Bangla']) for index, row in data.iterrows()]
# Calculate GPA for Bangla
data['Bangla_GPA'] = [functions.gpa(row['Bangla_Grad']) for index, row in data.iterrows()]
print(data)

# Calculate grad for English
data['English_Grad'] = [functions.grad(row['English']) for index, row in data.iterrows()]
# Calculate GPA for English
data['English_GPA'] = [functions.gpa(row['English_Grad']) for index, row in data.iterrows()]
# Show the result
print(data[['Name', 'English', 'English_GPA', 'English_Grad']])

# Calculate grad for Math
data['Math_Grad'] = [functions.grad(row['Math']) for index, row in data.iterrows()]
# Calculate GPA for Math
data['Math_GPA'] = [functions.gpa(row['Math_Grad']) for index, row in data.iterrows()]
# Show the result
print(data[['Name', 'Math', 'Math_GPA', 'Math_Grad']])

# Calculate grad for Science
data['Science_Grad'] = [functions.grad(row['Science']) for index, row in data.iterrows()]
# Calculate GPA for English
data['Science_GPA'] = [functions.gpa(row['Science_Grad']) for index, row in data.iterrows()]
# Show the result
print(data[['Name', 'Science', 'Science_GPA', 'Science_Grad']])

# Write the output
data.to_csv('output.csv', index=False)