[R] Slicing cra**y csv files

[jorgusch]

First of all, sorry for not giving all information.

Secondly, thanks a lot. This is a real help!! I did not know, that you can
use names...
This is really simple and works great!!!

If anyone is close enough to the people writing the help in R, please tell
them that they should write a tutorial for such scenarios. 
I mean, R can be as fancy and amazing statistical programm as it is, but not
getting the data in properly in first place, makes it kind of useless.

jorgusch



Patrick Connolly-4 wrote:
> 
> 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
> 	  
> ~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
> 
> ______________________________________________
> 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.
> 
> 

-- 
View this message in context: http://www.nabble.com/Slicing-cra**y-csv-files-tp24913849p24933830.html
Sent from the R help mailing list archive at Nabble.com.