Avoid that space in column name is replaced with period (".") when using read.csv()

r names read.csv
zeno tsang picture zeno tsang · Jun 17, 2013 · Viewed 32.6k times · Source

I am using R to do some data pre-processing, and here is the problem that I am faced with: I input the data using read.csv(filename,header=TRUE), and then the space in variable names became ".", for example, a variable named Full Code became Full.Code in the generated dataframe. After the processing, I use write.xlsx(filename) to export the results, while the variable names are changed. How to address this problem?

Besides, in the output .xlsx file, the first column become indices(i.e., 1 to N), which is not what I am expecting.

Answer

Greg Snow picture Greg Snow · Jun 18, 2013

If your set check.names=FALSE in read.csv when you read the data in then the names will not be changed and you will not need to edit them before writing the data back out. This of course means that you would need quote the column names (back quotes in some cases) or refer to the columns by location rather than name while editing.

Related questions

assign headers based on existing row in dataframe in R

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 …

Read More
Naming list elements in R

I've been doing some work with some large, complex lists lately and I've seen some behaviour which was surprising (to me, at least), mainly to do with assigning names to a list. A simple example: Fil <- list( a = …

Read More
use first row data as column names in r

I have a dirty dataset that I could not read it with header = T. After I read and clean it, I would like to use the now first row data as the column name. I tried multiple methods on Stack …

Read More