How to delete the first row of a dataframe in R?

Question

I have a dataset with 11 columns with over a 1000 rows each. The columns were labeled V1, V2, V11, etc..I replaced the names with something more useful to me using the "c" command.I didn't realize that row 1 also contained labels for each column and my actual data starts on row 2.Is there a way to delete row 1 and decrement?

Answer 1

Let's assume that you have a data frame called data_set that contains two columns, V1 and V2:

set.seed(0721) # use set.seed to replicate data set exactly

data_set <- data.frame(V1 = c("Variable 1", sample(c("apples", "grapes", "oranges"), size = 10, replace = TRUE)), V2 = c("Variable 2", sample(c("soccer", "basketball", "football"), size = 10, replace = TRUE)))

V1 contains information about the favorite fruit of several survey participants from three types (apples, grapes, and oranges), while V2 includes information on those same participants' favorite sport from a list of soccer, basketball, or football. Let's also assume that you want to rename the columns to something more meaningful, namely: fav_fruit and fav_sport:

names(data_set) <- c("fav_fruit", "fav_sport")

After renaming the columns, you notice that the first row of each column contains a variable label. Use the square bracket operator to remove these labels:

data_set2 <- data_set[-1, ]

A tidyverse solution using rename and slice from dplyr would be:

library(tidyverse) # load tidyverse

data_set2 <- data_set %>%

rename(fav_fruit = V1, fav_sport = V2) %>% # rename the columns

slice(-1) # remove the first row