Codecademy Learn R Review 6/6

#Sample Solution
---
title: "Modifying Data Frames in R"
output: html_notebook
---

```{r message=FALSE, warning=FALSE}
# load libraries
library(readr)
library(dplyr)
```

```{r message=FALSE}
# load data frame
dogs <- read_csv('dogs.csv')
```

```{r}
# inspect data frame
head(dogs)
```

```{r}
# add new columns, drop existing columns and arrange
dogs <- dogs %>% transmute(breed = breed, height_average_feet =(height_low_inches + height_high_inches)/24, popularity_change_15_to_16 = rank_2016 - rank_2015) %>% arrange(desc(popularity_change_15_to_16))
head(dogs)
```