[R] need help with excel data

Dr Polanski n.polyanskij at gmail.com
Wed Jan 21 21:31:56 CET 2015


Hi all!

Sorry to bother you, I am trying to learn some R via coursera courses and other internet sources yet haven’t managed to go far

And now I need to do some, I hope, not too difficult things, which I think R can do, yet have no idea how to make it do so

I have a big set of data (empirical) which was obtained by my colleagues and store at not convenient  way - all of the data in two cells of an excel table
an example of the data is in the attached file (the link)

https://drive.google.com/file/d/0B64YMbf_hh5BS2tzVE9WVmV3bFU/view?usp=sharing

so the first column has a number and the second has a whole vector (I guess it is) which looks like
«some words in Cyrillic(the length varies)» and then the set of numbers «12*23 34*45» (another problem that some times it is «12*23, 34*56» 

And the number of raws is about 3000 so it is impossible to do manually 

what I need to have at the end is to have it separately in different excel cells 
- what is written in words - |  12  | 23 | 34 | 45 |

Do you think it is possible to do so using R (or something else?)

Thank you very much in advance and sorry for asking for help and so stupid question, the problem is - I am trying and yet haven’t even managed to install openSUSE onto my laptop - only Ubuntu! :)


Thank you very much!


More information about the R-help mailing list