Source file ⇒ small-project-books.Rmd
This data was downloaded from the UC Berkeley Library from records in their online directory. You can find the data sets at the following website: http://tiny.cc/dcf/Library-small.rda
The Bks data table has 3765 cases, meaning 3765 books that may or may not be in the libraries collection. It also has 15 variables. Some of the information that can be drawn from this set include title, author, publication date, format, call number, and other variables in the set of 15 listed in the table.
On the other hand, the Inv data table has 2000 cases of books and has 18 variables. the Inv data table provides an inventory or collection of the books in the data table. Some of the information that can be drawn from this set include shelving location, book type, call number, author, title, ISBN number, and many more.
Number of cases for Bks data table:
## [1] 3765Number of cases for Inv data table:
## [1] 2000Number of variables Bks data table:
## [1] 15Number of variables for Inv data table:
## [1] 18View of the first few cases for Bks data table:
## Classes 'tbl_df', 'tbl' and 'data.frame': 3765 obs. of 15 variables:
## $ OCLC.Number : int 1179 9864 10413 10982 11900 23797 32490 32490 32490 35437 ...
## $ Format : chr "Book, Print" "Book, Print" "Book, Print" "Book, Print" ...
## $ Subject : chr "Special Industries & Trades, General" "History, General" "Religions, Mythology, Rationalism" "English Literature" ...
## $ Title : chr "United States oil policy, 1890-1964; business and government in twentieth century America" "The historian as detective; essays on evidence." "Religion in the Middle East: three religions in concord and conflict;" "Style in Hamlet." ...
## $ Author : chr "Nash, Gerald D." "Winks, Robin W.," "Arberry, A. J.1905-1969.(Arthur John)," "Charney, Maurice." ...
## $ Publication.Date : int 1968 1969 1969 1969 1969 1969 1969 1969 1969 1969 ...
## $ Edition : chr "" "[1st ed.]." "" "" ...
## $ Publisher : chr "University of Pittsburgh Press" "Harper & Row" "Cambridge U.P.," "Princeton University Press," ...
## $ ISBN : chr "" "" "521074002" "691061483" ...
## $ Language : chr "English" "English" "English" "English" ...
## $ Physical.Description: chr "ix, 286 pages" "xxiv, 543 pages" "2 v." "xxii, 333 pages" ...
## $ Genre : chr "" "" "" "" ...
## $ LC.Call.Number : chr "HD9565" "D13" "BL1600" "PR2807" ...
## $ Dewey.Call.Number : chr "338.2/7/282" "907/.2" "200/.956" "822.3/3" ...
## $ Local.Call.Number : chr "HD 9565 N28" "D 13 W65" "BL1600 .A7" "PR2807 .C28" ...View of the first few cases for Inv data table:
## Classes 'grouped_df', 'tbl_df', 'tbl' and 'data.frame': 2000 obs. of 18 variables:
## $ Shelving.Location : chr "Stacks - Level 3" "Stacks - Level 3" "Stacks - Level 3" "Stacks - Level 3" ...
## $ Item.Type : chr "VOLUME" "VOLUME" "VOLUME" "VOLUME" ...
## $ Call.Number : chr "HD9055 .B44 1989" "HD31 .C53 1961" "PG3476.B2 A6 1993" "JN30 .E94168 2010" ...
## $ Author : chr "Belasco, Warren James." "Churchman, C. West" "Babelʹ, I." "Kaiser, Wolfram," ...
## $ Title.or.Description : chr "Appetite for change : how the counterculture took on the food industry, 1966-1988 /" "Prediction and optimal decision; philosophical issues of a science of values." "Chetyre rasskaza /" "European Union history : themes and debates /" ...
## $ Textual.Holdings : chr NA NA NA NA ...
## $ Material.Format : chr "Book" "Book" "Book" "Book" ...
## $ OCLC.Number : int 19740110 228904 32110080 569523646 2732280 5128192 52386287 6944420 156834468 44502344 ...
## $ ISBN : chr "0394543998^9780394543994" "" "185399300" "0230232701^0230232698^9780230232693^9780230232709" ...
## $ Item.Barcode : chr "30527005082322" "30527021608449" "30527021072745" "30527023965441" ...
## $ Cost : chr "USD 0.00" "USD 0.00" "USD 0.00" "USD 27.84" ...
## $ Current.Status : chr "AVAILABLE" "WITHDRAWN" "AVAILABLE" "AVAILABLE" ...
## $ Loan.Date.Due : POSIXct, format: NA NA ...
## $ Issued.Count : int 26 0 0 1 1 1 1 3 1 2 ...
## $ Issued.Count.YTD : int 1 0 0 0 0 0 0 0 0 0 ...
## $ Last.Issued.Date : POSIXct, format: "2015-03-25 19:35:52" NA ...
## $ Last.Inventoried.Date: POSIXct, format: NA NA ...
## $ Item.Deleted.Date : POSIXct, format: NA "2015-03-24 11:48:51" ...
## - attr(*, "vars")=List of 1
## ..$ : symbol Item.Type
## - attr(*, "drop")= logi TRUE
## - attr(*, "indices")=List of 1
## ..$ : int 0 1 2 3 4 5 6 7 8 9 ...
## - attr(*, "group_sizes")= int 2000
## - attr(*, "biggest_group_size")= int 2000
## - attr(*, "labels")='data.frame': 1 obs. of 1 variable:
## ..$ Item.Type: chr "VOLUME"
## ..- attr(*, "vars")=List of 1
## .. ..$ : symbol Item.TypeBelow, one can observe the current status of books in the library, listing the number of available books in the library, missing books, loaned books, and withdrawn books. The left column, labeled Current.Status displays the different statuses while the right column, labeled n displays the number of books befitting the corresponding status type.
## Source: local data frame [4 x 2]
##
## Current.Status n
## (chr) (int)
## 1 AVAILABLE 1866
## 2 MISSING 1
## 3 ON_LOAN 18
## 4 WITHDRAWN 115The table below displays how many times books have been checked out.
## Source: local data frame [46 x 2]
##
## Issued.Count n
## (int) (int)
## 1 0 996
## 2 1 337
## 3 2 203
## 4 3 121
## 5 4 69
## 6 5 46
## 7 6 38
## 8 7 29
## 9 8 24
## 10 9 20
## .. ... ...As such, the results of the tables display current information about book statuses and number of times books have been checked out respectively. This can be used to provide quantitative information on the quantity of books that were checkd out, loaned, and other statuses, but does not display specific books in particular. To do so, other functions may be used to provide a list of a few books in the package for more information about the data table.