Converting data frame column from character to numeric

If we need only one column to be numeric

yyz$b <- as.numeric(as.character(yyz$b))

But, if all the columns needs to changed to numeric, use lapply to loop over the columns and convert to numeric by first converting it to character class as the columns were factor.

yyz[] <- lapply(yyz, function(x) as.numeric(as.character(x)))

Both the columns in the OP’s post are factor because of the string "n/a". This could be easily avoided while reading the file using na.strings = "n/a" in the read.table/read.csv or if we are using data.frame, we can have character columns with stringsAsFactors=FALSE (the default is stringsAsFactors=TRUE)

Regarding the usage of apply, it converts the dataset to matrix and matrix can hold only a single class. To check the class, we need

lapply(yyz, class)

Or

sapply(yyz, class)

Or check

str(yyz)

Related Posts:

  1. R Hex to RGB converter
  2. How do I select the first row in an R data frame that meets certain criteria?
  3. Error in file(file, “rt”) : cannot open the connection [duplicate]
  4. Error in : object of type ‘closure’ is not subsettable
  5. How to join (merge) data frames (inner, outer, left, right)
  6. Interpreting “condition has length > 1” warning from `if` function
  7. rbind error: “names do not match previous names”
  8. rbind error: “names do not match previous names”
  9. How to coerce a list object to type ‘double’
  10. $ operator is invalid for atomic vectors for dataframe R
  11. Plotting with ggplot2: “Error: Discrete value supplied to continuous scale” on categorical y-axis
  12. ggplot2 error : Discrete value supplied to continuous scale
  13. ggplot2 line chart gives “geom_path: Each group consist of only one observation. Do you need to adjust the group aesthetic?”
  14. R programming: How do I get Euler’s number?
  15. adding x and y axis labels in ggplot2
  16. Set NA to 0 in R
  17. ‘x’ and ‘y’ lengths differ ERROR when plotting
  18. What are the “standard unambiguous date” formats for string-to-date conversion in R?
  19. ‘x’ and ‘y’ lengths differ ERROR when plotting
  20. What are the “standard unambiguous date” formats for string-to-date conversion in R?
  21. Difference between paste() and paste0()
  22. Remove duplicated rows
  23. Error in colMeans(x, na.rm = TRUE) : ‘x’ must be numeric in KNN classification
  24. Error in ggplot.data.frame : Mapping should be created with aes or aes_string
  25. Error in plot.window(…) : need finite ‘xlim’ values
  26. Editing legend (text) labels in ggplot
  27. case_when in mutate pipe
  28. Logistic Regression on factor: Error in eval(family$initialize) : y values must be 0 <= y <= 1
  29. dim(X) must have a positive length when applying function in data frame
  30. Extract year from date
  31. Error: attempt to use zero-length variable name
  32. incorrect number of dimensions and incorrect number of subscripts in array
  33. How to debug “contrasts can be applied only to factors with 2 or more levels” error?
  34. R error: cannot coerce type ‘closure’ to vector of type ‘double’
  35. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
  36. R t-test Grouping factor must have exactly 2 levels error
  37. What does c do in R?
  38. Understanding the order() function
  39. Error in lis[[i]] : attempt to select less than one element
  40. Plot a line graph, error in xy.coords(x, y, xlabel, ylabel, log) : ‘x’ and ‘y’ lengths differ
  41. How to compute weighted mean in R?
  42. Calculate correlation for more than two variables?
  43. Error: unexpected symbol/input/string constant/numeric constant/SPECIAL in my code
  44. How to count the number of observations in R like Stata command count
  45. Remove all of x axis labels in ggplot
  46. Sum rows in data.frame or matrix
  47. Create an empty data.frame
  48. Can’t draw Histogram, ‘x’ must be numeric
  49. MLE error in R: initial value in ‘vmmin’ is not finite
  50. Rename multiple columns by names
  51. What is the difference between rm() and rm(list=ls())?
  52. Remove rows with all or some NAs (missing values) in data.frame
  53. Convert date-time string to class Date
  54. How do you create vectors with specific intervals in R?
  55. Linear model function lm() error: NA/NaN/Inf in foreign function call (arg 1)
  56. Remove rows with all or some NAs (missing values) in data.frame
  57. How to assign colors to categorical variables in ggplot2 that have stable mapping?
  58. Singularity in backsolve at level 0, block 1 in LME model
  59. Nested ifelse statement
  60. Is there a dictionary functionality in R
  61. Plot two graphs in same plot in R
  62. How to overcome error:”attempt to set ‘colnames’ on an object with less than two dimension” in xts object
  63. ggplot2 manually specifying colour with geom_line
  64. remove all variables except functions
  65. How to update a package in R?
  66. Error: Invalid input: date_trans works with objects of class Date only
  67. Run R script from command line
  68. Matrix expression causes error “requires numeric/complex matrix/vector arguments”?
  69. NAs are not allowed in subscripted assignments
  70. What’s the difference between facet_wrap() and facet_grid() in ggplot2?
  71. ggplot2, facet_grid, free scales?
  72. How do I install an R package from source?
  73. How can I convert Json to data frame in R
  74. lmer error: grouping factor must be < number of observations
  75. R Error (from NA’s to 0): duplicate subscripts for column in Data Frame
  76. Error in rbind(deparse.level, …) : numbers of columns of arguments do not match R
  77. Creating box plot on exercise
  78. What is the meaning of the dollar sign “$” in R function()?
  79. How to sort a data frame by alphabetic order of a character variable in R?
  80. Error in na.fail.default(as.ts(x)) : missing values in object in time series forecasting
  81. Argument “No” is missing, with no default
  82. R apply function with multiple parameters
  83. Geometric Mean: is there a built-in?
  84. Error in eval(predvars, data, env) : invalid ‘envir’ argument of type ‘character’
  85. Error in na.fail.default: missing values in object – but no missing values
  86. Error: Invalid number of ‘breaks’ in R
  87. Efficiently sum across multiple columns in R
  88. Convert the values in a column into row names in an existing data frame
  89. Deleting rows that are duplicated in one column based on the conditions of another column
  90. Replace all 0 values to NA
  91. The difference between bracket [ ] and double bracket [[ ]] for accessing the elements of a list or dataframe
  92. Merge error : negative length vectors are not allowed
  93. non-numeric argument to binary operator
  94. Error Error in storage.mode(x) <- "double" : 'list' object cannot be coerced to type 'double'
  95. Column standard deviation R [duplicate]
  96. Meaning of objects being masked by the global environment
  97. Subset and ggplot2
  98. Create a matrix of scatterplots (pairs() equivalent) in ggplot2
  99. How do I print a hexadecimal number with leading 0 to have width 2 using sprintf?
  100. In R, dealing with Error: ggplot2 doesn’t know how to deal with data of class numeric

Leave a Comment