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==