Specifying column names in a data.frame changes spaces to “.”

by

You may set check.names = FALSE in data.frame (as well as in read.table):

df <- data.frame("Label 1" = 1:3, "Label 2" = rnorm(3), check.names = FALSE)

returns:

  Label 1    Label 2
1       1  0.2013347
2       2  1.8823111
3       3 -0.5233811

From ?data.frame:

check.names
logical. If TRUE then the names of the variables in the data frame are checked to ensure that they are syntactically valid variable names and are not duplicated. If necessary they are adjusted (by make.names) so that they are.

From ?make.names:

A syntactically valid name consists of letters, numbers and the dot or underline characters and starts with a letter or the dot not followed by a number. Names such as “.2way” are not valid, and neither are the reserved words.

All invalid characters are translated to “.“

Also, if you need to subset a variable with an ‘invalid’ name using $, you can use backticks `. For example:

df$`Label 1`

More Related Contents:

  1. Why am I getting X. in my column names when reading a data frame?
  2. Numbers as column names of data frames
  3. Select the row with the maximum value in each group
  4. Access lapply index names inside FUN
  5. Sample random rows in dataframe
  6. Find indices of duplicated rows [duplicate]
  7. How to drop columns by name in a data frame
  8. Subset / filter rows in a data frame based on a condition in a column
  9. Coerce multiple columns to factors at once
  10. Reshape multiple values at once
  11. Remove columns from dataframe where ALL values are NA
  12. Match values in data frame with values in another data frame and replace former with a corresponding pattern from the other data frame
  13. Detect at least one match between each data frame row and values in vector
  14. Converting nested list to dataframe
  15. Cartesian product data frame
  16. Merge Two Lists in R
  17. How to sort a data frame by date
  18. Access and preserve list names in lapply function
  19. Randomly insert NAs into dataframe proportionaly
  20. How to delete rows where all the columns are zero
  21. R: Split unbalanced list in data.frame column
  22. Transposing a dataframe maintaining the first column as heading
  23. Filter data frame rows based on values in vector
  24. Should I use a data.frame or a matrix?
  25. Replace empty values with value from other column in a dataframe
  26. Split dataframe using two columns of data and apply common transformation on list of resulting dataframes
  27. Replace values in data frame based on other data frame in R
  28. Add an image to a table-like output in R
  29. R how can I calculate difference between rows in a data frame
  30. Color one point and add an annotation in ggplot2?

Leave a Comment