Merging Dataframes
This documentation will teach you how to merge dataframes together.
Mito's merge functionality can be used to combine datasets together horizontally. Merge looks for matches between the key column of the first sheet and the key column of the second sheet.
Looking to combine datasets vertically by stacking rows on top of each other? You're looking to concatenate. Check out concatenate documentation here.
Open the Merge Taskpane by clicking
Dataframe > Merge Dataframes. Then, configure the merge taskpane:- 1.Select the Merge Type:
- 1.Left Merge: Includes all rows from the first sheet and only matching rows from the second sheet. Includes all matches.
- 2.Right Merge: Includes all rows from the second sheet and only matching rows from the first sheet. Includes all matches.
- 3.Inner Merge: Only includes rows that have matches in both sheets.
- 4.Outer Merge: Includes all rows from both sheets, regardless of if there is a match in the other sheet.
- 5.Lookup Merge: Left join, but only includes the first match from the second sheet if there are multiple. Just like a Vlookup in Excel.
- 6.Unique in Left: Includes each row from the first sheet that doesn't have a match in the second sheet.
- 7.Unique in Right: Includes each row from second sheet that doesn't have a match in the first sheet.
- 2.Set the merge keys. These are the keys that must match for the rows to be merged. You can create as many merge keys as you want.
- 3.Then, optionally choose which columns from each dataset you want to keep in the final merge dataframe.
Last modified 1yr ago