Question

I have bigger data than this but I can use it as an example. Please, write a python 3.6 code for the question.

expenses = [['De La Fuente', 'Roque', 'NY', 6000, 'Prof. Srvcs.'], ['De La Fuente', 'Roque', 'NY', 6000, 'Prof. Srvcs.'], ['Malliotakis', 'Nicole', 'MA', 40000, 'Television Ads.'], ['Marte', 'Christopher', 'NY', 5152, 'Radio Ads.'], ['Yeger', 'Kalman', 'NY', 23000, 'Campgn Consuls.'], ['Marte', 'Christopher', 'CA', 5711, 'Other: explntion']]

DATA expenses [['De La Euente', 'Roque, 'NY, 6000, 'Prof. Srvcs,], ['De La Fuente', 'Roque, 'NY', 6000, 'Prof. Srvcs'. ['Malliotakis', 'Nicole', 'MA', 40000, Television Ads.'], ['Marte', Christopher', 'NY', 5152, 'Radio Ads.'], ['Yeger, Kalman', 'NY' 23000, 'Campgn Consuls.'], ['Marte, Christopher', 'CA', 5711, 'Other: explntion']] Question Instructions The user wants to find out the total expenses for a candidate. Get the last name of a candidate from user input print the total amount of expenses for that candidate Examples: [0] Candidate last name (string) [1] Candidate first name (string) [2] State of payment recipient (string) [3] Expense amount (int) [4] Category of expense (string) Sample records [Cerini', John', 'NY, 5700, Campgn Lit.'] ['Valdes', Delvis', 'NY', 5677, 'Postage' ['de Blasio', Bill', 'NY', 6000, 'Campgn Wrkrs $$'] ['Diaz Jr.', 'Ruben', 'NY', 21311, Television Ads.'] 'Concannon', Joseph', 'NY', 9000, 'Office Rent'] Massey, Jr.', Paul", 'LA', 6139, 'Fundraising'] [I] [2 [3 [4] #get total of all expenses expense amounts = [row[3] for row in expenses] print(sum(expense amounts)) #get expenses for particular candidate cand expenses [row[3] for row in expenses if row[0 print(sum(cand expenses)) "De La Fuente"]

Answer 1

expenses = [['De La Fuente', 'Roque', 'NY', 6000, 'Prof. Srvcs.'], ['De La Fuente', 'Roque', 'NY', 6000, 'Prof. Srvcs.'], ['Malliotakis', 'Nicole', 'MA', 40000, 'Television Ads.'], ['Marte', 'Christopher', 'NY', 5152, 'Radio Ads.'], ['Yeger', 'Kalman', 'NY', 23000, 'Campgn Consuls.'], ['Marte', 'Christopher', 'CA', 5711, 'Other: explntion']]

# user input for last name of candidate
last_name = input('Enter the last name of candidate: ')

# for displaying total amount of expenses
expense_amount = [row[3] for row in expenses]
print('Total Expenses', sum(expense_amount))

# for displaying expenses for a particular candidate
candidate_amount = [row[3] for row in expenses if row[0] == last_name]
print('Expenses for candidate with last name', last_name, ':', sum(candidate_amount))

In [4]: runfile ( ' C:/Users/Administrator/.spyder- py3/ temp.py', wdir='C:/Users/Administrator/. spyder-py3') Enter the last name of candidate: De La Fuente Total Expens es 85863 Expenses for candidate with last name De La Fuente : 12000 In [5]:

For help and modification please comment.

Thank You