1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
.. _rpy:
.. ipython:: python
:suppress:
import pandas as pd
pd.options.display.max_rows = 15
******************
rpy2 / R interface
******************
.. warning::
Up to pandas 0.19, a ``pandas.rpy`` module existed with functionality to
convert between pandas and ``rpy2`` objects. This functionality now lives in
the `rpy2 <https://rpy2.readthedocs.io/>`__ project itself.
See the `updating section <http://pandas.pydata.org/pandas-docs/version/0.19.0/r_interface.html#updating-your-code-to-use-rpy2-functions>`__
of the previous documentation for a guide to port your code from the
removed ``pandas.rpy`` to ``rpy2`` functions.
`rpy2 <http://rpy2.bitbucket.org/>`__ is an interface to R running embedded in a Python process, and also includes functionality to deal with pandas DataFrames.
Converting data frames back and forth between rpy2 and pandas should be largely
automated (no need to convert explicitly, it will be done on the fly in most
rpy2 functions).
To convert explicitly, the functions are ``pandas2ri.py2ri()`` and
``pandas2ri.ri2py()``.
See also the documentation of the `rpy2 <http://rpy2.bitbucket.org/>`__ project: https://rpy2.readthedocs.io.
In the remainder of this page, a few examples of explicit conversion is given. The pandas conversion of rpy2 needs first to be activated:
.. ipython:: python
from rpy2.robjects import r, pandas2ri
pandas2ri.activate()
Transferring R data sets into Python
------------------------------------
Once the pandas conversion is activated (``pandas2ri.activate()``), many conversions
of R to pandas objects will be done automatically. For example, to obtain the 'iris' dataset as a pandas DataFrame:
.. ipython:: python
r.data('iris')
r['iris'].head()
If the pandas conversion was not activated, the above could also be accomplished
by explicitly converting it with the ``pandas2ri.ri2py`` function
(``pandas2ri.ri2py(r['iris'])``).
Converting DataFrames into R objects
------------------------------------
The ``pandas2ri.py2ri`` function support the reverse operation to convert
DataFrames into the equivalent R object (that is, **data.frame**):
.. ipython:: python
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C':[7,8,9]},
index=["one", "two", "three"])
r_dataframe = pandas2ri.py2ri(df)
print(type(r_dataframe))
print(r_dataframe)
The DataFrame's index is stored as the ``rownames`` attribute of the
data.frame instance.
..
Calling R functions with pandas objects
High-level interface to R estimators
|
