Used for spreadsheet and SQL like operations, like grouping or joining data.
In order to ensure data type consistency, you have the option whether to infer data types (off by default).
Infer data types option in all relevant actions
If this option is turned on, the Helper will try to automatically infer the data type of each column. This might cause unexpected results when working with zip codes and other numbers that can start with 0.
Otherwise, the data types will be left as provided by the source.
Group a spreadsheet or CSV file and apply different aggregates and properties.
The available aggregation functions are:
Join multiple spreadsheets or tables with a common column (VLookup) - Pandas Docs for further details.
This comes in handy if you want to map different tables based on common column data.
Special cases not covered by SQLite: