search

amphi-ai / amphi-etl

Python-based Low-code ETL for data manipulation and transformation. Generates Python code you can deploy anywhere.
https://amphi.ai
Other
805 stars 35 forks source link

A tool to browse dataframe #85

Open simonaubertbd opened 1 month ago

simonaubertbd commented 1 month ago

Hello,

As ot today, you can have a look at your datafram with the console (with a sample of data but you don't know how)

image

or the console tool (note that it's not in "table" formatted)

image

We could imagine something very used on Alteryx : the "browse tool" that allow you to set the sample size (just like the console too) but when clicking on it after execution, it displays the dataframe (at the same place than the console). you can even imagine an option of the pipeline to not display dataframe on the console,which save space.

Example : execution console image

Result of the browse tool. Note it's interactive image

Best regards,

Simon

tgourdel commented 1 month ago

Hi Simon, thanks, had in mind something around what you suggest. Wondering, does the transformation available on columns (Data Cleanse, Filter, Sort) are actually modifying the data down the pipeline or is this just to browse the data?

simonaubertbd commented 1 month ago

@tgourdel No, it's just to browse the data. Like if you have a mini-excel on the ui. Also, there's nothing after that tool, it's a dead end. We usually put it every time we have to check (so several tools).

image