me
12/10/2019
This is an R Markdown presentation. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.
When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document.
## speed dist
## Min. : 4.0 Min. : 2.00
## 1st Qu.:12.0 1st Qu.: 26.00
## Median :15.0 Median : 36.00
## Mean :15.4 Mean : 42.98
## 3rd Qu.:19.0 3rd Qu.: 56.00
## Max. :25.0 Max. :120.00
GCN <- read_excel(“~/Downloads/Dispense Usage Transactions Top 50 GCN Seq Nbrs Week 201836.xlsx”)
nrow(GCN) dim(GCN) str(GCN)
names(GCN)
new <- GCN %>% group_by(NDC_DESC) %>% summarise(Mean_Price = mean(COGS_PRC_MTRC,na.rm = TRUE)) print(new)