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.
Lösung
Danke für Ihr Feedback!
single
Fragen Sie AI
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen
Großartig!
Completion Rate verbessert auf 2.27Manipulating Rows
Swipe um das Menü anzuzeigen
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.
Lösung
Wechseln Sie zum Desktop, um in der realen Welt zu übenFahren Sie dort fort, wo Sie sind, indem Sie eine der folgenden Optionen verwendenDanke für Ihr Feedback!
single
