| FrameTRowKey, TColumnKeyJoin Method (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]
Namespace:
Deedle
Assembly:
Deedle (in Deedle.dll) Version: 1.2
Syntax public Frame<TRowKey, TColumnKey> Join(
Frame<TRowKey, TColumnKey> otherFrame,
JoinKind kind,
Lookup lookup
)
Parameters
- otherFrame
- Type: DeedleFrameTRowKey, TColumnKey
[Missing <param name="otherFrame"/> documentation for "M:Deedle.Frame`2.Join(Deedle.Frame{`0,`1},Deedle.JoinKind,Deedle.Lookup)"]
- kind
- Type: DeedleJoinKind
[Missing <param name="kind"/> documentation for "M:Deedle.Frame`2.Join(Deedle.Frame{`0,`1},Deedle.JoinKind,Deedle.Lookup)"]
- lookup
- Type: DeedleLookup
[Missing <param name="lookup"/> documentation for "M:Deedle.Frame`2.Join(Deedle.Frame{`0,`1},Deedle.JoinKind,Deedle.Lookup)"]
Return Value
Type:
FrameTRowKey,
TColumnKey[Missing <returns> documentation for "M:Deedle.Frame`2.Join(Deedle.Frame{`0,`1},Deedle.JoinKind,Deedle.Lookup)"]
See Also