Our AI Assistant, powered by OpenAI's GPT-4 language model, provides an advanced and interactive approach to data analysis and visualization. This feature leverages natural language processing (NLP) to interpret text prompts and automate various tasks within the app. These tasks include:
- Querying PDFs: extract relevant information from documents in seconds;
- Processing data: use natural language to perform spreadsheet calculations;
- Visualizing data: use natural language to create and modify plots;
- Creating figures: use natural language to adjust and harmonize multiple plots in a figure.
Saving useful prompts and providing feedback
The AI Assistant keeps a personal searchable history of useful prompts that you like & save. This is particularly useful when you want to send the same or similar prompts in the future.
To save a prompt to your history, click on the heart icon next to it. To view your saved prompts, type '@' in the prompt input area.
To search your history, type '@' followed by a search term. For example, '@bar' will show all saved prompts containing the word 'bar'.
You can also provide feedback on the AI Assistant's responses by clicking on the thumbs up or thumbs down icon next to the response. This will help the assistant learn and improve its responses in the feature!
PDF analysis and information extraction
A powerful new feature allows users to upload, select, and query PDF documents in My Files area. This innovative capability utilizes state-of-the-art technology to extract relevant information from the PDFs, providing users with quick and insightful answers to their questions.
Uploading and managing PDF files
- Go to the My Files area in the platform.
- Click on the Upload button to select and upload one or multiple PDF files. The files will be securely stored in your personal space.
- Once uploaded, the PDF files can be viewed and managed in the My Files area. Users can rename, delete, or select files for analysis.
- To analyze a PDF, simply click on it in the My Files area. You can select multiple PDFs for a broader analysis.
- Selected files will be highlighted, indicating they are ready for querying.
- With the PDFs selected, you can ask the AI Assistant various questions about the content of these documents. The Assistant will process your query and extract relevant information from the selected PDFs.
How it works
The technology behind this feature involves converting the contents of the PDFs into embeddings, a form of data representation that captures the essence of the text. When a query is made, a semantic search is performed within the embedding database to find and extract the most relevant information.
Examples of queriesSummarize the key findings in the selected PDFs. What experimental models were used? What was the experimental approach?
Limitations and best practices
- Quality of PDFs: The accuracy of information extraction depends on the quality and clarity of the PDF documents.
- Complex Queries: While the AI can handle a wide range of queries, overly complex or ambiguous questions may result in less precise answers.
- Language Limitations: Currently, the feature supports PDFs primarily in English. Additional language support is being developed.
Spreadsheet calculations and data generation (data & visualization area)
The AI Assistant can perform a variety of calculations in the data grid and add new data to it based on your prompts. This is particularly handy when you need to quickly perform operations on existing data or add computed values to your data grid.
Examples of prompts to perform calculations or add data to the grid
- Calculate row-average of columns A-C, put in column D.
- Add gaussian-distributed random data to column A with mean 0 and standard deviation 1.
- Calculate average of column A, put in B1.
Data analysis (data & visualization area)
Apart from creating plots and performing calculations, the AI Assistant can also analyze the data present in your grid. You can ask the AI Assistant to interpret and analyze specific columns of data by simply specifying it in your prompt. The Assistant will also take the headers into account when analyzing the data.
The data you want to analyze and column headers will be sent to OpenAI! Read more about OpenAI's data policies.
Examples of prompts to analyze data
- Tell me what you think about data in columns A-B (they are linked).
- What is the distribution of data in column A?
- What is the correlation between columns A and B?
Creating and modifying plots (data & visualization area)
With the AI Assistant, you can easily create a new trace by simply typing in a text prompt. The Assistant will interpret your prompt and generate a trace based on the data from specified data grid columns. You can also specify the type of trace you want to create, or data sources for various trace properties.
Adding new traces is not possible in figure editor. This is because the AI Assistant needs access to the underlying data grid.
Examples of prompts to add a new trace
- Create a bar trace using column A for x and column B for y.
- Create a scatter trace from columns A and B. Use column C for marker color and column D for size.
- Create a heatmap from columns A and B. Use columns C-H for z. Axis titles: x-axis: 'axis x', y-axis: 'axis y'.
Before adding a trace, make sure data is already present in the grid. If you would like the assistant to generate data, you need to ask it to do so first. See examples of prompts to generate data.
Creating figures (figure editor area)
The AI Assistant can also modify existing plots based on your prompts. You can specify the type of modification you want to make, the trace you want to modify, and the data sources for the modification. The Assistant will interpret your prompt and modify the plot accordingly. This feature is available in both the data visualization area and the figure editor.
Examples of prompts to modify a trace or plot
- The first trace should use column A for x and column D for y. It should also use the rithe y-axis.
- Set tick spacing for the x-axis to 0.5 and for the y-axis to 0.1
- Set the title of the plot to 'Welcome AI'.
- Increase the plot width by 25% and the plot height by 50%.
Usage and limitations
The AI Assistant feature provides a history of prompts and responses in a scrollable element for reference. However, it's crucial to note that the AI Assistant operates on a one-time interaction basis. This means that each response from the assistant is generated from the specific prompt you input and the assistant does not have the awareness of previous prompts in the session.
Explore and make the most of this AI Assistant to make your data analysis and visualization tasks easier and more efficient. Happy analyzing!