emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* How to get a column correctly formatted in Babel + R (w/ or w/o name)?
@ 2015-02-19 16:05 Sebastien Vauban
  2015-02-19 18:40 ` Charles C. Berry
  0 siblings, 1 reply; 2+ messages in thread
From: Sebastien Vauban @ 2015-02-19 16:05 UTC (permalink / raw)
  To: emacs-orgmode-mXXj517/zsQ

#+PROPERTY:  session *R*

* Source

#+name: table
| ID      | User1 | User2 |
|---------+-------+-------|
| 26/0163 | lrp   | nil   |
| 37/0001 | nil   | nil   |
| 37/0003 | nil   | nil   |

#+begin_src R :var df=table :colnames yes
df
#+end_src

#+results:
| ID      | User1 | User2 |
|---------+-------+-------|
| 26/0163 | lrp   | nil   |
| 37/0001 | nil   | nil   |
| 37/0003 | nil   | nil   |

We just checked that the table is correctly imported in R.

* First column (with name)

When I try to get the first column printed along with its name ("ID"), I have
troubles doing so...

#+begin_src R :var df=table :colnames yes
df[, 1]
#+end_src

#+results:
| x       |
|---------|
| 26/0163 |
| 37/0001 |
| 37/0003 |

#+begin_src R :var df=table :colnames yes
as.data.frame(df[, 1])
#+end_src

#+results:
| df[, 1] |
|---------|
| 26/0163 |
| 37/0001 |
| 37/0003 |

Here, maybe I'm lacking R knowledge?

* First column (without name)

Now, to get it without the column name:

#+begin_src R :var df=table :colnames no
df[, 1]
#+end_src

#+results:
| ID      |
| 26/0163 |
| 37/0001 |
| 37/0003 |

It's not much better, as I don't expect "ID" to be printed here!

Can you clear up things for me?  Bad R code?  Babel feature?

Best regards,
  Seb

-- 
Sebastien Vauban

^ permalink raw reply	[flat|nested] 2+ messages in thread

* Re: How to get a column correctly formatted in Babel + R (w/ or w/o name)?
  2015-02-19 16:05 How to get a column correctly formatted in Babel + R (w/ or w/o name)? Sebastien Vauban
@ 2015-02-19 18:40 ` Charles C. Berry
  0 siblings, 0 replies; 2+ messages in thread
From: Charles C. Berry @ 2015-02-19 18:40 UTC (permalink / raw)
  To: Sebastien Vauban; +Cc: Org-Mode mailing list

On Thu, 19 Feb 2015, Sebastien Vauban wrote:

> #+PROPERTY:  session *R*
>
> * Source
>
> #+name: table
> | ID      | User1 | User2 |
> |---------+-------+-------|
> | 26/0163 | lrp   | nil   |
> | 37/0001 | nil   | nil   |
> | 37/0003 | nil   | nil   |
>

[snip]
>
> * First column (with name)
>
> When I try to get the first column printed along with its name ("ID"), I have
> troubles doing so...
>
> #+begin_src R :var df=table :colnames yes
> df[, 1]
> #+end_src
>

Try this:

,----
| #+begin_src R :var df=table :colnames yes
| df[, 1,drop=FALSE]
| #+end_src
|
| #+RESULTS:
| | ID      |
| |---------|
| | 26/0163 |
| | 37/0001 |
| | 37/0003 |
`----

Look at

#+BEGIN_SRC R :results output
   example(`[.data.frame`)
#+END_SRC

for some help on this.


HTH,

Chuck

^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2015-02-19 18:40 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2015-02-19 16:05 How to get a column correctly formatted in Babel + R (w/ or w/o name)? Sebastien Vauban
2015-02-19 18:40 ` Charles C. Berry

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).