Tugas Akhir Mandarel
Engine SQL
Database yang digunakan pada publikasi ini adalah database sampel chinook yang menjadi database untuk mengakses dan mengolah melalui R sehingga diperlukan beberapa package, yaitu DBI dan RSQLite.
install.packages(c("RSQLite", "DBI"), dependencies = TRUE)Selanjutnya package tidyverse yang mencakup beberapa package diretrieve. Fungsi dalam suatu package dapat juga dipanggil tanpa perintah library() atau require() jika sintaks yang ditulis menyertakan nama package tempat fungsi tersebut berasal. Penyertaan ini dengan menggunakan tanda ::.
library(tidyverse)
library(RSQLite)
library(DBI)Secara umum, koneksi terhadap database pada R dapat menggunakan sintaks berikut: DBI::dbConnect(RSQLite::SQLite(), path = ":dbname:")
chinook<-DBI::dbConnect(RSQLite::SQLite(), "C:/SQLite/chinook.db")
RSQLite::dbListTables(chinook)## [1] "albums" "artists" "customers" "employees"
## [5] "genres" "invoice_items" "invoices" "media_types"
## [9] "playlist_track" "playlists" "sqlite_sequence" "sqlite_stat1"
## [13] "tracks"Setelah melakukan dbConnect() kita dapat melakukan perintah SQL.
SELECT
*
FROM
playlists;| PlaylistId | Name |
|---|---|
| 1 | Music |
| 2 | Movies |
| 3 | TV Shows |
| 4 | Audiobooks |
| 5 | 90’s Music |
| 6 | Audiobooks |
| 7 | Movies |
| 8 | Music |
| 9 | Music Videos |
| 10 | TV Shows |
Setelah selesai mengolah database terkait dianjurkan memutuskan koneksi dengan fungsi dbDisconnect() dan jika ingin menyambungkan kembali cukup menggunakan kembali dbConnect()
dbDisconnect(chinook)Menggunakan DPLYR
chinook<-DBI::dbConnect(RSQLite::SQLite(), "C:/SQLite/chinook.db")
RSQLite::dbListTables(chinook)## [1] "albums" "artists" "customers" "employees"
## [5] "genres" "invoice_items" "invoices" "media_types"
## [9] "playlist_track" "playlists" "sqlite_sequence" "sqlite_stat1"
## [13] "tracks"dplyr::tbl(chinook,"playlists")## # Source: table<playlists> [?? x 2]
## # Database: sqlite 3.37.0 [C:\sqlite\chinook.db]
## PlaylistId Name
## <int> <chr>
## 1 1 Music
## 2 2 Movies
## 3 3 TV Shows
## 4 4 Audiobooks
## 5 5 90’s Music
## 6 6 Audiobooks
## 7 7 Movies
## 8 8 Music
## 9 9 Music Videos
## 10 10 TV Shows
## # ... with more rowsplaylists <- dplyr::tbl(chinook,"playlists")
class(playlists)## [1] "tbl_SQLiteConnection" "tbl_dbi" "tbl_sql"
## [4] "tbl_lazy" "tbl"playlists## # Source: table<playlists> [?? x 2]
## # Database: sqlite 3.37.0 [C:\sqlite\chinook.db]
## PlaylistId Name
## <int> <chr>
## 1 1 Music
## 2 2 Movies
## 3 3 TV Shows
## 4 4 Audiobooks
## 5 5 90’s Music
## 6 6 Audiobooks
## 7 7 Movies
## 8 8 Music
## 9 9 Music Videos
## 10 10 TV Shows
## # ... with more rowsquery <- playlists %>% select(-PlaylistId)
query## # Source: lazy query [?? x 1]
## # Database: sqlite 3.37.0 [C:\sqlite\chinook.db]
## Name
## <chr>
## 1 Music
## 2 Movies
## 3 TV Shows
## 4 Audiobooks
## 5 90’s Music
## 6 Audiobooks
## 7 Movies
## 8 Music
## 9 Music Videos
## 10 TV Shows
## # ... with more rowsdplyr::show_query(query)## <SQL>
## SELECT `Name`
## FROM `playlists`Data Wrangling
Dataset yang digunakan adalah storms yang tersedia pada package default R datasets.
library(datasets)
library(help = "datasets")
CO2## Plant Type Treatment conc uptake
## 1 Qn1 Quebec nonchilled 95 16.0
## 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.0
## 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.0
## 38 Qc3 Quebec chilled 250 38.1
## 39 Qc3 Quebec chilled 350 34.0
## 40 Qc3 Quebec chilled 500 38.9
## 41 Qc3 Quebec chilled 675 39.6
## 42 Qc3 Quebec chilled 1000 41.4
## 43 Mn1 Mississippi nonchilled 95 10.6
## 44 Mn1 Mississippi nonchilled 175 19.2
## 45 Mn1 Mississippi nonchilled 250 26.2
## 46 Mn1 Mississippi nonchilled 350 30.0
## 47 Mn1 Mississippi nonchilled 500 30.9
## 48 Mn1 Mississippi nonchilled 675 32.4
## 49 Mn1 Mississippi nonchilled 1000 35.5
## 50 Mn2 Mississippi nonchilled 95 12.0
## 51 Mn2 Mississippi nonchilled 175 22.0
## 52 Mn2 Mississippi nonchilled 250 30.6
## 53 Mn2 Mississippi nonchilled 350 31.8
## 54 Mn2 Mississippi nonchilled 500 32.4
## 55 Mn2 Mississippi nonchilled 675 31.1
## 56 Mn2 Mississippi nonchilled 1000 31.5
## 57 Mn3 Mississippi nonchilled 95 11.3
## 58 Mn3 Mississippi nonchilled 175 19.4
## 59 Mn3 Mississippi nonchilled 250 25.8
## 60 Mn3 Mississippi nonchilled 350 27.9
## 61 Mn3 Mississippi nonchilled 500 28.5
## 62 Mn3 Mississippi nonchilled 675 28.1
## 63 Mn3 Mississippi nonchilled 1000 27.8
## 64 Mc1 Mississippi chilled 95 10.5
## 65 Mc1 Mississippi chilled 175 14.9
## 66 Mc1 Mississippi chilled 250 18.1
## 67 Mc1 Mississippi chilled 350 18.9
## 68 Mc1 Mississippi chilled 500 19.5
## 69 Mc1 Mississippi chilled 675 22.2
## 70 Mc1 Mississippi chilled 1000 21.9
## 71 Mc2 Mississippi chilled 95 7.7
## 72 Mc2 Mississippi chilled 175 11.4
## 73 Mc2 Mississippi chilled 250 12.3
## 74 Mc2 Mississippi chilled 350 13.0
## 75 Mc2 Mississippi chilled 500 12.5
## 76 Mc2 Mississippi chilled 675 13.7
## 77 Mc2 Mississippi chilled 1000 14.4
## 78 Mc3 Mississippi chilled 95 10.6
## 79 Mc3 Mississippi chilled 175 18.0
## 80 Mc3 Mississippi chilled 250 17.9
## 81 Mc3 Mississippi chilled 350 17.9
## 82 Mc3 Mississippi chilled 500 17.9
## 83 Mc3 Mississippi chilled 675 18.9
## 84 Mc3 Mississippi chilled 1000 19.9The CO2 data frame has 84 rows and 5 columns of data from an experiment on the cold tolerance of the grass species Echinochloa crus-galli. Untuk mengetahui informasi terkait dataset dapat menggunakan sintaks ?sebelum nama dataset .
?CO2
View(CO2)Dataset tersebut akan dilakukan perintah arrange , mutate ,filter,select, dan summarise.
CO2%>% select(Plant,Type,Treatment,conc,uptake)## Plant Type Treatment conc uptake
## 1 Qn1 Quebec nonchilled 95 16.0
## 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.0
## 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.0
## 38 Qc3 Quebec chilled 250 38.1
## 39 Qc3 Quebec chilled 350 34.0
## 40 Qc3 Quebec chilled 500 38.9
## 41 Qc3 Quebec chilled 675 39.6
## 42 Qc3 Quebec chilled 1000 41.4
## 43 Mn1 Mississippi nonchilled 95 10.6
## 44 Mn1 Mississippi nonchilled 175 19.2
## 45 Mn1 Mississippi nonchilled 250 26.2
## 46 Mn1 Mississippi nonchilled 350 30.0
## 47 Mn1 Mississippi nonchilled 500 30.9
## 48 Mn1 Mississippi nonchilled 675 32.4
## 49 Mn1 Mississippi nonchilled 1000 35.5
## 50 Mn2 Mississippi nonchilled 95 12.0
## 51 Mn2 Mississippi nonchilled 175 22.0
## 52 Mn2 Mississippi nonchilled 250 30.6
## 53 Mn2 Mississippi nonchilled 350 31.8
## 54 Mn2 Mississippi nonchilled 500 32.4
## 55 Mn2 Mississippi nonchilled 675 31.1
## 56 Mn2 Mississippi nonchilled 1000 31.5
## 57 Mn3 Mississippi nonchilled 95 11.3
## 58 Mn3 Mississippi nonchilled 175 19.4
## 59 Mn3 Mississippi nonchilled 250 25.8
## 60 Mn3 Mississippi nonchilled 350 27.9
## 61 Mn3 Mississippi nonchilled 500 28.5
## 62 Mn3 Mississippi nonchilled 675 28.1
## 63 Mn3 Mississippi nonchilled 1000 27.8
## 64 Mc1 Mississippi chilled 95 10.5
## 65 Mc1 Mississippi chilled 175 14.9
## 66 Mc1 Mississippi chilled 250 18.1
## 67 Mc1 Mississippi chilled 350 18.9
## 68 Mc1 Mississippi chilled 500 19.5
## 69 Mc1 Mississippi chilled 675 22.2
## 70 Mc1 Mississippi chilled 1000 21.9
## 71 Mc2 Mississippi chilled 95 7.7
## 72 Mc2 Mississippi chilled 175 11.4
## 73 Mc2 Mississippi chilled 250 12.3
## 74 Mc2 Mississippi chilled 350 13.0
## 75 Mc2 Mississippi chilled 500 12.5
## 76 Mc2 Mississippi chilled 675 13.7
## 77 Mc2 Mississippi chilled 1000 14.4
## 78 Mc3 Mississippi chilled 95 10.6
## 79 Mc3 Mississippi chilled 175 18.0
## 80 Mc3 Mississippi chilled 250 17.9
## 81 Mc3 Mississippi chilled 350 17.9
## 82 Mc3 Mississippi chilled 500 17.9
## 83 Mc3 Mississippi chilled 675 18.9
## 84 Mc3 Mississippi chilled 1000 19.9CO2 %>% arrange(desc(Type))## Plant Type Treatment conc uptake
## 1 Mn1 Mississippi nonchilled 95 10.6
## 2 Mn1 Mississippi nonchilled 175 19.2
## 3 Mn1 Mississippi nonchilled 250 26.2
## 4 Mn1 Mississippi nonchilled 350 30.0
## 5 Mn1 Mississippi nonchilled 500 30.9
## 6 Mn1 Mississippi nonchilled 675 32.4
## 7 Mn1 Mississippi nonchilled 1000 35.5
## 8 Mn2 Mississippi nonchilled 95 12.0
## 9 Mn2 Mississippi nonchilled 175 22.0
## 10 Mn2 Mississippi nonchilled 250 30.6
## 11 Mn2 Mississippi nonchilled 350 31.8
## 12 Mn2 Mississippi nonchilled 500 32.4
## 13 Mn2 Mississippi nonchilled 675 31.1
## 14 Mn2 Mississippi nonchilled 1000 31.5
## 15 Mn3 Mississippi nonchilled 95 11.3
## 16 Mn3 Mississippi nonchilled 175 19.4
## 17 Mn3 Mississippi nonchilled 250 25.8
## 18 Mn3 Mississippi nonchilled 350 27.9
## 19 Mn3 Mississippi nonchilled 500 28.5
## 20 Mn3 Mississippi nonchilled 675 28.1
## 21 Mn3 Mississippi nonchilled 1000 27.8
## 22 Mc1 Mississippi chilled 95 10.5
## 23 Mc1 Mississippi chilled 175 14.9
## 24 Mc1 Mississippi chilled 250 18.1
## 25 Mc1 Mississippi chilled 350 18.9
## 26 Mc1 Mississippi chilled 500 19.5
## 27 Mc1 Mississippi chilled 675 22.2
## 28 Mc1 Mississippi chilled 1000 21.9
## 29 Mc2 Mississippi chilled 95 7.7
## 30 Mc2 Mississippi chilled 175 11.4
## 31 Mc2 Mississippi chilled 250 12.3
## 32 Mc2 Mississippi chilled 350 13.0
## 33 Mc2 Mississippi chilled 500 12.5
## 34 Mc2 Mississippi chilled 675 13.7
## 35 Mc2 Mississippi chilled 1000 14.4
## 36 Mc3 Mississippi chilled 95 10.6
## 37 Mc3 Mississippi chilled 175 18.0
## 38 Mc3 Mississippi chilled 250 17.9
## 39 Mc3 Mississippi chilled 350 17.9
## 40 Mc3 Mississippi chilled 500 17.9
## 41 Mc3 Mississippi chilled 675 18.9
## 42 Mc3 Mississippi chilled 1000 19.9
## 43 Qn1 Quebec nonchilled 95 16.0
## 44 Qn1 Quebec nonchilled 175 30.4
## 45 Qn1 Quebec nonchilled 250 34.8
## 46 Qn1 Quebec nonchilled 350 37.2
## 47 Qn1 Quebec nonchilled 500 35.3
## 48 Qn1 Quebec nonchilled 675 39.2
## 49 Qn1 Quebec nonchilled 1000 39.7
## 50 Qn2 Quebec nonchilled 95 13.6
## 51 Qn2 Quebec nonchilled 175 27.3
## 52 Qn2 Quebec nonchilled 250 37.1
## 53 Qn2 Quebec nonchilled 350 41.8
## 54 Qn2 Quebec nonchilled 500 40.6
## 55 Qn2 Quebec nonchilled 675 41.4
## 56 Qn2 Quebec nonchilled 1000 44.3
## 57 Qn3 Quebec nonchilled 95 16.2
## 58 Qn3 Quebec nonchilled 175 32.4
## 59 Qn3 Quebec nonchilled 250 40.3
## 60 Qn3 Quebec nonchilled 350 42.1
## 61 Qn3 Quebec nonchilled 500 42.9
## 62 Qn3 Quebec nonchilled 675 43.9
## 63 Qn3 Quebec nonchilled 1000 45.5
## 64 Qc1 Quebec chilled 95 14.2
## 65 Qc1 Quebec chilled 175 24.1
## 66 Qc1 Quebec chilled 250 30.3
## 67 Qc1 Quebec chilled 350 34.6
## 68 Qc1 Quebec chilled 500 32.5
## 69 Qc1 Quebec chilled 675 35.4
## 70 Qc1 Quebec chilled 1000 38.7
## 71 Qc2 Quebec chilled 95 9.3
## 72 Qc2 Quebec chilled 175 27.3
## 73 Qc2 Quebec chilled 250 35.0
## 74 Qc2 Quebec chilled 350 38.8
## 75 Qc2 Quebec chilled 500 38.6
## 76 Qc2 Quebec chilled 675 37.5
## 77 Qc2 Quebec chilled 1000 42.4
## 78 Qc3 Quebec chilled 95 15.1
## 79 Qc3 Quebec chilled 175 21.0
## 80 Qc3 Quebec chilled 250 38.1
## 81 Qc3 Quebec chilled 350 34.0
## 82 Qc3 Quebec chilled 500 38.9
## 83 Qc3 Quebec chilled 675 39.6
## 84 Qc3 Quebec chilled 1000 41.4CO2 %>% filter(conc>100)## Plant Type Treatment conc uptake
## 1 Qn1 Quebec nonchilled 175 30.4
## 2 Qn1 Quebec nonchilled 250 34.8
## 3 Qn1 Quebec nonchilled 350 37.2
## 4 Qn1 Quebec nonchilled 500 35.3
## 5 Qn1 Quebec nonchilled 675 39.2
## 6 Qn1 Quebec nonchilled 1000 39.7
## 7 Qn2 Quebec nonchilled 175 27.3
## 8 Qn2 Quebec nonchilled 250 37.1
## 9 Qn2 Quebec nonchilled 350 41.8
## 10 Qn2 Quebec nonchilled 500 40.6
## 11 Qn2 Quebec nonchilled 675 41.4
## 12 Qn2 Quebec nonchilled 1000 44.3
## 13 Qn3 Quebec nonchilled 175 32.4
## 14 Qn3 Quebec nonchilled 250 40.3
## 15 Qn3 Quebec nonchilled 350 42.1
## 16 Qn3 Quebec nonchilled 500 42.9
## 17 Qn3 Quebec nonchilled 675 43.9
## 18 Qn3 Quebec nonchilled 1000 45.5
## 19 Qc1 Quebec chilled 175 24.1
## 20 Qc1 Quebec chilled 250 30.3
## 21 Qc1 Quebec chilled 350 34.6
## 22 Qc1 Quebec chilled 500 32.5
## 23 Qc1 Quebec chilled 675 35.4
## 24 Qc1 Quebec chilled 1000 38.7
## 25 Qc2 Quebec chilled 175 27.3
## 26 Qc2 Quebec chilled 250 35.0
## 27 Qc2 Quebec chilled 350 38.8
## 28 Qc2 Quebec chilled 500 38.6
## 29 Qc2 Quebec chilled 675 37.5
## 30 Qc2 Quebec chilled 1000 42.4
## 31 Qc3 Quebec chilled 175 21.0
## 32 Qc3 Quebec chilled 250 38.1
## 33 Qc3 Quebec chilled 350 34.0
## 34 Qc3 Quebec chilled 500 38.9
## 35 Qc3 Quebec chilled 675 39.6
## 36 Qc3 Quebec chilled 1000 41.4
## 37 Mn1 Mississippi nonchilled 175 19.2
## 38 Mn1 Mississippi nonchilled 250 26.2
## 39 Mn1 Mississippi nonchilled 350 30.0
## 40 Mn1 Mississippi nonchilled 500 30.9
## 41 Mn1 Mississippi nonchilled 675 32.4
## 42 Mn1 Mississippi nonchilled 1000 35.5
## 43 Mn2 Mississippi nonchilled 175 22.0
## 44 Mn2 Mississippi nonchilled 250 30.6
## 45 Mn2 Mississippi nonchilled 350 31.8
## 46 Mn2 Mississippi nonchilled 500 32.4
## 47 Mn2 Mississippi nonchilled 675 31.1
## 48 Mn2 Mississippi nonchilled 1000 31.5
## 49 Mn3 Mississippi nonchilled 175 19.4
## 50 Mn3 Mississippi nonchilled 250 25.8
## 51 Mn3 Mississippi nonchilled 350 27.9
## 52 Mn3 Mississippi nonchilled 500 28.5
## 53 Mn3 Mississippi nonchilled 675 28.1
## 54 Mn3 Mississippi nonchilled 1000 27.8
## 55 Mc1 Mississippi chilled 175 14.9
## 56 Mc1 Mississippi chilled 250 18.1
## 57 Mc1 Mississippi chilled 350 18.9
## 58 Mc1 Mississippi chilled 500 19.5
## 59 Mc1 Mississippi chilled 675 22.2
## 60 Mc1 Mississippi chilled 1000 21.9
## 61 Mc2 Mississippi chilled 175 11.4
## 62 Mc2 Mississippi chilled 250 12.3
## 63 Mc2 Mississippi chilled 350 13.0
## 64 Mc2 Mississippi chilled 500 12.5
## 65 Mc2 Mississippi chilled 675 13.7
## 66 Mc2 Mississippi chilled 1000 14.4
## 67 Mc3 Mississippi chilled 175 18.0
## 68 Mc3 Mississippi chilled 250 17.9
## 69 Mc3 Mississippi chilled 350 17.9
## 70 Mc3 Mississippi chilled 500 17.9
## 71 Mc3 Mississippi chilled 675 18.9
## 72 Mc3 Mississippi chilled 1000 19.9CO2 %>% mutate(duration=conc*uptake)## Plant Type Treatment conc uptake duration
## 1 Qn1 Quebec nonchilled 95 16.0 1520.0
## 2 Qn1 Quebec nonchilled 175 30.4 5320.0
## 3 Qn1 Quebec nonchilled 250 34.8 8700.0
## 4 Qn1 Quebec nonchilled 350 37.2 13020.0
## 5 Qn1 Quebec nonchilled 500 35.3 17650.0
## 6 Qn1 Quebec nonchilled 675 39.2 26460.0
## 7 Qn1 Quebec nonchilled 1000 39.7 39700.0
## 8 Qn2 Quebec nonchilled 95 13.6 1292.0
## 9 Qn2 Quebec nonchilled 175 27.3 4777.5
## 10 Qn2 Quebec nonchilled 250 37.1 9275.0
## 11 Qn2 Quebec nonchilled 350 41.8 14630.0
## 12 Qn2 Quebec nonchilled 500 40.6 20300.0
## 13 Qn2 Quebec nonchilled 675 41.4 27945.0
## 14 Qn2 Quebec nonchilled 1000 44.3 44300.0
## 15 Qn3 Quebec nonchilled 95 16.2 1539.0
## 16 Qn3 Quebec nonchilled 175 32.4 5670.0
## 17 Qn3 Quebec nonchilled 250 40.3 10075.0
## 18 Qn3 Quebec nonchilled 350 42.1 14735.0
## 19 Qn3 Quebec nonchilled 500 42.9 21450.0
## 20 Qn3 Quebec nonchilled 675 43.9 29632.5
## 21 Qn3 Quebec nonchilled 1000 45.5 45500.0
## 22 Qc1 Quebec chilled 95 14.2 1349.0
## 23 Qc1 Quebec chilled 175 24.1 4217.5
## 24 Qc1 Quebec chilled 250 30.3 7575.0
## 25 Qc1 Quebec chilled 350 34.6 12110.0
## 26 Qc1 Quebec chilled 500 32.5 16250.0
## 27 Qc1 Quebec chilled 675 35.4 23895.0
## 28 Qc1 Quebec chilled 1000 38.7 38700.0
## 29 Qc2 Quebec chilled 95 9.3 883.5
## 30 Qc2 Quebec chilled 175 27.3 4777.5
## 31 Qc2 Quebec chilled 250 35.0 8750.0
## 32 Qc2 Quebec chilled 350 38.8 13580.0
## 33 Qc2 Quebec chilled 500 38.6 19300.0
## 34 Qc2 Quebec chilled 675 37.5 25312.5
## 35 Qc2 Quebec chilled 1000 42.4 42400.0
## 36 Qc3 Quebec chilled 95 15.1 1434.5
## 37 Qc3 Quebec chilled 175 21.0 3675.0
## 38 Qc3 Quebec chilled 250 38.1 9525.0
## 39 Qc3 Quebec chilled 350 34.0 11900.0
## 40 Qc3 Quebec chilled 500 38.9 19450.0
## 41 Qc3 Quebec chilled 675 39.6 26730.0
## 42 Qc3 Quebec chilled 1000 41.4 41400.0
## 43 Mn1 Mississippi nonchilled 95 10.6 1007.0
## 44 Mn1 Mississippi nonchilled 175 19.2 3360.0
## 45 Mn1 Mississippi nonchilled 250 26.2 6550.0
## 46 Mn1 Mississippi nonchilled 350 30.0 10500.0
## 47 Mn1 Mississippi nonchilled 500 30.9 15450.0
## 48 Mn1 Mississippi nonchilled 675 32.4 21870.0
## 49 Mn1 Mississippi nonchilled 1000 35.5 35500.0
## 50 Mn2 Mississippi nonchilled 95 12.0 1140.0
## 51 Mn2 Mississippi nonchilled 175 22.0 3850.0
## 52 Mn2 Mississippi nonchilled 250 30.6 7650.0
## 53 Mn2 Mississippi nonchilled 350 31.8 11130.0
## 54 Mn2 Mississippi nonchilled 500 32.4 16200.0
## 55 Mn2 Mississippi nonchilled 675 31.1 20992.5
## 56 Mn2 Mississippi nonchilled 1000 31.5 31500.0
## 57 Mn3 Mississippi nonchilled 95 11.3 1073.5
## 58 Mn3 Mississippi nonchilled 175 19.4 3395.0
## 59 Mn3 Mississippi nonchilled 250 25.8 6450.0
## 60 Mn3 Mississippi nonchilled 350 27.9 9765.0
## 61 Mn3 Mississippi nonchilled 500 28.5 14250.0
## 62 Mn3 Mississippi nonchilled 675 28.1 18967.5
## 63 Mn3 Mississippi nonchilled 1000 27.8 27800.0
## 64 Mc1 Mississippi chilled 95 10.5 997.5
## 65 Mc1 Mississippi chilled 175 14.9 2607.5
## 66 Mc1 Mississippi chilled 250 18.1 4525.0
## 67 Mc1 Mississippi chilled 350 18.9 6615.0
## 68 Mc1 Mississippi chilled 500 19.5 9750.0
## 69 Mc1 Mississippi chilled 675 22.2 14985.0
## 70 Mc1 Mississippi chilled 1000 21.9 21900.0
## 71 Mc2 Mississippi chilled 95 7.7 731.5
## 72 Mc2 Mississippi chilled 175 11.4 1995.0
## 73 Mc2 Mississippi chilled 250 12.3 3075.0
## 74 Mc2 Mississippi chilled 350 13.0 4550.0
## 75 Mc2 Mississippi chilled 500 12.5 6250.0
## 76 Mc2 Mississippi chilled 675 13.7 9247.5
## 77 Mc2 Mississippi chilled 1000 14.4 14400.0
## 78 Mc3 Mississippi chilled 95 10.6 1007.0
## 79 Mc3 Mississippi chilled 175 18.0 3150.0
## 80 Mc3 Mississippi chilled 250 17.9 4475.0
## 81 Mc3 Mississippi chilled 350 17.9 6265.0
## 82 Mc3 Mississippi chilled 500 17.9 8950.0
## 83 Mc3 Mississippi chilled 675 18.9 12757.5
## 84 Mc3 Mississippi chilled 1000 19.9 19900.0CO2 %>% group_by(Type)%>%summarise(mean=mean(conc))## # A tibble: 2 x 2
## Type mean
## <fct> <dbl>
## 1 Quebec 435
## 2 Mississippi 435CO2## Plant Type Treatment conc uptake
## 1 Qn1 Quebec nonchilled 95 16.0
## 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.0
## 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.0
## 38 Qc3 Quebec chilled 250 38.1
## 39 Qc3 Quebec chilled 350 34.0
## 40 Qc3 Quebec chilled 500 38.9
## 41 Qc3 Quebec chilled 675 39.6
## 42 Qc3 Quebec chilled 1000 41.4
## 43 Mn1 Mississippi nonchilled 95 10.6
## 44 Mn1 Mississippi nonchilled 175 19.2
## 45 Mn1 Mississippi nonchilled 250 26.2
## 46 Mn1 Mississippi nonchilled 350 30.0
## 47 Mn1 Mississippi nonchilled 500 30.9
## 48 Mn1 Mississippi nonchilled 675 32.4
## 49 Mn1 Mississippi nonchilled 1000 35.5
## 50 Mn2 Mississippi nonchilled 95 12.0
## 51 Mn2 Mississippi nonchilled 175 22.0
## 52 Mn2 Mississippi nonchilled 250 30.6
## 53 Mn2 Mississippi nonchilled 350 31.8
## 54 Mn2 Mississippi nonchilled 500 32.4
## 55 Mn2 Mississippi nonchilled 675 31.1
## 56 Mn2 Mississippi nonchilled 1000 31.5
## 57 Mn3 Mississippi nonchilled 95 11.3
## 58 Mn3 Mississippi nonchilled 175 19.4
## 59 Mn3 Mississippi nonchilled 250 25.8
## 60 Mn3 Mississippi nonchilled 350 27.9
## 61 Mn3 Mississippi nonchilled 500 28.5
## 62 Mn3 Mississippi nonchilled 675 28.1
## 63 Mn3 Mississippi nonchilled 1000 27.8
## 64 Mc1 Mississippi chilled 95 10.5
## 65 Mc1 Mississippi chilled 175 14.9
## 66 Mc1 Mississippi chilled 250 18.1
## 67 Mc1 Mississippi chilled 350 18.9
## 68 Mc1 Mississippi chilled 500 19.5
## 69 Mc1 Mississippi chilled 675 22.2
## 70 Mc1 Mississippi chilled 1000 21.9
## 71 Mc2 Mississippi chilled 95 7.7
## 72 Mc2 Mississippi chilled 175 11.4
## 73 Mc2 Mississippi chilled 250 12.3
## 74 Mc2 Mississippi chilled 350 13.0
## 75 Mc2 Mississippi chilled 500 12.5
## 76 Mc2 Mississippi chilled 675 13.7
## 77 Mc2 Mississippi chilled 1000 14.4
## 78 Mc3 Mississippi chilled 95 10.6
## 79 Mc3 Mississippi chilled 175 18.0
## 80 Mc3 Mississippi chilled 250 17.9
## 81 Mc3 Mississippi chilled 350 17.9
## 82 Mc3 Mississippi chilled 500 17.9
## 83 Mc3 Mississippi chilled 675 18.9
## 84 Mc3 Mississippi chilled 1000 19.9Melakukan kelima perintah bersamaan
CO2%>% select(Plant,Type,Treatment,conc,uptake) %>% arrange(desc(Type)) %>% filter(conc>100)%>% mutate(duration=conc*uptake)%>% group_by(Type)%>%summarise(mean=mean(conc))## # A tibble: 2 x 2
## Type mean
## <fct> <dbl>
## 1 Quebec 492.
## 2 Mississippi 492.