DataFrame.Append Method

public static DataFrame<R, C> Append<R, C>(
	params DataFrame<R, C>[] dataFrames
)

Public Shared Function Append(Of R, C) ( 
	ParamArray dataFrames As DataFrame(Of R, C)()
) As DataFrame(Of R, C)

public:
generic<typename R, typename C>
static DataFrame<R, C>^ Append(
	... array<DataFrame<R, C>^>^ dataFrames
)

static member Append : 
        dataFrames : DataFrame<'R, 'C>[] -> DataFrame<'R, 'C> 

Parameters

dataFrames  DataFrame<R, C>[]

A sequence of data frames.

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

The resulting data frame contains all columns from all data frames. Matching columns are merged into one. Missing values are inserted where a matching column was not found.

public static DataFrame<R, C> Append<R, C>(
	IEnumerable<DataFrame<R, C>> dataFrames,
	Index<C> newColumnIndex,
	bool verify = true
)

Public Shared Function Append(Of R, C) ( 
	dataFrames As IEnumerable(Of DataFrame(Of R, C)),
	newColumnIndex As Index(Of C),
	Optional verify As Boolean = true
) As DataFrame(Of R, C)

public:
generic<typename R, typename C>
static DataFrame<R, C>^ Append(
	IEnumerable<DataFrame<R, C>^>^ dataFrames, 
	Index<C>^ newColumnIndex, 
	bool verify = true
)

static member Append : 
        dataFrames : IEnumerable<DataFrame<'R, 'C>> * 
        newColumnIndex : Index<'C> * 
        ?verify : bool 
(* Defaults:
        let _verify = defaultArg verify true
*)
-> DataFrame<'R, 'C> 

Parameters

dataFrames  IEnumerable<DataFrame<R, C>>

A sequence of data frames.

newColumnIndex  Index<C>

An index that specifies the columns that should be retained in the combined data frame.

verify  Boolean  (Optional)

Optional. Indicates whether uniqueness of the values in the combined index should be verified. The default is true.

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

If two columns have the same column key, but different element types, both columns are retained.

public static DataFrame<R, C> Append<R, C>(
	IEnumerable<DataFrame<R, C>> dataFrames,
	JoinType columnJoinType = JoinType.Outer,
	bool verify = true
)

Public Shared Function Append(Of R, C) ( 
	dataFrames As IEnumerable(Of DataFrame(Of R, C)),
	Optional columnJoinType As JoinType = JoinType.Outer,
	Optional verify As Boolean = true
) As DataFrame(Of R, C)

public:
generic<typename R, typename C>
static DataFrame<R, C>^ Append(
	IEnumerable<DataFrame<R, C>^>^ dataFrames, 
	JoinType columnJoinType = JoinType::Outer, 
	bool verify = true
)

static member Append : 
        dataFrames : IEnumerable<DataFrame<'R, 'C>> * 
        ?columnJoinType : JoinType * 
        ?verify : bool 
(* Defaults:
        let _columnJoinType = defaultArg columnJoinType JoinType.Outer
        let _verify = defaultArg verify true
*)
-> DataFrame<'R, 'C> 

Parameters

dataFrames  IEnumerable<DataFrame<R, C>>

A sequence of data frames.

columnJoinType  JoinType  (Optional)

Specifies how columns that do not appear in all data frames should be handled.

verify  Boolean  (Optional)

Optional. Indicates whether uniqueness of the values in the combined index should be verified. The default is true.

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

Only Inner or Outer are supported for the columnJoinType argument. Left and right joins of two data frames can be obtained using an overload of this method which lets you specify the columns to be retained as an index.

If two columns have the same column key, but different element types, both columns are retained.

Reference