Report on ‘games.csv’ for ConRR tutorial on 11th October 2024.

The following document includes a detailed analysis of the file ‘games.csv’.

Defining the dimensions of the file “games.csv”

knitr::include_graphics("games.png")

games <- read.csv("games.csv")
dim(games)
## [1] 10532    23
summary(games)
##        X            game_id       description           image          
##  Min.   :    1   Min.   :     1   Length:10532       Length:10532      
##  1st Qu.: 2634   1st Qu.:  5444   Class :character   Class :character  
##  Median : 5266   Median : 28822   Mode  :character   Mode  :character  
##  Mean   : 5266   Mean   : 62059                                        
##  3rd Qu.: 7899   3rd Qu.:126410                                        
##  Max.   :10532   Max.   :216725                                        
##   max_players       max_playtime         min_age        min_players   
##  Min.   :  0.000   Min.   :    0.00   Min.   : 0.000   Min.   :0.000  
##  1st Qu.:  4.000   1st Qu.:   30.00   1st Qu.: 8.000   1st Qu.:2.000  
##  Median :  4.000   Median :   45.00   Median :10.000   Median :2.000  
##  Mean   :  5.657   Mean   :   91.34   Mean   : 9.715   Mean   :2.071  
##  3rd Qu.:  6.000   3rd Qu.:   90.00   3rd Qu.:12.000   3rd Qu.:2.000  
##  Max.   :999.000   Max.   :60000.00   Max.   :42.000   Max.   :9.000  
##   min_playtime          name            playing_time       thumbnail        
##  Min.   :    0.00   Length:10532       Min.   :    0.00   Length:10532      
##  1st Qu.:   25.00   Class :character   1st Qu.:   30.00   Class :character  
##  Median :   45.00   Mode  :character   Median :   45.00   Mode  :character  
##  Mean   :   80.88                      Mean   :   91.34                     
##  3rd Qu.:   90.00                      3rd Qu.:   90.00                     
##  Max.   :60000.00                      Max.   :60000.00                     
##  year_published    artist            category         compilation       
##  Min.   :1950   Length:10532       Length:10532       Length:10532      
##  1st Qu.:1998   Class :character   Class :character   Class :character  
##  Median :2007   Mode  :character   Mode  :character   Mode  :character  
##  Mean   :2003                                                           
##  3rd Qu.:2012                                                           
##  Max.   :2016                                                           
##    designer          expansion            family            mechanic        
##  Length:10532       Length:10532       Length:10532       Length:10532      
##  Class :character   Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character   Mode  :character  
##                                                                             
##                                                                             
##                                                                             
##   publisher         average_rating   users_rated     
##  Length:10532       Min.   :1.384   Min.   :   50.0  
##  Class :character   1st Qu.:5.830   1st Qu.:   85.0  
##  Mode  :character   Median :6.393   Median :  176.0  
##                     Mean   :6.371   Mean   :  870.1  
##                     3rd Qu.:6.943   3rd Qu.:  518.0  
##                     Max.   :9.004   Max.   :67655.0
colnames(games)
##  [1] "X"              "game_id"        "description"    "image"         
##  [5] "max_players"    "max_playtime"   "min_age"        "min_players"   
##  [9] "min_playtime"   "name"           "playing_time"   "thumbnail"     
## [13] "year_published" "artist"         "category"       "compilation"   
## [17] "designer"       "expansion"      "family"         "mechanic"      
## [21] "publisher"      "average_rating" "users_rated"

‘games.csv’ has 10532 rows and 23 columns.

Generating a table for “games.csv”

tab <- head(games[, 1:7])
better.colnames <- c("Number", "Game name", "Description", "Image", "Maximun # of players", "Maximum playtime", "Minimun age")
better.tab <- kable(tab,
                    col.names = better.colnames,
                    digits = c(1, 0, 0, 0, 0, 0, 0),
                    align = c("ccccccc"),
                    caption = "Source 'games.csv'")
librarian::shelf(kableExtra)
## 
##   The 'cran_repo' argument in shelf() was not set, so it will use
##   cran_repo = 'https://cran.r-project.org' by default.
## 
##   To avoid this message, set the 'cran_repo' argument to a CRAN
##   mirror URL (see https://cran.r-project.org/mirrors.html) or set
##   'quiet = TRUE'.
paper.tab <- kable_paper(kable_input=better.tab)
paper.tab
Source ‘games.csv’
Number Game name Description Image Maximun # of players Maximum playtime Minimun age
1 1 Die Macher is a game about seven sequential political races in different regions of Germany. Players are in charge of national political parties, and must manage limited resources to help their party to victory. The winning party will have the most victory points after all the regional elections. There are four different ways of scoring victory points. First, each regional election can supply one to eighty victory points, depending on the size of the region and how well your party does in it. Second, if a party wins a regional election and has some media influence in the region, then the party will receive some media-control victory points. Third, each party has a national party membership which will grow as the game progresses and this will supply a fair number of victory points. Lastly, parties score some victory points if their party platform matches the national opinions at the end of the game.&#10;&#10;The 1986 edition featured 4 parties from the old West Germany and supported 3-4 players. The 1997 edition supports up to 5 players in the re-united Germany and updated several features of the rules as well. The 2006 edition also supports up to 5 players and adds a shorter 5 round variant and additional rules updates by the original designer.&#10;&#10;Die Macher is #1 in the Valley Games Classic Line&#10;&#10; //cf.geekdo-images.com/images/pic159509.jpg 5 240 14
2 2 Dragonmaster is a trick-taking card game based on an older game called Coup d’etat. Each player is given a supply of plastic gems, which represent points. Each player will get to be the dealer for five different hands, with slightly different goals for each hand. After all cards have been dealt out, the dealer decides which hand best suits his or her current cards, and the other players are penalized points (in the form of crystals) for taking certain tricks or cards. For instance, if &quot;first&quot; or &quot;last&quot; is called, then a player is penalized for taking the first or last tricks. All players will get a chance to be dealer for five hands, but other players can steal this opportunity by taking all of the tricks during certain hands. At the end, the biggest pile of gems wins the game.&#10;&#10;Jewel contents:&#10;&#10;11 clear (3 extra)&#10;13 green (1 extra)&#10;22 red (2 extra)&#10;22 blue (2 extra)&#10;&#10; //cf.geekdo-images.com/images/pic184174.jpg 4 30 12
3 3 Part of the Knizia tile-laying trilogy, Samurai is set in medieval Japan. Players compete to gain the favor of three factions: samurai, peasants, and priests, which are represented by helmet, rice paddy, and Buddha tokens scattered about the board, which features the islands of Japan. The competition is waged through the use of hexagonal tiles, each of which help curry favor of one of the three factions &mdash; or all three at once! Players can make lightning-quick strikes with horseback ronin and ships or approach their conquests more methodically. As each token (helmets, rice paddies, and Buddhas) is surrounded, it is awarded to the player who has gained the most favor with the corresponding group.&#10;&#10;Gameplay continues until all the symbols of one type have been removed from the board or four tokens have been removed from play due to a tie for influence.&#10;&#10;At the end of the game, players compare captured symbols of each type, competing for majorities in each of the three types. Ties are not uncommon and are broken based on the number of other, &quot;non-majority&quot; symbols each player has collected.&#10;&#10; //cf.geekdo-images.com/images/pic3211873.jpg 4 60 10
4 4 When you see the triangular box and the luxurious, large blocks, you can tell this game was designed to be beautiful as well as functional. The object of the game is to build pyramids out of the different colored blocks. A pyramid scores more points when it’s made from a few colors, but it’s much harder to consistently outbid the other players for the necessary blocks. The game is over when the Pharoah’s Pyramid in the center is completed, which is built using all the blocks that the players don’t use during the course of the game.&#10;&#10;Final round 1990 Hippodice Spieleautorenwettbewerb.&#10;&#10; //cf.geekdo-images.com/images/pic285299.jpg 4 60 12
5 5 In Acquire, each player strategically invests in businesses, trying to retain a majority of stock. As the businesses grow with tile placements, they also start merging, giving the majority stockholders of the acquired business sizable bonuses, which can then be used to reinvest into other chains. All of the investors in the acquired company can then cash in their stocks for current value or trade them 2-for-1 for shares of the newer, larger business. The game is a race to acquire the greatest wealth.&#10;&#10;This Sid Sackson classic has taken many different forms over the years depending on the publisher. Some versions of the 3M bookshelf edition included rules for a 2-player variant. The original version is part of the 3M Bookshelf Series.&#10;&#10;Note: many books and websites list this as a 1962 publication. This is incorrect; information from Sid Sackson’s diaries, correspondence, and royalty statements prove that it was published in 1964. However, for some reason admins continue to accept &quot;corrections&quot; of the publication date to 1962. A detailed timeline of the development and publication of the game can be found at https://opinionatedgamers.com/2014/05/29/how-acquire-became-acquire/, for those interested.&#10;&#10; //cf.geekdo-images.com/images/pic342163.jpg 6 90 12
6 6 In the ancient lands along the Mediterranean, players attempt to satisfy their unique victory conditions via trade, war and construction. This lavishly produced game contains tons of wooden game components and a beautiful roll-out vinyl map. Players produce a score of different commodities to trade with other cities in the hope of creating enough income to fill their capitals with buildings, produce artwork, and fill warehouses with goods.&#10;&#10; //cf.geekdo-images.com/images/pic28424.jpg 6 240 12

Plotting the Maximun playtime of the games

hist(games$year_published)

Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.

Sub-heading: plots

You can run code that creates plots, and knitr will show them by default:

LS0tCnRpdGxlOiAiQW50aG9ueS1HYW1lcy1SZXBvcnQtMTExMDI0IgphdXRob3I6ICJEciBBbnRob255IFRvcnJlcy1SdWVzdGEiCmRhdGU6ICIyMDI0LTEwLTExIgpvdXRwdXQ6CiBodG1sX2RvY3VtZW50OgogICAgY3NzOiBib290c3RyYXAuY3NzCiAgICBjb2RlX2Rvd25sb2FkOiB0cnVlICMgc2hvdy9oaWRlIGNvZGUgZG93bmxvYWQgYnV0dG9uCiAgICAjY29kZV9mb2xkaW5nOiBzaG93CiAgICB0b2M6IHRydWUgIyBzaG93L2hpZGUgVGFibGUgT2YgQ29udGVudHMKICAgIHRvY19mbG9hdDogdHJ1ZSAjIHNob3cgVG9DIGFsbCB0aGUgdGltZSBvciBvbmx5IGF0IHRvcAogICAgdGhlbWU6IGJvb3RzdHJhcCAjICAoYXZhaWxhYmxlOiBkZWZhdWx0LCBib290c3RyYXAsIGNlcnVsZWFuLCBjb3NtbywgZGFya2x5LCBmbGF0bHksIGpvdXJuYWwsIGx1bWVuLCBwYXBlciwgcmVhZGFibGUsIHNhbmRzdG9uZSwgc2ltcGxleCwgc3BhY2VsYWIsIHVuaXRlZCwgYW5kIHlldGkpCiAgICBoaWdobGlnaHQ6IHplbmJ1cm4gIyAoYXZhaWxhYmxlOiBkZWZhdWx0LCB0YW5nbywgcHlnbWVudHMsIGthdGUsIG1vbm9jaHJvbWUsIGVzcHJlc3NvLCB6ZW5idXJuLCBoYWRkb2NrLCBicmVlemVkYXJrLCBhbmQgdGV4dG1hdGUpCi0tLQpgYGB7ciwgaW5jbHVkZT1GQUxTRX0Ka25pdHI6Om9wdHNfY2h1bmskc2V0KGVjaG8gPSBUUlVFKQoKaWYoImxpYnJhcmlhbiIgJWluJSBpbnN0YWxsZWQucGFja2FnZXMoKT09RkFMU0UpIGluc3RhbGwucGFja2FnZXMoImxpYnJhcmlhbiIpCmxpYnJhcmlhbjo6c2hlbGYoa25pdHIsIHByZXR0eWRvYywgZ2dwbG90MiwgY3Jhbl9yZXBvID0gJ2h0dHBzOi8vY3Jhbi5yLXByb2plY3Qub3JnJykKYGBgCgpgYGB7ciBzZXR1cCwgaW5jbHVkZT1GQUxTRX0Ka25pdHI6Om9wdHNfY2h1bmskc2V0KGVjaG8gPSBUUlVFKQpgYGAKCiMgUmVwb3J0IG9uICdnYW1lcy5jc3YnIGZvciBDb25SUiB0dXRvcmlhbCBvbiAxMXRoIE9jdG9iZXIgMjAyNC4KClRoZSBmb2xsb3dpbmcgZG9jdW1lbnQgaW5jbHVkZXMgYSBkZXRhaWxlZCBhbmFseXNpcyBvZiB0aGUgZmlsZSAnZ2FtZXMuY3N2Jy4KCiMjIERlZmluaW5nIHRoZSBkaW1lbnNpb25zIG9mIHRoZSBmaWxlICJnYW1lcy5jc3YiCgpgYGB7cn0Ka25pdHI6OmluY2x1ZGVfZ3JhcGhpY3MoImdhbWVzLnBuZyIpCmdhbWVzIDwtIHJlYWQuY3N2KCJnYW1lcy5jc3YiKQpkaW0oZ2FtZXMpCnN1bW1hcnkoZ2FtZXMpCmNvbG5hbWVzKGdhbWVzKQpgYGAKCidnYW1lcy5jc3YnIGhhcyAxMDUzMiByb3dzIGFuZCAyMyBjb2x1bW5zLgoKIyMgR2VuZXJhdGluZyBhIHRhYmxlIGZvciAiZ2FtZXMuY3N2IgoKYGBge3J9CnRhYiA8LSBoZWFkKGdhbWVzWywgMTo3XSkKYmV0dGVyLmNvbG5hbWVzIDwtIGMoIk51bWJlciIsICJHYW1lIG5hbWUiLCAiRGVzY3JpcHRpb24iLCAiSW1hZ2UiLCAiTWF4aW11biAjIG9mIHBsYXllcnMiLCAiTWF4aW11bSBwbGF5dGltZSIsICJNaW5pbXVuIGFnZSIpCmJldHRlci50YWIgPC0ga2FibGUodGFiLAogICAgICAgICAgICAgICAgICAgIGNvbC5uYW1lcyA9IGJldHRlci5jb2xuYW1lcywKICAgICAgICAgICAgICAgICAgICBkaWdpdHMgPSBjKDEsIDAsIDAsIDAsIDAsIDAsIDApLAogICAgICAgICAgICAgICAgICAgIGFsaWduID0gYygiY2NjY2NjYyIpLAogICAgICAgICAgICAgICAgICAgIGNhcHRpb24gPSAiU291cmNlICdnYW1lcy5jc3YnIikKbGlicmFyaWFuOjpzaGVsZihrYWJsZUV4dHJhKQpwYXBlci50YWIgPC0ga2FibGVfcGFwZXIoa2FibGVfaW5wdXQ9YmV0dGVyLnRhYikKcGFwZXIudGFiCmBgYAoKIyMgUGxvdHRpbmcgdGhlIE1heGltdW4gcGxheXRpbWUgb2YgdGhlIGdhbWVzCgpgYGB7cn0KaGlzdChnYW1lcyR5ZWFyX3B1Ymxpc2hlZCkKYGBgCgpOb3RlIHRoYXQgdGhlIGBlY2hvID0gRkFMU0VgIHBhcmFtZXRlciB3YXMgYWRkZWQgdG8gdGhlIGNvZGUgY2h1bmsgdG8gcHJldmVudCBwcmludGluZyBvZiB0aGUgUiBjb2RlIHRoYXQgZ2VuZXJhdGVkIHRoZSBwbG90LgoKIyMgU3ViLWhlYWRpbmc6IHBsb3RzCgpZb3UgY2FuIHJ1biBjb2RlIHRoYXQgY3JlYXRlcyBwbG90cywgYW5kIGtuaXRyIHdpbGwgc2hvdyB0aGVtIGJ5IGRlZmF1bHQ6Cg==