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).
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
123456789name <- 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
123456789101112name <- 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
12345678name <- 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, ]
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 thestoredata frame. Reassign the result to thestorevariable. -
Add a new row to the data frame
storeusing thelistapproach with this data:Item Price Sold Kitchen cabinet 70 67 -
Output modified data frame.
Oplossing
Bedankt voor je feedback!
single
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Geweldig!
Completion tarief verbeterd naar 2.27Manipulating Rows
Veeg om het menu te tonen
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).
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
123456789name <- 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
123456789101112name <- 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
12345678name <- 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, ]
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 thestoredata frame. Reassign the result to thestorevariable. -
Add a new row to the data frame
storeusing thelistapproach with this data:Item Price Sold Kitchen cabinet 70 67 -
Output modified data frame.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
single
