import pandas as pd
import random

# --- Ticket Data ---
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]

# --- Build Dictionary & DataFrame ---
mini_movie_dict = {
    'Name': all_names,
    'Ticket Price': all_ticket_costs,
    'Surcharge': all_surcharges
}

mini_movie_frame = pd.DataFrame(mini_movie_dict)

# --- Add Calculated Columns ---
mini_movie_frame['Total'] = mini_movie_frame["Ticket Price"] + mini_movie_frame['Surcharge']
mini_movie_frame['Profit'] = mini_movie_frame['Ticket Price'] - 5

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

# --- Display Table ---
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)
winner_index = all_names.index(winner)

winner_ticket_price = all_ticket_costs[winner_index]
winner_surcharge = all_surcharges[winner_index]
total_won = winner_ticket_price + winner_surcharge

print()
print(f"🎉 Raffle Winner: {winner} 🎉")
print(f"Their ticket is now free! Total refunded: ${total_won:.2f}")