Data Table🔮

What is data table

A data table is a typed, structured two-dimensional table that serves as the basis for data analysis.

It can be simply understood as similar to a database table or a structured excel table (no merging rows, skipping rows, etc.).

Column Type

In Bayeslab, we keep a simple type structure:

• Text

  • for short or long strings.

• Number

  • for integer types

• Real

  • For decimal/money types

• Date

  • For various type of dates regardless of format

Import from file

When you import your data into Bayeslab, you can use excel or csv files to do so, or directly reference external sources.

Then upload files or choose from what you already uploaded to this project

Seeing a preview of your files data, click next

You'll see Bayeslab automatically analyze the data, assign correct Type and generate corresponding descriptions.

Also, it generates an assessment of the data quality and provide recommendations to do if the quality is not so good.

Click Confirm and you'll see your table is now added.

All data table are accessible from all projects. If you'd like to remove this table from current project but keep for others, use "Unbind" to remove.

Writeback

By default, AI would not try to write anything back to data table.

If you'd like to do so, simply add "write back" or anything similar as part of your prompt.

Preview Data

Click anywhere with that table name, you'll see data preview on the right.

See here for more details on this panel.

Table Copilot

By clicking "AI" in Data Preview, you're now in one of the most interesting feature of Bayeslab: Table Copilot

You'll see firstly it automatically analyze the data in various aspects (schema, data quality.. etc).

Then it follows with recommendations, sample questions, and some ready to do actions.

Each of the actions here are uniquely put into your current data's context, and provide pinpointed recommendations.

Pay special attention to "Editor", which represents you can directly send this back to editor as an AI block and try run it!

For example, "automatic explore" would send back to editor as below:

Click "Run" will give AI a chance to explore on it's own and produce several interesting results.

Try this on every data table, have fun!