AI Data Analyst
Dive into your data like never before. No code, no complex queries; just plain English.
With AI Data Analyst, you can dive into your data like never before! No need for complex queries or coding, just use plain English to perform analysis on your databases and spreadsheets. This powerful plugin allows you to easily explore and gain insights from your data, helping you make informed decisions. Say goodbye to tedious data analysis and hello to a more efficient and user-friendly way of working with data. Get ready to uncover hidden patterns and trends with AI Data Analyst!
How to
Comments (0)
API docs
Learn how to use AI Data Analyst effectively! Here are a few example prompts, tips, and the documentation of available commands.
Example prompts
- Prompt 1: "Perform analysis on databases and spreadsheets."
Features and commands
| Feature/Command | Description |
|---|---|
get_available_sources | This command provides the sources available for querying data. |
get_aiDataAnalyst_instructions | This command provides instructions for how to use the plugin, for use when asked how to use it or other troubleshooting. |
linkDB | This command allows you to add a database to the conversation. You need to provide the database connection string, name, and purpose. |
linkSheet | This command links a Google Sheet to the conversation. You need to provide the sheet URL, name, and purpose. |
manipulateSheet | This command uses a Jupyter notebook to run Python code on any data, allowing you to inspect, edit, manipulate, download, and transform data. You can also install pip packages using this command. |
queryDB | This command allows you to run a read-only query on a database. You need to provide the data source ID, query, columns to use, and explanation. You can also specify whether to provide a plot of the query results. |
useFile | This command ensures that a file is usable for an operation before using it. You need to provide the filename of the file you want to use. |
For AI
Nameai_data_analyst
DescriptionPerform analysis on databases and spreadsheets.
Updates
First added7 August 2023