Displaying 1 result from an estimated 1 matches for "telltable".
Did you mean:
deletable
2012 Feb 28
6
Cleaning up messy Excel data
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