27.13 PgxFrames Tabular Data-Structure
PgxFrame
is a data-structure to load, store and manipulate tabular data. It contains rows and columns. A PgxFrame
can contain multiple columns where each column consist of elements of the same data type, and has a name. The list of the columns with their names and data types defines the schema of the frame. (The number of rows in the PgxFrame
is not part of the schema of the frame.)
PgxFrame
provides some operations that also output PgxFrames
(described later in the tutorial). Those operations can be performed in-place (meaning that the frame is mutated during the operation) in order to save memory. In place operations should be used whenever possible. However, we provide out-place variants, i.e., a new frame is created during the operation.
The following table lists all the in-place operations along with the respective out-place operations:
Table 27-7 Mapping between In-Place and Out-Place Operations
In-place operations | Out-place operations |
---|---|
headInPlace |
head |
tailInPlace |
tail |
flattenAllInPlace |
flattenAll |
renameColumnInPlace |
renameColumn |
renameColumnsInPlace |
renameColumns |
selectInPlace |
select |
- Converting PgqlResultSet to a PgxFrame
- Storing a PgxFrame to a Database
- Storing a PgxFrame to a CSV File
- Union of PGX Frames
- Joining PGX Frames
- Printing the Content of a PgxFrame
- Destroying a PgxFrame
- Loading and Storing Vector Properties
- Flattening Vector Properties
- PgxFrame Helpers
- Converting a PgxFrame to PgqlResultSet
- PgxFrame to Pandas DataFrame Conversions
- Loading a PgxFrame from a Database
- Loading a PgxFrame from a CSV File
- Loading a PgxFrame from Client-Side Data
- Creating a Graph from Multiple PgxFrame Objects
Parent topic: PGX Programming Guides