HW_Unit4_Pandas

Homework Unit 4 | Assignment - Pandas, Pandas, Pandas

Option 1: Heroes of Pymoli

Source File: purchase_data

Player Count

Total Number of Players

	Total Players
0	576

Purchasing Analysis (Total)

Number of Unique Items Average Purchase Price Total Number of Purchases Total Revenue

	Number of Unique Items	Average Price	Number of Purchases	Total Revenue
0	183	$3.05	780	$2,379.77

Gender Demographics

Percentage and Count of Male Players Percentage and Count of Female Players Percentage and Count of Other / Non-Disclosed

	Total Count	Percentage of Players
Male	484	84.03
Female	81	14.06
Other / Non-Disclosed	11	1.91

Purchasing Analysis (Gender)

The below each broken by gender:

• Purchase Count
• Average Purchase Price
• Total Purchase Value
• Average Purchase Total per Person by Gender

	Purchase Count	Average Purchase Price	Total Purchase Value	Avg Total Purchase per Person
Gender
Female	113	$3.20	$361.94	$4.47
Male	652	$3.02	$1,967.64	$4.07
Other / Non-Disclosed	15	$3.35	$50.19	$4.56

Age Demographics

The below each broken into bins of 4 years (i.e. <10, 10-14, 15-19, etc.)

• Purchase Count
• Average Purchase Price
• Total Purchase Value
• Average Purchase Total per Person by Age Group

	Total Count	Percentage of Players
<10	17	2.95
10-14	22	3.82
15-19	107	18.58
20-24	258	44.79
25-29	77	13.37
30-34	52	9.03
35-39	31	5.38
40+	12	2.08

Purchasing Analysis (Age)

The below each broken into bins of 4 years (i.e. <10, 10-14, 15-19, etc.)

• Purchase Count
• Average Purchase Price
• Total Purchase Value
• Average Purchase Total per Person etc. in the table below

	Purchase Count	Average Purchase Price	Total Purchase Value	Avg Total Purchase per Person
10-14	28	$2.96	$82.78	$3.76
15-19	136	$3.04	$412.89	$3.86
20-24	365	$3.05	$1,114.06	$4.32
25-29	101	$2.90	$293.00	$3.81
30-34	73	$2.93	$214.00	$4.12
35-39	41	$3.60	$147.67	$4.76
40+	13	$2.94	$38.24	$3.19
<10	23	$3.35	$77.13	$4.54

Top Spenders

Identify the the top 5 spenders in the game by total purchase value, then list (in a table):

• SN
• Purchase Count
• Average Purchase Price
• Total Purchase Value

	Purchase Count	Average Purchase Price	Total Purchase Value
SN
Lisosia93	5	$3.79	$18.96
Idastidru52	4	$3.86	$15.45
Chamjask73	3	$4.61	$13.83
Iral74	4	$3.40	$13.62
Iskadarya95	3	$4.37	$13.10

Most Popular Items

Identify the 5 most popular items by purchase count, then list (in a table):

• Item ID
• Item Name
• Purchase Count
• Item Price
• Total Purchase Value

		Purchase Count	Item Price	Total Purchase Value
Item ID	Item Name
178	Oathbreaker, Last Hope of the Breaking Storm	12	$4.23	$50.76
145	Fiery Glass Crusader	9	$4.58	$41.22
108	Extraction, Quickblade Of Trembling Hands	9	$3.53	$31.77
82	Nirvana	9	$4.90	$44.10
19	Pursuit, Cudgel of Necromancy	8	$1.02	$8.16

Most Profitable Items

Identify the 5 most profitable items by total purchase value, then list (in a table):

• Item ID
• Item Name
• Purchase Count
• Item Price
• Total Purchase Value

		Purchase Count	Item Price	Total Purchase Value
Item ID	Item Name
178	Oathbreaker, Last Hope of the Breaking Storm	12	$4.23	$50.76
82	Nirvana	9	$4.90	$44.10
145	Fiery Glass Crusader	9	$4.58	$41.22
92	Final Critic	8	$4.88	$39.04
103	Singed Scalpel	8	$4.35	$34.80

You must include a written description of three observable trends based on the data.

• 1. Males make up the majority of players at 84.03%, out of 576 total unique players
  • a. Females make up the second largest group of unique players at 14.06%, and Other/Non-Disclosed are 1.91% of total unique players
  • b. Males are the core market demographic
• 2. While Males make up the majority of unique players, the average total purchase per person is actually greatest for Other/Non-Disclosed at $4.56 compared to Males, who spent an average $4.56 total purchase per person, followed by Females who spent an average $4.47 total purchase per person
  • a. This would suggest increased marketing to Other/Non-Disclosed and Females could increase revenue
• 3. While the largest age demographic of unique players was the 20-24 age group at 44.79% of the total 576 unique players,
  • a. The largest average total purchase per person came from the 35-39 age group, which had an average total purchase per person of $4.76
  • b. The 20-24 age group actually ranked 3rd for average total purchase per person with $4.32 average total purchase per person - i. The <10 age group was second with an average total purchase per person of $4.50 - 1. Although based on reason/logic, the <10 age group most likely does not have a revenue stream, and much less disposable income, - 2. These purchases are most likely coming from individuals/parents with disposable income