Apprendre Manipulating Rows

Just like columns, rows in a data frame can also be added or removed.

Adding Single Rows

To add a single row, you can assign a new entry to the next available row index (nrow(data) + 1). Since a data frame can hold different types of values, the new row must be provided as a list (or a data frame).

Note

By default, text values may be converted to factors when creating data frames. This can cause problems when adding new rows. To avoid this, set stringsAsFactors = FALSE when creating the data frame.

Example


              123456789
            
name <- c("Alex", "Julia", "Finn")
age <- c(24, 43, 32)
gender <- c("M", "F", "M")
job <- c('Teacher', 'Doctor', 'Manager')
test <- data.frame(name, age, gender, job, stringsAsFactors = FALSE)

# Add a new row
test[nrow(test) + 1, ] <- list('Angela', 35, 'F', 'Accountant')
test

Adding Multiple Rows

Another way to add rows is by merging two data frames with the same columns using the merge() function. This allows you to add multiple rows at once.

Example


              123456789101112
            
name <- c("Alex", "Julia", "Finn")
age <- c(24, 43, 32)
gender <- c("M", "F", "M")
job <- c('Teacher', 'Doctor', 'Manager')
test <- data.frame(name, age, gender, job, stringsAsFactors = FALSE)

# New row as data a frame
new_person <- data.frame('Angela', 35, 'F', 'Accountant')
colnames(new_person) <- colnames(test)

# Merge
merge(test, new_person, all = T)

Removing Rows

To remove rows, use negative indices inside square brackets, like with matrices.

Example


              12345678
            
name <- c("Alex", "Julia", "Finn")
age <- c(24, 43, 32)
gender <- c("M", "F", "M")
job <- c('Teacher', 'Doctor', 'Manager')
test <- data.frame(name, age, gender, job, stringsAsFactors = FALSE)

# Remove a row
test[-1, ]

Tâche

Swipe to start coding

You have a data frame store that contains information on items, their prices, and their quantities sold in a small furniture shop.

Your task is to:

Remove the 'Dining chair' row (index 4) out of the store data frame. Reassign the result to the store variable.
Add a new row to the data frame store using the list approach with this data:

Item Price Sold
Kitchen cabinet 70 67
Output modified data frame.

Item	Price	Sold
Kitchen cabinet	70	67

Solution

Tout était clair ?

Merci pour vos commentaires !

Section 1. Chapitre 39

single

Demandez à l'IA

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

Glissez pour afficher le menu

Just like columns, rows in a data frame can also be added or removed.

Adding Single Rows

Note

Example


              123456789
            
name <- c("Alex", "Julia", "Finn")
age <- c(24, 43, 32)
gender <- c("M", "F", "M")
job <- c('Teacher', 'Doctor', 'Manager')
test <- data.frame(name, age, gender, job, stringsAsFactors = FALSE)

# Add a new row
test[nrow(test) + 1, ] <- list('Angela', 35, 'F', 'Accountant')
test

Adding Multiple Rows

Another way to add rows is by merging two data frames with the same columns using the merge() function. This allows you to add multiple rows at once.

Example


              123456789101112
            
name <- c("Alex", "Julia", "Finn")
age <- c(24, 43, 32)
gender <- c("M", "F", "M")
job <- c('Teacher', 'Doctor', 'Manager')
test <- data.frame(name, age, gender, job, stringsAsFactors = FALSE)

# New row as data a frame
new_person <- data.frame('Angela', 35, 'F', 'Accountant')
colnames(new_person) <- colnames(test)

# Merge
merge(test, new_person, all = T)

Removing Rows

To remove rows, use negative indices inside square brackets, like with matrices.

Example


              12345678
            
name <- c("Alex", "Julia", "Finn")
age <- c(24, 43, 32)
gender <- c("M", "F", "M")
job <- c('Teacher', 'Doctor', 'Manager')
test <- data.frame(name, age, gender, job, stringsAsFactors = FALSE)

# Remove a row
test[-1, ]

Tâche

Swipe to start coding

You have a data frame store that contains information on items, their prices, and their quantities sold in a small furniture shop.

Your task is to:

Remove the 'Dining chair' row (index 4) out of the store data frame. Reassign the result to the store variable.
Add a new row to the data frame store using the list approach with this data:

Item Price Sold
Kitchen cabinet 70 67
Output modified data frame.

Item	Price	Sold
Kitchen cabinet	70	67

Solution

Passez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous

Tout était clair ?

Merci pour vos commentaires !

Section 1. Chapitre 39

single