R Adding Column Names / Header to Data Frame (Example Code)
This article explains how to read a data set without header and adjust the column names in the R programming language.
Creation of Example Data
data(iris) # Example data in R head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa |
data(iris) # Example data in R head(iris) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3.0 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5.0 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa
write.table(iris, # Writing data without header "iris.csv", sep = ";", row.names = FALSE, col.names = FALSE) |
write.table(iris, # Writing data without header "iris.csv", sep = ";", row.names = FALSE, col.names = FALSE)
Example: Read Data without Header & Rename Column Names
iris_import <- read.csv2("iris.csv", # Read data set without column names header = FALSE) head(iris_import) # Print data frame to RStudio console # V1 V2 V3 V4 V5 # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa |
iris_import <- read.csv2("iris.csv", # Read data set without column names header = FALSE) head(iris_import) # Print data frame to RStudio console # V1 V2 V3 V4 V5 # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa
colnames(iris_import) <- c("Sepal.Length", # Renaming variables "Sepal.Width", "Petal.Length", "Petal.Width", "Species") head(iris_import) # Print data frame to RStudio console # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa |
colnames(iris_import) <- c("Sepal.Length", # Renaming variables "Sepal.Width", "Petal.Length", "Petal.Width", "Species") head(iris_import) # Print data frame to RStudio console # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa # 2 4.9 3 1.4 0.2 setosa # 3 4.7 3.2 1.3 0.2 setosa # 4 4.6 3.1 1.5 0.2 setosa # 5 5 3.6 1.4 0.2 setosa # 6 5.4 3.9 1.7 0.4 setosa
Related Articles
Have a look at the following R programming tutorials. They discuss topics such as variables and loops.