[R] need help with excel data
mccormack at molbio.mgh.harvard.edu
Wed Jan 21 23:45:06 CET 2015
Try asap utilities (Home and Student edition),
http://www.asap-utilities.com/index.php. When installed it will look
like this in Excel,
Select Columns & Rows and then #18.
If that is not helpful, then DigDB, http://www.digdb.com/, but this one
requires a subscription. It will also split columns.
You may have to do some 'cleaning' of individual cells, such as removing
leading and/or trainling spaces. A lot of this can be one with the ASAP
Utilities 'Text' pull down menu.
On 1/21/2015 3:31 PM, Dr Polanski wrote:
> 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)
> 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!
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help