Quadratic: an online data analysis form that integrates AI dialog and code execution

General Introduction

Quadratic is an open source, intelligent spreadsheet tool that combines AI, code and data connectivity features designed to provide users with powerful data manipulation and analysis capabilities. With support for programming languages such as Python, SQL, and Rust, Quadratic enables users to write and run code directly in spreadsheets to enable complex data manipulation and analysis. The tool is suitable for data scientists, analysts and developers to help them process and analyze data more efficiently.

Function List

• AI integration: Supports the use of AI functions in spreadsheets for data analysis and forecasting.
• Code Support: Allows users to write and run Python, SQL and Rust code in spreadsheets.
• data connection: Supports connection to various data sources for easy data import and export.
• Multi-User Collaboration: Supports multiple people editing and viewing spreadsheets at the same time, facilitating teamwork.
• data visualization: Provides a variety of charts and visualization tools to help users visualize data.
• Plug-in extensions: Supports extended functionality through plug-ins to meet the individual needs of users.

Using Help

Installation process

1. Visit the Quadratic GitHub repository.
2. Clone the repository to local:git clone https://github.com/quadratichq/quadratic.gitThe
3. Go to the project catalog:cd quadraticThe
4. Install the dependencies:npm install maybe yarn installThe
5. Start the development server:npm start maybe yarn startThe

Guidelines for use

1. Creating a new spreadsheet: Once you have opened the Quadratic application, click on the "New Spreadsheet" button to start creating a new spreadsheet.
2. Import dataClick "Import Data" button to select data source and import data. Support many data formats, such as CSV, Excel, etc..
3. Write code: Select a cell in the spreadsheet, click the "Edit Code" button, select a programming language (Python, SQL, or Rust), and write and run the code.
4. Using the AI functionSelect the data area to be analyzed, click the "AI Analysis" button, select the AI model and run the analysis.
5. data visualization: Select the data area to be visualized, click the "Insert Chart" button, select the chart type and generate the chart.
6. Collaborative editing: Invite team members to join the project, set permissions so team members can edit and view the spreadsheet at the same time.
7. Plug-in extensions: Visit the Plugin Marketplace to select and install the required plugins to extend the functionality of Quadratic.

Detailed Operation Procedure

• Data importClick the "Import Data" button, select the type of data source (e.g. local file, database, etc.) and follow the prompts to complete the data import.
• code editor: Input code in the cell, support multi-line code editing, click the "Run" button to execute the code, view the results.
• AI analysisAfter selecting the data area, click on the "AI Analysis" button, select a pre-trained model or a custom model, run the analysis and view the results.
• Chart Generation: After selecting the data area, click the "Insert Chart" button, select the type of chart (e.g. line chart, bar chart, etc.), generate and adjust the chart.
• Collaborative editingClick the "Invite Members" button, enter the member's email address, and set the permissions so that members can edit and view the spreadsheet at the same time.
• Plug-in Installation: Visit the Plugin Marketplace, browse and select the desired plugin, and click the "Install" button to complete the plugin installation and configuration.