Combining Dataframes

Join datasets together by selecting keys, concatenate dataframes on top of each other, or find unique values between datasets.

Why combine dataframes

If you have mulitple dataframes, it can be useful to combine them into a single dataframe. This may be because they share a key, and you want to analyze the data together, or that the dataframes are each pieces of a larger dataset that were split up for performance reasons, or something else entirely. Mito has tools that make combining these dataframes together incredibly easy!

Different ways to combine data:

Looking to include use VLOOKUP like in Excel? In Mito, you can use the VLOOKUP formula just like Excel. See the formula documentation here.

Merge combines dataframes based on values in shared columns (like a VLOOKUP in Excel):

Merge (horizontal)

Concat is used to stack two dataframes on top of eachother:

Concatenate (horizontal)

Dataframe difference calculates the difference between two dataframes:

Anti-merge (unique)