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