DataFrame.Merge Method

Definition

Namespace:

Microsoft.Data.Analysis

Assembly:

Microsoft.Data.Analysis.dll

Package:

Microsoft.Data.Analysis v0.21.1

Overloads

Merge(DataFrame, String[], String[], String, String, JoinAlgorithm)
Merge<TKey>(DataFrame, String, String, String, String, JoinAlgorithm)	Merge DataFrames with a database style join (for backward compatibility)

Merge(DataFrame, String[], String[], String, String, JoinAlgorithm)

public Microsoft.Data.Analysis.DataFrame Merge (Microsoft.Data.Analysis.DataFrame other, string[] leftJoinColumns, string[] rightJoinColumns, string leftSuffix = "_left", string rightSuffix = "_right", Microsoft.Data.Analysis.JoinAlgorithm joinAlgorithm = Microsoft.Data.Analysis.JoinAlgorithm.Left);

member this.Merge : Microsoft.Data.Analysis.DataFrame * string[] * string[] * string * string * Microsoft.Data.Analysis.JoinAlgorithm -> Microsoft.Data.Analysis.DataFrame

Public Function Merge (other As DataFrame, leftJoinColumns As String(), rightJoinColumns As String(), Optional leftSuffix As String = "_left", Optional rightSuffix As String = "_right", Optional joinAlgorithm As JoinAlgorithm = Microsoft.Data.Analysis.JoinAlgorithm.Left) As DataFrame

Parameters

other

DataFrame

leftJoinColumns

String[]

rightJoinColumns

String[]

leftSuffix

String

rightSuffix

String

joinAlgorithm

JoinAlgorithm

Returns

DataFrame

Merge<TKey>(DataFrame, String, String, String, String, JoinAlgorithm)

Merge DataFrames with a database style join (for backward compatibility)

public Microsoft.Data.Analysis.DataFrame Merge<TKey> (Microsoft.Data.Analysis.DataFrame other, string leftJoinColumn, string rightJoinColumn, string leftSuffix = "_left", string rightSuffix = "_right", Microsoft.Data.Analysis.JoinAlgorithm joinAlgorithm = Microsoft.Data.Analysis.JoinAlgorithm.Left);

member this.Merge : Microsoft.Data.Analysis.DataFrame * string * string * string * string * Microsoft.Data.Analysis.JoinAlgorithm -> Microsoft.Data.Analysis.DataFrame

Public Function Merge(Of TKey) (other As DataFrame, leftJoinColumn As String, rightJoinColumn As String, Optional leftSuffix As String = "_left", Optional rightSuffix As String = "_right", Optional joinAlgorithm As JoinAlgorithm = Microsoft.Data.Analysis.JoinAlgorithm.Left) As DataFrame

Type Parameters

TKey

Parameters

other

DataFrame

leftJoinColumn

String

rightJoinColumn

String

leftSuffix

String

rightSuffix

String

joinAlgorithm

JoinAlgorithm

Returns

DataFrame