The following is one way to parse your file using R (using R-3.1.2 on
Windows
in a US English locale). I downloaded it from Google Docs in tab-separated
format.
I could not get read.table() to do the job, but I don't completely
understand
the encoding/fileEncoding business there.
> file <- "examp
Message-
From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of Dr Polanski
Sent: 21 January 2015 10:32 PM
To: r-help@r-project.org
Subject: [R] need help with excel data
Hi all!
Sorry to bother you, I am trying to learn some R via coursera courses and other
internet sources yet haven
It is good to know R is up to the task and I have to agree with Ista and
Jeff that if you are more comfortable in R use it. By way of comparison
the python code would look something like what is below. You would need to
tweak the regular rexpression (re.match(...) to fit your needs but if you
are
I agree, R will be fine for this. Not being as expert with regex as
Jeff I would tend to do this in a few steps, something like
library(XLConnect)
DF <- readWorksheetFromFile( "exampX.xlsx", sheet="examp" )
library(stringi)
## insert a marker between the text and the numbers
txt <- stri_replace_al
I think R is quite capable of doing this. You would have to learn a
comparable number of fiddly bits to accomplish this in R, Python or Perl.
That is not to say that learning Perl or Python is a bad idea... but in
terms of "shortest path" I think they are of comparable complexity. All
three la
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 colum
Dr. Polanski, I would recommend something else. Given the messy nature of
your data I would suggest using a language like Python or Perl to extract
it to an appropriate format. Python has good regular expression support
and unicode support. If you can save your data as a csv file or even text
li
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)
8 matches
Mail list logo
