import pandas
import numpy

# lists to hold Pokémon cards
all_cards = ["Blastoise (Base)", "Mewtwo (Holo)", "Gen gar (Reverse)", "Charizard (Holo)", "Venusaur (Base)",
             "Umbreon (Gold Star)", "Espeon (Full Art)", "Lugia (Rainbow Rare)", "Rayquaza (Secret Rare)",
             "Pikachu (Japanese Promo)"]
all_card_costs = [100, 200, 350, 425, 700, 950, 1100, 1600, 2000, 2500]



Pokemon_Card_dict = {
    'Pokemon Cards': all_cards,
    'Pokemon Card Price': all_card_costs,
}

# create dataframe / table from dictionary
Pokemon_Card_frame = pandas.DataFrame(Pokemon_Card_dict)

# Rearranging index
Pokemon_Card_frame.index = numpy.arange(1, len(Pokemon_Card_frame) + 1)


# work out total paid and total profit
total_price_sum = Pokemon_Card_frame['Pokemon Card Price'].sum()

print(Pokemon_Card_frame)
print()
print(f"Total sum of all cards: ${total_price_sum:.2f}")
# print(f"Total Profit: ${total_profit:.2f}")