arrange() for sorting in R Programming - Mini Project: Build & Apply

Sorting Data Frames with arrange() in R

📖 Scenario: You work in a small bookstore and keep track of book sales in a data frame. You want to organize the sales data to see which books sold the most and which sold the least.

🎯 Goal: Learn how to use the arrange() function from the dplyr package in R to sort a data frame by one or more columns.

📋 What You'll Learn

Create a data frame called sales with book titles and number of copies sold

Load the dplyr package using library(dplyr)

Use arrange() to sort the data frame by copies sold in ascending order

Print the sorted data frame

💡 Why This Matters

🌍 Real World

Sorting sales data helps bookstores understand which books are popular and manage inventory better.

💼 Career

Data analysts and business professionals often sort data frames to organize and analyze data efficiently.

1

Create the sales data frame

Create a data frame called sales with two columns: book and copies_sold. Use these exact entries: 'The Hobbit' with 150, '1984' with 200, 'Pride and Prejudice' with 120, 'To Kill a Mockingbird' with 180.

R Programming

# Create the sales data frame with book titles and copies sold
# Your code here

Need a hint?

Use data.frame() with two vectors named book and copies_sold.

2

Load the dplyr package

Write the code to load the dplyr package using library(dplyr).

R Programming

sales <- data.frame(
  book = c('The Hobbit', '1984', 'Pride and Prejudice', 'To Kill a Mockingbird'),
  copies_sold = c(150, 200, 120, 180)
)
# Load the dplyr package
# Your code here

Need a hint?

Use library(dplyr) to load the package before using arrange().

3

Sort the sales data frame by copies sold

Use the arrange() function to sort the sales data frame by the copies_sold column in ascending order. Save the result in a new variable called sorted_sales.

R Programming

sales <- data.frame(
  book = c('The Hobbit', '1984', 'Pride and Prejudice', 'To Kill a Mockingbird'),
  copies_sold = c(150, 200, 120, 180)
)
library(dplyr)
# Use arrange() to sort sales by copies_sold in ascending order
# Your code here

Need a hint?

Use arrange(sales, copies_sold) and assign it to sorted_sales.

4

Print the sorted data frame

Print the sorted_sales data frame to see the books sorted by copies sold in ascending order.

R Programming

sales <- data.frame(
  book = c('The Hobbit', '1984', 'Pride and Prejudice', 'To Kill a Mockingbird'),
  copies_sold = c(150, 200, 120, 180)
)
library(dplyr)
sorted_sales <- arrange(sales, copies_sold)
# Print sorted_sales
# Your code here

Need a hint?

Use print(sorted_sales) to display the sorted data frame.