Unfortunately, some data I need to work with was delivered in a rather messy
Excel file. I want to import into R and clean up some things so that I can do
my analysis. Pulling in a CSV from Excel is the easy part.
My current challenge is dealing with some text mixed in the values.
i.e. 118 5.7 <2.0 3.7
Since this column in Excel has a "<2.0" value, then R reads the column as a
factor with levels. Ideally, I want to convert it a normal vector of scalars
and code code the "<2.0" as 0.
Can anyone suggest an easy way to do this?
Thanks!
--
Noah Silverman
UCLA Department of Statistics
8117 Math Sciences Building
Los Angeles, CA 90095
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
