Method and device for visualizing table type data
By determining the multi-dimensional feature probability and feature mining of tabular data, combined with data aggregation, the problems of high difficulty in visual adaptation of tabular data and limited view types in the prior art are solved, and more rich visual effects and flexibility are achieved.
Patent Information
- Application Number
- CN202410968840.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-18
- Publication Date
- 2024-11-08
AI Technical Summary
The prior art fails to effectively utilize multi-dimensional features in tabular data visualization, resulting in high difficulty in adapting visual components and limited types of visual views generated, and a large amount of real data is required to be trained to adapt to data updates.
By obtaining column data of tabular data, determining the probability of belonging to different data types, and performing data feature mining and aggregation, matching with preset visualization components based on these probabilities and features to generate visualization images.
It realizes the automatic generation of multi-dimensional visual views of tabular data, increases the types and quality of visual views, reduces the special setting requirements for visual components, and is highly adaptable.
Smart Images

Figure CN118916419A_ABST
Abstract
Description
Technical Field
[0001] The present disclosure relates to the field of visualization, and in particular to a method and device for visualizing table data. Background Art
[0002] In the process of visualizing tabular data, the tabular data is usually visualized by matching visualization components according to the types of fields in the data or by training the model through an existing data set to generate a model of the visualization component. However, the method of matching visualization components by the types of fields in the data is only a match for data types and a match for some specific features, without considering the multi-dimensional characteristics of tabular data. The model training method requires a large number of real tables as training data sets, and every time the training data set is updated, the visualization component needs to be trained again, which makes the adaptation of the visualization component difficult. Summary of the invention
[0003] The present disclosure provides a method, device, electronic device and storage medium for visualizing tabular data, so as to at least solve the above technical problems existing in the prior art.
[0004] According to a first aspect of the present disclosure, a method for visualizing tabular data is provided, the method comprising: acquiring tabular data, wherein column data of the tabular data comprises data fields and data content; determining the probability that the column data belongs to different data types according to the data fields and the data content; performing data feature mining on the tabular data to obtain data feature mining results according to the probability that the column data belongs to different data types; and matching the tabular data with a preset visualization component based on the probability that the column data belongs to different data types and the data feature mining results to generate a visualization image of the tabular data.
[0005] In one possible implementation, after determining the probability that the column data belongs to different data types, the method further includes: performing data aggregation on the column data according to the probability that the column data belongs to different data types, to obtain data aggregation results corresponding to the column data belonging to different data types.
[0006] In one possible implementation, determining the probability that the column data belongs to different data types based on the data field and the data content includes: determining a first probability that the column data belongs to different data types based on the field content of the data field; determining a second probability that the column data belongs to different data types based on the data content; obtaining a first weight function corresponding to the data field and the data content; and determining the probability that the column data belongs to different data types based on the first weight function, the first probability, and the second probability.
[0007] In one possible implementation, the data feature mining performed on the tabular data to obtain the data feature mining results includes: based on the probability that the column data belongs to different data types, performing statistical feature mining on the tabular data to determine the statistical features of the column data; based on the probability that the column data belongs to different data types, performing visual feature mining on the tabular data to determine the visual features of the column data; obtaining a second weight function corresponding to the statistical features and the visual features; and determining the data feature mining results based on the second weight function, the statistical features, and the visual features.
[0008] In one possible implementation, the column data is aggregated according to the probability that the column data belongs to different data types to obtain data aggregation results corresponding to the column data belonging to different data types, including: determining the data type that meets the preset probability according to the probability that the column data belongs to different data types; for each type of data type that meets the preset probability, aggregating the data content of the column data by different aggregation methods to obtain sub-aggregation results of the corresponding aggregation methods; obtaining a third weight function corresponding to different aggregation methods; and determining the data aggregation results corresponding to the column data belonging to different data types based on the third weight function and multiple sub-aggregation results.
[0009] According to a second aspect of the present disclosure, a device for visualizing tabular data is provided, the device comprising: an acquisition module for acquiring tabular data, wherein column data of the tabular data comprises data fields and data content; a determination module for determining, based on the data fields and the data content, the probability that the column data belongs to different data types; a mining module for performing data feature mining on the tabular data to obtain data feature mining results based on the probability that the column data belongs to different data types; and a generation module for matching the tabular data with preset visualization components based on the probability that the column data belongs to different data types and the data feature mining results to generate a visualization image of the tabular data.
[0010] In one possible implementation, the device also includes: an aggregation module, which is used to, after determining the probability that the column data belongs to different data types, perform data aggregation on the column data according to the probability that the column data belongs to different data types, to obtain data aggregation results corresponding to the column data belonging to different data types.
[0011] In one possible implementation, the determination module includes: a first determination submodule, used to determine a first probability that the column data belongs to different data types based on the field content of the data field; the first determination submodule, also used to determine a second probability that the column data belongs to different data types based on the data content; a first acquisition submodule, used to acquire a first weight function corresponding to the data field and the data content; a second determination submodule, used to determine the probability that the column data belongs to different data types based on the first weight function, the first probability and the second probability.
[0012] In one possible implementation, the mining module includes a third determination submodule, which is used to perform statistical feature mining on the tabular data to determine the statistical features of the column data based on the probability that the column data belongs to different data types; the third determination submodule is used to perform visual feature mining on the tabular data to determine the visual features of the column data based on the probability that the column data belongs to different data types; a second acquisition submodule is used to acquire a second weight function corresponding to the statistical features and the visual features; and a fourth determination submodule is used to determine the data feature mining results based on the second weight function, the statistical features and the visual features.
[0013] In one possible implementation, the aggregation module includes: a fifth determination submodule, used to determine the data type that meets the preset probability based on the probability that the column data belongs to different data types; an aggregation submodule, used to, for each type of data type that meets the preset probability, perform data aggregation on the data content of the column data through different aggregation methods to obtain a sub-aggregation result of the corresponding aggregation method; a third acquisition submodule, used to obtain a third weight function corresponding to different aggregation methods; and a sixth determination submodule, used to determine the data aggregation result corresponding to the different data types that the column data belongs to based on the third weight function and multiple sub-aggregation results.
[0014] According to a third aspect of the present disclosure, there is provided an electronic device, including:
[0015] at least one processor; and
[0016] a memory communicatively connected to the at least one processor; wherein,
[0017] The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method described in the present disclosure.
[0018] According to a fourth aspect of the present disclosure, a non-transitory computer-readable storage medium storing computer instructions is provided, wherein the computer instructions are used to cause the computer to execute the method described in the present disclosure.
[0019] The present invention discloses a method, device, electronic device and storage medium for visualizing tabular data. First, tabular data is obtained. The column data of the tabular data includes data fields and data content. The probability that the column data belongs to different data types is determined based on the data fields and data content. Then, data feature mining is performed on the tabular data based on the probability to obtain data feature mining results. Based on the probability that the column data belongs to different data types and the data feature mining results, the tabular data is finally matched with a preset visualization component to generate a visualization image of the tabular data. By applying this method, by determining the probability that the column data belongs to different data types, aggregating the data, mining the data features and matching with the visualization components, the multi-dimensional features of the tabular data are utilized, and a visualization view of the entire amount of the tabular data can be automatically generated. The number of visualization views generated for users to select is larger, the visualization effect is better, and there is no need to set up corresponding visualization components specifically for the tabular data.
[0020] It should be understood that the content described in this section is not intended to identify the key or important features of the embodiments of the present disclosure, nor is it intended to limit the scope of the present disclosure. Other features of the present disclosure will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] The above and other objects, features and advantages of the exemplary embodiments of the present disclosure will become readily understood by reading the detailed description below with reference to the accompanying drawings. In the accompanying drawings, several embodiments of the present disclosure are shown in an exemplary and non-limiting manner, in which:
[0022] In the drawings, the same or corresponding reference numerals represent the same or corresponding parts.
[0023] Figure 1 The following is a schematic diagram showing the implementation process of a method for visualizing tabular data in an embodiment of the present disclosure. Figure 1 ;
[0024] Figure 2 The following is a schematic diagram showing the implementation process of a method for visualizing tabular data in an embodiment of the present disclosure. Figure 2 ;
[0025] Figure 3 The following is a schematic diagram showing the implementation process of a method for visualizing tabular data in an embodiment of the present disclosure. Figure 3 ;
[0026] Figure 4 The following is a schematic diagram showing the implementation process of a method for visualizing tabular data in an embodiment of the present disclosure. Figure 4 ;
[0027] Figure 5A schematic diagram of a module of a device for visualizing tabular data according to an embodiment of the present disclosure is shown;
[0028] Figure 6 A schematic diagram of the structure of an electronic device according to an embodiment of the present disclosure is shown. DETAILED DESCRIPTION
[0029] In order to make the purpose, features, and advantages of the present disclosure more obvious and easy to understand, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the drawings in the embodiments of the present disclosure. Obviously, the described embodiments are only part of the embodiments of the present disclosure, not all of the embodiments. Based on the embodiments in the present disclosure, all other embodiments obtained by those skilled in the art without creative work are within the scope of protection of the present disclosure.
[0030] Figure 1 The following is a schematic diagram showing the implementation process of a method for visualizing tabular data in an embodiment of the present disclosure. Figure 1 ,include:
[0031] Step 101 : obtaining table data, wherein column data of the table data includes data fields and data content.
[0032] First, obtain tabular data. Tabular data includes row data and column data. In this application, the column data of the tabular data includes data fields and data content. The data field is the column header, and the data content is the data corresponding to the column header of each column and related to the content represented by the column header. For example, the information of students in a class can generate a tabular data, which includes the students' name, height, age, class and other information. The row data can be the above information of a student, and the column data can be the height of the students in the class. When the column data is height, the data field included in the column data is "height", and the data content included in the column data is the height of each student.
[0033] Step 102: Determine the probability that the column data belongs to different data types according to the data field and the data content.
[0034] Determine the probability that the column data belongs to different data types according to the data field, determine the probability that the column data belongs to different data types according to the data content, and determine the probability of the column data according to the probability determined by the data field and the probability determined by the data content. That is, calculate the probability of the data type determined by the data field and the probability of the same data type determined by the data content to obtain the probability of the data type corresponding to the column data.
[0035] Step 103 , based on the probability that the column data belongs to different data types, data feature mining is performed on the tabular data to obtain a data feature mining result.
[0036] Based on each data type to which the column data belongs, data feature mining is performed on the tabular data to obtain data feature mining results, wherein data feature mining includes statistical feature mining and visual feature mining, and corresponding statistical feature mining results and visual feature mining results are obtained. The statistical feature mining results and the visual feature mining results are merged to obtain the data feature mining results of the column data of the tabular data.
[0037] Step 104 , based on the probability that the column data belongs to different data types and the data feature mining results, the tabular data is matched with a preset visualization component to generate a visualization image of the tabular data.
[0038] Based on the probability and data feature mining results that the column data belongs to different data types, the tabular data is matched with the preset visualization component, and a visualization image of the tabular data is generated according to the corresponding matching results. The visualization component in this application can be configured separately, without customized configuration according to the tabular data. When matching, it is matched according to the rules of the visualization component, such as matching with the dimensions and categories of the visualization component, for example, the visualization component of the histogram requires two dimensions, one for the numerical dimension and the other for the time dimension, then the column data that meets these two dimensions in the tabular data can be successfully matched with the visualization component of the histogram to generate the corresponding visualization view. In addition, the rules of the visualization component also include the data features supported by the visualization component and the visualization features supported by the visualization component, such as when the data content of the column data has a large amount of data, it is not suitable for the visualization component of the pie chart, when the amount of data is small, it is not suitable for the visualization component of the scatter plot, and the visualization component suitable for the trend line with a more obvious data content trend. Matching the tabular data with the preset visualization component generates more types of visualization images of the tabular data, which better meets user needs.
[0039] The present application first obtains tabular data, which includes data fields and data content, determines the probability that the column data belongs to different data types based on the data fields and data content, then performs data feature mining on the tabular data based on the probability to obtain data feature mining results, and finally matches the tabular data with a preset visualization component based on the probability that the column data belongs to different data types and the data feature mining results, and generates a visualization view of the tabular data. Applying this method, a visualization view of the entire tabular data can be automatically generated, and the number of visualization views generated for users to select is larger, the visualization effect is better, and there is no need to specifically set corresponding visualization components for the tabular data.
[0040] In one possible implementation, after determining the probability that the column data belongs to different data types, the method further includes: performing data aggregation on the column data according to the probability that the column data belongs to different data types to obtain data aggregation results corresponding to the column data belonging to different data types.
[0041] After determining the probability that the column data belongs to different data types, for each type of data to which the column data belongs and for the data content of the column data, data aggregation is performed on the column data through different aggregation methods to obtain the aggregation results corresponding to each aggregation method, and the data aggregation results corresponding to the data type of the column data are obtained according to the aggregation results corresponding to the different aggregation methods, such as setting corresponding weights for different aggregation methods, and determining the data aggregation results corresponding to the data type of the column data according to the aggregation results corresponding to each aggregation method and the weight corresponding to each aggregation method. Therefore, the data aggregation results corresponding to other data types of the column data can be determined in the same way.
[0042] It can be understood that after determining the probability that the column data belongs to different data types, the tabular data can be matched with preset visualization components to generate a visualization image of the tabular data based on the probability that the column data belongs to different data types, the data aggregation results corresponding to the column data belonging to different data types, and the data feature mining results.
[0043] In one possible implementation, Figure 2 As shown, the probability of column data belonging to different data types is determined based on the data field and data content, including:
[0044] Step 201, determining a first probability that column data belongs to different data types according to field content of a data field;
[0045] Step 202, determining a second probability that the column data belongs to a different data type according to the data content;
[0046] Step 203, obtaining a first weight function corresponding to the data field and the data content;
[0047] Step 204: Determine the probability that the column data belongs to different data types according to the first weight function, the first probability and the second probability.
[0048] The semantic processing model can be used to perform semantic processing on the field content of the data field to determine the processing result, which is the first probability that the field content belongs to different data types. In this application, different data types can be pre-set according to the table data, such as data types including: character data type, numeric data type, proportional data type, etc. If the field content of the data field included in the column data in the above example is "height", the height is identified through the semantic processing model, and it is identified that the proportion of the field content of "height" belonging to the numeric data type is 70%, the proportion belonging to the character data type is 20%, and the proportion belonging to the proportional data type is 10%.
[0049] The data content of the column data is identified to determine the second probability that the column data belongs to different data types. For example, in the above example, the data content included in the column data is the height of each student. By identifying the height value, it is found that the proportion of data content belonging to the numeric data type is 80%, the proportion belonging to the character data type is 15%, and the proportion belonging to the proportional data type is 5%.
[0050] Obtain a first weight function corresponding to the data field and the data content, the first weight function including the weights corresponding to the data field and the data content respectively. Determine the probability that the column data belongs to different data types according to the weights corresponding to the data field and the data content respectively, the first probability of the data field and the second probability of the data content, that is, process the probability that the data field and the data content belong to the same data type respectively with the weights of the data field and the data content. As in the above example, if the weight corresponding to the preset data field is 0.5, and the weight corresponding to the data content is also 0.5, the probability that the column data belongs to numerical data is determined by multiplying the weight corresponding to the data field and the proportion of the data field belonging to the numerical data type, and then adding the result of multiplying the weight corresponding to the data content and the proportion of the data content belonging to the numerical data type to obtain the probability that the column data belongs to the numerical data type. Similarly, the probability that the column data belongs to other data types can be obtained.
[0051] In one possible implementation, Figure 3 As shown, data feature mining is performed on the tabular data to obtain data feature mining results, including:
[0052] Step 301, based on the probability that the column data belongs to different data types, statistical feature mining is performed on the table data to determine the statistical features of the column data;
[0053] Step 302, based on the probability that the column data belongs to different data types, visual feature mining is performed on the tabular data to determine the visual features of the column data;
[0054] Step 303, obtaining a second weight function corresponding to the statistical feature and the visualization feature;
[0055] Step 304: determine the data feature mining result according to the second weight function, the statistical features and the visualization features.
[0056] Based on the probability that the column data belongs to different data types, the column data of the tabular data is subjected to statistical feature mining to determine the statistical features of the column data. The statistical features may include the sum, variance, Pearson coefficient, etc. of the data content in the column data, such as summing the data content to determine the sum of the data content as a statistical feature. Based on the probability that the column data belongs to different data types, the column data of the tabular data is subjected to visual feature mining to determine the visual features of the column data. The visual features include the extreme values and trend ranges of the data content in the column data, such as determining the extreme values of the column data according to the data content.
[0057] Obtain a second weight function corresponding to the statistical feature and the visual feature. The second weight function may be a weight corresponding to each statistical feature and the visual feature, or a weight corresponding to each statistical feature and each visual feature. Then determine the data feature mining result according to the second weight function, the statistical feature and the visual feature. Specifically, the product of the weight of the statistical feature and the sum of the eigenvalues corresponding to all the statistical features and the product of the weight of the visual feature and the sum of the eigenvalues corresponding to all the visual features may be added as the probability that the column data belongs to a certain type of data; or the sum of the product of the weight of each statistical feature and the visual feature and the eigenvalue of the corresponding statistical feature and the visual feature may be used as the probability that the column data belongs to a certain type of data.
[0058] In one possible implementation, Figure 4 As shown, according to the probability that the column data belongs to different data types, data aggregation is performed on the column data to obtain data aggregation results corresponding to the column data belonging to different data types, including:
[0059] Step 401, determining a data type that meets a preset probability according to the probability that the column data belongs to different data types;
[0060] Step 402: for each type of data that meets the preset probability, data content of the column data is aggregated by different aggregation methods to obtain a sub-aggregation result of the corresponding aggregation method;
[0061] Step 403, obtaining third weight functions corresponding to different aggregation modes;
[0062] Step 404: Determine, based on the third weight function and the multiple sub-aggregation results, whether the column data belongs to data aggregation results corresponding to different data types.
[0063] After obtaining the probability that the column data belongs to different data types, the probability that the column data belongs to different data types is screened based on the preset probability, the data types with a probability greater than the preset probability are retained, and the data types with a probability less than the preset probability are deleted. For example, the probability that the column data of the tabular data belongs to the numeric data type is 70%, the probability that it belongs to the character data type is 20%, and the probability that it belongs to the ratio data type is 10%. Assuming the preset probability is 15%, the numeric data type and the character data type are the data types that meet the preset probability.
[0064] For each type of data that meets the preset probability, the data content is clustered by different aggregation methods to obtain the sub-aggregation results of the corresponding aggregation methods. The aggregation methods in this application can be set according to the tabular data and the specific implementation scenarios, such as time aggregation, category aggregation, relationship aggregation, hierarchical aggregation, etc., that is, for each type of data type, the data content of the column data is aggregated by multiple aggregation methods to obtain the sub-aggregation results corresponding to each aggregation method. Different weights can be set for different aggregation methods, and the third weight function corresponding to different aggregation methods is obtained. The data aggregation results corresponding to the column data belonging to a certain type of data type are determined according to the third weight function and the sub-aggregation results corresponding to each aggregation method. Specifically, the sum of the products of the weight corresponding to each aggregation method and the sub-aggregation results corresponding to the corresponding aggregation method is used as the data aggregation results corresponding to the column data belonging to a certain type of data type. Similarly, the data aggregation results corresponding to each type of data type for the column data can be determined separately in the same way.
[0065] Figure 5 A module schematic diagram of a device for visualizing tabular data according to an embodiment of the present disclosure is shown.
[0066] See also Figure 5 According to a second aspect of the present disclosure, a device for visualizing tabular data is provided, the device comprising: an acquisition module 501, used to acquire tabular data, the column data of the tabular data comprising data fields and data content; a determination module 502, used to determine the probability that the column data belongs to different data types according to the data fields and the data content; a mining module 503, used to perform data feature mining on the tabular data according to the probability that the column data belongs to different data types to obtain data feature mining results; a generation module 504, used to match the tabular data with a preset visualization component based on the probability that the column data belongs to different data types and the data feature mining results, to generate a visualization image of the tabular data.
[0067] In one embodiment, the device also includes: an aggregation module 505, which is used to aggregate the column data according to the probability that the column data belongs to different data types after determining the probability that the column data belongs to different data types, to obtain data aggregation results corresponding to the column data belonging to different data types.
[0068] In one embodiment, the determination module 502 includes: a first determination submodule 5021, used to determine a first probability that the column data belongs to different data types based on the field content of the data field; the first determination submodule 5021, also used to determine a second probability that the column data belongs to different data types based on the data content; a first acquisition submodule 5022, used to acquire a first weight function corresponding to the data field and the data content; a second determination submodule 5023, used to determine the probability that the column data belongs to different data types based on the first weight function, the first probability and the second probability.
[0069] In one embodiment, the mining module 503 includes a third determination submodule 5031, which is used to perform statistical feature mining on the tabular data to determine the statistical features of the column data based on the probability that the column data belongs to different data types; the third determination submodule 5031 is used to perform visual feature mining on the tabular data to determine the visual features of the column data based on the probability that the column data belongs to different data types; the second acquisition submodule 5032 is used to acquire a second weight function corresponding to the statistical features and the visual features; and the fourth determination submodule 5033 is used to determine the data feature mining results based on the second weight function, the statistical features and the visual features.
[0070] In one embodiment, the aggregation module 505 includes: a fifth determination submodule 5051, used to determine the data type that meets the preset probability based on the probability that the column data belongs to different data types; an aggregation submodule 5052, used to, for each type of data type that meets the preset probability, perform data aggregation on the data content of the column data through different aggregation methods to obtain a sub-aggregation result of the corresponding aggregation method; a third acquisition submodule 5053, used to obtain a third weight function corresponding to different aggregation methods; a sixth determination submodule 5054, used to determine the data aggregation result corresponding to the column data belonging to different data types based on the third weight function and multiple sub-aggregation results.
[0071] According to an embodiment of the present disclosure, the present disclosure also provides an electronic device and a readable storage medium.
[0072] Figure 6A schematic block diagram of an example electronic device 800 that can be used to implement an embodiment of the present disclosure is shown. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workstations, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present disclosure described and / or required herein.
[0073] like Figure 6 As shown, the device 600 includes a computing unit 601, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 602 or a computer program loaded from a storage unit 608 into a random access memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the device 600 can also be stored. The computing unit 601, the ROM 602, and the RAM 603 are connected to each other via a bus 604. An input / output (I / O) interface 605 is also connected to the bus 604.
[0074] A number of components in the device 600 are connected to the I / O interface 605, including: an input unit 606, such as a keyboard, a mouse, etc.; an output unit 607, such as various types of displays, speakers, etc.; a storage unit 608, such as a disk, an optical disk, etc.; and a communication unit 609, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 609 allows the device 600 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.
[0075] The computing unit 601 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the computing unit 601 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, digital signal processors (DSPs), and any appropriate processors, controllers, microcontrollers, etc. The computing unit 601 performs the various methods and processes described above, such as a method for visualizing tabular data. For example, in some embodiments, a method for visualizing tabular data may be implemented as a computer software program, which is tangibly contained in a machine-readable medium, such as a storage unit 608. In some embodiments, part or all of the computer program may be loaded and / or installed on the device 600 via the ROM 602 and / or the communication unit 609. When the computer program is loaded into the RAM 603 and executed by the computing unit 601, one or more steps of the method for visualizing tabular data described above may be performed. Alternatively, in other embodiments, the computing unit 601 may be configured to perform a method for visualizing tabular data in any other appropriate manner (e.g., by means of firmware).
[0076] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.
[0077] The program code for implementing the method of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that the program code, when executed by the processor or controller, enables the functions / operations specified in the flow chart and / or block diagram to be implemented. The program code may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.
[0078] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
[0079] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the computer. Other types of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).
[0080] The systems and techniques described herein may be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), and the Internet.
[0081] A computer system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The relationship of client and server is generated by computer programs running on respective computers and having a client-server relationship with each other. The server may be a cloud server, a server of a distributed system, or a server combined with a blockchain.
[0082] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps recorded in this disclosure can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solutions disclosed in this disclosure can be achieved, and this document does not limit this.
[0083] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of the features. In the description of the present disclosure, the meaning of "plurality" is two or more, unless otherwise clearly and specifically defined.
[0084] The above is only a specific embodiment of the present disclosure, but the protection scope of the present disclosure is not limited thereto. Any person skilled in the art who is familiar with the technical field can easily think of changes or substitutions within the technical scope disclosed in the present disclosure, which should be included in the protection scope of the present disclosure. Therefore, the protection scope of the present disclosure should be based on the protection scope of the claims.
Claims
1. A method for visualizing tabular data, characterized in that: The method comprises: Acquire table data, wherein column data of the table data includes data fields and data content; Determine, according to the data field and the data content, the probability that the column data belongs to different data types; According to the probability that the column data belongs to different data types, data feature mining is performed on the table data to obtain a data feature mining result; Based on the probability that the column data belongs to different data types and the data feature mining result, the tabular data is matched with a preset visualization component to generate a visualization image of the tabular data.
2. The method according to claim 1, characterized in that: After determining the probability that the column data belongs to different data types, the method further includes: According to the probability that the column data belongs to different data types, data aggregation is performed on the column data to obtain data aggregation results corresponding to the column data belonging to different data types.
3. The method according to claim 1, characterized in that The determining, according to the data field and the data content, the probability that the column data belongs to different data types includes: Determining a first probability that the column data belongs to a different data type according to the field content of the data field; Determining, according to the data content, a second probability that the column data belongs to a different data type; Obtaining a first weight function corresponding to the data field and the data content; The probability that the column data belongs to different data types is determined according to the first weight function, the first probability, and the second probability.
4. The method according to claim 1, characterized in that: The performing data feature mining on the tabular data to obtain a data feature mining result includes: Based on the probability that the column data belongs to different data types, performing statistical feature mining on the tabular data to determine the statistical features of the column data; Based on the probability that the column data belongs to different data types, performing visual feature mining on the tabular data to determine the visual features of the column data; Obtaining a second weight function corresponding to the statistical feature and the visualization feature; The data feature mining result is determined according to the second weight function, the statistical feature and the visualization feature.
5. The method according to claim 2, characterized in that: The step of performing data aggregation on the column data according to the probability that the column data belongs to different data types to obtain data aggregation results corresponding to the column data belonging to different data types includes: Determine a data type that satisfies a preset probability according to the probability that the column data belongs to different data types; For each type of data that meets the preset probability, data content of the column data is aggregated by different aggregation methods to obtain a sub-aggregation result of the corresponding aggregation method; Obtain the third weight function corresponding to different aggregation methods; Based on the third weight function and multiple sub-aggregation results, it is determined that the column data belongs to data aggregation results corresponding to different data types.
6. A device for visualizing tabular data, characterized in that: The device comprises: An acquisition module, used for acquiring table data, wherein the column data of the table data includes data fields and data contents; A determination module, configured to determine the probability that the column data belongs to different data types according to the data field and the data content; A mining module, used for performing data feature mining on the tabular data to obtain data feature mining results according to the probability that the column data belongs to different data types; A generation module is used to match the tabular data with a preset visualization component based on the probability that the column data belongs to different data types and the data feature mining result, so as to generate a visualization image of the tabular data.
7. The device according to claim 6, characterized in that The device also includes: The aggregation module is used to, after determining the probability that the column data belongs to different data types, aggregate the column data according to the probability that the column data belongs to different data types to obtain data aggregation results corresponding to the column data belonging to different data types.
8. The device according to claim 6, characterized in that The determining module comprises: A first determination submodule, configured to determine a first probability that the column data belongs to different data types according to the field content of the data field; The first determining submodule is further used to determine a second probability that the column data belongs to a different data type according to the data content; A first acquisition submodule, used to acquire a first weight function corresponding to the data field and the data content; The second determining submodule is used to determine the probability that the column data belongs to different data types according to the first weight function, the first probability and the second probability.
9. An electronic device, characterized in that: include: at least one processor; as well as a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 5.
10. A non-transitory computer-readable storage medium storing computer instructions, characterized in that: The computer instructions are used to cause the computer to execute the method according to any one of claims 1-5.
Citation Information
Patent Citations
Intelligent chart recommendation system and method
CN110377659A
Data exploration method and device and storage medium
CN113946741A
Data interactive transformation and visual embedding method for complex table
CN115391371A
Data visualization type recommendation method using meta information
KR1020170046881A
Cited By
Data intelligent question and answer ChatBI method and device based on large model
CN120804144A
A large model-based data intelligent question answering ChatBI method and device
CN120804144B
