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
|
.. currentmodule:: Orange.data.pandas_compat
###########################################
Pandas interoperability (``pandas_compat``)
###########################################
:obj:`Orange.data.pandas_compat` module provides functions to convert between :class:`pandas.DataFrame` and :class:`Orange.data.Table`. These functions enable integration of Orange's data structures with the pandas library, enabling users to shift between the frameworks.
.. method::`table_from_frame`
.. autofunction:: table_from_frame
.. method::`table_to_frame`
.. autofunction:: table_to_frame
Example
=======
>>> import pandas as pd
>>> from Orange.data import Table
>>> from Orange.data.pandas_compat import table_from_frame, table_to_frame
>>> df = pd.DataFrame({'A': [1, 2, 3], 'B': [4.0, 5.0, 6.0], 'C': ['a', 'b', 'c']})
>>> df
A B C
0 1 4.0 a
1 2 5.0 b
2 3 6.0 c
>>> table = table_from_frame(df)
>>> table
[[1, 4] {a},
[2, 5] {b},
[3, 6] {c}
]
Note that the non-numeric column 'C' becomes a meta attribute in the resulting table. To set it to a categorical variable, use ``force_nominal=True``:
>>> table = table_from_frame(df, force_nominal=True)
[[1, 4, a],
[2, 5, b],
[3, 6, c]
]
To convert back to a pandas DataFrame, use :func:`table_to_frame`:
>>> frame = table_to_frame(table)
>>> frame
A B
0 1 4.0
1 2 5.0
2 3 6.0
|
