```r
library(tidyverse)
## Warning: package 'tidyverse' was built under R version 4.3.2
## Warning: package 'lubridate' was built under R version 4.3.2
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.3     ✔ readr     2.1.4
## ✔ forcats   1.0.0     ✔ stringr   1.5.0
## ✔ ggplot2   3.4.4     ✔ tibble    3.2.1
## ✔ lubridate 1.9.3     ✔ tidyr     1.3.0
## ✔ purrr     1.0.2     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(datasets)
data(CO2)
CO2 <- tibble::as_tibble(CO2)
class(CO2)
## [1] "tbl_df"     "tbl"        "data.frame"
#melihat seluruh data
View(CO2)  

#melihat rangkuman
head(CO2) 
## # A tibble: 6 × 5
##   Plant Type   Treatment   conc uptake
##   <ord> <fct>  <fct>      <dbl>  <dbl>
## 1 Qn1   Quebec nonchilled    95   16  
## 2 Qn1   Quebec nonchilled   175   30.4
## 3 Qn1   Quebec nonchilled   250   34.8
## 4 Qn1   Quebec nonchilled   350   37.2
## 5 Qn1   Quebec nonchilled   500   35.3
## 6 Qn1   Quebec nonchilled   675   39.2
#melihat tide data
glimpse(CO2) 
## Rows: 84
## Columns: 5
## $ Plant     <ord> Qn1, Qn1, Qn1, Qn1, Qn1, Qn1, Qn1, Qn2, Qn2, Qn2, Qn2, Qn2, …
## $ Type      <fct> Quebec, Quebec, Quebec, Quebec, Quebec, Quebec, Quebec, Queb…
## $ Treatment <fct> nonchilled, nonchilled, nonchilled, nonchilled, nonchilled, …
## $ conc      <dbl> 95, 175, 250, 350, 500, 675, 1000, 95, 175, 250, 350, 500, 6…
## $ uptake    <dbl> 16.0, 30.4, 34.8, 37.2, 35.3, 39.2, 39.7, 13.6, 27.3, 37.1, …
#menghitung rata-rata variabel conc
mean(CO2$conc) == CO2$conc %>% mean()
## [1] TRUE
#menghitung rata-rata variabel uptake
mean(CO2$uptake) == CO2$conc %>% mean()
## [1] FALSE
## SUMMARIZE
# menghitung rata-rata conc pada setiap peubah plant
CO2 %>% group_by(Plant) %>% summarize (mean=mean(conc))
## # A tibble: 12 × 2
##    Plant  mean
##    <ord> <dbl>
##  1 Qn1     435
##  2 Qn2     435
##  3 Qn3     435
##  4 Qc1     435
##  5 Qc3     435
##  6 Qc2     435
##  7 Mn3     435
##  8 Mn2     435
##  9 Mn1     435
## 10 Mc2     435
## 11 Mc3     435
## 12 Mc1     435
#menghitung rata-rata conc pada setiap peubah Type
CO2 %>% group_by(Type) %>% summarize(mean=mean(conc))
## # A tibble: 2 × 2
##   Type         mean
##   <fct>       <dbl>
## 1 Quebec        435
## 2 Mississippi   435
#menghitung rata-rata conc pada setiap peubah Treatment
CO2 %>% group_by(Treatment) %>% summarize (mean=mean(conc))
## # A tibble: 2 × 2
##   Treatment   mean
##   <fct>      <dbl>
## 1 nonchilled   435
## 2 chilled      435
#menghitung rata-rata uptake pada setiap peubah Type
CO2 %>% group_by(Type) %>% summarize (mean=mean(uptake))
## # A tibble: 2 × 2
##   Type         mean
##   <fct>       <dbl>
## 1 Quebec       33.5
## 2 Mississippi  20.9
#menghitung rata-rata uptake pada setiap peubah Treatment
CO2 %>% group_by(Treatment) %>% summarize (mean=mean(uptake))
## # A tibble: 2 × 2
##   Treatment   mean
##   <fct>      <dbl>
## 1 nonchilled  30.6
## 2 chilled     23.8
#menghitung rata-rata uptake pada setiap peubah Plant
CO2 %>% group_by(Plant) %>% summarize (mean=mean(uptake))
## # A tibble: 12 × 2
##    Plant  mean
##    <ord> <dbl>
##  1 Qn1    33.2
##  2 Qn2    35.2
##  3 Qn3    37.6
##  4 Qc1    30.0
##  5 Qc3    32.6
##  6 Qc2    32.7
##  7 Mn3    24.1
##  8 Mn2    27.3
##  9 Mn1    26.4
## 10 Mc2    12.1
## 11 Mc3    17.3
## 12 Mc1    18
#Mengurutkan berdasar uptake terkecil
CO2 %>% arrange(uptake) %>% print(n=84)
## # A tibble: 84 × 5
##    Plant Type        Treatment   conc uptake
##    <ord> <fct>       <fct>      <dbl>  <dbl>
##  1 Mc2   Mississippi chilled       95    7.7
##  2 Qc2   Quebec      chilled       95    9.3
##  3 Mc1   Mississippi chilled       95   10.5
##  4 Mn1   Mississippi nonchilled    95   10.6
##  5 Mc3   Mississippi chilled       95   10.6
##  6 Mn3   Mississippi nonchilled    95   11.3
##  7 Mc2   Mississippi chilled      175   11.4
##  8 Mn2   Mississippi nonchilled    95   12  
##  9 Mc2   Mississippi chilled      250   12.3
## 10 Mc2   Mississippi chilled      500   12.5
## 11 Mc2   Mississippi chilled      350   13  
## 12 Qn2   Quebec      nonchilled    95   13.6
## 13 Mc2   Mississippi chilled      675   13.7
## 14 Qc1   Quebec      chilled       95   14.2
## 15 Mc2   Mississippi chilled     1000   14.4
## 16 Mc1   Mississippi chilled      175   14.9
## 17 Qc3   Quebec      chilled       95   15.1
## 18 Qn1   Quebec      nonchilled    95   16  
## 19 Qn3   Quebec      nonchilled    95   16.2
## 20 Mc3   Mississippi chilled      250   17.9
## 21 Mc3   Mississippi chilled      350   17.9
## 22 Mc3   Mississippi chilled      500   17.9
## 23 Mc3   Mississippi chilled      175   18  
## 24 Mc1   Mississippi chilled      250   18.1
## 25 Mc1   Mississippi chilled      350   18.9
## 26 Mc3   Mississippi chilled      675   18.9
## 27 Mn1   Mississippi nonchilled   175   19.2
## 28 Mn3   Mississippi nonchilled   175   19.4
## 29 Mc1   Mississippi chilled      500   19.5
## 30 Mc3   Mississippi chilled     1000   19.9
## 31 Qc3   Quebec      chilled      175   21  
## 32 Mc1   Mississippi chilled     1000   21.9
## 33 Mn2   Mississippi nonchilled   175   22  
## 34 Mc1   Mississippi chilled      675   22.2
## 35 Qc1   Quebec      chilled      175   24.1
## 36 Mn3   Mississippi nonchilled   250   25.8
## 37 Mn1   Mississippi nonchilled   250   26.2
## 38 Qn2   Quebec      nonchilled   175   27.3
## 39 Qc2   Quebec      chilled      175   27.3
## 40 Mn3   Mississippi nonchilled  1000   27.8
## 41 Mn3   Mississippi nonchilled   350   27.9
## 42 Mn3   Mississippi nonchilled   675   28.1
## 43 Mn3   Mississippi nonchilled   500   28.5
## 44 Mn1   Mississippi nonchilled   350   30  
## 45 Qc1   Quebec      chilled      250   30.3
## 46 Qn1   Quebec      nonchilled   175   30.4
## 47 Mn2   Mississippi nonchilled   250   30.6
## 48 Mn1   Mississippi nonchilled   500   30.9
## 49 Mn2   Mississippi nonchilled   675   31.1
## 50 Mn2   Mississippi nonchilled  1000   31.5
## 51 Mn2   Mississippi nonchilled   350   31.8
## 52 Qn3   Quebec      nonchilled   175   32.4
## 53 Mn1   Mississippi nonchilled   675   32.4
## 54 Mn2   Mississippi nonchilled   500   32.4
## 55 Qc1   Quebec      chilled      500   32.5
## 56 Qc3   Quebec      chilled      350   34  
## 57 Qc1   Quebec      chilled      350   34.6
## 58 Qn1   Quebec      nonchilled   250   34.8
## 59 Qc2   Quebec      chilled      250   35  
## 60 Qn1   Quebec      nonchilled   500   35.3
## 61 Qc1   Quebec      chilled      675   35.4
## 62 Mn1   Mississippi nonchilled  1000   35.5
## 63 Qn2   Quebec      nonchilled   250   37.1
## 64 Qn1   Quebec      nonchilled   350   37.2
## 65 Qc2   Quebec      chilled      675   37.5
## 66 Qc3   Quebec      chilled      250   38.1
## 67 Qc2   Quebec      chilled      500   38.6
## 68 Qc1   Quebec      chilled     1000   38.7
## 69 Qc2   Quebec      chilled      350   38.8
## 70 Qc3   Quebec      chilled      500   38.9
## 71 Qn1   Quebec      nonchilled   675   39.2
## 72 Qc3   Quebec      chilled      675   39.6
## 73 Qn1   Quebec      nonchilled  1000   39.7
## 74 Qn3   Quebec      nonchilled   250   40.3
## 75 Qn2   Quebec      nonchilled   500   40.6
## 76 Qn2   Quebec      nonchilled   675   41.4
## 77 Qc3   Quebec      chilled     1000   41.4
## 78 Qn2   Quebec      nonchilled   350   41.8
## 79 Qn3   Quebec      nonchilled   350   42.1
## 80 Qc2   Quebec      chilled     1000   42.4
## 81 Qn3   Quebec      nonchilled   500   42.9
## 82 Qn3   Quebec      nonchilled   675   43.9
## 83 Qn2   Quebec      nonchilled  1000   44.3
## 84 Qn3   Quebec      nonchilled  1000   45.5
#FILTER
CO2 %>% filter(Type=="Quebec") %>% print(n=50)
## # A tibble: 42 × 5
##    Plant Type   Treatment   conc uptake
##    <ord> <fct>  <fct>      <dbl>  <dbl>
##  1 Qn1   Quebec nonchilled    95   16  
##  2 Qn1   Quebec nonchilled   175   30.4
##  3 Qn1   Quebec nonchilled   250   34.8
##  4 Qn1   Quebec nonchilled   350   37.2
##  5 Qn1   Quebec nonchilled   500   35.3
##  6 Qn1   Quebec nonchilled   675   39.2
##  7 Qn1   Quebec nonchilled  1000   39.7
##  8 Qn2   Quebec nonchilled    95   13.6
##  9 Qn2   Quebec nonchilled   175   27.3
## 10 Qn2   Quebec nonchilled   250   37.1
## 11 Qn2   Quebec nonchilled   350   41.8
## 12 Qn2   Quebec nonchilled   500   40.6
## 13 Qn2   Quebec nonchilled   675   41.4
## 14 Qn2   Quebec nonchilled  1000   44.3
## 15 Qn3   Quebec nonchilled    95   16.2
## 16 Qn3   Quebec nonchilled   175   32.4
## 17 Qn3   Quebec nonchilled   250   40.3
## 18 Qn3   Quebec nonchilled   350   42.1
## 19 Qn3   Quebec nonchilled   500   42.9
## 20 Qn3   Quebec nonchilled   675   43.9
## 21 Qn3   Quebec nonchilled  1000   45.5
## 22 Qc1   Quebec chilled       95   14.2
## 23 Qc1   Quebec chilled      175   24.1
## 24 Qc1   Quebec chilled      250   30.3
## 25 Qc1   Quebec chilled      350   34.6
## 26 Qc1   Quebec chilled      500   32.5
## 27 Qc1   Quebec chilled      675   35.4
## 28 Qc1   Quebec chilled     1000   38.7
## 29 Qc2   Quebec chilled       95    9.3
## 30 Qc2   Quebec chilled      175   27.3
## 31 Qc2   Quebec chilled      250   35  
## 32 Qc2   Quebec chilled      350   38.8
## 33 Qc2   Quebec chilled      500   38.6
## 34 Qc2   Quebec chilled      675   37.5
## 35 Qc2   Quebec chilled     1000   42.4
## 36 Qc3   Quebec chilled       95   15.1
## 37 Qc3   Quebec chilled      175   21  
## 38 Qc3   Quebec chilled      250   38.1
## 39 Qc3   Quebec chilled      350   34  
## 40 Qc3   Quebec chilled      500   38.9
## 41 Qc3   Quebec chilled      675   39.6
## 42 Qc3   Quebec chilled     1000   41.4
#SELECT
#memunculkan data yang diinginkan
CO2 %>% select(Type, Treatment, uptake)
## # A tibble: 84 × 3
##    Type   Treatment  uptake
##    <fct>  <fct>       <dbl>
##  1 Quebec nonchilled   16  
##  2 Quebec nonchilled   30.4
##  3 Quebec nonchilled   34.8
##  4 Quebec nonchilled   37.2
##  5 Quebec nonchilled   35.3
##  6 Quebec nonchilled   39.2
##  7 Quebec nonchilled   39.7
##  8 Quebec nonchilled   13.6
##  9 Quebec nonchilled   27.3
## 10 Quebec nonchilled   37.1
## # ℹ 74 more rows
#menghilangkan atau menghapus
CO2 %>% select(-Type)
## # A tibble: 84 × 4
##    Plant Treatment   conc uptake
##    <ord> <fct>      <dbl>  <dbl>
##  1 Qn1   nonchilled    95   16  
##  2 Qn1   nonchilled   175   30.4
##  3 Qn1   nonchilled   250   34.8
##  4 Qn1   nonchilled   350   37.2
##  5 Qn1   nonchilled   500   35.3
##  6 Qn1   nonchilled   675   39.2
##  7 Qn1   nonchilled  1000   39.7
##  8 Qn2   nonchilled    95   13.6
##  9 Qn2   nonchilled   175   27.3
## 10 Qn2   nonchilled   250   37.1
## # ℹ 74 more rows
#MUTATE
CO2 %>% mutate(strength=conc+uptake)
## # A tibble: 84 × 6
##    Plant Type   Treatment   conc uptake strength
##    <ord> <fct>  <fct>      <dbl>  <dbl>    <dbl>
##  1 Qn1   Quebec nonchilled    95   16       111 
##  2 Qn1   Quebec nonchilled   175   30.4     205.
##  3 Qn1   Quebec nonchilled   250   34.8     285.
##  4 Qn1   Quebec nonchilled   350   37.2     387.
##  5 Qn1   Quebec nonchilled   500   35.3     535.
##  6 Qn1   Quebec nonchilled   675   39.2     714.
##  7 Qn1   Quebec nonchilled  1000   39.7    1040.
##  8 Qn2   Quebec nonchilled    95   13.6     109.
##  9 Qn2   Quebec nonchilled   175   27.3     202.
## 10 Qn2   Quebec nonchilled   250   37.1     287.
## # ℹ 74 more rows
#COMBINATION
newCO2 <- CO2 %>% select(-Type) %>% mutate(strength=conc+uptake)
newCO2
## # A tibble: 84 × 5
##    Plant Treatment   conc uptake strength
##    <ord> <fct>      <dbl>  <dbl>    <dbl>
##  1 Qn1   nonchilled    95   16       111 
##  2 Qn1   nonchilled   175   30.4     205.
##  3 Qn1   nonchilled   250   34.8     285.
##  4 Qn1   nonchilled   350   37.2     387.
##  5 Qn1   nonchilled   500   35.3     535.
##  6 Qn1   nonchilled   675   39.2     714.
##  7 Qn1   nonchilled  1000   39.7    1040.
##  8 Qn2   nonchilled    95   13.6     109.
##  9 Qn2   nonchilled   175   27.3     202.
## 10 Qn2   nonchilled   250   37.1     287.
## # ℹ 74 more rows