{"id":8095,"date":"2024-04-16T10:08:06","date_gmt":"2024-04-16T02:08:06","guid":{"rendered":"https:\/\/www.1ai.net\/?p=8095"},"modified":"2024-04-16T10:08:23","modified_gmt":"2024-04-16T02:08:23","slug":"%e5%9b%bd%e5%86%85ai%e5%a4%a7%e6%a8%a1%e5%9e%8b%e8%a1%a8%e6%a0%bc%e6%95%b0%e6%8d%ae%e5%a4%84%e7%90%86%e5%93%aa%e5%ae%b6%e5%bc%ba%ef%bc%9f%e6%99%ba%e8%b0%b1glm-4%e3%80%81kimi%e4%bc%98%e7%a7%80%ef%bc%88","status":"publish","type":"post","link":"https:\/\/www.1ai.net\/en\/8095.html","title":{"rendered":"Which domestic AI large model table data processing company is the best? Zhipu GLM-4, Kimi are excellent (4000 words detailed evaluation process + results)"},"content":{"rendered":"<div class=\"pgc-img\" data-pm-slice=\"0 0 []\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8097\" title=\"get-408\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-408.jpg\" alt=\"get-408\" width=\"1080\" height=\"608\" \/><\/div>\n<p data-track=\"121\">Image generated from ideogram<\/p>\n<p data-track=\"124\">Today (March 16) is the 2024 civil servant written examination in Guangxi. I have heard some friends discussing the positions they are applying for.<br \/>\nGuotou thought: Now domestic AI<a href=\"https:\/\/www.1ai.net\/en\/tag\/%e5%a4%a7%e6%a8%a1%e5%9e%8b\" title=\"[View articles tagged with [large models]]\" target=\"_blank\" >Large Model<\/a>There are so many, is it possible to use them to help me quickly interpret the information in the job list? Wen Xin Yi Yan 3.5,<a href=\"https:\/\/www.1ai.net\/en\/tag\/%e8%ae%af%e9%a3%9e%e6%98%9f%e7%81%ab\" title=\"[Sees articles with tags]\" target=\"_blank\" >iFlytek Spark<\/a>,<a href=\"https:\/\/www.1ai.net\/en\/tag\/%e8%b1%86%e5%8c%85\" title=\"[View articles tagged with [beanbag]]\" target=\"_blank\" >Bean curd<\/a>,<a href=\"https:\/\/www.1ai.net\/en\/tag\/%e6%99%ba%e8%b0%b1%e6%b8%85%e8%a8%80\" title=\"Look at the article that contains the tag\" target=\"_blank\" >Zhipu Qingyan<\/a>GLM-3, Zhipu Qingyan GLM-4,<a href=\"https:\/\/www.1ai.net\/en\/tag\/%e9%80%9a%e4%b9%89%e5%8d%83%e9%97%ae\" title=\"[View articles tagged with [Tongyi Thousand Questions]]\" target=\"_blank\" >Thousand Questions on Tongyi<\/a>,<a href=\"https:\/\/www.1ai.net\/en\/tag\/kimi\" title=\"[View articles tagged with [Kimi]]\" target=\"_blank\" >Kimi<\/a>Which one is stronger?<\/p>\n<p data-track=\"127\">I thought about my needs, which are as follows:<\/p>\n<ul>\n<li data-track=\"128\">Upload the job table excel file.<\/li>\n<li data-track=\"129\">Verify that AI can read the table data correctly.<\/li>\n<li data-track=\"130\">Do you know how many jobs there are in Nanning, Guangxi?<\/li>\n<li data-track=\"131\">How many positions in Nanning are eligible for &quot;computer-related majors&quot;?<\/li>\n<li data-track=\"132\">How many jobs are there in each city in Guangxi?<\/li>\n<li data-track=\"133\">Based on the job data of each city, can it be presented in a tabular form?<\/li>\n<li data-track=\"134\">Based on the job data of each city, can it be presented in the form of a bar chart?<\/li>\n<li data-track=\"135\">Based on the job data of each city, what is the respective proportion?<\/li>\n<li data-track=\"136\">Based on the proportion of job data in each city, can it be presented in the form of a pie chart?<\/li>\n<li data-track=\"137\"><\/li>\n<\/ul>\n<p data-track=\"138\">The figure below shows the results of this evaluation. The full score is 45 points. The specific scoring criteria and evaluation process are shown below.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8096\" title=\"get-407\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-407.jpg\" alt=\"get-407\" width=\"862\" height=\"554\" \/><\/div>\n<p data-track=\"140\">The picture comes from the Guotou evaluation results<\/p>\n<h2 data-track=\"144\"><strong>Scoring Criteria<\/strong><\/h2>\n<p data-track=\"145\">Before testing, in order to more intuitively and conveniently compare the test results of each model, we briefly define the test scoring criteria as follows:<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p data-track=\"146\"><strong>Scoring Criteria<\/strong><\/p>\n<\/td>\n<td>\n<p data-track=\"147\"><strong>Fraction<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p data-track=\"148\">As expected<strong>Exactly matches<\/strong><\/p>\n<\/td>\n<td>\n<p data-track=\"149\">5<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p data-track=\"150\">As expected<strong>Mostly consistent<\/strong><\/p>\n<\/td>\n<td>\n<p data-track=\"151\">4<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p data-track=\"152\">As expected<strong>A few parts match<\/strong><\/p>\n<\/td>\n<td>\n<p data-track=\"153\">3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p data-track=\"154\"><strong>Unable to determine whether it matches<\/strong><\/p>\n<\/td>\n<td>\n<p data-track=\"155\">2<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p data-track=\"156\">As expected<strong>Totally inconsistent, irrelevant answer<\/strong><\/p>\n<\/td>\n<td>\n<p data-track=\"157\">1<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p data-track=\"158\"><strong>No such feature<\/strong>or<strong>Does not support generation<\/strong><\/p>\n<\/td>\n<td>\n<p data-track=\"159\">0<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p data-track=\"160\"><strong>(Note: This score is only for the perceptual feedback of this test. It is not an authoritative test, so please don&#039;t worry about it.)<\/strong><\/p>\n<h2 data-track=\"164\"><strong>Test items<\/strong><\/h2>\n<ul>\n<li data-track=\"165\">Upload the form file.<\/li>\n<li data-track=\"166\">Read the value of a cell in a row and column in a data table.<\/li>\n<li data-track=\"167\">Read the statistics of a dimension in the data table.<\/li>\n<li data-track=\"168\">Read the statistics of two dimensions in the data table.<\/li>\n<li data-track=\"169\">Based on the understanding of the data table, multiple statistical data are output.<\/li>\n<li data-track=\"170\">Based on the understanding of the data table, multiple statistical data are output and converted into a tabular form.<\/li>\n<li data-track=\"171\">Based on the understanding of the data table, multiple statistical data are output and converted into a bar chart.<\/li>\n<li data-track=\"172\">Based on the understanding of the data table, output the proportion of multiple statistical data.<\/li>\n<li data-track=\"173\">Based on the understanding of the data table, output the proportions of multiple statistical data and convert the proportion data into a pie chart.<\/li>\n<\/ul>\n<h2 data-track=\"177\"><strong>Testing the Model<\/strong><\/h2>\n<ul>\n<li data-track=\"178\">Wenxin Yiyan-Wenxin Big Model 3.5<\/li>\n<li data-track=\"179\">iFlytek Spark<\/li>\n<li data-track=\"180\">Thousand Questions on Tongyi<\/li>\n<li data-track=\"181\">Bean curd<\/li>\n<li data-track=\"182\">Zhipu Qingyan-GLM-4<\/li>\n<li data-track=\"183\">Zhipu Qingyan-GLM-3<\/li>\n<li data-track=\"184\">Kimi<\/li>\n<\/ul>\n<p data-track=\"188\"><strong>Testing time<\/strong><\/p>\n<p data-track=\"189\">March 15 and 16, 2024.<\/p>\n<p data-track=\"193\"><strong>After the preparation work is completed, we start to test.<\/strong><\/p>\n<h2 data-track=\"197\"><strong>Wenxin Yiyan-Wenxin Big Model 3.5<\/strong><\/h2>\n<p data-track=\"198\"><strong>Test 1: Upload a table file<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8098\" title=\"get-409\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-409.jpg\" alt=\"get-409\" width=\"1080\" height=\"728\" \/><\/div>\n<p data-track=\"199\"><strong>Feedback and Ratings:<\/strong>Only supports word and pdf, not xlsx and other table formats. Unable to conduct subsequent tests, ended before it even started-_-||<\/p>\n<p data-track=\"200\"><strong>Total score: 0.<\/strong><\/p>\n<h2 data-track=\"202\"><strong>iFlytek Spark<\/strong><\/h2>\n<p data-track=\"203\"><strong>Test 1: Upload a table file<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8099\" title=\"get-410\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-410.jpg\" alt=\"get-410\" width=\"1080\" height=\"914\" \/><\/div>\n<p data-track=\"204\"><strong>Feedback and Ratings:<\/strong>Does not support xlsx and other table formats. Unable to conduct subsequent tests, ended before it even started -_-||<\/p>\n<p data-track=\"205\"><strong>Total score: 0.<\/strong><\/p>\n<hr \/>\n<h2 data-track=\"207\"><strong>Bean curd<\/strong><\/h2>\n<p data-track=\"209\"><strong>Test 1: Upload a table file<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8100\" title=\"get-411\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-411.jpg\" alt=\"get-411\" width=\"1080\" height=\"1212\" \/><\/div>\n<p data-track=\"210\"><strong>Feedback and Ratings:<\/strong>File upload is not supported. Subsequent testing is unavailable. It ended before it even started -_-||<\/p>\n<p data-track=\"211\"><strong>Total score: 0.<\/strong><\/p>\n<h2 class=\"pgc-h-arrow-right\" spellcheck=\"false\" data-track=\"215\">Zhipu Qingyan-GLM-3<\/h2>\n<p data-track=\"216\"><strong>Test 1: Upload a table file<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8101\" title=\"get-412\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-412.jpg\" alt=\"get-412\" width=\"1080\" height=\"1366\" \/><\/div>\n<p data-track=\"217\"><strong>Feedback and Ratings:<\/strong>Does not support xlsx and other table formats. Unable to conduct subsequent tests, ended before it even started -_-||<\/p>\n<p data-track=\"218\"><strong>Total score: 0.<\/strong><\/p>\n<h2 class=\"pgc-h-arrow-right\" spellcheck=\"false\" data-track=\"220\">Zhipu Qingyan-GLM-4<\/h2>\n<p data-track=\"221\"><strong>Test 1: Upload a table file<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8102\" title=\"get-413\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-413.jpg\" alt=\"get-413\" width=\"1080\" height=\"393\" \/><\/div>\n<p data-track=\"222\"><strong>Feedback and Ratings:<\/strong>Successfully uploaded the position table xlsx file, this item will be scored 5 points.<\/p>\n<p data-track=\"224\"><strong>Test Item 2: Read the value of a cell in a row or column in a data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8103\" title=\"get-414\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-414.jpg\" alt=\"get-414\" width=\"1080\" height=\"450\" \/><\/div>\n<p data-track=\"225\">Feedback and Rating: The picture below is a screenshot of the table. After removing the header column names, the third column of the first row of the text is indeed &quot;People&#039;s Courts at All Levels&quot;. This item is rated 5 points.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8104\" title=\"get-415\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-415.jpg\" alt=\"get-415\" width=\"1080\" height=\"394\" \/><\/div>\n<p data-track=\"227\"><strong>Test Item 3: Read the statistics of a dimension in the data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8105\" title=\"get-416\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-416.jpg\" alt=\"get-416\" width=\"1080\" height=\"943\" \/><\/div>\n<p data-track=\"228\">Feedback and scoring: The figure below is a screenshot of the table. The Nanning sheet contains 524 positions. If the answer is correct, score 5 points.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8106\" title=\"get-417\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-417.jpg\" alt=\"get-417\" width=\"1080\" height=\"907\" \/><\/div>\n<p data-track=\"230\"><strong>Test Item 4: Read the statistics of two dimensions in the data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8107\" title=\"get-418\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-418.jpg\" alt=\"get-418\" width=\"1080\" height=\"654\" \/><\/div>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8108\" title=\"get-419\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-419.jpg\" alt=\"get-419\" width=\"1020\" height=\"862\" \/><\/div>\n<p data-track=\"231\">I found that when I directly searched for keywords including &quot;computer majors&quot;, nothing was found.<\/p>\n<p data-track=\"232\">Let&#039;s ask it another way: How many jobs are there in Nanning that are suitable for computer majors? I found that 21 jobs can be retrieved.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8109\" title=\"get-420\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-420.jpg\" alt=\"get-420\" width=\"1080\" height=\"640\" \/><\/div>\n<p data-track=\"233\"><strong>Feedback and Ratings:<\/strong>The picture below is a screenshot of the table. A total of 21 professional categories containing &quot;computer&quot; were filtered out from the Nanning sheet. The answer is correct, but since the first search result was 0, it is considered partially in line with expectations and is scored 3 points.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8110\" title=\"get-421\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-421.jpg\" alt=\"get-421\" width=\"1080\" height=\"702\" \/><\/div>\n<p data-track=\"235\"><strong>Test Item 5: Based on the understanding of the data table, output multiple statistical data.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8111\" title=\"get-422\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-422.jpg\" alt=\"get-422\" width=\"1080\" height=\"1141\" \/><\/div>\n<p data-track=\"236\">Feedback and scoring: The figure below is a screenshot of job statistics in some cities. If the answer is correct, you will get 5 points.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8112\" title=\"get-423\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-423.jpg\" alt=\"get-423\" width=\"1080\" height=\"115\" \/><\/div>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8114\" title=\"get-425\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-425.jpg\" alt=\"get-425\" width=\"1080\" height=\"126\" \/><\/div>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8113\" title=\"get-424\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-424.jpg\" alt=\"get-424\" width=\"1080\" height=\"117\" \/><\/div>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8115\" title=\"get-426\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-426.jpg\" alt=\"get-426\" width=\"1080\" height=\"120\" \/><\/div>\n<p data-track=\"238\"><strong>Test Item 6: Based on the understanding of the data table, output multiple statistical data and convert the statistical data into a tabular form.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8116\" title=\"get-427\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-427.jpg\" alt=\"get-427\" width=\"1080\" height=\"999\" \/><\/div>\n<p data-track=\"239\"><strong>Feedback and Ratings:<\/strong>Although the table header has an English name, the answer is correct and 5 points are awarded.<\/p>\n<p data-track=\"241\"><strong>Test Item 7: Based on the understanding of the data table, output multiple statistical data and convert the statistical data into a bar chart.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8117\" title=\"get-428\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-428.jpg\" alt=\"get-428\" width=\"1080\" height=\"856\" \/><\/div>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8118\" title=\"get-429\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-429.jpg\" alt=\"get-429\" width=\"1066\" height=\"681\" \/><\/div>\n<p data-track=\"242\"><strong>Feedback and Ratings:<\/strong>A bar chart can be generated, but the city names cannot be displayed. This is considered to be a small part that meets expectations, so I give it a score of 3.<\/p>\n<p data-track=\"244\"><strong>Test Item 8: Based on the understanding of the data table, output the proportion of multiple statistical data.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8119\" title=\"get-430\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-430.jpg\" alt=\"get-430\" width=\"1080\" height=\"1069\" \/><\/div>\n<p data-track=\"245\"><strong>Feedback and Ratings:<\/strong>If the percentage answer is correct, 5 points will be awarded.<\/p>\n<p data-track=\"247\"><strong>Test Item 9: Based on the understanding of the data table, output the proportions of multiple statistical data and convert the proportion data into a pie chart.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8120\" title=\"get-431\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-431.jpg\" alt=\"get-431\" width=\"1080\" height=\"700\" \/><\/div>\n<p data-track=\"248\"><strong>Feedback and Ratings:<\/strong>The pie chart proportion data is correct, but the option name cannot be displayed, which is considered a small part of the compliance and is scored 3 points.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8121\" title=\"get-432\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-432.jpg\" alt=\"get-432\" width=\"967\" height=\"606\" \/><\/div>\n<p data-track=\"249\"><strong>Total score: 5+5+5+3+5+5+3+5+3=39.<\/strong><\/p>\n<h2 data-track=\"252\"><strong>Thousand Questions on Tongyi<\/strong><\/h2>\n<p data-track=\"253\"><strong>Test 1: Upload a table file<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8122\" title=\"get-433\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-433.jpg\" alt=\"get-433\" width=\"1080\" height=\"758\" \/><\/div>\n<p data-track=\"254\"><strong>Feedback and Ratings:<\/strong>Successfully uploaded the position table xlsx file, this item will be scored 5 points.<\/p>\n<p data-track=\"256\"><strong>Test Item 2: Read the value of a cell in a row or column in a data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8123\" title=\"get-434\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-434.jpg\" alt=\"get-434\" width=\"1080\" height=\"616\" \/><\/div>\n<p data-track=\"257\"><strong>Feedback and Ratings:<\/strong>It is unable to give an answer, and after further clarifying the input, it is still unable to give an answer. It also says that it needs to be guessed. This is considered to be irrelevant and completely inconsistent with the question. This item will be scored 1 point.<\/p>\n<p data-track=\"259\"><strong>Test Item 3: Read the statistics of a dimension in the data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8124\" title=\"get-435\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-435.jpg\" alt=\"get-435\" width=\"1080\" height=\"739\" \/><\/div>\n<p data-track=\"260\"><strong>Feedback and Ratings:<\/strong>I only read part of the information from the table and made some data based on it. I took the information out of context and answered the question irrelevantly. I will give you 1 point.<\/p>\n<p data-track=\"262\"><strong>Test Item 4: Read the statistics of two dimensions in the data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8125\" title=\"get-436\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-436.jpg\" alt=\"get-436\" width=\"1080\" height=\"610\" \/><\/div>\n<p data-track=\"263\"><strong>Feedback and Ratings:<\/strong>The result is the same as the third test. If you selectively extract part of the information to answer the question, take it out of context, or answer irrelevant questions, you will get 1 point.<\/p>\n<p data-track=\"265\"><strong>Test Item 5: Based on the understanding of the data table, output multiple statistical data.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8126\" title=\"get-437\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-437.jpg\" alt=\"get-437\" width=\"1080\" height=\"645\" \/><\/div>\n<p data-track=\"266\"><strong>Feedback and Ratings:<\/strong>Similar to the previous test results, if you selectively extract part of the information to answer the question, take it out of context, or answer irrelevant questions, you will get 1 point.<\/p>\n<p data-track=\"268\"><strong>Test Item 6: Based on the understanding of the data table, output multiple statistical data and convert the statistical data into a tabular form.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8127\" title=\"get-438\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-438.jpg\" alt=\"get-438\" width=\"1080\" height=\"725\" \/><\/div>\n<p data-track=\"269\"><strong>Feedback and Ratings:<\/strong>Based on the results of test item 5, it was correctly converted into a table format and the table presentation function met expectations, so it was given a score of 5.<\/p>\n<p data-track=\"271\"><strong>Test Item 7: Based on the understanding of the data table, output multiple statistical data and convert the statistical data into a bar chart.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8130\" title=\"get-441\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-441.jpg\" alt=\"get-441\" width=\"1080\" height=\"564\" \/><\/div>\n<p data-track=\"272\"><strong>Feedback and Ratings:<\/strong>It does not support drawing graphs or bar charts. Without this function, this item is scored 0.<\/p>\n<p data-track=\"274\"><strong>Test Item 8: Based on the understanding of the data table, output the proportion of multiple statistical data.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8128\" title=\"get-439\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-439.jpg\" alt=\"get-439\" width=\"1080\" height=\"812\" \/><\/div>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8129\" title=\"get-440\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-440.jpg\" alt=\"get-440\" width=\"1080\" height=\"408\" \/><\/div>\n<p data-track=\"275\"><strong>Feedback and Ratings:<\/strong>The data percentage requirement was raised, but the total number of people could not be directly identified. They kept asking me to provide the total number of people. Well, then we can use the information given as the total number of people, or there is no total number of people in all positions. OK, then I will give the total number of positions as 4210. At this time, they told me a lot of reasons, but I don&#039;t have the patience to waste time with them. This is irrelevant, so I give 1 point.<\/p>\n<p data-track=\"277\"><strong>Test Item 9: Based on the understanding of the data table, output the proportions of multiple statistical data and convert the proportion data into a pie chart.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8131\" title=\"get-442\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-442.jpg\" alt=\"get-442\" width=\"1080\" height=\"647\" \/><\/div>\n<p data-track=\"278\"><strong>Feedback and Ratings:<\/strong>Does not support drawing charts, does not have this function, and gives 0 points.<\/p>\n<p data-track=\"279\"><strong>Total score: 5+1+1+1+1+5+0+1+0=15.<\/strong><\/p>\n<h2 data-track=\"283\"><strong>Kimi<\/strong><\/h2>\n<p data-track=\"284\"><strong>Test 1: Upload a table file<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8132\" title=\"get-443\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-443.jpg\" alt=\"get-443\" width=\"1080\" height=\"907\" \/><\/div>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8134\" title=\"get-445\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-445.jpg\" alt=\"get-445\" width=\"1080\" height=\"1069\" \/><\/div>\n<p data-track=\"285\"><strong>Feedback and Ratings:<\/strong>The first upload prompted that it exceeded the conversation length and was not supported. After deleting most of the content in the Excel table and retaining only the job plan table of Wuzhou City, it was successfully uploaded. This is considered a small part of the compliance, and this item is scored 3 points.<\/p>\n<p data-track=\"287\"><strong>Test Item 2: Read the value of a cell in a row or column in a data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8133\" title=\"get-444\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-444.jpg\" alt=\"get-444\" width=\"1080\" height=\"288\" \/><\/div>\n<p data-track=\"288\"><strong>Feedback and Ratings:<\/strong>The picture below is a screenshot of the table. After removing the header column name, the third column of the first row of the text is indeed &quot;city level&quot;, which is 5 points.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8135\" title=\"get-446\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-446.jpg\" alt=\"get-446\" width=\"1080\" height=\"231\" \/><\/div>\n<p data-track=\"290\"><strong>Test Item 3: Read the statistics of a dimension in the data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8137\" title=\"get-448\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-448.jpg\" alt=\"get-448\" width=\"984\" height=\"214\" \/><\/div>\n<p data-track=\"291\"><strong>Feedback and Ratings:<\/strong>The picture below is a screenshot of the table. From the Wuzhou sheet, we can see that there are a total of 308 rows. After removing the header, there are a total of 307 job details. The answer is correct and is worth 5 points.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8136\" title=\"get-447\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-447.jpg\" alt=\"get-447\" width=\"1080\" height=\"128\" \/><\/div>\n<p data-track=\"294\"><strong>Test Item 4: Read the statistics of two dimensions in the data table<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8138\" title=\"get-449\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-449.jpg\" alt=\"get-449\" width=\"1080\" height=\"695\" \/><\/div>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8139\" title=\"get-450\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-450.jpg\" alt=\"get-450\" width=\"1060\" height=\"1333\" \/><\/div>\n<p data-track=\"295\"><strong>Feedback and Ratings:<\/strong>The first filter was &quot;computer majors&quot;, and Kimi converted it into the keyword &quot;computer science and technology&quot;, but the output was wrong. The second time, Kimi did not use quotation marks to convert it into mentions of &quot;computer majors&quot;, but the statistical data and detailed descriptions were wrong. See the screenshot below, you can see that for position numbers 14-19, the word &quot;computer&quot; does not appear in the corresponding professional (discipline) category. This is considered a non-answer, and I give it 1 point.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8140\" title=\"get-451\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-451.jpg\" alt=\"get-451\" width=\"1080\" height=\"681\" \/><\/div>\n<p data-track=\"298\"><strong>Test Item 5: Based on the understanding of the data table, output multiple statistical data.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8141\" title=\"get-452\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-452.jpg\" alt=\"get-452\" width=\"1051\" height=\"1029\" \/><\/div>\n<p data-track=\"299\"><strong>Feedback and Ratings:<\/strong>The figure below is the result of pivoting the Excel table. It is found that some data are accurate, some data are wrong, and a small part is in line with expectations, so it is scored 3 points.<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8142\" title=\"get-453\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-453.jpg\" alt=\"get-453\" width=\"535\" height=\"727\" \/><\/div>\n<p data-track=\"302\"><strong>Test Item 6: Based on the understanding of the data table, output multiple statistical data and convert the statistical data into a tabular form.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8143\" title=\"get-454\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-454.jpg\" alt=\"get-454\" width=\"1069\" height=\"1290\" \/><\/div>\n<p data-track=\"303\"><strong>Feedback and Ratings:<\/strong>5 points if the data can be correctly converted into a table based on the data results and meets expectations.<\/p>\n<p data-track=\"306\"><strong>Test Item 7: Based on the understanding of the data table, output multiple statistical data and convert the statistical data into a bar chart.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8144\" title=\"get-455\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-455.jpg\" alt=\"get-455\" width=\"1080\" height=\"938\" \/><\/div>\n<p data-track=\"307\"><strong>Feedback and Ratings:<\/strong>Unable to create chart, no such function, 0 points.<\/p>\n<p data-track=\"309\"><strong>Test Item 8: Based on the understanding of the data table, output the proportion of multiple statistical data.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8145\" title=\"get-456\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-456.jpg\" alt=\"get-456\" width=\"1074\" height=\"1062\" \/><\/div>\n<p data-track=\"310\">Feedback and scoring: If the answer based on the statistical percentage of existing results is correct according to the estimated results and meets expectations, it will be scored 5 points.<\/p>\n<p data-track=\"312\"><strong>Test Item 9: Based on the understanding of the data table, output the proportions of multiple statistical data and convert the proportion data into a pie chart.<\/strong><\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8146\" title=\"get-457\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-457.jpg\" alt=\"get-457\" width=\"940\" height=\"1261\" \/><\/div>\n<p data-track=\"313\">Feedback and Rating: Unable to create a chart, no such function, 0 points.<\/p>\n<p data-track=\"314\"><strong>Total score: 5+3+5+1+3+5+0+5+0=27 points.<\/strong><\/p>\n<h2 class=\"pgc-h-arrow-right\" spellcheck=\"false\" data-track=\"317\">Evaluation Summary<\/h2>\n<p data-track=\"318\">The evaluation results are summarized in the following table:<\/p>\n<div class=\"pgc-img\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8147\" title=\"get-458\" src=\"https:\/\/www.1ai.net\/wp-content\/uploads\/2024\/04\/get-458.jpg\" alt=\"get-458\" width=\"1080\" height=\"692\" \/><\/div>\n<p data-track=\"319\"><strong>From the evaluation results table we can see that:<br \/>\nZhipu Qingyan GLM-4<a href=\"https:\/\/www.1ai.net\/en\/tag\/%e8%a1%a8%e6%a0%bc%e6%95%b0%e6%8d%ae%e5%a4%84%e7%90%86\" title=\"[See articles with [form data processing] labels]\" target=\"_blank\" >Table data processing<\/a>The experience effect is far ahead.<br \/>\nNext was Kimi, who was able to answer most of the data questions but was unable to generate charts.<br \/>\nNext, I come to Tongyi Qianwen. I can only say that it has the function of uploading spreadsheet files, but its IQ is not enough to correctly process and analyze the spreadsheet data.<br \/>\nFinally, there are Wenxin Yiyan Large Model 3.5, iFlytek Spark, Doubao, and Zhipu Qingyan GLM-3, which are now simply not supported.<\/strong><\/p>\n<p data-track=\"320\">Based on the current performance of Zhipu Qingyan GLM-4, would you use it to process spreadsheet files?<\/p>\n<p data-track=\"321\">Looking forward to the re-evaluation after the major models of each manufacturer are updated (*^\u25bd^*).<\/p>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>Image generated from ideogram Today (March 16) is the time of Guangxi 2024 annual civil service written examination test, have heard some friends discussing the situation of the positions applied for. Pothead thought: now there are so many big domestic AI models, is it possible to use them to help me quickly interpret the information on the job list? Which one is stronger, Wenxin Yiyan 3.5, Xunfei Starfire, Doubao, Zhispectrum Qingyin GLM-3, Zhispectrum Qingyin GLM-4, Tongyi Qianqian, or Kimi? Brainstorm your requirements as follows: Upload the job list excel file. Verify whether AI can read the table data correctly. How many jobs are there in Nanning, Guangxi? How many positions in Nanning City that meet the \"computer class major\"? How many jobs are there in each city in Guangxi? Based on each city<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[144],"tags":[1814,216,822,2249,362,2248,331],"collection":[],"class_list":["post-8095","post","type-post","status-publish","format-standard","hentry","category-baike","tag-kimi","tag-216","tag-822","tag-2249","tag-362","tag-2248","tag-331"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/posts\/8095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/comments?post=8095"}],"version-history":[{"count":0,"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/posts\/8095\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/media?parent=8095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/categories?post=8095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/tags?post=8095"},{"taxonomy":"collection","embeddable":true,"href":"https:\/\/www.1ai.net\/en\/wp-json\/wp\/v2\/collection?post=8095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}