import pandas as pd import numpy as np file = 'jobb.xlsx' # name of the file data = pd.read_excel(file) # reading the file knut = data['Knut'].values # values in column Knut sara = data['Sara'].values # values in column Sara baskets_knut = np.sum(knut) baskets_sara = np.sum(sara) print('Total number of baskets by Knut:', baskets_knut) print('Total number of baskets by Sara:', baskets_sara)