5 Powerful AI Data Analysis Tools for Innovative Research

5 Powerful AI Data Analysis Tools for Innovative Research

Powerful AI tools have arrived, and there are many useful AI data analysis tools that can truly make the tedious task of data analysis much simpler. Today, I will introduce 5 AI + data analysis tools that I recommend you to bookmark.
01
Cool Table EXCEL
Websitehttps://chatexcel.com/
This is an AI office assistant tool developed by a team consisting of Assistant Professor Yuan Li from the School of Information Engineering at Peking University Shenzhen Graduate School and three graduate students, which allows for interactive control of Excel through text chat.
The steps are very simple, you input commands, and it executes!

5 Powerful AI Data Analysis Tools for Innovative Research

Recently, ChatExcel integrated an open-source online spreadsheet tool, which supports local modification mode. Unlike other Excel AI formula generators, it executes commands directly without requiring you to retrieve and copy formulas, making it very user-friendly for those who are not familiar with Excel or its formulas!
Example:
After uploading a list of students, the first operation is to find students with the surname Wang and three-character names, and it successfully found them.

5 Powerful AI Data Analysis Tools for Innovative Research

Second test, input:Find out what honors different colleges have received and how many honors they have received, and it was also completed quickly.

5 Powerful AI Data Analysis Tools for Innovative Research

Next, let’s add “Doctor-” in front of names starting with student number “BX” and “Master-” in front of the remaining names, this is the data effect, which can be said to hit the target accurately.
5 Powerful AI Data Analysis Tools for Innovative Research
02

AskExcel

Website:https://askexcel.cn/

5 Powerful AI Data Analysis Tools for Innovative Research

Excel’s complex and numerous built-in formulas have a high learning curve, and most people need Excel, but this knowledge is not mastered by everyone.
Most people can accurately articulate their needs when using Excel, that is, what kind of results I want.However, they just don’t know how to implement it using Excel.
This AskExcel feature is very powerful, including automatically creating tables, generating and modifying pivot tables (reports), creating new independent tables and modifying them,cross-table calculations, performance testing for large tables with 80,000 rows, and complex tasks.
Example:
For this Excel table of student grades,
input command:Create a new table that only requires student names and scores for Chinese, Mathematics, and English, and it completed quickly.

5 Powerful AI Data Analysis Tools for Innovative Research

Then, let’s add a column for grade levels to this table, and generate a pivot table, which it also completed successfully.

5 Powerful AI Data Analysis Tools for Innovative Research

03

AEE

Website:

https://www.yishijuan.com/#banner

It is also an online AI Excel editor tool that requires no learning of Excel’s complicated operations and formulas. Just input simple prompts, and it automatically performs data operations or writes formulas, greatly improving efficiency!

AEE Editor is a pure offline tool product, ensuring that data will not be uploaded to the server, thus ensuring data privacy and security. It can enhance work efficiency in basic CRUD operations on simple data, and specific situations can be viewed in the detailed demonstration below.

1
Formula Calculation

AEE can write formulas or calculate directly based on requirements.

Example:

Calculate the median and average, and it was implemented immediately.

5 Powerful AI Data Analysis Tools for Innovative Research

5 Powerful AI Data Analysis Tools for Innovative Research
2
Modify and Delete

Highlight and group part of the duplicate data in the area, input requirements and achieve results.

5 Powerful AI Data Analysis Tools for Innovative Research

5 Powerful AI Data Analysis Tools for Innovative Research

5 Powerful AI Data Analysis Tools for Innovative Research
3
Data Extraction

Extract the birth date from the specified area based on the ID card number correctly.

5 Powerful AI Data Analysis Tools for Innovative Research

5 Powerful AI Data Analysis Tools for Innovative Research
4
Data Filling

Can fill in some data such as: ID card number, specific person names, place names, product components, etc..

Example: Randomly fill in Beijing ID card numbers in the blank areas, and it was completed successfully.

5 Powerful AI Data Analysis Tools for Innovative Research

In addition, it can also achieve cross-table operations or data filtering, which is very convenient.

04
WPS AI

Link:https://vip.wps.cn/home

5 Powerful AI Data Analysis Tools for Innovative Research

Using WPS AI for data analysis is very convenient, such as categorical summation,data visualization, cross-table analysis, intelligent extraction, and even sentiment analysis can all be handled directly.

No need to search for steps or tutorials one by one online; just describe the data to be processed and the processing requirements, and leave the rest to WPS!

In simple terms, just tell it your needs + scope, AI generates formulas, and gets results in 1 second, super convenient!

For example:

Upload a data table and ask it to calculate the total sales volume without needing to know what the formula is, the AI calculates it by itself.

5 Powerful AI Data Analysis Tools for Innovative Research

Here are some tips for using WPS AI:

1. Requirements should be specific and clear~
2. Clarify the scope; if it’s not the entire table, specify the positions like cell xxx, sheet xxx, etc.
3. For conditional functions like IF, specify clear conditions!
05
Smart Charting

Link:https://chatglm.cn/

Smart Charting is a Tsinghua University product that focuses on comprehensive functionality. It is very excellent in data processing, not only generating tables but also creating visual graphs.

It is very easy to operate; just upload the table and issue commands in text.

Example:

After uploading a table, input text: Please create a visual graph based on the table.

5 Powerful AI Data Analysis Tools for Innovative Research

If you want to learn more about generative AI tools empowering teaching practices, you can click on the poster below to learn about the “Intelligent Teaching Assistance & Efficiency Optimization Training Camp for Generative AI Tools Deep Empowerment of Teacher Teaching Innovation Practices,” which is about to start!! Everyone is welcome to scan the code for inquiries!

5 Powerful AI Data Analysis Tools for Innovative Research

Source丨Network

Statement丨Reprinting aims to share, this account respects originality, and the copyright belongs to the original author. If there are any copyright issues, please contact us for deletion.

5 Powerful AI Data Analysis Tools for Innovative Research

Recommended Reading

Bookmark! Summary of 139 National Teaching Achievement Awards (with download)
1000+ Course Ideological and Political Case Collection (with 52 PPTs + 8 Application Forms)
65 Teaching Innovation Competition Materials Summary (with 13 Reports + 35 PPTs)
290 National First-Class Course Summary (with download)
Director Wu Yan’s 2022-2018 Report Summary (with download)
160 Pages! New Round of Review and Evaluation Reference Materials Compilation (with download)

5 Powerful AI Data Analysis Tools for Innovative Research

Leave a Comment