[R] Slicing cra**y csv files

Patrick Connolly p_connolly at slingshot.co.nz
Tue Aug 11 12:38:21 CEST 2009


On Tue, 11-Aug-2009 at 01:39AM -0700, jorgusch wrote:

|> 
|> Hello,
|> 
|> For not too regular users of R, preparing the data is somehow a burden.
|> 
|> Comming from iMacro in FireFox I get a badly designed csv, which I need to
|> put into a daily R script. 
|> The data looks like that (e.g.):


How did you get from here

|> 22 Results,"35 Results","39 Results","2 Results","7 Results","23
|> Results","42 Results","36 Results","22 Results","28 Results"
|> 
|> and R does this to it:


to here?

|>              V1         V2         V3        V4        V5         V6        
|> V7
|> 1 22 Results 35 Results 39 Results 2 Results 7 Results 23 Results 42
|> Results
|>           V8         V9        V10
|> 1 36 Results 22 Results 28 Results

It's probably easy enough to do but we don't have anything repeatable to use.

If I make a csv file from the text string and call it junk.csv, I can
get a vector of numbers like this:

> as.numeric(gsub("[A-z.]", "", names(read.csv("junk.csv"))))
 [1]  22  35  39   2   7  23  42  36 221  28
> 

But there's probably more general ways if we knew more about your
position.  It's likely you could use the clipboard instead of the
junk.csv text file.

HTH



|> 
|> I just need the numbers as a vector.
|> 
|> Excel can do it with a few lines of VBA, but there must be a way to do it
|> directly in R, would make things easier.
|> 
|> Thanks a lot!
|>  jorgusch
|> -- 
|> View this message in context: http://www.nabble.com/Slicing-cra**y-csv-files-tp24913849p24913849.html
|> Sent from the R help mailing list archive at Nabble.com.
|> 
|> ______________________________________________
|> R-help at 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.

-- 
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.   
   ___    Patrick Connolly   
 {~._.~}                   Great minds discuss ideas    
 _( Y )_  	         Average minds discuss events 
(:_~*~_:)                  Small minds discuss people  
 (_)-(_)  	                      ..... Eleanor Roosevelt
	  
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.




More information about the R-help mailing list