pandas-challenge

Observable trends located in the analysis folder within the HeroesOfPymoli directory.

Acting as Lead Analyst for an imaginary game called Heroes of Pymoli.

The purpose of this challenge is to simplify the data and uncover trends by using pandas in Jupyter Notebook. The background concept of this challenge, is that Heroes of Pymoli is a free game that offers players the option to make in-app purchases for items that can give them a competitive edge over other players.

In this challenge, I generated a report that lists the following:

Player Count (Number of unique players)

A Purchasing Analysis consisting of:

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

Gender Demographics, which shows the Percentage and Count of players separated by Gender

Purchasing Analysis by Gender, which shows each of the following broken up by Gender:

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

Age Demographics, which shows the Percentage and Count of players separated by Age Group.

Purchasing Analysis by Gender, which shows each of the following broken up by Age Group:

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

The Top 5 Spenders, showing the following for each player:

• Player SN (Gamertag)
• Purchase Count
• Average Purchase Price
• Total Purchase Value

The 5 Most Popular Items, showing:

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

The 5 Most Profitable Items, showing:

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

To get a better visualization of the tables, download this repository and run the script in Jupyter Notebook.

To run the script in jupyter:

• Save the repository in desired location, then cd into that directory in git bash (or terminal if OS user).
• Type jupyter notebook into terminal.
• Once in jupyter notebook, open HeroesOfPymoli_starter.ipynb file and run through each section of the script.