Combining Dataframes
Join datasets together by selecting keys, concatenate dataframes on top of each other, or find unique values between datasets.
Last updated
Join datasets together by selecting keys, concatenate dataframes on top of each other, or find unique values between datasets.
Last updated
© Mito
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!
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):
Concat is used to stack two dataframes on top of eachother:
Dataframe difference calculates the difference between two dataframes: