 | FrameTRowKey, TColumnKeyJoin Method |
Overload List| Name | Description | |
|---|---|---|
 | Join(FrameTRowKey, TColumnKey) |
Performs outer join on two data frames. The columns of the joined frames must not
overlap and their rows are aligned. The unavailable values are marked as missing.
## Parameters
- `otherFrame` - Other frame (right) to be joined with the current instance (left)
[category:Joining, zipping and appending]
|
| JoinV(TColumnKey, SeriesTRowKey, V) |
Performs outer join on data frame and a series. The column key for the joined
series must not occur in the current data frame. The rows are automatically aligned
and unavailable values are marked as missing.
## Parameters
- `colKey` - Column key to be used for the joined series
- `series` - Series to be joined with the current data frame
[category:Joining, zipping and appending]
|
| Join(FrameTRowKey, TColumnKey, JoinKind) |
Join two data frames. The columns of the joined frames must not overlap and their
rows are aligned and transformed according to the specified join kind.
For more alignment options on ordered frames, see overload taking `lookup`.
## Parameters
- `otherFrame` - Other frame (right) to be joined with the current instance (left)
- `kind` - Specifies the joining behavior on row indices. Use `JoinKind.Outer` and
`JoinKind.Inner` to get the union and intersection of the row keys, respectively.
Use `JoinKind.Left` and `JoinKind.Right` to use the current key of the left/right
data frame.
[category:Joining, zipping and appending]
|
| JoinV(TColumnKey, SeriesTRowKey, V, JoinKind) |
Join data frame and a series. The column key for the joined series must not occur in the
current data frame. The rows are aligned and transformed according to the specified join kind.
## Parameters
- `colKey` - Column key to be used for the joined series
- `series` - Series to be joined with the current data frame
- `kind` - Specifies the joining behavior on row indices. Use `JoinKind.Outer` and
`JoinKind.Inner` to get the union and intersection of the row keys, respectively.
Use `JoinKind.Left` and `JoinKind.Right` to use the current key of the left/right
data frame.
[category:Joining, zipping and appending]
|
| Join(FrameTRowKey, TColumnKey, JoinKind, Lookup) |
Join two data frames. The columns of the joined frames must not overlap and their
rows are aligned and transformed according to the specified join kind.
When the index of both frames is ordered, it is possible to specify `lookup`
in order to align indices from other frame to the indices of the main frame
(typically, to find the nearest key with available value for a key).
## Parameters
- `otherFrame` - Other frame (right) to be joined with the current instance (left)
- `kind` - Specifies the joining behavior on row indices. Use `JoinKind.Outer` and
`JoinKind.Inner` to get the union and intersection of the row keys, respectively.
Use `JoinKind.Left` and `JoinKind.Right` to use the current key of the left/right
data frame.
- `lookup` - When `kind` is `Left` or `Right` and the two frames have ordered row index,
this parameter can be used to specify how to find value for a key when there is no
exactly matching key or when there are missing values.
Supported values are `Lookup.Exact`, `Lookup.ExactOrSmaller` and `Lookup.ExactOrGreater`.
[category:Joining, zipping and appending]
|
| JoinV(TColumnKey, SeriesTRowKey, V, JoinKind, Lookup) |
Join data frame and a series. The column key for the joined series must not occur in the
current data frame. The rows are aligned and transformed according to the specified join kind.
When the index of both objects is ordered, it is possible to specify `lookup`
in order to align indices from other frame to the indices of the main frame
(typically, to find the nearest key with available value for a key).
## Parameters
- `colKey` - Column key to be used for the joined series
- `series` - Series to be joined with the current data frame
- `kind` - Specifies the joining behavior on row indices. Use `JoinKind.Outer` and
`JoinKind.Inner` to get the union and intersection of the row keys, respectively.
Use `JoinKind.Left` and `JoinKind.Right` to use the current key of the left/right
data frame.
- `lookup` - When `kind` is `Left` or `Right` and the two frames have ordered row index,
this parameter can be used to specify how to find value for a key when there is no
exactly matching key or when there are missing values.
Supported values are `Lookup.Exact`, `Lookup.ExactOrSmaller` and `Lookup.ExactOrGreater`.
[category:Joining, zipping and appending]
|
See Also