Heroes of Pymoli is a fantasy game that, like many others in its genre, is free-to-play, but players are encouraged to purchase optional items that enhance their playing experience. The goal of the project was to clean and organize the data using Pandas to answer some specific questions about gamer buying patterns and demographics that can help drive strategic decisions in other areas of the business like marketing.
- Player Count - What is the total player count? How many are male vs. female?
- Age Demograhics - What are the peak age demographics?
- Purchasing Analysis by Gender - Do females or males spend more on average?
- Popular Items - Which items are sold the most?
- Profitable Items - Which items account for highest total revenue?
https://github.com/dmilestone/pandas-challenge/blob/master/purchase_data.csv
- Calculated total player count.
- Calculated percentage and count of males versus females.
- Calculated the average price and total purchase count of each gender group.
- Binned age groups and calculated the number of players and percentage of players in each group.
- Calculated the purchase count, average purchase price, and total purchase value for each age group.
- Calculated the purchase count and total purchase value for the five most popular items.
- Calculated the purchase count and total purchase value for the five most profitable items.
-
Player Count - Of the 1163 active players, the vast majority are male (84%). There also exists, a smaller, but notable proportion of female players (14%).
-
Age Demograhics - Peak age demographics fall between 20-24 (44.8%) with secondary groups falling between 15-19 (18.60%) and 25-29 (13.4%).
-
Purchasing Analysis by Gender - Females spend more on average at 4.47 per person, while males sepnd an average of 4.07 per person.
-
Popular Items - "Oathbreaker, Last Hope of the Breaking Storm" was the most popular item sold at 12 purchases. Three items were tied for second most popular at 9 purchases - "Fiery Glass Crusader", "Extraction, Quickblade Of Trembling Hands", and "Nirvana."
-
Profitable Items - "Oathbreaker, Last Hope of the Breaking Storm" accounted for the most total revenue at 50.76 in total sales.
This project was published for educational purposes only. Copyright Trilogy Education Services © 2019. All Rights Reserved.