Cereal.csv data file from Canvas for this
lab.R
markdown file, run some simple code. The questions here aim to get you
familiar with the R syntax.Before you start the tutorial, create a new RStudio project in a new directory. Then, start your tutorial by writing your answers in a new R Markdown file.
Cereal.csv file from the Canvas page and
use the read.csv command to read in the csv file into
R and assign it to the object called
cereal.cereal=read.csv("Cereal.csv", head=T)
R called
cereal. Use the head function to inspect the
first few lines of the data frame and use class to check
that cereal is in fact a data frame.head(cereal)
## name mfr type calories protein fat sodium fiber carbo
## 1 100%_Bran N C 70 4 1 130 10.0 5.0
## 2 100%_Natural_Bran Q C 120 3 5 15 2.0 8.0
## 3 All-Bran K C 70 4 1 260 9.0 7.0
## 4 All-Bran_with_Extra_Fiber K C 50 4 0 140 14.0 8.0
## 5 Almond_Delight R C 110 2 2 200 1.0 14.0
## 6 Apple_Cinnamon_Cheerios G C 110 2 2 180 1.5 10.5
## sugars potass vitamins shelf weight cups rating
## 1 6 280 25 3 1 0.33 68.40297
## 2 8 135 0 3 1 1.00 33.98368
## 3 5 320 25 3 1 0.33 59.42551
## 4 0 330 25 3 1 0.50 93.70491
## 5 8 -1 25 3 1 0.75 34.38484
## 6 10 70 25 1 1 0.75 29.50954
class(cereal)
## [1] "data.frame"
cereal data frame? How
many rows are there? (dim and nrow)colnames(cereal)
## [1] "name" "mfr" "type" "calories" "protein" "fat"
## [7] "sodium" "fiber" "carbo" "sugars" "potass" "vitamins"
## [13] "shelf" "weight" "cups" "rating"
dim(cereal)
## [1] 77 16
nrow(cereal)
## [1] 77
calories column using the $
operator and using the [[ operator.install.packages("magrittr")
## 将程序包安装入'C:/Users/sl226/AppData/Local/R/win-library/4.3'
## (因为'lib'没有被指定)
## 程序包'magrittr'打开成功,MD5和检查也通过
##
## 下载的二进制程序包在
## C:\Users\sl226\AppData\Local\Temp\RtmpMrQXtz\downloaded_packages里
install.packages("dplyr")
## 将程序包安装入'C:/Users/sl226/AppData/Local/R/win-library/4.3'
## (因为'lib'没有被指定)
## 程序包'dplyr'打开成功,MD5和检查也通过
##
## 下载的二进制程序包在
## C:\Users\sl226\AppData\Local\Temp\RtmpMrQXtz\downloaded_packages里
library(magrittr)
library(dplyr)
##
## 载入程辑包:'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
cereal$calories
## [1] 70 120 70 50 110 110 110 130 90 90 120 110 120 110 110 110 100 110 110
## [20] 110 100 110 100 100 110 110 100 120 120 110 100 110 100 110 120 120 110 110
## [39] 110 140 110 100 110 100 150 150 160 100 120 140 90 130 120 100 50 50 100
## [58] 100 120 100 90 110 110 80 90 90 110 110 90 110 140 100 110 110 100 100
## [77] 110
cereal["calories"]
## calories
## 1 70
## 2 120
## 3 70
## 4 50
## 5 110
## 6 110
## 7 110
## 8 130
## 9 90
## 10 90
## 11 120
## 12 110
## 13 120
## 14 110
## 15 110
## 16 110
## 17 100
## 18 110
## 19 110
## 20 110
## 21 100
## 22 110
## 23 100
## 24 100
## 25 110
## 26 110
## 27 100
## 28 120
## 29 120
## 30 110
## 31 100
## 32 110
## 33 100
## 34 110
## 35 120
## 36 120
## 37 110
## 38 110
## 39 110
## 40 140
## 41 110
## 42 100
## 43 110
## 44 100
## 45 150
## 46 150
## 47 160
## 48 100
## 49 120
## 50 140
## 51 90
## 52 130
## 53 120
## 54 100
## 55 50
## 56 50
## 57 100
## 58 100
## 59 120
## 60 100
## 61 90
## 62 110
## 63 110
## 64 80
## 65 90
## 66 90
## 67 110
## 68 110
## 69 90
## 70 110
## 71 140
## 72 100
## 73 110
## 74 110
## 75 100
## 76 100
## 77 110
cereal[["calories"]]
## [1] 70 120 70 50 110 110 110 130 90 90 120 110 120 110 110 110 100 110 110
## [20] 110 100 110 100 100 110 110 100 120 120 110 100 110 100 110 120 120 110 110
## [39] 110 140 110 100 110 100 150 150 160 100 120 140 90 130 120 100 50 50 100
## [58] 100 120 100 90 110 110 80 90 90 110 110 90 110 140 100 110 110 100 100
## [77] 110
cereal %>% select("calories")
## calories
## 1 70
## 2 120
## 3 70
## 4 50
## 5 110
## 6 110
## 7 110
## 8 130
## 9 90
## 10 90
## 11 120
## 12 110
## 13 120
## 14 110
## 15 110
## 16 110
## 17 100
## 18 110
## 19 110
## 20 110
## 21 100
## 22 110
## 23 100
## 24 100
## 25 110
## 26 110
## 27 100
## 28 120
## 29 120
## 30 110
## 31 100
## 32 110
## 33 100
## 34 110
## 35 120
## 36 120
## 37 110
## 38 110
## 39 110
## 40 140
## 41 110
## 42 100
## 43 110
## 44 100
## 45 150
## 46 150
## 47 160
## 48 100
## 49 120
## 50 140
## 51 90
## 52 130
## 53 120
## 54 100
## 55 50
## 56 50
## 57 100
## 58 100
## 59 120
## 60 100
## 61 90
## 62 110
## 63 110
## 64 80
## 65 90
## 66 90
## 67 110
## 68 110
## 69 90
## 70 110
## 71 140
## 72 100
## 73 110
## 74 110
## 75 100
## 76 100
## 77 110
cereal data frame.cereal[0:10,]
## name mfr type calories protein fat sodium fiber carbo
## 1 100%_Bran N C 70 4 1 130 10.0 5.0
## 2 100%_Natural_Bran Q C 120 3 5 15 2.0 8.0
## 3 All-Bran K C 70 4 1 260 9.0 7.0
## 4 All-Bran_with_Extra_Fiber K C 50 4 0 140 14.0 8.0
## 5 Almond_Delight R C 110 2 2 200 1.0 14.0
## 6 Apple_Cinnamon_Cheerios G C 110 2 2 180 1.5 10.5
## 7 Apple_Jacks K C 110 2 0 125 1.0 11.0
## 8 Basic_4 G C 130 3 2 210 2.0 18.0
## 9 Bran_Chex R C 90 2 1 200 4.0 15.0
## 10 Bran_Flakes P C 90 3 0 210 5.0 13.0
## sugars potass vitamins shelf weight cups rating
## 1 6 280 25 3 1.00 0.33 68.40297
## 2 8 135 0 3 1.00 1.00 33.98368
## 3 5 320 25 3 1.00 0.33 59.42551
## 4 0 330 25 3 1.00 0.50 93.70491
## 5 8 -1 25 3 1.00 0.75 34.38484
## 6 10 70 25 1 1.00 0.75 29.50954
## 7 14 30 25 2 1.00 1.00 33.17409
## 8 8 100 25 3 1.33 0.75 37.03856
## 9 6 125 25 1 1.00 0.67 49.12025
## 10 5 190 25 3 1.00 0.67 53.31381
Kelloggs which only
contains rows that belongs to manufacturer, Kellogs (when
mfr takes the value "K").Kelloggs <- cereal[cereal$mfr=="K",]
print(Kelloggs)
## name mfr type calories protein fat sodium fiber carbo
## 3 All-Bran K C 70 4 1 260 9 7
## 4 All-Bran_with_Extra_Fiber K C 50 4 0 140 14 8
## 7 Apple_Jacks K C 110 2 0 125 1 11
## 17 Corn_Flakes K C 100 2 0 290 1 21
## 18 Corn_Pops K C 110 1 0 90 1 13
## 20 Cracklin'_Oat_Bran K C 110 3 3 140 4 10
## 22 Crispix K C 110 2 0 220 1 21
## 25 Froot_Loops K C 110 2 1 125 1 11
## 26 Frosted_Flakes K C 110 1 0 200 1 14
## 27 Frosted_Mini-Wheats K C 100 3 0 0 3 14
## 29 Fruitful_Bran K C 120 3 0 240 5 14
## 39 Just_Right_Crunchy__Nuggets K C 110 2 1 170 1 17
## 40 Just_Right_Fruit_&_Nut K C 140 3 1 170 2 20
## 47 Mueslix_Crispy_Blend K C 160 3 2 150 3 17
## 49 Nut&Honey_Crunch K C 120 2 1 190 0 15
## 50 Nutri-Grain_Almond-Raisin K C 140 3 2 220 3 21
## 51 Nutri-grain_Wheat K C 90 3 0 170 3 18
## 54 Product_19 K C 100 3 0 320 1 20
## 59 Raisin_Bran K C 120 3 1 210 5 14
## 61 Raisin_Squares K C 90 2 0 0 2 15
## 63 Rice_Krispies K C 110 2 0 290 0 22
## 67 Smacks K C 110 2 1 70 1 9
## 68 Special_K K C 110 6 0 230 1 16
## sugars potass vitamins shelf weight cups rating
## 3 5 320 25 3 1.00 0.33 59.42551
## 4 0 330 25 3 1.00 0.50 93.70491
## 7 14 30 25 2 1.00 1.00 33.17409
## 17 2 35 25 1 1.00 1.00 45.86332
## 18 12 20 25 2 1.00 1.00 35.78279
## 20 7 160 25 3 1.00 0.50 40.44877
## 22 3 30 25 3 1.00 1.00 46.89564
## 25 13 30 25 2 1.00 1.00 32.20758
## 26 11 25 25 1 1.00 0.75 31.43597
## 27 7 100 25 2 1.00 0.80 58.34514
## 29 12 190 25 3 1.33 0.67 41.01549
## 39 6 60 100 3 1.00 1.00 36.52368
## 40 9 95 100 3 1.30 0.75 36.47151
## 47 13 160 25 3 1.50 0.67 30.31335
## 49 9 40 25 2 1.00 0.67 29.92429
## 50 7 130 25 3 1.33 0.67 40.69232
## 51 2 90 25 3 1.00 1.00 59.64284
## 54 3 45 100 3 1.00 1.00 41.50354
## 59 12 240 25 2 1.33 0.75 39.25920
## 61 6 110 25 3 1.00 0.50 55.33314
## 63 3 35 25 1 1.00 1.00 40.56016
## 67 15 40 25 2 1.00 0.75 31.23005
## 68 3 55 25 1 1.00 1.00 53.13132
Cereal data again with the
read.csv command again. This time, use the optional
argument, stringsAsFactors = TRUE.cereal2=read.csv("Cereal.csv", stringsAsFactors = TRUE)
mfr and type columns are now factors.
Check that this is true.class(cereal$mfr)
## [1] "character"
class(cereal2$mfr)
## [1] "factor"
class(cereal$type)
## [1] "character"
class(cereal2$type)
## [1] "factor"
mfr and type?
(use the functions levels or nlevels)levels(cereal$mfr)
## NULL
levels(cereal2$mfr)
## [1] "A" "G" "K" "N" "P" "Q" "R"
levels(cereal$type)
## NULL
levels(cereal2$type)
## [1] "C" "H"
calories into a new vector called
cereal.calories.cereal.calories <- cereal$calories
cereal.calories?
(length)length(cereal.calories)
## [1] 77
cereal.calories.cereal.calories[5:10]
## [1] 110 110 110 130 90 90
cereal.calories using
c().cereal.calories=c(cereal.calories,1)
print(cereal.calories)
## [1] 70 120 70 50 110 110 110 130 90 90 120 110 120 110 110 110 100 110 110
## [20] 110 100 110 100 100 110 110 100 120 120 110 100 110 100 110 120 120 110 110
## [39] 110 140 110 100 110 100 150 150 160 100 120 140 90 130 120 100 50 50 100
## [58] 100 120 100 90 110 110 80 90 90 110 110 90 110 140 100 110 110 100 100
## [77] 110 1
as.matrix(cereal)). Check that the elements have been
forced into the character type.cereal.mat <- as.matrix(cereal)
str(cereal.mat)
## chr [1:77, 1:16] "100%_Bran" "100%_Natural_Bran" "All-Bran" ...
## - attr(*, "dimnames")=List of 2
## ..$ : NULL
## ..$ : chr [1:16] "name" "mfr" "type" "calories" ...
mfr,
name and type columns. Check that the elements
are now numeric.cereal.mat <- as.matrix(cereal[,!(names(cereal) %in% c('mfr','name','type'))])
str(cereal.mat)
## num [1:77, 1:13] 70 120 70 50 110 110 110 130 90 90 ...
## - attr(*, "dimnames")=List of 2
## ..$ : NULL
## ..$ : chr [1:13] "calories" "protein" "fat" "sodium" ...
summary function to extract the median, 1st
quartile and 3rd quartile data from the sodium column.summary(cereal$sodium)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.0 130.0 180.0 159.7 210.0 320.0
sodium (max(), min(),
sd(), mean())max(cereal$sodium)
## [1] 320
min(cereal$sodium)
## [1] 0
sd(cereal$sodium)
## [1] 83.8323
mean(cereal$sodium)
## [1] 159.6753
sodium of each mfr.tapply(cereal$sodium, cereal$mfr, mean)
## A G K N P Q R
## 0.0000 200.4545 174.7826 37.5000 146.1111 92.5000 198.1250
sodium against mfr
using boxplot().boxplot(sodium~mfr, data=cereal)
calories against sodium using
plot().plot(calories~sodium, data=cereal)
kelloggs.csv. Use the write.csv
command.write.csv(Kelloggs,"kelloggs.csv", row.names = FALSE)
head(Kelloggs)
## name mfr type calories protein fat sodium fiber carbo
## 3 All-Bran K C 70 4 1 260 9 7
## 4 All-Bran_with_Extra_Fiber K C 50 4 0 140 14 8
## 7 Apple_Jacks K C 110 2 0 125 1 11
## 17 Corn_Flakes K C 100 2 0 290 1 21
## 18 Corn_Pops K C 110 1 0 90 1 13
## 20 Cracklin'_Oat_Bran K C 110 3 3 140 4 10
## sugars potass vitamins shelf weight cups rating
## 3 5 320 25 3 1 0.33 59.42551
## 4 0 330 25 3 1 0.50 93.70491
## 7 14 30 25 2 1 1.00 33.17409
## 17 2 35 25 1 1 1.00 45.86332
## 18 12 20 25 2 1 1.00 35.78279
## 20 7 160 25 3 1 0.50 40.44877