2d:null 2e:["$","title",null,{"children":"Nothing will hinder players from enjoying their Games, not even Ads. | Kasi Viswanath | Observable"}] 33:T636,{ let img = vl .markImage({ height: 40 }) .transform( vl.calculate("datum.ratings/1000000 + 'M'").as("Ratings"), vl.calculate("datum.developer").as("Publisher"), vl.calculate("datum.maxInstalls/1000000 + 'M'").as("Downloads"), vl.calculate("datum.maxInstalls").as("downloads") ) .encode( vl.x().fieldN("title"), vl.url().field("img"), vl.y().fieldQ(plotBy), vl.tooltip().field("title"), vl.href().field("url"), vl.color().fieldN("contentRating").scale({ scheme: "redpurple" }), vl.tooltip([ vl.field("title"), vl.field("Publisher"), vl.field("contentRating"), vl.field("Downloads"), vl.field("Ratings") ]) // vl.row().fieldN("category") ); const points = img.markPoint({ color: "firebrick", size: 8000 }); let line = vl .markLine() .transform(vl.calculate("datum.maxInstalls").as("downloads")) .encode( vl.x().fieldN("title").axis(null), vl.y().fieldQ(plotBy).axis({ grid: false }), vl.url().fieldN("img"), vl.tooltip([vl.field("title"), vl.field("publisher")]) // vl.row().fieldN("category") ); let plot = vl .layer(line, points, img) .data( [ ...selected_games.filter((d) => free_games != "N/A" ? d.free === free_games_dict[free_games] : d ) ] .sort((a, b) => { return a["ratings"] >= b["ratings"] ? -1 : 1; }) .slice(0, noOfGamesToPlot) ) .width(950) .render({ renderer: "svg" }); return plot; }34:Tc93,### Target Audience : - Gamers searching for the most popular and highly-rated games within each genre based on ratings and downloads - Gaming publishers who are looking to analyze user download patterns to determine their preference for ad-friendly or ad-free experiences ### Made-up Insights(Hypothesis): - Advertisements in gaming can irritate players and lower their interest, resulting in decreased playtime. Due to these reasons, gamers will not prefer games that have advertisements which can result in lower ratings/downloads of the game [selected] - Considerations: - I will need enough data on downloads and ratings of different games - I need to iterate all the records and group them by category to find avg rating/download - In terms of the idiom (visualization), I need to display the total of downloads/ratings for ad-supported and non-ad-supported games across various game genres using a line chart, with colors to distinguish the user download/rating patterns. - The pandemic led to an increase in multiplayer game players like PUBG, CALL OF DUTY, MOBILE LEGENDS, and growth in the gaming industry. Remote work and social distancing likely contributed to this trend - Considerations: - I will need enough data on downloads and ratings of different games - I need to iterate all the records and group them by category to find games with max rating/download - In terms of the idiom (visualization), I need to display the total of downloads/ ratings grouping by singe/multi-player games using Bar Chart will help me to distinguish them ### Data Abstraction(What): - Dataset type : Table - Dataset Availability : Static - Attributes: - Ratings - Quantitative; sequential - Downloads - Quantitative; sequential - Category - Categorical - Content-rating - Ordinal - Imgsrc - Categorical - AdSupported - Categorical - Free - Categorical - URL: Derived attribute url from imageheader - Categorical The dataset is manually downloaded utilizing the [google-play-scrapper](https://github.com/facundoolano/google-play-scraper) ### Tasks Abstraction(Why): By examining the dataset, we can check the made-up insights are true by the following: - T1 : Compare the download/rating of games from different genres with and without add support [Compare,Similarity] - T2 : Displaying the top n games with most downloads/ratings for different genre [Enjoy,Trends] - T3 : Summarize the top n games with most downloads/ratings of all genre [Summarize,Distribution] ### Marks and Channels (How): - Mark:- Line - Channel - **Color Saturation:** To identify the games with respect to content rating. - Attribute: Content Rating - Task: T1 - **Color Hue:** To identify the games with respect to Add Support. - Attribute: AddSupport - Task: T1 ### Real Insights: - From the line chart, we can conclude that gamers download the game of their choice irrespective of ads in the game. This deviated from my made-up insight where I believed that gamers do not like ads in their games. - The top-grossing game in action genre is Free fire, irrespective of metrics such as downloads, ratings35:[{"id":"03ab665b6eb7c77c0fbc99be3dba56dbba5251302df39e88045caa4eb9bc97f25c7583f2044c3d3faad956487f5ec92eb7110828212e3d482999bb8eb2c5a599","href":"https://static.observableusercontent.com/files/03ab665b6eb7c77c0fbc99be3dba56dbba5251302df39e88045caa4eb9bc97f25c7583f2044c3d3faad956487f5ec92eb7110828212e3d482999bb8eb2c5a599","name":"android-games.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1674972899320.501,"size":219343},{"id":"af92bc17b081325ebaaf39ecbecbed6a50a4f9d5a229422d4f07eec1f65f8ecf93d91d760b6ab92e40c279453b82cb39b703f70c2c045329a1e8e6ab234a0d39","href":"https://static.observableusercontent.com/files/af92bc17b081325ebaaf39ecbecbed6a50a4f9d5a229422d4f07eec1f65f8ecf93d91d760b6ab92e40c279453b82cb39b703f70c2c045329a1e8e6ab234a0d39","name":"games.json","type":"application/json","lastModified":1675144788174.918,"size":79053},{"id":"4564b84c98c259cf2f24c714cd3758997fb9559c9f303ff16e1c7497674462d5a3b96ba388611dbb68fe721834882949533c2e5f203f48402c8f45a384004d62","href":"https://static.observableusercontent.com/files/4564b84c98c259cf2f24c714cd3758997fb9559c9f303ff16e1c7497674462d5a3b96ba388611dbb68fe721834882949533c2e5f203f48402c8f45a384004d62","name":"top_10_games.json","type":"application/json","lastModified":1675144972303.55,"size":1305573},{"id":"5dc097a894a1bed146175a716ba3d13043aeb21a60fb3c66bc3d8d857d37b2f2d2dadfa55da0a016b21626cc9a3e9f30a29cf43c4973ac4a7e014438beb1fd68","href":"https://static.observableusercontent.com/files/5dc097a894a1bed146175a716ba3d13043aeb21a60fb3c66bc3d8d857d37b2f2d2dadfa55da0a016b21626cc9a3e9f30a29cf43c4973ac4a7e014438beb1fd68","name":"top_100_games.json","type":"application/json","lastModified":1675148214658.64,"size":14293066}] 31:{"id":"9f2900f8b2d06270","slug":"andriod-game-analysis","title":"Nothing will hinder players from enjoying their Games, not even Ads.","thumbnail":"bcdacdb010b89c26d08756b431ec24af396e83004bc61b780e5e5af8332e6419","access_level":"public","create_time":"$D2023-01-29T06:14:18.357Z","update_time":"$D2023-04-05T09:53:14.968Z","view_time":null,"first_public_time":"$D2023-01-29T06:14:18.357Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"b760ea566a896d7d","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":"starter_2024"},"version":1120,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"fcd94e1c1ca12ae9","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":null}],"members":[{"type":"individual","id":"fcd94e1c1ca12ae9","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":null,"role":"editor"}],"comments":[{"id":"29f0dfd163115d68","reply_to_id":null,"content":"Nice headline - good insight!","create_time":"$D2023-02-08T21:19:32.908Z","update_time":null,"resolved":false,"user":{"type":"individual","id":"d06cccb760acb8c3","login":"lilyneu","name":"LilyLi","avatar_url":"https://avatars-next.observableusercontent.com/57d00e99e7bd16a222a22f6669c9ce03fafca3705a95350ea5f4e3608b1f0ec9","tier":null}},{"id":"2a22e235d91450ba","reply_to_id":null,"content":"Very nice and clear data abstraction and task abstraction!","create_time":"$D2023-02-08T21:22:16.825Z","update_time":null,"resolved":false,"user":{"type":"individual","id":"d06cccb760acb8c3","login":"lilyneu","name":"LilyLi","avatar_url":"https://avatars-next.observableusercontent.com/57d00e99e7bd16a222a22f6669c9ce03fafca3705a95350ea5f4e3608b1f0ec9","tier":null}}],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"14a0961462b84603","slug":"dataviz","title":"DataViz","owner":{"id":"b760ea566a896d7d","login":"kasivisu4","name":"Kasi Viswanath"}},"type":"notebook","body":{"title":"Nothing will hinder players from enjoying their Games, not even Ads.","cells":[{"id":0,"value":"# Nothing will hinder players from enjoying their Games, not even Ads.\n\n Homework 2: Vega-Lite Visualization \n- Created by [Kasi Viswanath Vandanapu](https://vandanapuk.sites.northeastern.edu/)\n- Class [CS 7295: Special Topics Course / Information Visualization](https://johnguerra.co/classes/data_visualization_spring_2023/)\n- Professor Name : [John Alexis Guerra Gómez](https://johnguerra.co)\n- [Youtube](https://www.youtube.com/watch?v=3FpB_OxYpjE)\n- [Tweet](https://twitter.com/kasi_vandanapu/status/1620872573423882243)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":230,"value":"### Introduction\n\nGames offer more than just entertainment. Some studies show that certain games can improve cognitive skills like problem-solving, decision-making and spatial awareness. The trend in Android games is moving towards more realistic and immersive experiences with a focus on online multiplayer. Battle Royale games like PUBG Mobile and Call of Duty: Mobile and open-world games like Garena Free Fire are popular examples.\n\nThe Google Play Store offers a diverse range of gaming genres to cater to different tastes, including action, puzzle, arcade, sports, and strategy. There is a vast selection of both free and paid Android games available on the platform, providing players with ample choice and flexibility. According to [Statistsa](https://www.statista.com/statistics/780229/number-of-available-gaming-apps-in-the-google-play-store-quarter/), approximately 490 thousand mobile gaming apps were available in the Google Play Store","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":249,"value":"viewof selected_categories = {\n let categories = Array.from(\n d3.group(top_100_games, (d) => d[\"genreId\"]).keys()\n );\n\n return searchCheckbox(categories, {\n value: categories,\n label: html`*Select the Game Category`,\n height: \"100%\"\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":863,"value":"*** Adjust the counter to specify the number of games to show on the chart
\n Click play to animate displaying games","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":913,"value":"viewof noOfGamesToPlot = Scrubber([1, 2, 3, 4, 5, 6, 7, 8, 9, 10], {\n delay: 2000,\n loop: false,\n alternate: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":874,"value":"*** Choose the option to select free or paid games explicitly","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":519,"value":"viewof free_games = Inputs.radio([\"YES\", \"NO\", \"N/A\"], {\n label: \"FREE GAMES\",\n value: \"N/A\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":954,"value":"*** Choose the option to compare the games by ratings or downloads","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":950,"value":"viewof plotBy = Inputs.radio([\"ratings\", \"downloads\"], {\n label: \"Compare by \",\n value: \"downloads\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1082,"value":"## Top ${noOfGamesToPlot} Games by ${plotBy} w.r.t Content Rating","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":136,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1096,"value":"## Top ${noOfGamesToPlot} Games by ${plotBy} w.r.t Genre","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":451,"value":"{\n let v = vl\n .markImage({ height: 100 })\n .data(top_n_games)\n .encode(\n vl.x().fieldN(\"rank\"),\n vl.y().fieldN(\"genreId\").title(\"genre\"),\n vl.url().field(\"img\"),\n vl.href().field(\"url\"),\n vl.tooltip().fieldN(\"title\")\n )\n\n .width(100 * noOfGamesToPlot)\n .height(55 * selected_categories.length)\n // .facet(vl.fieldN(\"genreId\"))\n\n .render();\n\n return v;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1099,"value":"## Top ${noOfGamesToPlot} Games by ${plotBy}, genre w.r.t Adsupported","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":678,"value":"{\n let v = vl\n .markLine()\n .data(top_n_games)\n .transform(\n vl\n .groupby(\"genreId\", \"adSupported\")\n .aggregate(vl.mean(plotBy_dict[plotBy]).as(plotBy))\n )\n .encode(\n vl.x().fieldN(\"genreId\").title(\"genre\"),\n vl.y().fieldQ(plotBy).axis({ grid: false }),\n vl.color().fieldN(\"adSupported\"),\n vl.tooltip([vl.fieldN(\"genreId\"), vl.field(\"adSupported\")])\n )\n .width(1000);\n\n let c = v.markCircle();\n\n return vl.layer(v, c).render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":992,"value":"$34","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1037,"value":"### Data Preprocessing - with javascript\n - In order to select the top n games for different genres, i have used d3 to group by genres and rank them based on ratings/downloads chosen by the user and sort them based on ratings/downloads","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":570,"value":"top_n_games = [\n ...d3.group(\n selected_games.filter((d) =>\n free_games != \"N/A\" ? d.free === free_games_dict[free_games] : d\n ),\n (d) => d.genreId\n )\n]\n .map((d) => {\n let x = [...d[1]].sort(\n (a, b) => a[plotBy_dict[plotBy]] < b[plotBy_dict[plotBy]]\n );\n return x.slice(0, noOfGamesToPlot).map((d, i) => {\n d[\"rank\"] = i + 1;\n return d;\n });\n })\n .flat()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1051,"value":" - Inorder to display images, I have appended the width and height of the image to the url","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":273,"value":"//Filter Based on category\nselected_games = top_100_games.filter((d) =>\n selected_categories.includes(d[\"genreId\"]) \n).map((d) => {\n d[\"img\"] = d[\"headerImage\"] + \"=w832-h470\";\n return d;\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":960,"value":"plotBy_dict = ({\n ratings: \"ratings\",\n downloads: \"maxInstalls\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"free_games_dict = ({\n YES: true,\n NO: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"top_100_games = FileAttachment(\"top_100_games.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"import { vl } from \"@vega/vega-lite-api-v5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":282,"value":"import { searchCheckbox } from \"@john-guerra/search-checkbox\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1111,"value":"

","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":909,"value":"import { Scrubber } from \"@mbostock/scrubber\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":743,"value":"selected_games","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 32:"$31:body"