This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.
When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:
require(ggplot2)
## Loading required package: ggplot2
library(ggplot2)
week9books<-read.csv('c:/temp/week9Assignment.csv',header=TRUE)
str(week9books)
## 'data.frame': 35 obs. of 7 variables:
## $ Serial.No: Factor w/ 35 levels "1st Edition ",..: 24 23 16 17 18 14 13 12 28 22 ...
## $ X1 : Factor w/ 28 levels " 1401323251",..: 25 26 28 28 28 28 28 4 10 20 ...
## $ X2 : Factor w/ 26 levels " 978-8184024913",..: 15 20 26 21 21 21 21 7 13 24 ...
## $ X3 : Factor w/ 30 levels " Brian W. Kernighan and Dennis M. Ritchie",..: 19 26 29 29 29 23 23 7 10 20 ...
## $ X4 : Factor w/ 26 levels " 5.4 x 1.1 x 8.2 inches",..: 21 19 25 25 25 25 25 2 6 13 ...
## $ X5 : Factor w/ 27 levels " Hurwitz, Alan Nugent, Fern Halper, Marcia Kaufman",..: 14 16 23 27 27 23 23 3 8 15 ...
## $ X6 : Factor w/ 26 levels " 7.4 x 0.8 x 9.3 inches",..: 25 22 23 26 26 23 23 5 13 17 ...
summary(week9books)
## Serial.No
## 1st Edition : 1
## Amazon Best Sellers Rank: 1
## Audible : 1
## Audio CD : 1
## Author of the Book : 1
## Average Customer Review : 1
## (Other) :29
## X1
## Yes : 6
## 1 : 2
## This book is a very large gift in its compact : 2
## 1401323251 : 1
## 978-1401323257 : 1
## instead of finding inspiration, I was deeply disappointed and sometimes downright irritated.: 1
## (Other) :22
## X2
## 0 : 4
## No : 4
## None : 3
## Yes : 2
## 978-8184024913 : 1
## A must have library collection: 1
## (Other) :20
## X3
## yes : 3
## 0 : 2
## No : 2
## Brian W. Kernighan and Dennis M. Ritchie: 1
## 14.4 ounces : 1
## (Other) :25
## NA's : 1
## X4
## 4.93 : 5
## yes : 5
## 1 : 2
## 5.4 x 1.1 x 8.2 inches: 1
## 1/1/2007 : 1
## 11.4 ounces : 1
## (Other) :20
## X5
## 0 : 4
## no : 3
## yes : 3
## 1 : 2
## Hurwitz, Alan Nugent, Fern Halper, Marcia Kaufman: 1
## 1118504224 : 1
## (Other) :21
## X6
## 0 : 3
## no : 3
## None : 3
## yes : 3
## 1 : 2
## 7.4 x 0.8 x 9.3 inches: 1
## (Other) :20
require(gdata)
## Loading required package: gdata
## gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED.
##
## gdata: read.xls support for 'XLSX' (Excel 2007+) files ENABLED.
##
## Attaching package: 'gdata'
##
## The following object is masked from 'package:stats':
##
## nobs
##
## The following object is masked from 'package:utils':
##
## object.size
week9xls<-read.xls('c:/temp/week9Assignment.xls')
str(week9xls)
## 'data.frame': 35 obs. of 7 variables:
## $ Serial.No: Factor w/ 35 levels "1st Edition ",..: 24 23 16 17 18 14 13 12 28 22 ...
## $ X1 : Factor w/ 28 levels " 1401323251",..: 25 26 28 28 28 28 28 4 11 20 ...
## $ X2 : Factor w/ 26 levels " 978-8184024913",..: 15 20 26 21 21 21 21 6 13 24 ...
## $ X3 : Factor w/ 30 levels " Brian W. Kernighan and Dennis M. Ritchie",..: 19 26 29 29 29 23 23 7 10 20 ...
## $ X4 : Factor w/ 26 levels " 5.4 x 1.1 x 8.2 inches",..: 21 19 25 25 25 25 25 2 6 13 ...
## $ X5 : Factor w/ 27 levels " Hurwitz, Alan Nugent, Fern Halper, Marcia Kaufman",..: 14 16 23 27 27 23 23 3 9 15 ...
## $ X6 : Factor w/ 26 levels " 7.4 x 0.8 x 9.3 inches",..: 25 22 23 26 26 23 23 5 14 17 ...
summary(week9xls)
## Serial.No
## 1st Edition : 1
## Amazon Best Sellers Rank: 1
## Audible : 1
## Audio CD : 1
## Author of the Book : 1
## Average Customer Review : 1
## (Other) :29
## X1
## Yes : 6
## 1 : 2
## This book is a very large gift in its compact : 2
## 1401323251 : 1
## 978-1401323257 : 1
## instead of finding inspiration, I was deeply disappointed and sometimes downright irritated.: 1
## (Other) :22
## X2
## 0 : 4
## No : 4
## None : 3
## Yes : 2
## 978-8184024913 : 1
## A must have library collection: 1
## (Other) :20
## X3
## yes : 3
## 0 : 2
## No : 2
## Brian W. Kernighan and Dennis M. Ritchie: 1
## 14.4 ounces : 1
## (Other) :25
## NA's : 1
## X4
## 4.93 : 5
## yes : 5
## 1 : 2
## 5.4 x 1.1 x 8.2 inches: 1
## 11.4 ounces : 1
## 12463 : 1
## (Other) :20
## X5
## 0 : 4
## no : 3
## yes : 3
## 1 : 2
## Hurwitz, Alan Nugent, Fern Halper, Marcia Kaufman: 1
## 1118504224 : 1
## (Other) :21
## X6
## 0 : 3
## no : 3
## None : 3
## yes : 3
## 1 : 2
## 7.4 x 0.8 x 9.3 inches: 1
## (Other) :20
week9xls
## Serial.No
## 1 Name of the Book
## 2 Meaning of the book
## 3 Is Available in Hardcover
## 4 Is Available in Kindle Edition
## 5 Is Available in Paperback
## 6 Is Available as Audible
## 7 Is Audio CD Available
## 8 How Many volume
## 9 Pages
## 10 Language
## 11 ISBN-10
## 12 ISBN-13
## 13 Product Dimension
## 14 Shipping Weight
## 15 Average Customer Review
## 16 Number of customer reviewed
## 17 Amazon Best Sellers Rank
## 18 Publisher
## 19 1st Edition
## 20 Hardcover Cost
## 21 Kindle Edition cost
## 22 Paper Back Cost
## 23 Audible
## 24 Audio CD
## 25 Author of the Book
## 26 Contributor
## 27 Top Most Good Review 1
## 28 Top Most Good Review 2
## 29 Top Most Good Review 3
## 30 Bad Review 1
## 31 Bad Review 2
## 32 Is Available in Amzon.com
## 33 Other Market Places 1
## 34 Other Market Places 2
## 35 Currently Available Edition
## X1
## 1 The Last Lecture
## 2 the last lecture of Randy Pausch before his death
## 3 Yes
## 4 Yes
## 5 Yes
## 6 Yes
## 7 Yes
## 8 1
## 9 206
## 10 English
## 11 1401323251
## 12 978-1401323257
## 13 5.5 x 0.9 x 7.2 inches
## 14 9.6 ounces
## 15 4.6 out of 5.0
## 16 2117
## 17 1455
## 18 Hachette Books
## 19 2008-04-08
## 20 16.48
## 21 9.99
## 22 2.78
## 23 14.95
## 24 15.79
## 25 Randy Pausch
## 26 Jeffrey Zaslow
## 27 This book is a very large gift in its compact
## 28 This book is a very large gift in its compact
## 29 A Fantastic Gift
## 30 Emotionally, I was moved but I was expecting something deeper or better written.
## 31 instead of finding inspiration, I was deeply disappointed and sometimes downright irritated.
## 32 Yes
## 33 Goodreads.com
## 34 Barnes & Noble
## 35 1
## X2
## 1 Arthamulla Indhu Madham
## 2 Meaning of the Hindu Religion
## 3 Yes
## 4 No
## 5 No
## 6 No
## 7 No
## 8 10
## 9 800
## 10 Tamil
## 11 8184024916
## 12 978-8184024913
## 13 22.2 x 14.4 x 4.6 cm
## 14 Not Available
## 15 5 out of 5
## 16 16
## 17 3384
## 18 Kannadhasan Pathippagam
## 19 2009-01-01
## 20 5.5
## 21 0
## 22 0
## 23 0
## 24 0
## 25 Kannadhasan
## 26 None
## 27 very short and understandable
## 28 would recommend it to all human beings irrespective of religions
## 29 A must have library collection
## 30 None
## 31 None
## 32 Yes
## 33 flipkart.com
## 34 junglee.com
## 35 1
## X3
## 1 C Programming Language
## 2 Programming in C
## 3 yes
## 4 yes
## 5 yes
## 6 No
## 7 No
## 8 1
## 9 296
## 10 English
## 11 131103709
## 12 978-0131103702
## 13 9.5 x 7.3 x 1 inches
## 14 14.4 ounces
## 15 4.7 out of 5
## 16 489
## 17 332546
## 18 Prentice Hall
## 19 <NA>
## 20 35.13
## 21 33.5
## 22 52.89
## 23 0
## 24 0
## 25 Brian W. Kernighan and Dennis M. Ritchie
## 26 None
## 27 it gives you accurate and concise answers
## 28 I especially liked the excercises
## 29 This book is not \\for Dummies\\
## 30 The book was a trendsetter in several ways
## 31 No offense intended - but this is for the old version of ANSI C
## 32 Yes
## 33 Goodreads.com
## 34 Barnes & Noble
## 35 2
## X4
## 1 Rich Dad Poor Dad
## 2 Motivational reading for making money
## 3 yes
## 4 yes
## 5 yes
## 6 yes
## 7 yes
## 8 1
## 9 288
## 10 English
## 11 3442217784
## 12 978-3442217786
## 13 5.4 x 1.1 x 8.2 inches
## 14 11.4 ounces
## 15 4.3 out of 5.0
## 16 40
## 17 12463
## 18 Goldmann TB
## 19 2007-01-01
## 20 4.93
## 21 4.93
## 22 4.93
## 23 4.93
## 24 4.93
## 25 Sharon L. Lechter and Robert T. Kiyosaki
## 26 None
## 27 This is a fantastic book and last I heard it became the best selling book of all time in its category and I can see why. It is a perfect example about how we are \\trained\\ to think about money
## 28 I state that financial auditors shouldn't read this book because it goes against what they are taught.
## 29 He also explains it to you like a third grader what the difference is between a \\liability\\ and an \\asset\\ which sadly, most people don't know.
## 30 This book was a difficult read; I felt it was too drawn out but the message is worth the difficult read.
## 31 I had to read this book for a Nonprofit Fundraising class to think about how rich people think about money. For that reason, and that reason only, it was valuable. But my short Amazon review cannot do justice to how awful the book itself actually is. It is awful on so many levels, so I'll just cherry pick a few.
## 32 Yes
## 33 Goodreads.com
## 34 Barnes & Noble
## 35 1
## X5
## 1 Big Data Dummies
## 2 Find the right big data solution for your business or organization Big data management is one of the major challenges facing business, industry, and not-for-profit organizations.
## 3 no
## 4 yes
## 5 yes
## 6 no
## 7 no
## 8 1
## 9 336
## 10 English
## 11 1118504224
## 12 978-1118504222
## 13 7.4 x 0.6 x 9.3 inches
## 14 Not Available
## 15 3.7 out off 5
## 16 30
## 17 50974
## 18 For Dummies
## 19 2013-04-15
## 20 0
## 21 0
## 22 18.48
## 23 0
## 24 0
## 25 Hurwitz, Alan Nugent, Fern Halper, Marcia Kaufman
## 26 None
## 27 My Engineering department constantly talks about Hadoop, Sqoop, Pig and Hive, and I was afraid that the zookeeper they referred to was somehow a real thing.
## 28 t covers a lot of aspects of big data, topics
## 29 I wish it had more general business elements, and the sections that deal with the problems and challenges of big data
## 30 I regret buying this book. No, it's not the money that I paid, I regret the time I spent trying to see if there was something that I could learn in it.
## 31 Incoherent. It was amazing to read things I understood already, and not understand the explanations. Apparently written piecemeal by committee.
## 32 yes
## 33 Goodreads.com
## 34 Barnes & Noble
## 35 1
## X6
## 1 R Dummies
## 2 Master the programming language of choice among statisticiansand data analysts worldwide
## 3 no
## 4 yes
## 5 yes
## 6 no
## 7 no
## 8 1
## 9 406
## 10 English
## 11 1119962846
## 12 978-1119962847
## 13 7.4 x 0.8 x 9.3 inches
## 14 1.4 pounds
## 15 4.0 out of 5.0
## 16 35
## 17 36431
## 18 For Dummies
## 19 2012-06-25
## 20 0
## 21 16.49
## 22 19.88
## 23 0
## 24 0
## 25 Andrie de Vries , Joris Meys
## 26 None
## 27 Given the series' reputation, R for Dummies should be suited for readers with little or no experience in programming or R.
## 28 \\R For Dummies\\ also provides useful directions to the various R online communities
## 29 I had not done any programming for at least 15 years. I had a project that needed programming. The R language was recommended to me. I had no experience with R so I bought this book. I found it an excellent way to learn the basics and the nuances of R. I recommend it highly.
## 30 None
## 31 None
## 32 yes
## 33 Goodreads.com
## 34 Barnes & Noble
## 35 1