import pandas
import random

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

mini_movie_dict = {
    'Name': all_names,
    'Ticket Price': all_ticket_costs,
    'Surcharge': all_surcharges,
}

# Create dataframe / table from dictionary
mini_movie_frame = pandas.DataFrame(mini_movie_dict)

# Calculate the total payable and profit for each ticket
mini_movie_frame['Total'] = mini_movie_frame['Ticket Price'] + mini_movie_frame['Surcharge']
mini_movie_frame['Profit'] = mini_movie_frame['Ticket Price'] - 5

# Work out total paid and total profit
total_paid = mini_movie_frame['Total'].sum()
total_profit = mini_movie_frame['Profit'].sum()

print(mini_movie_frame.to_string(index=False))

# Choose random winner
winner = random.choice(all_names)

# Find index of winner (ie: position in list)
winner_index = all_names.index(winner)
print("Winner", winner, "list position", winner_index)

# Retrieve total won
total_won = mini_movie_frame.at[winner_index, 'Total']

# Winner announcement
print(f"The lucky winner is {winner}. Their ticket worth ${total_won:.2f} is free!")