From: Dov Grobgeld <dov.grobgeld@gmail.com>
To: emacs-orgmode <emacs-orgmode@gnu.org>
Subject: org-mode and python pandas
Date: Fri, 28 Jun 2013 08:26:45 +0300 [thread overview]
Message-ID: <CA++fsGHwZs32w4kxv-kCc4_Mgx2dWanQehA6V4r4_hJ_ZEh2dQ@mail.gmail.com> (raw)
Has anyone used org-mode with the python pandas package? Pandas is in
a certain way an alternative to R, but with the (for me) familiar
syntax of python. See: http://pandas.pydata.org/
Pandas is very much built to be used interactively, and it outputs its
data in space separated tabular format. E.g. in ipython:
In [1]: import pandas as pd
In [2]: import numpy as np
In [3]: pd.DataFrame(np.random.random((4,3)), columns=['A','B','C'])
Out[3]:
A B C
0 0.628365 0.424279 0.619791
1 0.799666 0.527572 0.132928
2 0.837255 0.138906 0.408233
3 0.388080 0.146212 0.575346
Unfortunately this doesn't output as nicely when used from org-mode:
#+BEGIN_SRC python
import pandas as pd
import numpy as np
return pd.DataFrame(np.random.random((4,3)), columns=list('ABC'))
#+END_SRC
#+RESULTS:
: A B C
: 0 0.827817 0.664009 0.089161
: 1 0.170031 0.729214 0.110918
: 2 0.575918 0.863924 0.757536
: 3 0.682722 0.774445 0.992041
while I would like to have:
| | A | B | C |
|---+----------+----------+----------|
| 0 | 0.827817 | 0.664009 | 0.089161 |
| 1 | 0.170031 | 0.729214 | 0.110918 |
| 2 | 0.575918 | 0.863924 | 0.757536 |
| 3 | 0.682722 | 0.774445 | 0.992041 |
The question is how to get this? Here are a few ideas:
1. Write a general filter in the org-mode elisp than uses heuristics
to recognize ascii aligned tables and change these to org-tables.
2. Add to pandas the option of globally influencing the text
formatting so that it outputs something more parsable by org-mode.
3. Create a special language "pandas" that recognize the ascii aligned
tables and saves the need to import pandas and np?
4. And the obvious approach of writing a python function that writes a
org-mode parsable table and always call it as part of the return.
Which is the preferable approach? Any other ideas?
Regards,
Dov
next reply other threads:[~2013-06-28 5:26 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2013-06-28 5:26 Dov Grobgeld [this message]
2013-06-30 23:15 ` org-mode and python pandas Eric Schulte
2013-07-01 16:34 ` Achim Gratz
2013-07-01 17:04 ` Rasmus
2013-07-03 9:15 ` Dov Grobgeld
2013-07-03 10:31 ` Rasmus
2013-07-03 14:09 ` Eric Schulte
2015-04-28 8:36 ` Dov Grobgeld
-- strict thread matches above, loose matches on Subject: below --
2015-04-29 7:12 Dror Atariah
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=CA++fsGHwZs32w4kxv-kCc4_Mgx2dWanQehA6V4r4_hJ_ZEh2dQ@mail.gmail.com \
--to=dov.grobgeld@gmail.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).