Why data frames are central to R in R Programming - See It in Action

Why data frames are central to R

📖 Scenario: Imagine you are a small business owner who wants to keep track of your sales data. You have information about the products sold, the quantity, and the price. You want to organize this data so you can easily analyze it and make decisions.

🎯 Goal: You will create a simple data frame in R to store sales data, add a helper variable for a sales threshold, filter the data based on this threshold, and then display the filtered results. This will show why data frames are central to R for handling tabular data.

📋 What You'll Learn

Create a data frame called sales_data with columns Product, Quantity, and Price using exact values

Create a variable called min_sales with the value 50

Use a subset operation to create a new data frame filtered_sales with rows where Quantity is greater than min_sales

Print the filtered_sales data frame

💡 Why This Matters

🌍 Real World

Data frames help organize and analyze data like sales, customer info, or survey results in a clear table format.

💼 Career

Many jobs in data analysis, statistics, and research use R data frames to handle and explore data efficiently.

1

Create the sales data frame

Create a data frame called sales_data with these exact columns and values: Product with values 'Apples', 'Bananas', 'Cherries'; Quantity with values 30, 60, 45; and Price with values 1.2, 0.5, 2.0.

R Programming

# Create the sales_data data frame with Product, Quantity, and Price columns
# Your code here

Hint

Use the data.frame() function with named vectors for each column.

2

Set the minimum sales threshold

Create a variable called min_sales and set it to the number 50.

R Programming

sales_data <- data.frame(
  Product = c('Apples', 'Bananas', 'Cherries'),
  Quantity = c(30, 60, 45),
  Price = c(1.2, 0.5, 2.0)
)
# Create min_sales variable and set it to 50
# Your code here

Hint

Just assign the number 50 to the variable min_sales.

3

Filter the sales data by quantity

Create a new data frame called filtered_sales that contains only the rows from sales_data where the Quantity is greater than min_sales.

R Programming

sales_data  min_sales
# Your code here

Hint

Use the subset() function to filter rows where Quantity is greater than min_sales.

4

Display the filtered sales data

Print the filtered_sales data frame to show the products with quantity greater than min_sales.

R Programming

sales_data  min_sales)
# Print filtered_sales
# Your code here

Hint

Use the print() function to display the filtered_sales data frame.

Practice

1. Why are data frames considered central to R programming?

easy

A. Because they only store numeric data efficiently

B. Because they organize data in rows and columns, allowing easy data analysis

C. Because they are used to create graphics directly

D. Because they replace all other data structures in R

Solution

1. Step 1: Understand data frame structure

   Data frames store data in rows and columns, similar to a spreadsheet, making data easy to view and analyze.

2. Step 2: Recognize their role in R

   They allow different types of data in each column and are widely used for data manipulation and analysis.

3. Final Answer:

   Because they organize data in rows and columns, allowing easy data analysis -> Option B

4. Quick Check:

   Data frames = central for organizing data [OK]

Hint: Think spreadsheet style data storage [OK]

Common Mistakes:

• Assuming data frames only store numeric data
• Confusing data frames with plotting functions
• Thinking data frames replace all data types

2. Which of the following is the correct way to create a simple data frame in R?

easy

A. df <- dataframe(name = ['Anna', 'Bob'], age = [25, 30])

B. df <- data.frame('Anna', 25, 'Bob', 30)

C. df <- data.frame(name = c('Anna', 'Bob'), age = c(25, 30))

D. df <- data.frame(name = 'Anna', age = 25, name = 'Bob', age = 30)

Solution

1. Step 1: Check syntax for data.frame()

   The correct function is data.frame() with named arguments and vectors for each column.

2. Step 2: Validate df <- data.frame(name = c('Anna', 'Bob'), age = c(25, 30))

   df <- data.frame(name = c('Anna', 'Bob'), age = c(25, 30)) uses c() to create vectors for columns 'name' and 'age', which is correct syntax.

3. Final Answer:

   df <- data.frame(name = c('Anna', 'Bob'), age = c(25, 30)) -> Option C

4. Quick Check:

   Correct data.frame() syntax = df <- data.frame(name = c('Anna', 'Bob'), age = c(25, 30)) [OK]

Hint: Use c() for column vectors inside data.frame() [OK]

Common Mistakes:

• Using square brackets instead of c()
• Passing values without naming columns
• Repeating column names in arguments

3. What will be the output of the following R code?

df <- data.frame(name = c('Tom', 'Sue'), age = c(22, 28))
str(df)

medium

A. A summary showing structure with 2 observations and 2 variables

B. An error because str() cannot be used on data frames

C. A list of names only

D. The data frame printed as a table

Solution

1. Step 1: Understand str() function

   str() shows the internal structure of an R object, including data frames.

2. Step 2: Apply str() to the data frame

   It will display number of observations (rows), variables (columns), and their types.

3. Final Answer:

   A summary showing structure with 2 observations and 2 variables -> Option A

4. Quick Check:

   str() shows structure summary [OK]

Hint: str() summarizes data frame structure [OK]

Common Mistakes:

• Expecting str() to print data as table
• Thinking str() causes error on data frames
• Confusing str() with summary()

4. Identify the error in this R code that tries to create a data frame:

df <- data.frame(name = c('Amy', 'John'), age = c(30, 'twenty'))

medium

A. Using single quotes instead of double quotes causes error

B. No error, code runs fine

C. Missing closing parenthesis

D. Mixed data types in 'age' column cause coercion to character

Solution

1. Step 1: Check data types in 'age' column

   The 'age' column has numeric 30 and string 'twenty', mixing types.

2. Step 2: Understand R's coercion rules

   R converts the entire column to character to accommodate 'twenty', which may cause issues in numeric operations.

3. Final Answer:

   Mixed data types in 'age' column cause coercion to character -> Option D

4. Quick Check:

   Mixed types cause coercion [OK]

Hint: Check column data types for consistency [OK]

Common Mistakes:

• Ignoring type coercion effects
• Thinking quotes style causes error
• Assuming code syntax is wrong

5. You have a data frame with columns of different types. Which feature of data frames allows this, and why is it important?

hard

A. Data frames allow each column to have its own data type, enabling mixed data storage

B. Data frames force all columns to be the same type for consistency

C. Data frames store data as a single vector, so types don't matter

D. Data frames convert all data to factors automatically

Solution

1. Step 1: Recall data frame column type rules

   Each column in a data frame can have a different data type, such as numeric, character, or factor.

2. Step 2: Understand importance

   This flexibility allows data frames to represent real-world data accurately, where different attributes have different types.

3. Final Answer:

   Data frames allow each column to have its own data type, enabling mixed data storage -> Option A

4. Quick Check:

   Mixed column types = data frame strength [OK]

Hint: Remember columns can differ in type [OK]

Common Mistakes:

• Thinking all columns must share one type
• Believing data frames store data as one vector
• Assuming automatic conversion to factors