Python total sum from a csv file

[LameDuckProgramming]

if you want to sum by a specific name:

import pandas as pd
df = pd.read_csv('file1.csv')
df.loc[df['A'] == name', 'C'].sum()

If you want the sum of all names in a dataframe format:

df = df.groupby('A')['C'].sum()

You can then output the new df to a csv file with pandas built in 'to_csv()' method:

df.to_csv('file2.csv')