assign headers based on existing row in dataframe in R

r dataframe names
user3166363 picture user3166363 · Jan 6, 2014 · Viewed 116.7k times · Source

After transforming a dataframe, I would like to assign heads/names to the columns based on an existing row. My headers are currently: 

row.names   X2  X3  X4  X5  X6  X7  X8  X9  ...

I would like to get rid of that and use the following row as column headers (without having to type them out since I have many).

The only solution I have for this is to export and re-load the data (with header=T).

Answer

Vishnu Jayanand picture Vishnu Jayanand · May 20, 2016

The key here is to unlist the row first.

colnames(DF) <- as.character(unlist(DF[1,]))
DF = DF[-1, ]

Related questions

Function to add names to data frame

I'm have a data frame without columns: df<-data.frame(v1=c(1:10), v2=seq(1, 100, length=10)) I want to change the header names to "X" and "Y" I know I can do this using: names(df)<-c("X","Y") …

Read More
R: losing column names when adding rows to an empty data frame

I am just starting with R and encountered a strange behaviour: when inserting the first row in an empty data frame, the original column names get lost. example: a<-data.frame(one = numeric(0), two = numeric(0)) a #[1] one two #<0 …

Read More
Specifying column names in a data.frame changes spaces to "."

Let's say I have a data.frame, like so: x <- c(1:10,1:10,1:10,1:10,1:10,1:10,1:10,1:10,1:10,1:10) df <- data.frame("Label 1"=x,"Label 2"=rnorm(100)) head(df,3) returns: Label.1 Label.2 1 1 1.9825458 2 2 -0.4515584 3 3 0.6397516 How do I get R to stop automagically replacing the space with …

Read More