Having numbers as column names instead of string values in R exported excel

Asked Apr 06 '18 at 10:05

Active Apr 06 '18 at 10:05

Viewed 46 times

I exported an excel in r without headers.

df = read.xlsx('D:/hotel rates/Yoho 5th Lane Signature 2799850.xls', sheetIndex = 1, header = FALSE)

Then changed the colnames as the second row values.

colnames(df) =df[2,]

But my column names appeared as numbers as follows.

Actually I want the second row as my colnames. Can any one fix this?

I think thereis some kind of factor level in data. when I run df[2,2]the console shows the following.`

asked Apr 06 '18 at 10:05

Jaliya

2

What about `colnames(df) <- as.character(df[2,])`? – Fustincho Apr 06 '18 at 10:26
similar to https://cran.r-project.org/doc/FAQ/R-FAQ.html#How-do-I-convert-factors-to-numeric_003f – jogo Apr 06 '18 at 10:30
No good the result is same... – Jaliya Apr 06 '18 at 10:31
Please give a [reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) – jogo Apr 06 '18 at 10:41
How about `startRow=2,colNames=TRUE` in your `read.xlsx` call? – Andrew Gustar Apr 06 '18 at 10:45
How about `colnames(df) = unlist(df[2,])`? – Prem Apr 06 '18 at 10:47
1

Thanks every one .. found the answer.. df <- data.frame(lapply(df, as.character), stringsAsFactors=FALSE) – Jaliya Apr 06 '18 at 12:18

0 Answers0