DataFrame.Join Method

Definition

Namespace: Extreme.DataAnalysis
Assembly: Extreme.Numerics (in Extreme.Numerics.dll) Version: 8.1.23

Overload List

Join<R>(DataFrame<R, String>, DataFrame<R, String>, JoinType, String, String)	Returns a new data frame by joining this data frame with another data frame on the data frames' indexes.
Join<R, C>(DataFrame<R, C>, JoinType, DataFrame<R, C>, Func<C, C>, Func<C, C>)	Returns a new data frame by joining two data frames on their row indexes.
Join<R1, R2>(DataFrame<R1, String>, JoinType, DataFrame<R2, String>, IList<String>, String, String)	Returns a new data frame by joining this data frame with another data frame on the data frame's indexes.
Join<R1, R2>(DataFrame<R1, String>, JoinType, DataFrame<R2, String>, String, String, String)	Returns a new data frame by joining this data frame with another data frame on the data frame's row index.
Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, C, Func<C, C>, Func<C, C>)	Returns a new data frame by joining a data frame to another on the specified columns of the left data frame and the row index of the right data frame.
Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, Boolean, C, C)	Returns a new data frame by joining two data frames on the specified columns in each data frame.
Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, IList<C>, Func<C, C>, Func<C, C>)	Returns a new data frame by joining a data frame to another on the specified columns of the left data frame and the row index of the right data frame.

DataFrame.Join<R>(DataFrame<R, String>, DataFrame<R, String>, JoinType, String, String)

Returns a new data frame by joining this data frame with another data frame on the data frames' indexes.

public static DataFrame<R, string> Join<R>(
	this DataFrame<R, string> left,
	DataFrame<R, string> right,
	JoinType joinType,
	string leftSuffix = "_x",
	string rightSuffix = "_y"
)

Visual Basic

<ExtensionAttribute>
Public Shared Function Join(Of R) ( 
	left As DataFrame(Of R, String),
	right As DataFrame(Of R, String),
	joinType As JoinType,
	Optional leftSuffix As String = "_x",
	Optional rightSuffix As String = "_y"
) As DataFrame(Of R, String)

C++/CLI

public:
[ExtensionAttribute]
generic<typename R>
static DataFrame<R, String^>^ Join(
	DataFrame<R, String^>^ left, 
	DataFrame<R, String^>^ right, 
	JoinType joinType, 
	String^ leftSuffix = L"_x", 
	String^ rightSuffix = L"_y"
)

[<ExtensionAttribute>]
static member Join : 
        left : DataFrame<'R, string> * 
        right : DataFrame<'R, string> * 
        joinType : JoinType * 
        ?leftSuffix : string * 
        ?rightSuffix : string 
(* Defaults:
        let _leftSuffix = defaultArg leftSuffix "_x"
        let _rightSuffix = defaultArg rightSuffix "_y"
*)
-> DataFrame<'R, string>

Parameters

left DataFrame<R, String>: The data frame that serves as the left operand of the join operation.
right DataFrame<R, String>: The data frame that serves as the right operand of the join operation.
joinType JoinType: The type of join operation to perform on the indexes.
leftSuffix String (Optional): The suffix to add to the key of a column in the left frame to make it unique.
rightSuffix String (Optional): The suffix to add to the key of a column in the right frame to make it unique.

Type Parameters

R: The element type of the row index of the data frames.

Return Value

DataFrame<R, String>
The joined data frame.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type DataFrame<R, String>. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).

DataFrame.Join<R, C>(DataFrame<R, C>, JoinType, DataFrame<R, C>, Func<C, C>, Func<C, C>)

Returns a new data frame by joining two data frames on their row indexes.

public static DataFrame<R, C> Join<R, C>(
	this DataFrame<R, C> left,
	JoinType joinType,
	DataFrame<R, C> right,
	Func<C, C> thisKeyModifier = null,
	Func<C, C> rightKeyModifier = null
)

Visual Basic

<ExtensionAttribute>
Public Shared Function Join(Of R, C) ( 
	left As DataFrame(Of R, C),
	joinType As JoinType,
	right As DataFrame(Of R, C),
	Optional thisKeyModifier As Func(Of C, C) = Nothing,
	Optional rightKeyModifier As Func(Of C, C) = Nothing
) As DataFrame(Of R, C)

C++/CLI

public:
[ExtensionAttribute]
generic<typename R, typename C>
static DataFrame<R, C>^ Join(
	DataFrame<R, C>^ left, 
	JoinType joinType, 
	DataFrame<R, C>^ right, 
	Func<C, C>^ thisKeyModifier = nullptr, 
	Func<C, C>^ rightKeyModifier = nullptr
)

[<ExtensionAttribute>]
static member Join : 
        left : DataFrame<'R, 'C> * 
        joinType : JoinType * 
        right : DataFrame<'R, 'C> * 
        ?thisKeyModifier : Func<'C, 'C> * 
        ?rightKeyModifier : Func<'C, 'C> 
(* Defaults:
        let _thisKeyModifier = defaultArg thisKeyModifier null
        let _rightKeyModifier = defaultArg rightKeyModifier null
*)
-> DataFrame<'R, 'C>

Parameters

left DataFrame<R, C>: The data frame that serves as the left operand of the join operation.
joinType JoinType: The type of join operation to perform on the indexes.
right DataFrame<R, C>: The data frame that serves as the right operand of the join operation.
thisKeyModifier Func<C, C> (Optional): A function that modifies a column key of this data frame to make it unique.
rightKeyModifier Func<C, C> (Optional): A function that modifies a column key of the right data frame to make it unique.

Type Parameters

R: The element type of the row index of the data frames.
C: The element type of the column index of the data frames.

Return Value

DataFrame<R, C>
The joined data frame.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type DataFrame<R, C>. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).

Exceptions

ArgumentNullException

right is null.

DataFrame.Join<R1, R2>(DataFrame<R1, String>, JoinType, DataFrame<R2, String>, IList<String>, String, String)

Returns a new data frame by joining this data frame with another data frame on the data frame's indexes.

public static DataFrame<R1, string> Join<R1, R2>(
	this DataFrame<R1, string> left,
	JoinType joinType,
	DataFrame<R2, string> right,
	IList<string> keys,
	string leftSuffix = "_x",
	string rightSuffix = "_y"
)

Visual Basic

<ExtensionAttribute>
Public Shared Function Join(Of R1, R2) ( 
	left As DataFrame(Of R1, String),
	joinType As JoinType,
	right As DataFrame(Of R2, String),
	keys As IList(Of String),
	Optional leftSuffix As String = "_x",
	Optional rightSuffix As String = "_y"
) As DataFrame(Of R1, String)

C++/CLI

public:
[ExtensionAttribute]
generic<typename R1, typename R2>
static DataFrame<R1, String^>^ Join(
	DataFrame<R1, String^>^ left, 
	JoinType joinType, 
	DataFrame<R2, String^>^ right, 
	IList<String^>^ keys, 
	String^ leftSuffix = L"_x", 
	String^ rightSuffix = L"_y"
)

[<ExtensionAttribute>]
static member Join : 
        left : DataFrame<'R1, string> * 
        joinType : JoinType * 
        right : DataFrame<'R2, string> * 
        keys : IList<string> * 
        ?leftSuffix : string * 
        ?rightSuffix : string 
(* Defaults:
        let _leftSuffix = defaultArg leftSuffix "_x"
        let _rightSuffix = defaultArg rightSuffix "_y"
*)
-> DataFrame<'R1, string>

Parameters

left DataFrame<R1, String>: The data frame that serves as the left operand of the join operation.
joinType JoinType: The type of join operation to perform on the indexes.
right DataFrame<R2, String>: The data frame that serves as the right operand of the join operation.
keys IList<String>: The keys of the columns in the left data frame that are used in the joins.
leftSuffix String (Optional): The suffix to add to the key of a column in the left frame to make it unique.
rightSuffix String (Optional): The suffix to add to the key of a column in the right frame to make it unique.

Type Parameters

R1: The element type of the row index of the left data frame.
R2: The element type of the row index of the right data frame.

Return Value

DataFrame<R1, String>
The joined data frame.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type DataFrame<R1, String>. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).

DataFrame.Join<R1, R2>(DataFrame<R1, String>, JoinType, DataFrame<R2, String>, String, String, String)

Returns a new data frame by joining this data frame with another data frame on the data frame's row index.

public static DataFrame<R1, string> Join<R1, R2>(
	this DataFrame<R1, string> left,
	JoinType joinType,
	DataFrame<R2, string> right,
	string key,
	string leftSuffix = "_x",
	string rightSuffix = "_y"
)

Visual Basic

<ExtensionAttribute>
Public Shared Function Join(Of R1, R2) ( 
	left As DataFrame(Of R1, String),
	joinType As JoinType,
	right As DataFrame(Of R2, String),
	key As String,
	Optional leftSuffix As String = "_x",
	Optional rightSuffix As String = "_y"
) As DataFrame(Of R1, String)

C++/CLI

public:
[ExtensionAttribute]
generic<typename R1, typename R2>
static DataFrame<R1, String^>^ Join(
	DataFrame<R1, String^>^ left, 
	JoinType joinType, 
	DataFrame<R2, String^>^ right, 
	String^ key, 
	String^ leftSuffix = L"_x", 
	String^ rightSuffix = L"_y"
)

[<ExtensionAttribute>]
static member Join : 
        left : DataFrame<'R1, string> * 
        joinType : JoinType * 
        right : DataFrame<'R2, string> * 
        key : string * 
        ?leftSuffix : string * 
        ?rightSuffix : string 
(* Defaults:
        let _leftSuffix = defaultArg leftSuffix "_x"
        let _rightSuffix = defaultArg rightSuffix "_y"
*)
-> DataFrame<'R1, string>

Parameters

left DataFrame<R1, String>: The data frame that serves as the left operand of the join operation.
joinType JoinType: The type of join operation to perform on the indexes.
right DataFrame<R2, String>: The data frame that serves as the right operand of the join operation.
key String: The key of the column in the left data frame that is used in the joins.
leftSuffix String (Optional): The suffix to add to the key of a column in the left frame to make it unique.
rightSuffix String (Optional): The suffix to add to the key of a column in the right frame to make it unique.

Type Parameters

R1: The element type of the row index of the left data frame.
R2: The element type of the row index of the right data frame.

Return Value

DataFrame<R1, String>
The joined data frame.

Usage Note

DataFrame.Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, C, Func<C, C>, Func<C, C>)

Returns a new data frame by joining a data frame to another on the specified columns of the left data frame and the row index of the right data frame.

public static DataFrame<R1, C> Join<R1, R2, C>(
	this DataFrame<R1, C> left,
	JoinType joinType,
	DataFrame<R2, C> right,
	C key,
	Func<C, C> thisKeyModifier = null,
	Func<C, C> rightKeyModifier = null
)

Visual Basic

<ExtensionAttribute>
Public Shared Function Join(Of R1, R2, C) ( 
	left As DataFrame(Of R1, C),
	joinType As JoinType,
	right As DataFrame(Of R2, C),
	key As C,
	Optional thisKeyModifier As Func(Of C, C) = Nothing,
	Optional rightKeyModifier As Func(Of C, C) = Nothing
) As DataFrame(Of R1, C)

C++/CLI

public:
[ExtensionAttribute]
generic<typename R1, typename R2, typename C>
static DataFrame<R1, C>^ Join(
	DataFrame<R1, C>^ left, 
	JoinType joinType, 
	DataFrame<R2, C>^ right, 
	C key, 
	Func<C, C>^ thisKeyModifier = nullptr, 
	Func<C, C>^ rightKeyModifier = nullptr
)

[<ExtensionAttribute>]
static member Join : 
        left : DataFrame<'R1, 'C> * 
        joinType : JoinType * 
        right : DataFrame<'R2, 'C> * 
        key : 'C * 
        ?thisKeyModifier : Func<'C, 'C> * 
        ?rightKeyModifier : Func<'C, 'C> 
(* Defaults:
        let _thisKeyModifier = defaultArg thisKeyModifier null
        let _rightKeyModifier = defaultArg rightKeyModifier null
*)
-> DataFrame<'R1, 'C>

Parameters

left DataFrame<R1, C>: The data frame that serves as the left operand of the join operation.
joinType JoinType: The type of join operation to perform on the indexes.
right DataFrame<R2, C>: The data frame that serves as the right operand of the join operation.
key C: The key of the column in the left data frame that is used in the joins.
thisKeyModifier Func<C, C> (Optional): A function that modifies a column key of this data frame to make it unique.
rightKeyModifier Func<C, C> (Optional): A function that modifies a column key of the right data frame to make it unique.

Type Parameters

R1: The element type of the row index of the left data frame.
R2: The element type of the row index of the right data frame.
C: The element type of the column index of the data frames.

Return Value

DataFrame<R1, C>
The joined data frame.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type DataFrame<R1, C>. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).

Exceptions

ArgumentNullException

right is null.

DataFrame.Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, Boolean, C, C)

Returns a new data frame by joining two data frames on the specified columns in each data frame.

public static DataFrame<long, C> Join<R1, R2, C>(
	this DataFrame<R1, C> left,
	JoinType joinType,
	DataFrame<R2, C> right,
	bool sort,
	C leftColumnKey,
	C rightColumnKey
)

Visual Basic

<ExtensionAttribute>
Public Shared Function Join(Of R1, R2, C) ( 
	left As DataFrame(Of R1, C),
	joinType As JoinType,
	right As DataFrame(Of R2, C),
	sort As Boolean,
	leftColumnKey As C,
	rightColumnKey As C
) As DataFrame(Of Long, C)

C++/CLI

public:
[ExtensionAttribute]
generic<typename R1, typename R2, typename C>
static DataFrame<long long, C>^ Join(
	DataFrame<R1, C>^ left, 
	JoinType joinType, 
	DataFrame<R2, C>^ right, 
	bool sort, 
	C leftColumnKey, 
	C rightColumnKey
)

[<ExtensionAttribute>]
static member Join : 
        left : DataFrame<'R1, 'C> * 
        joinType : JoinType * 
        right : DataFrame<'R2, 'C> * 
        sort : bool * 
        leftColumnKey : 'C * 
        rightColumnKey : 'C -> DataFrame<int64, 'C>

Parameters

left DataFrame<R1, C>: The data frame that serves as the left operand of the join operation.
joinType JoinType: The type of join operation to perform.
right DataFrame<R2, C>: The data frame that serves as the right operand of the join operation.
sort Boolean: If true, sort the resulting data frame on the join column(s).
leftColumnKey C: The key of the join column in the left data frame..
rightColumnKey C: The key of the join column in the right data frame..

Type Parameters

R1: The element type of the row index of the left data frame.
R2: The element type of the row index of the right data frame.
C: The element type of the column index of the data frames.

Return Value

DataFrame<Int64, C>
The joined data frame.

Usage Note

Exceptions

ArgumentNullException

right is null.

KeyNotFoundException

This data frame does not contain a column with key leftColumnKey.

-or-

right does not contain a column with key rightColumnKey.

DataFrame.Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, IList<C>, Func<C, C>, Func<C, C>)

Returns a new data frame by joining a data frame to another on the specified columns of the left data frame and the row index of the right data frame.

public static DataFrame<R1, C> Join<R1, R2, C>(
	this DataFrame<R1, C> left,
	JoinType joinType,
	DataFrame<R2, C> right,
	IList<C> keys,
	Func<C, C> thisKeyModifier = null,
	Func<C, C> rightKeyModifier = null
)

Visual Basic

<ExtensionAttribute>
Public Shared Function Join(Of R1, R2, C) ( 
	left As DataFrame(Of R1, C),
	joinType As JoinType,
	right As DataFrame(Of R2, C),
	keys As IList(Of C),
	Optional thisKeyModifier As Func(Of C, C) = Nothing,
	Optional rightKeyModifier As Func(Of C, C) = Nothing
) As DataFrame(Of R1, C)

C++/CLI

public:
[ExtensionAttribute]
generic<typename R1, typename R2, typename C>
static DataFrame<R1, C>^ Join(
	DataFrame<R1, C>^ left, 
	JoinType joinType, 
	DataFrame<R2, C>^ right, 
	IList<C>^ keys, 
	Func<C, C>^ thisKeyModifier = nullptr, 
	Func<C, C>^ rightKeyModifier = nullptr
)

[<ExtensionAttribute>]
static member Join : 
        left : DataFrame<'R1, 'C> * 
        joinType : JoinType * 
        right : DataFrame<'R2, 'C> * 
        keys : IList<'C> * 
        ?thisKeyModifier : Func<'C, 'C> * 
        ?rightKeyModifier : Func<'C, 'C> 
(* Defaults:
        let _thisKeyModifier = defaultArg thisKeyModifier null
        let _rightKeyModifier = defaultArg rightKeyModifier null
*)
-> DataFrame<'R1, 'C>

Parameters

left DataFrame<R1, C>: The data frame that serves as the left operand of the join operation.
joinType JoinType: The type of join operation to perform on the indexes.
right DataFrame<R2, C>: The data frame that serves as the right operand of the join operation.
keys IList<C>: The keys of the columns in the left data frame that are used in the joins.
thisKeyModifier Func<C, C> (Optional): A function that modifies a column key of this data frame to make it unique.
rightKeyModifier Func<C, C> (Optional): A function that modifies a column key of the other data frame to make it unique.

Type Parameters

R1: The element type of the row index of the left data frame.
R2: The element type of the row index of the right data frame.
C: The element type of the column index of the data frames.

Return Value

DataFrame<R1, C>
The joined data frame.

Usage Note

Exceptions

ArgumentNullException

right is null.

-or-

keys is null.

DataFrame.Join Method

Definition

Overload List

DataFrame.Join<R>(DataFrame<R, String>, DataFrame<R, String>, JoinType, String, String)

Parameters

Type Parameters

Return Value

Usage Note

DataFrame.Join<R, C>(DataFrame<R, C>, JoinType, DataFrame<R, C>, Func<C, C>, Func<C, C>)

Parameters

Type Parameters

Return Value

Usage Note

Exceptions

DataFrame.Join<R1, R2>(DataFrame<R1, String>, JoinType, DataFrame<R2, String>, IList<String>, String, String)

Parameters

Type Parameters

Return Value

Usage Note

DataFrame.Join<R1, R2>(DataFrame<R1, String>, JoinType, DataFrame<R2, String>, String, String, String)

Parameters

Type Parameters

Return Value

Usage Note

DataFrame.Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, C, Func<C, C>, Func<C, C>)

Parameters

Type Parameters

Return Value

Usage Note

Exceptions

DataFrame.Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, Boolean, C, C)

Parameters

Type Parameters

Return Value

Usage Note

Exceptions

DataFrame.Join<R1, R2, C>(DataFrame<R1, C>, JoinType, DataFrame<R2, C>, IList<C>, Func<C, C>, Func<C, C>)

Parameters

Type Parameters

Return Value

Usage Note

Exceptions

See Also

Reference