pandas_get_total_row.py

"""
Get total of each column values
"""
def totalcount(data):
    return data.assign(Total=data.drop('Total', errors='ignore', axis=1).sum(1))

def pandas_get_total_row(df):
  df = df.pipe(totalcount).T.pipe(totalcount).T
  return df

df = pd.read_csv("<path to csv>")
df = pandas_get_total_row(df)
print(df)