{"id":32763,"date":"2022-02-14T08:21:42","date_gmt":"2022-02-14T08:21:42","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/panda-challenge-1-computer-science-homework-help\/"},"modified":"2022-02-14T08:21:42","modified_gmt":"2022-02-14T08:21:42","slug":"panda-challenge-1-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/panda-challenge-1-computer-science-homework-help\/","title":{"rendered":"Panda challenge 1 | Computer Science homework help"},"content":{"rendered":"<div>\n<p>After a lot of hard work in the data munging mines, you&#8217;ve landed a job as Lead Analyst for an independent gaming company. You&#8217;ve been assigned the task of analyzing the data for their most recent fantasy game Heroes of Pymoli.<\/p>\n<p>Like many others in its genre, the game is free-to-play, but players are encouraged to purchase optional items that enhance their playing experience. As a first task, the company would like you to generate a report that breaks down the game&#8217;s purchasing data into meaningful insights.<\/p>\n<p>Your final report should include each of the following:<\/p>\n<h3><strong>Player Count<\/strong><\/h3>\n<h3><strong>Purchasing Analysis (Total)<\/strong><\/h3>\n<ul>\n<li>Number of Unique Items<\/li>\n<li>Average Purchase Price<\/li>\n<li>Total Number of Purchases<\/li>\n<li>Total Revenue<\/li>\n<\/ul>\n<h3><strong>Gender Demographics<\/strong><\/h3>\n<ul>\n<li>Percentage and Count of Male Players<\/li>\n<li>Percentage and Count of Female Players<\/li>\n<li>Percentage and Count of Other \/ Non-Disclosed<\/li>\n<\/ul>\n<h3><strong>Purchasing Analysis (Gender)<\/strong><\/h3>\n<ul>\n<li>The below each broken by gender\n<ul>\n<li>Purchase Count<\/li>\n<li>Average Purchase Price<\/li>\n<li>Total Purchase Value<\/li>\n<li>Average Purchase Total per Person by Gender<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><strong>Age Demographics<\/strong><\/h3>\n<ul>\n<li>The below each broken into bins of 4 years (i.e. &lt;10, 10-14, 15-19, etc.)\n<ul>\n<li>Purchase Count<\/li>\n<li>Average Purchase Price<\/li>\n<li>Total Purchase Value<\/li>\n<li>Average Purchase Total per Person by Age Group<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><strong>Top Spenders<\/strong><\/h3>\n<ul>\n<li>Identify the the top 5 spenders in the game by total purchase value, then list (in a table):\n<ul>\n<li>SN<\/li>\n<li>Purchase Count<\/li>\n<li>Average Purchase Price<\/li>\n<li>Total Purchase Value<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><strong>Most Popular Items<\/strong><\/h3>\n<ul>\n<li>Identify the 5 most popular items by purchase count, then list (in a table):\n<ul>\n<li>Item ID<\/li>\n<li>Item Name<\/li>\n<li>Purchase Count<\/li>\n<li>Item Price<\/li>\n<li>Total Purchase Value<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><strong>Most Profitable Items<\/strong><\/h3>\n<ul>\n<li>Identify the 5 most profitable items by total purchase value, then list (in a table):\n<ul>\n<li>Item ID<\/li>\n<li>Item Name<\/li>\n<li>Purchase Count<\/li>\n<li>Item Price<\/li>\n<li>Total Purchase Value<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>As final considerations:<\/p>\n<ul>\n<li>You must use the Pandas Library and the Jupyter Notebook.<\/li>\n<li>You must submit a link to your Jupyter Notebook with the viewable Data Frames.<\/li>\n<li>You must include a written description of three observable trends based on the data.<\/li>\n<li>See <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/UCF-Coding-Boot-Camp\/UCF-LKM-DATA-PT-05-2020-U-C\/blob\/master\/Homework\/04-Pandas\/Instructions\/HeroesOfPymoli\/HeroesOfPymoli_starter.ipynb\">Example Solution<\/a> for a reference on expected format(attachment).<\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>After a lot of hard work in the data munging mines, you&#8217;ve landed a job as Lead Analyst for an independent gaming company. You&#8217;ve been assigned the task of analyzing the data for their most recent fantasy game Heroes of Pymoli. Like many others in its genre, the game is free-to-play, but players are encouraged [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-32763","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/32763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=32763"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/32763\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=32763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=32763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=32763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}