7. Bind
Concatenate or Merge DataFrames
Select Bind from the Data Analysis category.
Choose the Bind Type.
2-1. Concat concatenates dataframes along rows or columns.
2-2. Merge merges "two" dataframes based on a common column.
Concat
Select the dataframes to concatenate.
Choose the concatenation method
2-1. Outer: When concatenating dataframes, non-matching indices are filled with NaN.
2-2. Inner concatenates only the data with matching indices (non-matching data is removed.)
Choose the concatenation direction.
3-1. Index concatenates data along the row direction (vertical).
3-2. Column concatenates data along the column direction (horizontal).
Choose whether to sort the index. Sorting is done in ascending order based on index numbers, which may alter the data order.
Add additional options beyond those provided by Visual Python.
Specify the variable name to assign to the result.
Reset the index to assign a new default integer index.
Preview the code that will be output in Code View.
Preview the resulting dataframe in Data View.
Execute the code.
Merge
Merge two dataframes based on a standard column, creating two new columns for the values from each dataframe.
Select the two dataframes to merge.
Choose the merging method.
2-1. Inner merges based on the common values in the key column, keeping only the common values.
2-2. Outer merges based on all rows in the key column, filling with input data.
2-3. Left merges based on all rows in the key column from the left dataframe.
2-4. Left merges based on all rows in the key column from the right dataframe.
2-5. Cross outputs all combinations of data, regardless of the values in the key column.
Select the key column that will be the reference for merging; it must be common to both dataframes.
Optionally, select the key column separately for each dataframe.
Append a suffix to columns with the same name other than the common key column.
Add additional options beyond those provided by Visual Python.
Specify the variable name to assign to the result.
Reset the index to assign a new default integer index.
Preview the code that will be output in Code View.
Preview the resulting dataframe in Data View.
Execute the code.
Last updated
