Prepare with App
Process, clean and prepare your data without any coding. When clicking is not enough, use 200+ Excel compatible formulas. Add custom Python code using the built-in editor for more complex requirements. Export the final clean data to a file, data lake or database directly from the app. To build repeatable data pipelines, export to pure Python code and run anywhere you need.
This section of the documentation is work in progress..
You can sort the columns you want in ascending or descending order.
You can filter any column using logical operators.
You can change the name of the column you choose.
You can run and test more than one formula on the column you want.
When you want to add the formula, the new column on the worksheet will be ready.
In this section, you can run the code yourself and test the code you wrote on the worksheet. When you apply the code, the change on the worksheet is saved.
In addition, you can easily perform Show/Hide, Move Left , Move Right, Delete , Split, Convert, Missing, Group By, Categorical, One Hot and Join operations on data and columns.