On Wed, 13 Oct 2010, Schwab,Wilhelm K wrote:
It will get a good look, as will gnumeric - thanks to all!
emacs org-mode can convert your tab delimited file to a 'table' that you
can edit either using org-mode functions OR as plain text by switching to
fundamental mode.
In emacs speak, just put the cursor at the top of a buffer holding your
file and do
M-x replace-string RET TAB RET | RET
I think, then move your cursor to a line that has a '|' in it and hit TAB,
and you have a neatly formatted table.
See,
http://orgmode.org/worg/org-tutorials/tables.php
for an intro.
A big advantage in using an org-mode table is you can place an R source
code block further down in the same file, and it can read in the data in
the table. Then you can go back to the table to edit, then rerun R, ...
I append an example below.
There is a load of tutorial info at
http://orgmode.org/worg/org-tutorials/index.php
HTH,
Chuck
#+begin_example
#+tblname: simpleDF
| a | b | c |
|---+---+---|
| 1 | 2 | 3 |
| 5 | 4 | 2 |
|---+---+---|
#+end_example
#+begin_src R :var df=simpleDF :results output :colnames yes
summary( df )
#+end_src
#+results:
: a b c
: Min. :1 Min. :2.0 Min. :2.00
: 1st Qu.:2 1st Qu.:2.5 1st Qu.:2.25
: Median :3 Median :3.0 Median :2.50
: Mean :3 Mean :3.0 Mean :2.50
: 3rd Qu.:4 3rd Qu.:3.5 3rd Qu.:2.75
: Max. :5 Max. :4.0 Max. :3.00
Bill
________________________________________
From: Albyn Jones [jo...@reed.edu]
Sent: Wednesday, October 13, 2010 2:14 PM
To: Schwab,Wilhelm K
Subject: Re: [R] [OT] (slightly) - OpenOffice Calc and text files
emacs shows you exactly what is there, nothing more nor less.
it isn't a spreadsheet, but tabs will align columns.
albyn
On Wed, Oct 13, 2010 at 01:53:46PM -0400, Schwab,Wilhelm K wrote:
Albyn,
I'll look into it. In fact, I have a small book on it that I bought in my very
early days of using Linux. I quickly found TeX Maker (for the obvious),
Code::Blocks for C/C++ and I would not have started the move without a working
Smalltalk (http://pharo-project.org/home).
For editing data files, I really just want something that shows data in an
understandable grid and does not do weird stuff thinking it's being helpful.
Bill
________________________________________
From: Albyn Jones [jo...@reed.edu]
Sent: Wednesday, October 13, 2010 1:39 PM
To: Schwab,Wilhelm K
Cc: r-help@r-project.org
Subject: Re: [R] [OT] (slightly) - OpenOffice Calc and text files
How about emacs?
albyn
On Wed, Oct 13, 2010 at 01:13:03PM -0400, Schwab,Wilhelm K wrote:
Hello all,
<.....>
Have any of you found a nice (or at least predictable) way to use OO Calc to
edit files like this? If it insists on thinking for me, I wish it would think
in 24 hour time and 4 digit years :) I work on Linux, so Excel is off the
table, but another spreadsheet or text editor would be a viable option, as
would configuration changes to Calc.
Bill
______________________________________________
R-help@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.
--
Albyn Jones
Reed College
jo...@reed.edu
--
Albyn Jones
Reed College
jo...@reed.edu
______________________________________________
R-help@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.
Charles C. Berry (858) 534-2098
Dept of Family/Preventive Medicine
E mailto:cbe...@tajo.ucsd.edu UC San Diego
http://famprevmed.ucsd.edu/faculty/cberry/ La Jolla, San Diego 92093-0901
______________________________________________
R-help@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.
