Spreadsheet Helper

Used for spreadsheet and SQL like operations, like grouping or joining data.

Infer data types
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.
Actions
Group by
Group a spreadsheet or CSV file and apply different aggregates and properties.
The available aggregation functions are:
mean
sum
size
count
std
var
sem
first
last
min
max
median
Insert column
Insert a column into a spreadsheet - Pandas Docs for further details
Join
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.
Query spreadsheet
The database is purely in memory and SQLite is used. See SQLite functions here.
Special cases not covered by SQLite:
​Full outer join - can be achieved like here
Remove duplicates
Remove duplicates from a spreadsheet - Pandas Docs for further details
Remove specific labels
Remove a specified row or column - Pandas Docs for further details
Return first n rows
Return the first n rows of a spreadsheet - Pandas Docs for further details
Sort by
Sort the spreadsheet by one or more columns - Pandas Docs for further details

Dict Helper

REST Helper

Last modified 10mo ago