In Einblick, you can join multiple dataframes together to create a new dataframe. As shown in the following screenshot, you can drag two input dataframes that you would like to join, and specify the details of the join operations through the left menus. These details include:
- Join keys: currently we only support equi-join, that is, the values match exactly. You can also specify multiple join keys, e.g. both
left.age == right.age_valueand
left.name == right.full_name.
- Join type: we support *INNER, LEFT OUTER, RIGHT OUTER and FULL OUTER joins. Here are more details about their definitions.
- Join prefixes: to address naming collisions, you can control whether to attach prefixes to the output dataframe's columns, and what those prefixes would be.