import pandas

#lists to hold ticket details
all_names = ["A","B","C","D","E"]
all_ticket_cost = [7.50,7.50,10.50,10.50,6.50]
all_surcharges = [0,0, 0.53,0.53,0]

mini_moive_dict = {
    'Name': all_names,
    'Ticket Price': all_ticket_cost,
    'surcharge': all_surcharges
}


mini_moive_frame = pandas.DataFrame(mini_moive_dict)


mini_moive_frame['Total'] = mini_moive_frame['Ticket Price'] + mini_moive_frame ['surcharge']
mini_moive_frame['profit'] = mini_moive_frame['Ticket Price'] - 5


total_paid = mini_moive_frame['Total'].sum()
total_profit = mini_moive_frame['profit'].sum()

print(mini_moive_frame)
print()
print(f"total paid ${total_paid:.2f}")
print(f"total profit {total_profit:.2f}")