Converting from a character to a numeric data frame

As @thijs van den bergh points you to,

dat <- data.frame(x=c("NaN","2"),y=c("NaN","3"),stringsAsFactors=FALSE)

dat <- as.data.frame(sapply(dat, as.numeric)) #<- sapply is here

dat[complete.cases(dat), ]
#  x y
#2 2 3

Is one way to do this.

Your error comes from trying to make a data.fr

Related Posts:

  1. Convert data.frame column to a vector?
  2. Create empty data frame with column names by assigning a string vector?
  3. How to remove outliers from a dataset
  4. Insert a blank column in dataframe
  5. Convert data.frame columns from factors to characters
  6. dplyr: “Error in n(): function should not be called directly”
  7. Error in eval(expr, envir, enclos) : object not found
  8. How do I convert a factor into date format?
  9. Write lines of text to a file in R
  10. scale_fill_discrete and scale_fill_manual – legend options confusion
  11. ‘Incomplete final line’ warning when trying to read a .csv file into R
  12. Conditional mean statement
  13. R error: “New Column would leave holes after existing columns”
  14. Warning in GLM analysis
  15. What does ‘length of ‘dimnames’ [1] not equal to array extent’ mean?
  16. How do I flip rows and columns in R
  17. How to catch integer(0)?
  18. “no function to return from, jumping to top level”
  19. r random forest error – type of predictors in new data do not match
  20. env=baseenv() in R
  21. Sample random rows in dataframe
  22. Removing punctuations from text using R
  23. How to find out which package version is loaded in R?
  24. How to solve it. error:Error in data[[rowvar]] : attempt to select less than one element
  25. Gradient of n colors ranging from color 1 and color 2
  26. How to prevent scientific notation in R?
  27. What is the difference between require() and library()?
  28. How to declare a vector of zeros in R
  29. R Sweave: NO TeX installation detected
  30. ERROR: [on_request_read] connection reset by peer in R shiny
  31. Error in as.vector(x, mode) : cannot coerce type ‘closure’ to vector of type ‘any’
  32. Suppress output of a function
  33. Error in G * t(hat) : non-conformable arrays
  34. Error: isTRUE(gpclibPermitStatus()) is not TRUE
  35. How to counter the ‘non-numeric matrix extent’ error in R?
  36. What does is.na() applied to non-(list or vector) of type ‘NULL’ mean?
  37. error r: invalid subscript type “closure” in a simple regression
  38. Merge two rows in data.frame
  39. r function unzip error 1 in extracting from zip file
  40. Get the list of installed packages by user in R
  41. Colour points in a plot differently depending on a vector of values
  42. How to access the last value in a vector?
  43. increase legend font size ggplot2
  44. Mask output of `The following objects are masked from….:` after calling attach() function
  45. How To Create Vector of Vector In R
  46. Use of ~ (tilde) in R programming Language
  47. Construct a manual legend for a complicated plot
  48. Code to clear all plots in RStudio
  49. Error: x must be atomic for ‘sort.list’
  50. How can I change the name of a data frame
  51. Installing R on Android
  52. Transposing in dplyr
  53. Does the c command create a row vector or a column vector by default in R
  54. Error in summary.connection(connection) : invalid connection
  55. How to create lag variables
  56. When trying to replace values, “missing values are not allowed in subscripted assignments of data frames”
  57. R Hex to RGB converter
  58. Renaming column names in Pandas
  59. Delete a column from a Pandas DataFrame
  60. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  61. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  62. Adding new column to existing DataFrame in Python pandas
  63. How to change the order of DataFrame columns?
  64. How do I select rows from a DataFrame based on column values?
  65. How do I get the row count of a Pandas DataFrame?
  66. Convert pandas dataframe to NumPy array
  67. Editing legend (text) labels in ggplot
  68. How do I get the row count of a Pandas DataFrame?
  69. ‘DataFrame’ object has no attribute ‘sort’
  70. Rename Pandas DataFrame Index
  71. Convert DataFrame column type from string to datetime, dd/mm/yyyy format
  72. Get a list from Pandas DataFrame column headers
  73. Replace a value in a data frame based on a conditional (`if`) statement
  74. Shuffle DataFrame rows
  75. How to randomize ggplot factor color scheme, keeping same default distances on color wheel?
  76. Count number of occurences for each unique value
  77. Python: create a pandas data frame from a list
  78. Mean per group in a data.frame
  79. Error in dev.off() : cannot shut down device 1 (the null device)
  80. Selecting/excluding sets of columns in pandas
  81. What is the difference between = and ==?
  82. Merge r brings error “‘by’ must specify uniquely valid columns”
  83. What does the error “arguments imply differing number of rows: x, y” mean?
  84. Non-numeric argument to mathematical function
  85. pandas dataframe convert column type to string or categorical
  86. R – Concatenate two dataframes?
  87. Pandas DataFrame: replace all values in a column, based on condition
  88. R multiple conditions in if statement
  89. Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer
  90. Pandas – How to flatten a hierarchical index in columns
  91. Simple manual RMarkdown tables that look good in HTML, PDF and DOCX
  92. Select rows from a data frame based on values in a vector
  93. Filter data.frame rows by a logical condition
  94. How to plot 3D scatter diagram using ggplot?
  95. Groupby value counts on the dataframe pandas
  96. How to melt and cast dataframes using dplyr?
  97. use first row data as column names in r
  98. Boolean operators && and ||
  99. Getting the IP address of the current machine using Java
  100. Got continuous is not supported error in RandomForestRegressor

Leave a Comment