Pandas DataFrame Integration¶

This functionality is in Alpha and may behave unexpectedly

Rayforce-Py provides seamless conversion from Pandas DataFrames to Rayforce-Py Tables

Installation¶

The pandas integration is available as an optional dependency. Install it with:

pip install rayforce-py[pandas]

Basic Usage¶

To convert a Pandas DataFrame to a Rayforce Table, import the from_pandas function:

>>> import pandas as pd
>>> from rayforce.plugins.pandas import from_pandas

>>> df = pd.DataFrame({
...     "id": [1, 2, 3, 4, 5],
...     "name": ["Alice", "Bob", "Charlie", "Diana", "Eve"],
...     "age": [25, 30, 35, 28, 32],
...     "salary": [50000.0, 60000.0, 70000.0, 55000.0, 65000.0],
...     "active": [True, True, False, True, False],
... })

>>> table = from_pandas(df)
>>> table
Table[Symbol('id'), Symbol('name'), Symbol('age'), Symbol('salary'), Symbol('active')]

>>> print(table)
┌─────┬─────────┬─────┬─────────┬────────┐
│ id  │  name   │ age │ salary  │ active │
│ I64 │   SYM   │ I64 │   F64   │   B8   │
├─────┼─────────┼─────┼─────────┼────────┤
│ 1   │ Alice   │ 25  │ 50000.0 │ true   │
│ 2   │ Bob     │ 30  │ 60000.0 │ true   │
│ 3   │ Charlie │ 35  │ 70000.0 │ false  │
│ 4   │ Diana   │ 28  │ 55000.0 │ true   │
│ 5   │ Eve     │ 32  │ 65000.0 │ false  │
├─────┴─────────┴─────┴─────────┴────────┤
│ 5 rows (5 shown) 5 columns (5 shown)   │
└────────────────────────────────────────┘

Type Conversion¶

The from_pandas() function automatically infers Rayforce types from Pandas dtypes:

Pandas dtype	Rayforce Type
`int8`, `int16`	`I16`
`int32`, `int`	`I32`
`int64`, `int_`	`I64`
`float32`, `float`, `float64`	`F64`
`bool`, `boolean`, `bool8`	`B8`
`object`, `string`, `str`	`Symbol`
`date` (object dtype with date objects)	`Date`
`datetime64[ns]`, `datetime64`	`Timestamp`