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