CN111159987A - Data chart drawing method, device, equipment and computer readable storage medium - Google Patents
Data chart drawing method, device, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN111159987A CN111159987A CN201911401699.1A CN201911401699A CN111159987A CN 111159987 A CN111159987 A CN 111159987A CN 201911401699 A CN201911401699 A CN 201911401699A CN 111159987 A CN111159987 A CN 111159987A
- Authority
- CN
- China
- Prior art keywords
- chart
- data
- user
- template
- intention
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000010586 diagram Methods 0.000 claims abstract description 47
- 238000012545 processing Methods 0.000 claims abstract description 20
- 238000004590 computer program Methods 0.000 claims description 10
- 239000003086 colorant Substances 0.000 claims description 4
- 238000003066 decision tree Methods 0.000 claims description 4
- 238000009877 rendering Methods 0.000 claims description 2
- 230000008569 process Effects 0.000 description 14
- 239000000523 sample Substances 0.000 description 10
- 238000004891 communication Methods 0.000 description 6
- 238000012549 training Methods 0.000 description 6
- 239000000284 extract Substances 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 241000227653 Lycopersicon Species 0.000 description 3
- 235000007688 Lycopersicon esculentum Nutrition 0.000 description 3
- 230000009471 action Effects 0.000 description 3
- 238000010801 machine learning Methods 0.000 description 3
- 238000013528 artificial neural network Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 235000015278 beef Nutrition 0.000 description 1
- 238000010425 computer drawing Methods 0.000 description 1
- 238000013075 data extraction Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000002068 genetic effect Effects 0.000 description 1
- 235000013372 meat Nutrition 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000012706 support-vector machine Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
- G06F16/3343—Query execution using phonetics
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
- G06F16/3344—Query execution using natural language analysis
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- General Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Acoustics & Sound (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a data chart drawing method, which comprises the following steps: when a data chart drawing request is received, acquiring user voice information corresponding to the data chart drawing request, and acquiring initial chart data corresponding to the data chart drawing request; analyzing the user voice information to obtain user intention, and selecting a chart template according to the user intention; processing the initial chart data according to the chart template to obtain standard chart data; and adjusting the chart template according to the standard chart data to generate a data chart corresponding to the data chart drawing request. The invention also discloses a data chart drawing device, equipment and a computer readable storage medium. According to the invention, the voice information of the user is analyzed to determine the user intention, and the data diagram is drawn according to the user intention, so that the operation of drawing the data diagram is more convenient.
Description
Technical Field
The present invention relates to the field of graph processing, and in particular, to a data graph drawing method, apparatus, device, and computer-readable storage medium.
Background
With the rapid development of computer technology, computers are increasingly applied in people's lives, and the computers can be used for data chart drawing operations.
In the current computer drawing, a data chart processing software, such as an Excel tool, is opened in a computer by a user, and the data chart processing software is selected and provided in the data chart processing software for data chart drawing.
Disclosure of Invention
The invention mainly aims to provide a data chart drawing method, a data chart drawing device, data chart drawing equipment and a computer readable storage medium, and aims to solve the technical problems that the current data chart drawing operation is troublesome and the data chart drawing efficiency is low.
In order to achieve the above object, the present invention provides a data chart drawing method, including the steps of:
when a data chart drawing request is received, acquiring user voice information corresponding to the data chart drawing request, and acquiring initial chart data corresponding to the data chart drawing request;
analyzing the user voice information to obtain user intention, and selecting a chart template according to the user intention;
processing the initial chart data according to the chart template to obtain standard chart data;
and adjusting the chart template according to the standard chart data to generate a data chart corresponding to the data chart drawing request.
In an embodiment, the step of obtaining the initial chart data corresponding to the data chart drawing request includes:
reading an original data file associated with the data chart drawing request, and extracting initial chart data contained in the original data file;
if the original data file associated with the data chart drawing request does not exist, recognizing the user voice information to obtain text information corresponding to the user voice information;
if the text information does not contain the database identification, outputting prompt information to prompt a user to input an original data file or input new user voice information;
if the text information contains a database identifier, acquiring an sql instruction corresponding to the database identifier, executing the sql instruction to query a database corresponding to the database identifier, and acquiring initial chart data corresponding to the data chart drawing request.
In an embodiment, the step of analyzing the user voice information to obtain a user intention and selecting a chart template according to the user intention includes:
inputting the user voice information into an intention recognizer, and processing the user voice information through the intention recognizer according to a regular expression to obtain user intention;
when the user intention is comparison intention, selecting a preset time sequence chart template, a bar chart template or an area chart template as a chart template;
when the user intention is a relation intention, selecting a preset scatter diagram template, a bubble diagram template, a radar diagram template or a parallel coordinate diagram template as a diagram template;
and when the user intention is the analysis intention, selecting a preset tree diagram template or a pie diagram template as a chart template.
In an embodiment, the step of processing the initial chart data according to the chart template to obtain standard chart data includes:
acquiring a data dimension corresponding to the chart template, and extracting target chart data corresponding to the data dimension from the initial chart data;
classifying the target chart data according to respective data types to obtain data subsets of different data types;
unifying the data units of the target chart data in the data subset, and summarizing the target chart data in the data subset to obtain standardized data.
In an embodiment, the step of adjusting the chart template according to the standard chart data to generate the data chart corresponding to the data chart drawing request includes:
obtaining chart elements in the chart template, and establishing an association relation between the chart elements and the standard chart data according to a decision tree model;
adding the standard chart data into the chart elements according to the association relationship, adjusting the colors of the chart elements according to the attributes of the standard chart data, adjusting the sizes of the chart elements according to the numerical values of the standard chart data, and/or adjusting the positions of the chart elements according to the generation time of the standard chart data to obtain the data chart corresponding to the data chart drawing request.
In an embodiment, after the step of adjusting the chart template according to the standard chart data to generate the data chart corresponding to the data chart drawing request, the method includes:
when a chart editing request is received, outputting a chart editing window for a user to configure chart information based on the chart editing window, wherein the chart information comprises: chart element information, chart color information, chart size information, and/or display format information;
receiving chart information configured on the basis of the chart editing window, and adjusting the data chart according to the chart information.
In an embodiment, after the step of acquiring the user voice information corresponding to the data chart drawing request when the data chart drawing request is received, the method includes:
carrying out voiceprint recognition on the user voice information to obtain a voiceprint recognition result, and judging whether the user voice information belongs to the same user according to the voiceprint recognition result;
and when the user voice information does not belong to the same user, selecting the target voice information which is closest to the user in the user voice information for analysis to obtain the user intention, and selecting the chart template according to the user intention.
In addition, to achieve the above object, the present invention provides a data chart drawing device including:
the data acquisition module is used for acquiring user voice information corresponding to a data chart drawing request and acquiring initial chart data corresponding to the data chart drawing request when the data chart drawing request is received;
the analysis selection module is used for analyzing the user voice information to obtain user intention and selecting a chart template according to the user intention;
the data processing module is used for processing the initial chart data according to the chart template to obtain standard chart data;
and the chart generation module is used for adjusting the chart template according to the standard chart data and generating a data chart corresponding to the data chart drawing request.
In addition, in order to achieve the above object, the present invention also provides a data diagram drawing apparatus;
the data chart drawing device includes: a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein:
the computer program, when executed by the processor, implements the steps of the data charting method as described above.
In addition, to achieve the above object, the present invention also provides a computer-readable storage medium;
the computer-readable storage medium has stored thereon a computer program which, when being executed by a processor, carries out the steps of the data diagram rendering method as described above.
According to the data chart drawing method, the data chart drawing device, the data chart drawing equipment and the computer readable storage medium, when a data chart drawing request is received, user voice information corresponding to the data chart drawing request is obtained, and initial chart data corresponding to the data chart drawing request is obtained; analyzing the user voice information to obtain user intention, and selecting a chart template according to the user intention; processing the initial chart data according to the chart template to obtain standard chart data; and adjusting the chart template according to the standard chart data to generate a data chart corresponding to the data chart drawing request. According to the embodiment of the invention, the user intention is obtained by analyzing the voice information of the user, the data chart drawing equipment draws the data chart according to the user intention, the user does not need to process initial chart data related to the data chart in the process, the data chart drawing equipment can automatically process data to generate the required data chart, the operation convenience of the user is improved, and meanwhile, the generation efficiency of the data chart is effectively ensured.
Drawings
FIG. 1 is a schematic diagram of an apparatus in a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart diagram illustrating a first exemplary embodiment of a data diagram plotting method according to the present invention;
FIG. 3 is a schematic flow chart diagram illustrating a data diagram plotting method according to a second embodiment of the present invention;
FIG. 4 is a schematic flow chart diagram illustrating a data diagram plotting method according to a third embodiment of the present invention;
fig. 5 is a functional block diagram of an embodiment of a data chart drawing apparatus according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As shown in fig. 1, fig. 1 is a schematic structural diagram of a server (also called a data chart drawing device, where the data chart drawing device may be formed by a separate data chart drawing device or may be formed by combining other devices with the data chart drawing device) in a hardware operating environment according to an embodiment of the present invention.
The server in the embodiment of the invention refers to a computer for managing resources and providing services for users, and is generally divided into a file server, a database server and an application server. The computer or computer system running the above software is also referred to as a server. Compared with a common PC (personal computer), the server has higher requirements on stability, safety, performance and the like; as shown in fig. 1, the server may include: the processor 1001 includes, for example, a Central Processing Unit (CPU), a network interface 1004, a user interface 1003, a memory 1005, a communication bus 1002, a chipset, a disk system, hardware such as a network, and the like. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a WIreless interface (e.g., WIFI interface, WIreless FIdelity, WIFI interface). The memory 1005 may be a Random Access Memory (RAM) or a non-volatile memory (e.g., a disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.
Optionally, the server may further include a camera, a Radio Frequency (RF) circuit, a sensor, an audio circuit, and a WiFi module; the input unit is compared with a display screen and a touch screen; the network interface can be selected from the wireless interface, such as Bluetooth, a probe and the like except WiFi. Those skilled in the art will appreciate that the server architecture shown in FIG. 1 is not meant to be limiting, and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, the computer software product is stored in a computer readable storage medium (computer readable storage medium: computer medium, readable storage medium, computer storage medium or direct call medium, etc., the computer readable storage medium may be a non-volatile readable storage medium, such as RAM, magnetic disk, optical disk, etc.), and includes several instructions for enabling a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to execute the method according to the embodiments of the present invention, and a memory 1005 as a computer readable storage medium may include an operating system, a network communication module, a user interface module, and a computer program.
In the server shown in fig. 1, the network interface 1004 is mainly used for connecting to a background database and performing data communication with the background database; the user interface 1003 is mainly used for connecting a client (client, also called user side or terminal, the terminal in the embodiment of the present invention may be a fixed terminal or a mobile terminal, for example, an intelligent air conditioner with networking function, an intelligent electric lamp, an intelligent power supply, an intelligent sound box, an automatic driving car, a PC, a smart phone, a tablet computer, an electronic book reader, a portable computer, etc., the terminal includes sensors such as a light sensor, a motion sensor, and other sensors, which are not described herein again), and performs data communication with the client; and the processor 1001 may be configured to call a computer program stored in the memory 1005 and perform steps in the data diagram drawing method provided by the following embodiment of the present invention.
Referring to fig. 2, in a first embodiment of a data diagram drawing method according to the present invention, the data diagram drawing method includes:
step S10, when receiving the data chart drawing request, acquiring user voice information corresponding to the data chart drawing request, and acquiring initial chart data corresponding to the data chart drawing request.
The data chart drawing method in the embodiment is applied to data chart drawing equipment, the data chart drawing equipment receives a data chart drawing request, and the triggering mode of the data chart drawing request is not specifically limited, that is, the data chart drawing request can be actively triggered by a user, for example, the user clicks a chart drawing key on the data chart drawing equipment to trigger the data chart drawing request; in addition, the data chart drawing request may also be automatically triggered by the data chart drawing device, for example, the data chart drawing device is preset with the data chart drawing conditions: and when the data updating is detected, the data chart drawing equipment automatically triggers a data chart drawing request.
When the data chart drawing equipment receives a data chart drawing request, the data chart drawing equipment starts a preset voice collecting device, the voice collecting device can be a microphone, the data chart drawing equipment controls the voice collecting device to collect user voice information, the data chart drawing equipment takes the user voice information as user voice information corresponding to the data chart drawing request, and the data chart drawing equipment obtains the user voice information.
The data chart drawing device obtains initial chart data corresponding to the data chart drawing request, and specifically, the data chart drawing device analyzes the user voice information to obtain data source information (the data source information may refer to information for identifying a data source, for example, the data source information may be a database name or a data table name) in the user voice information, and the data chart drawing device obtains the initial chart data corresponding to the data chart drawing request from the data source corresponding to the data source information.
In this embodiment, the data diagram drawing device draws a data image according to the user voice information and the initial diagram data, specifically:
and step S20, analyzing the user voice information to obtain a user intention, and selecting a chart template according to the user intention.
The data graph drawing device performs speech recognition on the user speech information to obtain text information corresponding to the user speech information, the speech recognition mode of the user is not particularly limited, and specifically, the data graph drawing device may perform linguistic and acoustic methods, a random model method, a method using an artificial neural network, or a probabilistic grammar analysis.
After obtaining the text information corresponding to the user voice information, the data diagram drawing device determines the user intention according to the text information, specifically:
the implementation mode is as follows: and the data chart drawing equipment deletes redundant information in the text information, extracts keywords in the text information, and combines the keywords to obtain the user intention. That is, the data chart drawing device removes redundant words according to semantic relationships (relationships between concepts and meanings used in the semantic relationship reflection language) in the text information, that is, the data chart drawing device removes synonyms (words whose attribute names have almost the same or similar meanings, for example, "USA" is a synonym of "USA"); the data charting device removes the hypername (a hypername is a generic term that specifies the entire class of a particular attribute, e.g., "meat" is a hypernoun for "beef"); the data charting apparatus removes duplicate whole words (whole words refer to terms indicating a part of the whole or a part of the whole as opposed to, for example, "car" is a whole word of "wheel"); and combining the keywords obtained after the redundant words are removed by the data chart drawing equipment to obtain the user intention.
The implementation mode two is as follows: and the data chart drawing equipment compares the text information with each intention information in a preset intention list, and acquires the intention information matched with the text information as a drawing operation instruction. That is, the data chart drawing device calculates the similarity of the text information to each intention information in the preset intention list, and if there is intention information whose similarity to the text information is higher than a preset threshold, the data chart drawing device regards the intention information as the user intention matching the text information.
Then, the data chart drawing device selects the chart template according to the user's intention, for example, the user voice message is "compare prices of apple and tomato", the data chart drawing device determines that the user's intention is the comparison intention, the data chart drawing device determines that both the apple and the tomato have the same unit (price), the data chart drawing device selects the line chart template as the chart template, and then, the prices of the apple and the tomato are placed on the y-axis, and the time is taken as the x-axis.
And step S30, processing the initial chart data according to the chart template to obtain standard chart data.
The data chart drawing device processes the initial chart data according to the chart template to obtain standard chart data required by the chart template, and specifically comprises the following steps:
a1, acquiring data dimensions corresponding to the chart template, and extracting target chart data corresponding to the data dimensions from the initial chart data;
step a2, classifying the target chart data according to respective data types to obtain data subsets of different data types;
step a3, unifying the data units of the target chart data in the data subset, and summarizing the target chart data in the data subset to obtain standardized data.
The data dimension mapping method includes that data dimension corresponding to a chart template is obtained by data chart drawing equipment, namely, a chart template and data dimension mapping relation is preset in the data chart drawing equipment, the data dimension corresponding to the chart template is obtained by the data chart drawing equipment, the data dimension comprises a time dimension, a space dimension and the like, and the data chart drawing equipment extracts target chart data corresponding to the data dimension from initial chart data; the data chart drawing equipment classifies the target chart data according to respective data types to obtain data subsets of different data types; the data chart drawing equipment unifies data units of the target chart data in the data subset, and the target chart data in the data subset are summarized to obtain standardized data.
And step S40, adjusting the chart template according to the standard chart data, and generating a data chart corresponding to the data chart drawing request.
The data chart drawing equipment adjusts the chart template according to the standard chart data to generate the data chart corresponding to the data chart drawing request, and specifically comprises the following steps:
b1, acquiring chart elements in the chart template, and establishing an association relationship between the chart elements and the standard chart data according to a decision tree model;
b2, adding the standard chart data into the chart elements according to the association relationship, adjusting the colors of the chart elements according to the attributes of the standard chart data, adjusting the sizes of the chart elements according to the numerical values of the standard chart data, and/or adjusting the positions of the chart elements according to the generation time of the standard chart data to obtain the data chart corresponding to the data chart drawing request.
In the embodiment, the user intention is obtained by analyzing the voice information of the user, the data chart drawing equipment draws the data chart according to the user intention, the user does not need to process initial chart data related to the data chart in the process, the data chart drawing equipment can automatically process data to generate a required data chart, the operation convenience of the user is improved, and meanwhile the generation efficiency of the data chart is effectively ensured.
Further, referring to fig. 3, a second embodiment of the data chart drawing method of the present invention is proposed on the basis of the first embodiment of the present invention.
This embodiment is a refinement of step S10 in the first embodiment, and this embodiment provides a specific implementation manner of obtaining initial chart data, including:
step S11, reading the original data file associated with the data chart drawing request, and extracting the initial chart data included in the original data file.
And the data chart drawing equipment reads the original data file associated with the data chart drawing request, and extracts the initial chart data contained in the original data file.
Step S12, if there is no original data file associated with the data chart drawing request, recognizing the user voice information, and obtaining text information corresponding to the user voice information.
And the data chart drawing equipment judges that an original data file associated with the data chart drawing request does not exist, identifies the voice information of the user to obtain text information corresponding to the voice information of the user, and judges whether the text information contains a database identifier or not.
Step S13, if the text information does not include the database identifier, outputting a prompt message to prompt the user to input the original data file or input new user voice information.
If the text information does not contain the database identification, the data chart drawing equipment outputs prompt information to prompt a user to input an original data file or input new user voice information.
Step S14, if the text information includes a database identifier, acquiring an sql instruction corresponding to the database identifier, executing the sql instruction to query the database corresponding to the database identifier, and acquiring initial chart data corresponding to the data chart drawing request.
And if the text information contains a database identifier, the data chart drawing equipment acquires an sql instruction corresponding to the database identifier, executes the sql instruction to query the database corresponding to the database identifier, and acquires initial chart data corresponding to the data chart drawing request. In the data chart drawing device in the embodiment, the initial chart data corresponding to the data chart drawing request can be obtained by analyzing the original data file or querying the database, so that the initial chart data does not need to be manually input by a user, the operation of the user is reduced, and the chart data generation efficiency is further improved.
Further, referring to fig. 4, a third embodiment of the data chart drawing method of the present invention is proposed on the basis of the first embodiment of the present invention.
The present embodiment is a refinement of step S20 in the first embodiment, and the specific implementation manner of extracting topic feature data in a user speech sample and generating an intention recognizer is provided in the present embodiment, and includes:
and step S21, inputting the user voice information into an intention recognizer, and processing the user voice information through the intention recognizer according to a regular expression to obtain the user intention.
Before the data graph drawing equipment draws the data image, the data image drawing equipment needs to construct an intention recognizer, and the intention recognizer is constructed in a machine learning mode; specifically, the data image drawing device firstly obtains a user voice sample set used for training a model, the user voice sample set comprises different user voice samples, and the data image drawing device uses the user voice samples in the user voice sample set to perform machine learning and train to obtain an intention recognizer. The machine learning process can be realized in various ways such as a neural network, a genetic algorithm, a support vector machine and the like.
Specifically, the data chart drawing device defines sample attributes according to the recognition requirements, may randomly extract a plurality of proportions of user voice samples in the user voice sample set as primary training samples, and train the initial recognition function using the primary training samples, where in the primary training, the initial recognition function may be determined randomly or by some constraint conditions. After one training, the data image drawing device extracts samples with the same proportion from the user voice sample set to serve as iteration samples, and continuously adjusts the initial recognition function by using the iteration samples until the correct separation rate of the samples reaches a preset threshold (the preset threshold refers to a preset critical value, for example, the preset threshold is set to be 98%), that the training is finished is considered, and the intention recognizer is obtained.
The data graph drawing equipment inputs user voice information to an intention recognizer, the intention recognizer processes the user voice information according to a regular expression to obtain user intention, namely the intention recognizer conducts voice recognition on the user voice information to obtain text information, then the intention recognizer conducts character string division on the text information, and the data graph drawing equipment matches the divided character strings with the regular expression to obtain the user intention.
In the embodiment, the intention recognizer is used for accurately recognizing the user voice information to obtain the user intention corresponding to the user voice information, namely, the user tells the data chart drawing equipment what the user wants to see, and the data chart drawing equipment can recognize the user intention and intelligently create the visualization.
And step S22, when the user intention is comparison intention, selecting a preset time sequence chart template, a bar chart template or an area chart template as a chart template.
When the user intention is the comparison intention, the data chart drawing equipment selects a preset time sequence chart template, a bar chart template or an area chart template as a chart template; specifically, the data chart drawing device determines that the user intention is the comparison intention, the data chart drawing device acquires a time series chart template, a bar chart template and an area chart template corresponding to the comparison intention, then the data chart drawing device can acquire the time series chart template, the bar chart template or the area chart template which is the most frequently used by the user as the chart template, and in addition, the data chart drawing device can also output an interface containing the time series chart template, the bar chart template and the area chart template to prompt the user to select.
And step S23, when the user intention is the relationship intention, selecting a preset scatter diagram template, a bubble diagram template, a radar diagram template or a parallel coordinate diagram template as a diagram template.
When the user intention is a relationship intention, that is, the user focuses on finding the correlation between two or more attributes, the data graph drawing device selects a preset scattergram template, a bubble graph template, a radar graph template or a parallel coordinate graph template as a graph template, for example, people known to each other in a social network or web pages connected to each other, and the graph template may display the structure or interconnection between all data entities in the grid graph.
Step S24, when the user intention is an analysis intention, selecting a preset tree diagram template or a pie diagram template as a diagram template.
When the user intent is an analysis intent, i.e., the analysis intent includes the task of summarizing features or patterns of the sample data by numerically describing the data observed in the sample using statistical methods. Examples of digital descriptions include: mean or standard deviation, amount calculated from a set of consecutive data; and the composition or percentage is used for displaying the classification data structure or the composition amount, and the data chart drawing equipment selects a preset tree chart template or pie chart template as a chart template.
In the embodiment, the data chart drawing equipment analyzes the voice information of the user instead of keyword matching, can capture the input important language features, better understand the intention of the user, and possibly provide a more relevant chart template for the user, so that the chart data is accurately displayed.
Further, on the basis of the above-described embodiment of the present invention, a fourth embodiment of the data chart drawing method of the present invention is proposed.
This embodiment is a step after step S40 in the first embodiment, and is different from the above embodiment in that:
when a chart editing request is received, outputting a chart editing window for a user to configure chart information based on the chart editing window, wherein the chart information comprises: chart element information, chart color information, chart size information, and/or display format information;
receiving chart information configured on the basis of the chart editing window, and adjusting the data chart according to the chart information.
That is, the data chart drawing device receives the chart editing request, and when receiving the chart editing request, the data chart drawing device outputs a chart editing window for the user to configure the chart information based on the chart editing window, wherein the chart information includes: chart element information (chart element information includes a deleted chart element), chart color information (image), chart size information, and/or display format information.
The data chart drawing equipment receives the chart information configured based on the chart editing window, and adjusts the data chart according to the chart information.
Further, a fifth embodiment of the data chart drawing method of the present invention is proposed on the basis of the above-described embodiments of the present invention.
This embodiment is a step after step S40 in the first embodiment, and is different from the above embodiment in that:
carrying out voiceprint recognition on the user voice information to obtain a voiceprint recognition result, and judging whether the user voice information belongs to the same user according to the voiceprint recognition result;
and when the user voice information does not belong to the same user, selecting the target voice information which is closest to the user in the user voice information for analysis to obtain the user intention, and selecting the chart template according to the user intention.
The data chart drawing equipment judges whether the user voice information belongs to the same user according to the voiceprint recognition result; when the user voice information belongs to the same user, directly obtaining user intention for the user voice information, and selecting a chart template according to the user intention; when the voice information of the users do not belong to the same user, the data chart drawing equipment selects the target voice information which is closest to the user in the voice information of the users to analyze so as to obtain the user intention, and selects the chart template according to the user intention.
In this embodiment, the data graph drawing device performs voiceprint recognition on the user voice information, determines whether the user voice information belongs to the same user according to a voiceprint recognition result, selects target voice information, which is closest to the user, in the user voice information to analyze when the user voice information does not belong to the same user, and determines interference voice according to the distance to reduce the processing amount of the user voice information, thereby achieving the purpose of improving the data graph generation efficiency.
In addition, referring to fig. 5, an embodiment of the present invention further provides a data chart drawing device, where the data chart drawing device includes:
the data acquisition module 10 is configured to, when a data chart drawing request is received, acquire user voice information corresponding to the data chart drawing request, and acquire initial chart data corresponding to the data chart drawing request;
the analysis selection module 20 is used for analyzing the user voice information to obtain user intention and selecting a chart template according to the user intention;
the data processing module 30 is configured to process the initial chart data according to the chart template to obtain standard chart data;
and the chart generating module 40 is configured to adjust the chart template according to the standard chart data, and generate a data chart corresponding to the data chart drawing request.
In one embodiment, the data acquisition module 10 includes:
the data extraction unit is used for reading an original data file associated with the data chart drawing request and extracting initial chart data contained in the original data file;
the voice recognition unit is used for recognizing the user voice information if an original data file associated with the data chart drawing request does not exist, and obtaining text information corresponding to the user voice information;
the prompt input unit is used for outputting prompt information to prompt a user to input an original data file or input new user voice information if the text information does not contain the database identification;
and the data query unit is used for acquiring an sql instruction corresponding to the database identifier if the text information contains the database identifier, executing the sql instruction to query the database corresponding to the database identifier, and acquiring initial chart data corresponding to the data chart drawing request.
In one embodiment, the parsing selection module 20 includes:
the intention determining unit is used for inputting the user voice information into an intention recognizer and processing the user voice information through the intention recognizer according to a regular expression to obtain user intention;
the first selection unit is used for selecting a preset time sequence chart template, a bar chart template or an area chart template as a chart template when the user intention is comparison intention;
the second selection unit is used for selecting a preset scatter diagram template, a bubble diagram template, a radar diagram template or a parallel coordinate diagram template as a diagram template when the user intention is a relationship intention;
and the third selection unit is used for selecting a preset tree drawing template or a pie drawing template as a chart template when the user intention is an analysis intention.
In one embodiment, the data processing module 30 includes:
the data acquisition unit is used for acquiring the data dimension corresponding to the chart template and extracting target chart data corresponding to the data dimension from the initial chart data;
the data classification unit is used for classifying the target chart data according to respective data types to obtain data subsets of different data types;
and the data summarizing unit is used for unifying the data units of the target chart data in the data subset and summarizing the target chart data in the data subset to obtain standardized data.
In one embodiment, the chart generation module 30 includes:
the obtaining association unit is used for obtaining chart elements in the chart template and establishing association relation between the chart elements and the standard chart data according to a decision tree model;
and the adjustment generating unit is used for adding the standard chart data into the chart elements according to the association relationship, adjusting the colors of the chart elements according to the attributes of the standard chart data, adjusting the sizes of the chart elements according to the numerical values of the standard chart data, and/or adjusting the positions of the chart elements according to the generation time of the standard chart data to obtain the data chart corresponding to the data chart drawing request.
In one embodiment, the data chart drawing apparatus includes:
a window output module, configured to output a chart editing window when a chart editing request is received, so that a user configures chart information based on the chart editing window, where the chart information includes: chart element information, chart color information, chart size information, and/or display format information;
and the chart adjusting module is used for receiving the chart information configured on the basis of the chart editing window and adjusting the data chart according to the chart information.
In one embodiment, the parsing selection module 20 includes:
the voiceprint recognition unit is used for carrying out voiceprint recognition on the user voice information to obtain a voiceprint recognition result, and judging whether the user voice information belongs to the same user or not according to the voiceprint recognition result;
and the voice selection unit is used for selecting the target voice information which is closest to the user in the user voice information to analyze when the user voice information does not belong to the same user, so as to obtain the user intention, and selecting the chart template according to the user intention.
The steps implemented by the functional modules of the data chart drawing device may refer to the embodiments of the data chart drawing method of the present invention, and are not described herein again.
In addition, the embodiment of the invention also provides a computer readable storage medium.
The computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the operations in the data chart drawing method provided by the above-described embodiments.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity/action/object from another entity/action/object without necessarily requiring or implying any actual such relationship or order between such entities/actions/objects; the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
For the apparatus embodiment, since it is substantially similar to the method embodiment, it is described relatively simply, and reference may be made to some descriptions of the method embodiment for relevant points. The above-described apparatus embodiments are merely illustrative, in that elements described as separate components may or may not be physically separate. Some or all of the modules can be selected according to actual needs to achieve the purpose of the scheme of the invention. One of ordinary skill in the art can understand and implement it without inventive effort.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A data chart drawing method, characterized by comprising the steps of:
when a data chart drawing request is received, acquiring user voice information corresponding to the data chart drawing request, and acquiring initial chart data corresponding to the data chart drawing request;
analyzing the user voice information to obtain user intention, and selecting a chart template according to the user intention;
processing the initial chart data according to the chart template to obtain standard chart data;
and adjusting the chart template according to the standard chart data to generate a data chart corresponding to the data chart drawing request.
2. The data chart drawing method according to claim 1, wherein the step of obtaining initial chart data corresponding to the data chart drawing request includes:
reading an original data file associated with the data chart drawing request, and extracting initial chart data contained in the original data file;
if the original data file associated with the data chart drawing request does not exist, recognizing the user voice information to obtain text information corresponding to the user voice information;
if the text information does not contain the database identification, outputting prompt information to prompt a user to input an original data file or input new user voice information;
if the text information contains a database identifier, acquiring an sql instruction corresponding to the database identifier, executing the sql instruction to query a database corresponding to the database identifier, and acquiring initial chart data corresponding to the data chart drawing request.
3. A method for drawing a data chart according to claim 1, wherein said step of analyzing said user voice information to obtain a user intention and selecting a chart template according to said user intention comprises:
inputting the user voice information into an intention recognizer, and processing the user voice information through the intention recognizer according to a regular expression to obtain user intention;
when the user intention is comparison intention, selecting a preset time sequence chart template, a bar chart template or an area chart template as a chart template;
when the user intention is a relation intention, selecting a preset scatter diagram template, a bubble diagram template, a radar diagram template or a parallel coordinate diagram template as a diagram template;
and when the user intention is the analysis intention, selecting a preset tree diagram template or a pie diagram template as a chart template.
4. The method of data charting of claim 1, wherein said step of processing said initial chart data in accordance with said chart template to obtain standard chart data comprises:
acquiring a data dimension corresponding to the chart template, and extracting target chart data corresponding to the data dimension from the initial chart data;
classifying the target chart data according to respective data types to obtain data subsets of different data types;
unifying the data units of the target chart data in the data subset, and summarizing the target chart data in the data subset to obtain standardized data.
5. The method for drawing a data chart according to claim 1, wherein the step of adjusting the chart template according to the standard chart data to generate the data chart corresponding to the data chart drawing request includes:
obtaining chart elements in the chart template, and establishing an association relation between the chart elements and the standard chart data according to a decision tree model;
adding the standard chart data into the chart elements according to the association relationship, adjusting the colors of the chart elements according to the attributes of the standard chart data, adjusting the sizes of the chart elements according to the numerical values of the standard chart data, and/or adjusting the positions of the chart elements according to the generation time of the standard chart data to obtain the data chart corresponding to the data chart drawing request.
6. The method of claim 1, wherein the step of adjusting the chart template based on the standard chart data to generate the data chart corresponding to the data chart drawing request comprises, after the step of:
when a chart editing request is received, outputting a chart editing window for a user to configure chart information based on the chart editing window, wherein the chart information comprises: chart element information, chart color information, chart size information, and/or display format information;
receiving chart information configured on the basis of the chart editing window, and adjusting the data chart according to the chart information.
7. A data chart drawing method according to any one of claims 1 to 6, wherein said step of parsing said user voice information to obtain a user intention and selecting a chart template according to said user intention comprises:
carrying out voiceprint recognition on the user voice information to obtain a voiceprint recognition result, and judging whether the user voice information belongs to the same user according to the voiceprint recognition result;
and when the user voice information does not belong to the same user, selecting the target voice information which is closest to the user in the user voice information for analysis to obtain the user intention, and selecting the chart template according to the user intention.
8. A data chart drawing apparatus characterized by comprising:
the data acquisition module is used for acquiring user voice information corresponding to a data chart drawing request and acquiring initial chart data corresponding to the data chart drawing request when the data chart drawing request is received;
the analysis selection module is used for analyzing the user voice information to obtain user intention and selecting a chart template according to the user intention;
the data processing module is used for processing the initial chart data according to the chart template to obtain standard chart data;
and the chart generation module is used for adjusting the chart template according to the standard chart data and generating a data chart corresponding to the data chart drawing request.
9. A data chart drawing device characterized by comprising: a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein:
the computer program, when executed by the processor, implementing the steps of the data charting method of any one of claims 1 to 7.
10. A computer-readable storage medium, characterized in that a computer program is stored thereon, which computer program, when being executed by a processor, carries out the steps of the data diagram rendering method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911401699.1A CN111159987A (en) | 2019-12-27 | 2019-12-27 | Data chart drawing method, device, equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911401699.1A CN111159987A (en) | 2019-12-27 | 2019-12-27 | Data chart drawing method, device, equipment and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111159987A true CN111159987A (en) | 2020-05-15 |
Family
ID=70559389
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911401699.1A Pending CN111159987A (en) | 2019-12-27 | 2019-12-27 | Data chart drawing method, device, equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111159987A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112182074A (en) * | 2020-09-27 | 2021-01-05 | 中国建设银行股份有限公司 | Data visualization method and device, electronic equipment and readable storage medium |
| CN112560422A (en) * | 2020-12-10 | 2021-03-26 | 北京煜邦电力技术股份有限公司 | Chart processing method, device, equipment and medium |
| CN113205569A (en) * | 2021-04-25 | 2021-08-03 | Oppo广东移动通信有限公司 | Image drawing method and device, computer readable medium and electronic device |
| CN113487698A (en) * | 2021-07-27 | 2021-10-08 | 平安国际智慧城市科技股份有限公司 | Form generation method and device based on two-channel neural network model |
| CN114064029A (en) * | 2020-07-31 | 2022-02-18 | 阿里巴巴集团控股有限公司 | Method, device and architecture for realizing back-end drawing and data robot |
| WO2023010856A1 (en) * | 2021-08-02 | 2023-02-09 | 上海派森诺生物科技有限公司 | Online drawing method and apparatus for combined density plot, and electronic device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050283754A1 (en) * | 2004-06-18 | 2005-12-22 | Peter Vignet | Method and system to generate chart models |
| US20160092405A1 (en) * | 2014-09-30 | 2016-03-31 | Microsoft Technology Licensing, Llc | Intent Based Authoring |
| CN105653507A (en) * | 2014-11-12 | 2016-06-08 | 北大方正集团有限公司 | Chart generation method and device |
| CN106155988A (en) * | 2015-03-31 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Data drawing list method for drafting based on excel and relevant apparatus |
| US20180129800A1 (en) * | 2016-11-10 | 2018-05-10 | Ricoh Company, Ltd. | Information processing apparatus, information processing system, and method of processing information |
-
2019
- 2019-12-27 CN CN201911401699.1A patent/CN111159987A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050283754A1 (en) * | 2004-06-18 | 2005-12-22 | Peter Vignet | Method and system to generate chart models |
| US20160092405A1 (en) * | 2014-09-30 | 2016-03-31 | Microsoft Technology Licensing, Llc | Intent Based Authoring |
| CN105653507A (en) * | 2014-11-12 | 2016-06-08 | 北大方正集团有限公司 | Chart generation method and device |
| CN106155988A (en) * | 2015-03-31 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Data drawing list method for drafting based on excel and relevant apparatus |
| US20180129800A1 (en) * | 2016-11-10 | 2018-05-10 | Ricoh Company, Ltd. | Information processing apparatus, information processing system, and method of processing information |
Non-Patent Citations (1)
| Title |
|---|
| 王丽华;: "录井柱状图绘制软件的开发", 录井工程, no. 02, 25 June 2011 (2011-06-25) * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114064029A (en) * | 2020-07-31 | 2022-02-18 | 阿里巴巴集团控股有限公司 | Method, device and architecture for realizing back-end drawing and data robot |
| CN114064029B (en) * | 2020-07-31 | 2024-08-09 | 阿里巴巴集团控股有限公司 | Method, device and architecture for realizing back-end drawing and data robot |
| CN112182074A (en) * | 2020-09-27 | 2021-01-05 | 中国建设银行股份有限公司 | Data visualization method and device, electronic equipment and readable storage medium |
| CN112560422A (en) * | 2020-12-10 | 2021-03-26 | 北京煜邦电力技术股份有限公司 | Chart processing method, device, equipment and medium |
| CN113205569A (en) * | 2021-04-25 | 2021-08-03 | Oppo广东移动通信有限公司 | Image drawing method and device, computer readable medium and electronic device |
| CN113487698A (en) * | 2021-07-27 | 2021-10-08 | 平安国际智慧城市科技股份有限公司 | Form generation method and device based on two-channel neural network model |
| CN113487698B (en) * | 2021-07-27 | 2023-12-12 | 深圳赛安特技术服务有限公司 | Form generation method and device based on two-channel neural network model |
| WO2023010856A1 (en) * | 2021-08-02 | 2023-02-09 | 上海派森诺生物科技有限公司 | Online drawing method and apparatus for combined density plot, and electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111179975B (en) | Voice endpoint detection method for emotion recognition, electronic device and storage medium | |
| CN111159987A (en) | Data chart drawing method, device, equipment and computer readable storage medium | |
| JP6894534B2 (en) | Information processing method and terminal, computer storage medium | |
| WO2021174717A1 (en) | Text intent recognition method and apparatus, computer device and storage medium | |
| EP3839942A1 (en) | Quality inspection method, apparatus, device and computer storage medium for insurance recording | |
| CN110688454A (en) | Method, device, equipment and storage medium for processing consultation conversation | |
| CN111368043A (en) | Event question-answering method, device, equipment and storage medium based on artificial intelligence | |
| CN108664599B (en) | Intelligent question-answering method and device, intelligent question-answering server and storage medium | |
| CN109961786B (en) | Product recommendation method, device, equipment and storage medium based on voice analysis | |
| CN105260416A (en) | Voice recognition based searching method and apparatus | |
| EP3115907A1 (en) | Common data repository for improving transactional efficiencies of user interactions with a computing device | |
| CN111639156B (en) | Query method, device, equipment and storage medium based on hierarchical label | |
| CN104866308A (en) | Scenario image generation method and apparatus | |
| CN112000776B (en) | Topic matching method, device, equipment and storage medium based on voice semantics | |
| CN113051362B (en) | Data query method, device and server | |
| CN110246496A (en) | Speech recognition method, system, computer device and storage medium | |
| CN109508441A (en) | Data analysing method, device and electronic equipment | |
| WO2020233381A1 (en) | Speech recognition-based service request method and apparatus, and computer device | |
| CN110795942B (en) | Keyword determination method and device based on semantic recognition and storage medium | |
| CN110263121B (en) | Table data processing method, apparatus, electronic apparatus and computer readable storage medium | |
| CN117312535B (en) | Method, device, equipment and medium for processing problem data based on artificial intelligence | |
| CN113220828B (en) | Method, device, computer equipment and storage medium for processing intention recognition model | |
| CN114491010A (en) | Training method and device of information extraction model | |
| CN111640450A (en) | Multi-person audio processing method, device, equipment and readable storage medium | |
| CN112307200A (en) | Emotional attribute acquisition method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |