Lære 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, ]

Oppgave

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

Løsning

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 39

single

Spør AI

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

Sveip for å vise menyen

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, ]

Oppgave

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

Løsning

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 39

single