Locoia
Search…
Spreadsheet Helper

Group by

Group a spreadsheet or CSV file and apply different aggregates and properties like mean, median,
sum, size, count, std, var, sem, first, last, min, max

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:

Remove duplicates

Remove duplicates from a spreadsheet - Pandas Docs for further details

Remove specific labels

Remove specific labels from a spreadsheet - 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
Last modified 13d ago