Smart table transformer

Typing name : TASK.gws_core.SmartTableTransformer

Brick : gws_core

Table transformer that uses AI (OpenAI).

This task uses AI to tranform a table. This task is useful to filter a table, transform it, generate simple statistics, etc.

The data of the table is not transferered to OpenAI, only the provided text. Please provide a clear description of what you want to achieve by providing column names, row names, etc. You can provide multiple message to the AI to get the best result, the context will be kept between the messages.

This task uses openAI API to generate python code which is then automatically executed.

⚠️ This task does not support table tags. ⚠️

Input

Table

2d excel like table

Table

Output

Table

2d excel like table

Table

Generated code

Modified generated code that can be used in a python agent directly.

Text

Configuration

prompt

Type : open_ai_chat_param

keep_columns_tags

Optional

If true, the columns tags are kept in the output table for columns that have the same names.

Type : bool

keep_rows_tags

Optional

If true, the rows tags are kept in the output table for rows that have the same names.

Type : bool

Input

Output

Configuration

Have you developed a brick?