Click or drag to resize
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
C#
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