From: Liu Hui <liuhui1610@gmail.com>
To: Jack Kamm <jackkamm@gmail.com>
Cc: emacs-orgmode@gnu.org, Ihor Radchenko <yantar92@posteo.net>
Subject: Re: [PATCH] ob-python results handling for dicts, dataframes, arrays, and plots
Date: Thu, 17 Aug 2023 13:35:45 +0800 [thread overview]
Message-ID: <CAOQTW-PUr9vXbNUie9DeeyanyxXKuacvUaTTB2NcfpU5G89Abw@mail.gmail.com> (raw)
In-Reply-To: <87a5ur6f7w.fsf@gmail.com>
Hi,
Thank you for the patch!
> Next, for numpy arrays and pandas dataframes/series: these are
> converted to tables, for example:
>
> #+begin_src python
> import pandas as pd
> import numpy as np
>
> return pd.DataFrame(np.array([[1,2,3],[4,5,6]]),
> columns=['a','b','c'])
> #+end_src
>
> #+RESULTS:
> | | a | b | c |
> |---+---+---+---|
> | 0 | 1 | 2 | 3 |
> | 1 | 4 | 5 | 6 |
>
> To avoid conversion, you can specify "raw", "verbatim", "scalar", or
> "output" in the ":results" header argument.
Do we need to limit the table/list size by default, or handle them
only with relevant result type (e.g. `table/list')? Dataframe/array
are often large. The following results are truncated by default
previously, which can be tweaked via np.set_printoptions and
pd.set_option.
#+begin_src python
import numpy as np
return np.random.randint(10, size=(30,40))
#+end_src
#+begin_src python
import numpy as np
return np.random.rand(20,3,4,5)
#+end_src
#+begin_src python
import pandas as pd
import numpy as np
d = {'col1': np.random.rand(100), 'col2': np.random.rand(100)}
return pd.DataFrame(d)
#+end_src
> +def __org_babel_python_format_value(result, result_file, result_params):
> + with open(result_file, 'w') as f:
> + if 'graphics' in result_params:
> + result.savefig(result_file)
> + elif 'pp' in result_params:
> + import pprint
> + f.write(pprint.pformat(result))
> + else:
> + if not set(result_params).intersection(\
> +['scalar', 'verbatim', 'raw']):
> + try:
> + import pandas
> + except ImportError:
> + pass
> + else:
> + if isinstance(result, pandas.DataFrame):
> + result = [[''] + list(result.columns), None] + \
Here we can use '{}'.format(df.index.name) to show the name of index
> (defun org-babel-python-format-session-value
> (src-file result-file result-params)
> "Return Python code to evaluate SRC-FILE and write result to RESULT-FILE."
> - (format "\
> + (concat org-babel-python--def-format-value
> + (format "
Maybe `org-babel-python--def-format-value' can be evaluated only once
in the session mode? It would shorten the string sent to the python
shell, where temp files are used for long strings.
next prev parent reply other threads:[~2023-08-17 9:29 UTC|newest]
Thread overview: 26+ messages / expand[flat|nested] mbox.gz Atom feed top
2023-08-15 23:46 [PATCH] ob-python results handling for dicts, dataframes, arrays, and plots Jack Kamm
2023-08-16 9:32 ` Ihor Radchenko
2023-08-17 4:04 ` Jack Kamm
2023-08-17 9:14 ` gerard.vermeulen
2023-08-17 12:10 ` Ihor Radchenko
2023-08-18 4:37 ` gerard.vermeulen
2023-08-18 6:01 ` gerard.vermeulen
2023-08-18 23:30 ` Jack Kamm
2023-08-19 8:50 ` Ihor Radchenko
2023-08-20 18:01 ` Jack Kamm
2023-08-20 18:21 ` Ihor Radchenko
2023-08-19 8:58 ` Ihor Radchenko
2023-08-20 18:13 ` Jack Kamm
2023-08-20 18:25 ` Ihor Radchenko
2023-08-22 23:37 ` Jack Kamm
2023-08-17 12:07 ` Ihor Radchenko
2023-08-18 22:49 ` Jack Kamm
2023-08-17 5:35 ` Liu Hui [this message]
2023-08-18 23:09 ` Jack Kamm
2023-08-20 12:13 ` Liu Hui
2023-08-20 18:31 ` Jack Kamm
2023-08-21 6:21 ` Liu Hui
2023-08-22 23:44 ` Jack Kamm
2023-08-17 11:57 ` Ihor Radchenko
2023-08-18 23:18 ` Jack Kamm
2023-08-19 8:54 ` Ihor Radchenko
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=CAOQTW-PUr9vXbNUie9DeeyanyxXKuacvUaTTB2NcfpU5G89Abw@mail.gmail.com \
--to=liuhui1610@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=jackkamm@gmail.com \
--cc=yantar92@posteo.net \
/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).