ChatGPT Excel? Peking University ChatExcel changed the table with just a few words

Excel is the most common data statistics tool, used to summarize and query data information. On top of it, usually when we query information, we need to find the relevant cells and obtain the data in them. This is a logical method for computer operation.

But for many people, operations such as sorting, multiplication and division, and averaging are relatively simple. If they encounter complex operations that require programming code, they have no idea how to start.

Recently, researchers from Peking University have proposed a new method that is more in line with people's daily communication habits - a new application called ChatExcel that can directly use natural language to Perform query, modification and other operations on the data information, just like an assistant proficient in Excel.

Tool link: ​https://chatexcel.com/​

ChatExcel, as its name suggests, allows you to handle table calculations in a conversational manner. The author shows how to use it: downloaded a table of "GDP of China's Provinces" from the Internet, and then started an operation:

If you want to know For the growth rate of each province, you only need to enter text:

##In addition to querying and changing, Excel also has a very commonly used function: Data summary statistics, the author demonstrated it using a student information table.

First, summarize and count the honors received by each college and the number of various honors:

Then sort the colleges by the total number of honors received:

What’s even more powerful is that ChatExcel can not only process a single table, but also handle multiple related tables at the same time. The author uses two tables about "QS Ranking of World Universities" and "Soft Subject Ranking of World Universities" to demonstrate ChatExcel's ability to process multiple tables. For example, you can put "*"

after the name of a university that is in the top ten in both rankings. As you can see, the user does not need to make any edits to the table throughout the process, nor does he need to search the documentation to find out how to implement the Excel functions for each step of the operation. All he has to do is express his needs in detail to the ChatExcel dialog box, and the table will be done. Make corresponding "self-adjustments".

In addition, we also noticed that ChatExcel also has certain natural language understanding capabilities. For example, there is a column in the student information table that contains the student's name. As long as you enter the last name, ChatExcel can find the corresponding data. For example, "Find the data with the surname Wang and a name of three characters":

Picture source: https://zhuanlan.zhihu.com/p/607997627

Different from one-time interaction with products such as ChatBCG (one-click generation of PPT), excelformulabot (one-click generation of excel functions), ChatExcel is a tool that can continuously interact, and can perform real-time operations based on the current table content and user needs. make corresponding changes. In other words, it is like a smart form processing AI assistant that can complete the entire form processing process accurately and efficiently.

According to reports, ChatExcel comes from the team of Professor Yuan Li from the Peking University Shenzhen Graduate School/School of Information Engineering, and is mainly independently developed by three master's and doctoral students.

The author stated that the current version of ChatExcel is only an immature Demo, and there may be many gaps with the expected usage, and it has not reached the omnipotent status of ChatGPT. It is positioned as an intelligent assistant that can make complex Excel operations simple and convenient. "We hope it ends up being a small but beautiful product," the author said.

The above is the detailed content of ChatGPT Excel? Peking University ChatExcel changed the table with just a few words. For more information, please follow other related articles on the PHP Chinese website!