import pandas as pd
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]

# --- Create dictionary and DataFrame ---
mini_movie_dict = {
    'Name': all_names,
    'Ticket Price': all_ticket_costs,
    'Surcharge': all_surcharges
}

mini_movie_frame = pd.DataFrame(mini_movie_dict)

# --- Calculate Total and Profit ---
mini_movie_frame['Total'] = mini_movie_frame['Ticket Price'] + mini_movie_frame['Surcharge']
mini_movie_frame['Profit'] = mini_movie_frame['Ticket Price'] - 5

# --- Calculate Totals ---
total_paid = mini_movie_frame['Total'].sum()
total_profit = mini_movie_frame['Profit'].sum()

# --- Display ticket summary ---
print(mini_movie_frame)
print()
print(f"Total Paid: ${total_paid:.2f}")
print(f"Total Profit: ${total_profit:.2f}")

# --- Raffle Winner Selection ---
winner = random.choice(all_names)

# Get winner's index
winner_index = all_names.index(winner)
print("Winner:", winner, "List position:", winner_index)

# Get their total ticket value using DataFrame
total_won = mini_movie_frame.at[winner_index, 'Total']

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