Manipulating Columns
Data frames are flexible: you can add, remove, and rename columns as needed.
Adding Columns
To add a new column, assign a vector of values to a new column name. You can use either the dollar ($) sign or square brackets with quotes.
Example
12345678name <- c("Alex", "Julia", "Finn") age <- c(24, 43, 32) gender <- c("M", "F", "M") test <- data.frame(name, age, gender) # Adding a new column with job titles test$job <- c("Teacher", "Doctor", "Manager") test
You could also do the same with:
test[, "Job"] <- c("Teacher", "Doctor", "Manager")
The length of the vector you add must match the number of rows in the data frame.
Deleting Columns
To remove one or more columns, use the subset() function with the select = -... argument.
Example
12345678910name <- c("Alex", "Julia", "Finn") age <- c(24, 43, 32) gender <- c("M", "F", "M") test <- data.frame(name, age, gender) test$job <- c('Teacher', 'Doctor', 'Manager') # Drop a single column subset(test, select = -job) # Drop multiple columns subset(test, select = -c(age, gender))
Renaming Columns
To rename columns, use the colnames() function. The syntax is the same as with matrices:
colnames(data) <- new_names
Swipe to start coding
You have a data frame store containing information on items and their prices from a small furniture store:
| items | prices |
|---|---|
| Sofa | 340 |
| Armchair | 150 |
| Dining table | 115 |
| Dining chair | 45 |
| Bookshelf | 160 |
You need to transform it into this table:
| Item | Price | Sold |
|---|---|---|
| Sofa | 340 | 67 |
| Armchair | 150 | 81 |
| Dining table | 115 | 79 |
| Dining chair | 45 | 76 |
| Bookshelf | 160 | 42 |
Follow the next steps:
- Rename the columns names of
storetoc('Item', 'Price'). - Add new column
Soldwith the values ofc(67, 81, 79, 76, 42). - Output modified data frame.
Ratkaisu
Kiitos palautteestasi!
single
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
Mahtavaa!
Completion arvosana parantunut arvoon 2.27Manipulating Columns
Pyyhkäise näyttääksesi valikon
Data frames are flexible: you can add, remove, and rename columns as needed.
Adding Columns
To add a new column, assign a vector of values to a new column name. You can use either the dollar ($) sign or square brackets with quotes.
Example
12345678name <- c("Alex", "Julia", "Finn") age <- c(24, 43, 32) gender <- c("M", "F", "M") test <- data.frame(name, age, gender) # Adding a new column with job titles test$job <- c("Teacher", "Doctor", "Manager") test
You could also do the same with:
test[, "Job"] <- c("Teacher", "Doctor", "Manager")
The length of the vector you add must match the number of rows in the data frame.
Deleting Columns
To remove one or more columns, use the subset() function with the select = -... argument.
Example
12345678910name <- c("Alex", "Julia", "Finn") age <- c(24, 43, 32) gender <- c("M", "F", "M") test <- data.frame(name, age, gender) test$job <- c('Teacher', 'Doctor', 'Manager') # Drop a single column subset(test, select = -job) # Drop multiple columns subset(test, select = -c(age, gender))
Renaming Columns
To rename columns, use the colnames() function. The syntax is the same as with matrices:
colnames(data) <- new_names
Swipe to start coding
You have a data frame store containing information on items and their prices from a small furniture store:
| items | prices |
|---|---|
| Sofa | 340 |
| Armchair | 150 |
| Dining table | 115 |
| Dining chair | 45 |
| Bookshelf | 160 |
You need to transform it into this table:
| Item | Price | Sold |
|---|---|---|
| Sofa | 340 | 67 |
| Armchair | 150 | 81 |
| Dining table | 115 | 79 |
| Dining chair | 45 | 76 |
| Bookshelf | 160 | 42 |
Follow the next steps:
- Rename the columns names of
storetoc('Item', 'Price'). - Add new column
Soldwith the values ofc(67, 81, 79, 76, 42). - Output modified data frame.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
single
