Introduction Actions task Base env shell Base env shell task Conda env live task Conda env shell Conda env task Converter Create a sugar type of food Create report Create robot Dataset exporter Dataset importer Dispatch2 Download resource from a S3 bucket Download resource from external source Eat task Encoded table exporter Encoded table importer EncodingTable exporter EncodingTable importer Env live task Fifo2 Fly task Fs node extractor JSON Dict exporter JSON Dict importer Mamba env live task Mamba env task MetadataTable exporter MetadataTable importer Move robot Pip env live task Pip env shell Pip env task Python live task R conda env live task R mamba env live task Resource exporter Resource importer Resource picker Resource set exporter Resource stacker Robot add Select report Shell Shell task Shell wait Sink Smart interactive plot generator Smart json transformer Smart plot generator Smart table transformer Source Switch2 Table aggregator Table aggregator filter Table annotator Table column aggregator Table column aggregator filter Table column annotator Table column concat Table column data numeric filter Table column data text filter Table column operation mass Table column operations Table column scaler Table column tag aggregator Table column tag extractor Table column tag unfolder Table column tags deleter Table column tags selector Table columns deleter Table columns selector Table decoder Table encoder Table exporter Table filter Table filter Table importer Table replace Table row aggregator Table row aggregator filter Table row annotator Table row concat Table row data numeric filter Table row data text filter Table row scaler Table row tag aggregator Table row tag extractor Table row tag unfolder Table row tags deleter Table row tags selector Table rows deleter Table rows selector Table scaler Table to dataset converter Table transposer Task Text exporter Text importer The travel of `Astro` Transformer Uncompress file Upload resource to S3 Viewer Wait Wait task Write to file
Technical Documentation
Resources
Tasks
Protocols
Smart table transformer
Table transformer that uses AI (OpenAI).
This task is still in beta version.
This task uses openAI API to generate python code that transforms a dataframe. This code is then automatically executed.
/!\ This task does not support table tags.
The data of the table is not transferered to OpenAI, only the provided text.
Input
Table
2d excel like table
Output
Table
2d excel like table
Generated code
Modified generated code that can be used in a python live task directly.
Configuration
prompt
open_ai_chat_paramkeep_columns_tags
If true, the columns tags are kept in the output table for columns that have the same names.
boolkeep_rows_tags
If true, the rows tags are kept in the output table for rows that have the same names.
bool