Load Liabries
library(tidyverse)
#import data
Bootcamp_52 <- read_csv("Bootcamp_52.csv",
col_types = cols(`Row ID` = col_character(),
`Order Date` = col_date(format = "%m/%d/%Y"),
Year = col_date(format = "%Y"), `Postal Code` = col_character()))
Warning: One or more parsing issues, call `problems()` on your data frame for
details, e.g.:
dat <- vroom(...)
problems(dat)
Excercise 52
Ship_cost <- Bootcamp_52 %>%
group_by(Category, Year, 'order priority') %>%
#filter(Year == 2025) %>%
summarize(Ship_cost = sum(`shipping costs`= FALSE))
`summarise()` has grouped output by 'Category', 'Year'. You can override using the `.groups` argument.
Add a new chunk by clicking the *Insert
When you save the notebook, an HTML file containing the code and
output will be saved alongside it (click the Preview button or
press Cmd+Shift+K to preview the HTML file).
The preview shows you a rendered HTML copy of the contents of the
editor. Consequently, unlike Knit, Preview does not
run any R code chunks. Instead, the output of the chunk when it was last
run in the editor is displayed.
LS0tCnRpdGxlOiAiV2lsZXkgWEwgYm9vdGNhbXAiCm91dHB1dDogaHRtbF9ub3RlYm9vawotLS0KCiMgTG9hZCBMaWFicmllcwpgYGB7cn0KbGlicmFyeSh0aWR5dmVyc2UpCmBgYAoKI2ltcG9ydCBkYXRhCmBgYHtyfQpCb290Y2FtcF81MiA8LSByZWFkX2NzdigiQm9vdGNhbXBfNTIuY3N2IiwgCiAgICBjb2xfdHlwZXMgPSBjb2xzKGBSb3cgSURgID0gY29sX2NoYXJhY3RlcigpLCAKICAgICAgICBgT3JkZXIgRGF0ZWAgPSBjb2xfZGF0ZShmb3JtYXQgPSAiJW0vJWQvJVkiKSwgCiAgICAgICAgWWVhciA9IGNvbF9kYXRlKGZvcm1hdCA9ICIlWSIpLCBgUG9zdGFsIENvZGVgID0gY29sX2NoYXJhY3RlcigpKSkKCmBgYAoKCiMgRXhjZXJjaXNlIDUyCgpgYGB7cn0KU2hpcF9jb3N0IDwtIEJvb3RjYW1wXzUyICU+JQpncm91cF9ieShDYXRlZ29yeSwgWWVhciwgJ29yZGVyIHByaW9yaXR5JykgJT4lCiNmaWx0ZXIoWWVhciA9PSAyMDI1KSAlPiUKc3VtbWFyaXplKFNoaXBfY29zdCA9IHN1bShgc2hpcHBpbmcgY29zdHNgPSBGQUxTRSkpCgoKYGBgCgpBZGQgYSBuZXcgY2h1bmsgYnkgY2xpY2tpbmcgdGhlICpJbnNlcnQgCgpXaGVuIHlvdSBzYXZlIHRoZSBub3RlYm9vaywgYW4gSFRNTCBmaWxlIGNvbnRhaW5pbmcgdGhlIGNvZGUgYW5kIG91dHB1dCB3aWxsIGJlIHNhdmVkIGFsb25nc2lkZSBpdCAoY2xpY2sgdGhlICpQcmV2aWV3KiBidXR0b24gb3IgcHJlc3MgKkNtZCtTaGlmdCtLKiB0byBwcmV2aWV3IHRoZSBIVE1MIGZpbGUpLiAKClRoZSBwcmV2aWV3IHNob3dzIHlvdSBhIHJlbmRlcmVkIEhUTUwgY29weSBvZiB0aGUgY29udGVudHMgb2YgdGhlIGVkaXRvci4gQ29uc2VxdWVudGx5LCB1bmxpa2UgKktuaXQqLCAqUHJldmlldyogZG9lcyBub3QgcnVuIGFueSBSIGNvZGUgY2h1bmtzLiBJbnN0ZWFkLCB0aGUgb3V0cHV0IG9mIHRoZSBjaHVuayB3aGVuIGl0IHdhcyBsYXN0IHJ1biBpbiB0aGUgZWRpdG9yIGlzIGRpc3BsYXllZC4KCg==