CN109145277A - Chart generation method, device, storage medium and electronic equipment - Google Patents
Chart generation method, device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN109145277A CN109145277A CN201810975636.6A CN201810975636A CN109145277A CN 109145277 A CN109145277 A CN 109145277A CN 201810975636 A CN201810975636 A CN 201810975636A CN 109145277 A CN109145277 A CN 109145277A
- Authority
- CN
- China
- Prior art keywords
- data
- type
- column
- group
- chart
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This disclosure relates to a kind of chart generation method, device, storage medium and electronic equipment, it is related to information technology field, this method comprises: obtaining the data type of multiple data column in target list, the data type arranged according to multiple data, multiple data column are grouped, multiple data column are divided into index group, dimension group or abandon data, the chart according to the data column-generation chart in index group and dimension group, as target list.The quantity for generating chart can be simplified, efficiency and operability that chart generates are improved.
Description
Technical field
This disclosure relates to information technology field, and in particular, to a kind of chart generation method, device, storage medium and electricity
Sub- equipment.
Background technique
Table with the fast development of the information technologies such as internet, big data, applied to fields such as industry, government affairs, management
Single business all begins to use electronic chart.Electronic chart can collect a large amount of data information, convenient for being analyzed data, examined
Rope and statistics.The generating process of electronic chart, it is necessary first to selected index axis and latitude axis, then by data corresponding in database
It shows in electronic chart.And the design for electronic chart, operation difficulty are big, for the user used for the first time, use
It is poor to experience, and expends workload, and existing electronic chart automatically generates scheme, can generate a large amount of meaningless charts, same to drop
The low usage experience and working efficiency of user.
Summary of the invention
Purpose of this disclosure is to provide a kind of chart generation method, device, storage medium and electronic equipments, to solve certainly
It is dynamic to generate a large amount of meaningless charts when generating chart, lead to efficiency and the low problem of operability.
To achieve the goals above, according to the first aspect of the embodiments of the present disclosure, a kind of chart generation method is provided, it is described
Method includes:
Obtain the data type of multiple data column in target list；
According to the data type that the multiple data arrange, the multiple data column are grouped, by the multiple number
It is divided into index group, dimension group according to column or abandons data；
Chart according to the data column-generation chart in the index group and the dimension group, as the target list.
Optionally, the data type arranged according to the multiple data is grouped the multiple data column, will
The multiple data column are divided into index group, dimension group or abandon data, comprising:
When the data type of the first data column is numeric type, first data column are divided into the index group, institute
State any data column that the first data are classified as in the multiple data column；
When the data type of first data column is that type may be selected, first data column are divided into the dimension
Group, the optional type include: date type and classification drop-down type.
Optionally, the data type arranged according to the multiple data is grouped the multiple data column, will
The multiple data column are divided into index group, dimension group or abandon data, further includes:
When the data type of first data column is text type, and the probability point of the data in first data column
When being covered with the data distribution of sufficient specified type, first data column are divided into the dimension group；
First data column of the index group or the dimension group will be not divided into, be divided into discarding data.
Optionally, the data type arranged when first data is text type, and in first data column
When data meet the data distribution of specified type, first data column are divided into the dimension group, comprising:
When first data column data type be text type when, to first data column in every item data into
Row number, wherein identical data number having the same；
Input by the number of every item data as preset algorithm, to obtain all volumes of the preset algorithm output
Number probability distribution；
Judge whether the numbered probability distribution of institute meets to be uniformly distributed；
When the numbered probability distribution satisfaction of the institute is uniformly distributed, first data column are divided into the dimension
Group.
Optionally, the data column-generation chart according in the index group and the dimension group, as the target
The chart of list, comprising:
According to the data column in the index group and the latitude group, the index axis and latitude of at least one chart are determined
Axis；
The index axis and the corresponding data of the latitude axis are shown at least one each described chart.
According to the second aspect of an embodiment of the present disclosure, a kind of chart generating means are provided, described device includes:
Module is obtained, for obtaining the data type of multiple data column in target list；
Grouping module, the data type for being arranged according to the multiple data are grouped the multiple data column, with
The multiple data column are divided into index group, dimension group or abandon data；
Generation module, for according to the data column-generation chart in the index group and the dimension group, as the mesh
Mark the chart of list.
Optionally, the grouping module includes:
First grouping submodule, when the data type for arranging when the first data is numeric type, by first data
Column are divided into the index group, and first data are classified as any data column in the multiple data column；
Second packet submodule, data type for arranging when first data be when type may be selected, by described the
One data column are divided into the dimension group, and the optional type includes: date type and classification drop-down type.
Optionally, the grouping module further include:
Third is grouped submodule, is also used to when the data type of first data column be text type, and described first
When the probability distribution of data in data column meets the data distribution of specified type, first data column are divided into the dimension
Group；
4th grouping submodule, for will not be divided into first data of the index group or the dimension group
Column, are divided into discarding data.
Optionally, the third grouping submodule is used for:
When first data column data type be text type when, to first data column in every item data into
Row number, wherein identical data number having the same；
Input by the number of every item data as preset algorithm, to obtain all volumes of the preset algorithm output
Number probability distribution；
Judge whether the numbered probability distribution of institute meets to be uniformly distributed；
When the numbered probability distribution satisfaction of the institute is uniformly distributed, first data column are divided into the dimension
Group.
Optionally, the generation module includes:
It determines submodule, for arranging according to the data in the index group and the latitude group, determines at least one chart
Index axis and latitude axis；
Display sub-module, for showing the index axis and the corresponding data of the latitude axis each described at least one
In a chart.
According to the third aspect of an embodiment of the present disclosure, a kind of computer readable storage medium is provided, calculating is stored thereon with
The step of machine program, the chart generation method that realization first aspect provides when which is executed by processor.
According to a fourth aspect of embodiments of the present disclosure, a kind of electronic equipment is provided, comprising:
Memory is stored thereon with computer program；
Processor, for executing the computer program in the memory, to realize the chart of first aspect offer
The step of generation method.
Through the above technical solutions, the disclosure obtains the data type of multiple data column in target list first, then successively
Be grouped according to the data type of each data column in multiple data column, by each data column be divided into index group, dimension group or
Data are abandoned, finally, making data corresponding in dimension group using data corresponding in index group as the corresponding data of index axis
For the corresponding data of latitude axis, to generate the chart of target list.It can be under the premise of not needing user's participation design, certainly
The chart that dynamic generation quantity is simplified, to improve the efficiency and operability of chart generation.
Other feature and advantage of the disclosure will the following detailed description will be given in the detailed implementation section.
Detailed description of the invention
Attached drawing is and to constitute part of specification for providing further understanding of the disclosure, with following tool
Body embodiment is used to explain the disclosure together, but does not constitute the limitation to the disclosure.In the accompanying drawings:
Fig. 1 is a kind of flow chart of chart generation method shown according to an exemplary embodiment；
Fig. 2 is the flow chart of another chart generation method shown according to an exemplary embodiment；
Fig. 3 is the flow chart of another chart generation method shown according to an exemplary embodiment；
Fig. 4 is the flow chart of another chart generation method shown according to an exemplary embodiment；
Fig. 5 is any chart generation method chart generated according to shown in Fig. 1 to Fig. 4；
Fig. 6 is a kind of block diagram of chart generating means shown according to an exemplary embodiment；
Fig. 7 is the block diagram of another chart generating means shown according to an exemplary embodiment；
Fig. 8 is the block diagram of another chart generating means shown according to an exemplary embodiment；
Fig. 9 is the block diagram of another chart generating means shown according to an exemplary embodiment；
Figure 10 is the block diagram of a kind of electronic equipment shown according to an exemplary embodiment.
Specific embodiment
Example embodiments are described in detail here, and the example is illustrated in the accompanying drawings.Following description is related to
When attached drawing, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements.Following exemplary embodiment
Described in embodiment do not represent all implementations consistent with this disclosure.On the contrary, they be only with it is such as appended
The example of the consistent device and method of some aspects be described in detail in claims, the disclosure.
Fig. 1 is a kind of flow chart of chart generation method shown according to an exemplary embodiment, as shown in Figure 1, the party
Method includes:
Step 101, the data type of multiple data column in target list is obtained.
For example, for the mass data stored in database, user is difficult directly to find out the rule for including in data
And trend, therefore can be generated it is more intuitive, be easier to the chart of Rule Summary to assist user.Under normal conditions, Yong Hu
Initial stage to the analysis of data often without specific directive property, then the figure of there may be practical significance can be generated
Table, so that user analyzes and judges, to further carry out secondary editor or screening to chart.It include two in two-dimensional diagram
Axis: index axis (Y-axis) and dimension axis (X-axis), size of the index axis commonly used to display data, and dimension axis is commonly used to instruction
Different classification.Target list stores in the database, contains multiple data column, obtains each data first and arrange corresponding number
According to type.
Step 102, the data type arranged according to multiple data is grouped multiple data column, multiple data is arranged
It is divided into index group, dimension group or abandons data.
Step 103, the chart according to the data column-generation chart in index group and dimension group, as target list.
It is exemplary, the data that can be used as index axis column are divided into index group, the data column that can be used as dimension axis are divided into
Remaining data column are divided into discarding data by latitude group.It is divided into index group for example, the data of numeric type can be arranged, it can
Selective type (such as: date type, classification drop-down type etc.) it is divided into latitude group.After the grouping for completing to arrange multiple data,
It is using data corresponding in index group as the corresponding data of index axis, data corresponding in dimension group are corresponding as latitude axis
Data, to generate the chart of target list.It can be by the data column combination of two in index group and dimension group, respectively as index
Data in axis and dimension axis generate multiple charts, and the number that can also be arranged according to data in index group generates chart, Mei Getu
Each data in dimension group are contained in table arranges corresponding data.Further, according to the chart of the target list of generation, user
Screening or secondary editor can also be carried out to chart according to actual needs, make the more flexible design of user and use chart.
In conclusion the disclosure obtains the data type of multiple data column in target list first, then successively according to multiple
The data type of each data column is grouped in data column, and each data column are divided into index group, dimension group or abandon data,
Finally, using data corresponding in index group as the corresponding data of index axis, using data corresponding in dimension group as latitude axis
Corresponding data, to generate the chart of target list.Number can be automatically generated under the premise of not needing user's participation design
The chart simplified is measured, to improve the efficiency and operability of chart generation.
Fig. 2 is the flow chart of another chart generation method shown according to an exemplary embodiment, as shown in Fig. 2, step
Rapid 102 include:
Step 1021, when the data type of the first data column is numeric type, the first data column are divided into index group, the
One data are classified as any data column in multiple data column.
Step 1022, when the data type of the first data column is that type may be selected, the first data column are divided into dimension group,
Optional type includes: date type and classification drop-down type.
For example, successively each data in multiple data column are arranged and is classified according to data type, when the first number
When according to the data type of column being numeric type, the first data column, which are divided into, can be used as the index group of index axis, when the first data
The data type of column is that the first data column are divided into the dimension group that can be used as dimension axis when type may be selected.Wherein, it may be selected
Type can be the enumeration types such as date type and classification drop-down type (including: single choice or final election).For example, when the first data arrange
Data instruction be achievement (numeric type), by the first data column be divided into index group, when the first data column data instruction
It is gender, comprising: male, two class of female, then the first data column are divided into dimension group.
Fig. 3 is the flow chart of another chart generation method shown according to an exemplary embodiment, as shown in figure 3, step
Rapid 102 further include:
Step 1023, when the first data column data type be text type, and the first data column in data probability
When distribution meets the data distribution of specified type, the first data column are divided into dimension group.
Step 1024, the first data for not being divided into index group or dimension group are arranged, is divided into discarding data.
It is exemplary, the data of text type are arranged, need to judge whether data column have statistical significance, if the number
There is statistical significance according to column, then data column are shown in the graph as latitude axis, it may have practical significance, if the number
Do not have statistical significance according to column, if data column are shown that in the graph corresponding chart does not have reality yet as latitude axis
Border meaning, therefore data column should be abandoned.I.e. when a data column data type be text type, and the first data column in
When the probability distribution of data meets the data distribution of specified type, the first data column are divided into dimension group, wherein specified type
Data distribution, which can be, to be uniformly distributed.The data column that index group or dimension group are not divided into multiple data column are divided into discarding
Data.For example, containing the demographic data in the multiple provincial administrative areas in the whole nation in target list, the data type of the first data column is
Text type, every item data instruction therein can be 34 provincial administrative areas, have statistical significance, when in the first data column
Data probability distribution satisfaction when being uniformly distributed, the first data can be arranged and be divided into dimension group.If being contained in target list
The data type of different section's purpose achievements of some school whole student, the first data column is text type, wherein every item data
What is indicated is the name of each student, then the first data column do not have statistical significance, if regarding the first data column as latitude
Axis generates chart (including whole students i.e. in X-axis), and for a user, and the data being directly viewable in database do not have area
Not, it is difficult directly to find out the rule and trend for including in data.Therefore, the first data can be arranged and is divided into discarding data.
Optionally, step 1023 can be accomplished by the following way:
1) when the data type of the first data column is text type, every item data in the first data column is compiled
Number, wherein identical data number having the same.
2) input by the number of every item data as preset algorithm, it is numbered general with the institute for obtaining preset algorithm output
Rate distribution.
3) judge whether the numbered probability distribution of institute meets to be uniformly distributed.
4) when the numbered probability distribution satisfaction of institute is uniformly distributed, the first data column are divided into dimension group.
For example, when the data type of the first data column is text type, by every item data in the first data column
It is numbered respectively, identical data compile identical number, to convert numeric type for the data of text type to calculate
The probability distribution of first data column.Input by the number of every item data as preset algorithm, it is corresponding to obtain all numbers
Probability distribution.Wherein, preset algorithm can be W (full name: Shapiro-Wilk) method of inspection, K-S (Russian: Kolmogorov-
Smirnov, Chinese: Ke Ermo can love-Si meter love) the common statistical analysis algorithms such as method of inspection.When institute is numbered general
When rate distribution satisfaction is uniformly distributed, determines that the first data column have statistical significance, the first data column are divided into dimension group.
Fig. 4 is the flow chart of another chart generation method shown according to an exemplary embodiment, as shown in figure 4, step
Rapid 103 include:
Step 1031, it is arranged according to the data in index group and latitude group, determines the index axis and latitude of at least one chart
Axis.
Step 1032, index axis and the corresponding data of latitude axis are shown at least one each chart.
For example, one or more data column in selective goal group and dimension group can be distinguished, respectively as chart
Index axis and latitude axis, then index axis and the corresponding data of latitude axis are shown in the graph.For example, data arrange in index group
Quantity be M, the quantity of data column is N in dimension group.It can be by the data column combination of two in index group and dimension group, respectively
As index axis and dimension axis, M*N chart can be generated.The number that can also be arranged according to data in index group generates chart,
Each data in dimension group are contained in each chart arranges corresponding data, it can M chart is generated, it is every in M chart
A chart all include in dimension group N number of data arrange corresponding data.Different numbers can also be generated according to the demand of user
Chart, such as can be set by the user in each chart of generation comprising several latitudes.
It is exemplary, the data information of certain project bid is contained with target list, as shown in table 1, wherein containing multiple
Data column, the data type of " budget " data column are numeric type, therefore the data can be arranged and be divided into index group, " contract shape
The data type of state " data column is that type (include: effectively, fail, wait renew a contract) may be selected, therefore the data can be arranged and be divided into
Dimension group, and " qualification " data column and " responsible person " data column are all text type, need further to judge that the two data arrange
Probability distribution the data can be arranged when " qualification " data, which arrange corresponding probability distribution satisfaction, to be uniformly distributed and be divided into dimension
Group, and the responsible person of the company of each participation bid indicated in " responsible person " data column, it is general without actual statistical significance
Rate distribution is unsatisfactory for being uniformly distributed, therefore data column are divided into discarding data.It confirmed index group (including a column) and latitude
After degree group (including two column), with the data column combination of two in index group and dimension group, respectively as index axis and dimension axis
For, two charts can be generated, as shown in figure 5, wherein scheme (A) in index axis be shown " budget " data column it is corresponding
Data, dimension axis are shown " contract status " data and arrange corresponding data, and " budget " number is shown in the index axis in figure (B)
According to corresponding data are arranged, dimension axis is shown " qualification " data and arranges corresponding data.
Table 1
| Budget (ten thousand yuan) | Contract status | Qualification | … | Responsible person |
| 280 | Effectively | Second-rank first class | … | Zhang Ming |
| 510 | Effectively | Level-one the second grade | … | Li Xin |
| 375 | Wait renew a contract | Second level the second grade | … | Wang Tao |
| … | … | … | … | … |
| 420 | Effectively | Three-level is first-class | … | Zhao Kang |
In conclusion the disclosure obtains the data type of multiple data column in target list first, then successively according to multiple
The data type of each data column is grouped in data column, and each data column are divided into index group, dimension group or abandon data,
Finally, using data corresponding in index group as the corresponding data of index axis, using data corresponding in dimension group as latitude axis
Corresponding data, to generate the chart of target list.Number can be automatically generated under the premise of not needing user's participation design
The chart simplified is measured, to improve the efficiency and operability of chart generation.
Fig. 6 is a kind of block diagram of chart generating means shown according to an exemplary embodiment, as shown in fig. 6, the device
200 include:
Module 201 is obtained, for obtaining the data type of multiple data column in target list.
Grouping module 202, the data type for being arranged according to multiple data are grouped multiple data column, will be more
A data column are divided into index group, dimension group or abandon data.
Generation module 203, for the figure according to the data column-generation chart in index group and dimension group, as target list
Table.
Fig. 7 is the block diagram of another chart generating means shown according to an exemplary embodiment, as shown in fig. 7, grouping
Module 202 includes:
First grouping submodule 2021, when the data type for arranging when the first data is numeric type, by the first data
Column are divided into index group, and the first data are classified as any data column in multiple data column.
Second packet submodule 2022, the data type for arranging when the first data are when type may be selected, by the first number
It is divided into dimension group according to column, optional type includes: date type and classification drop-down type.
Fig. 8 is the block diagram of another chart generating means shown according to an exemplary embodiment, as shown in figure 8, grouping
Module 202 further include:
Third is grouped submodule 2023, is also used to when the data type of the first data column be text type, and the first data
When the probability distribution of data in column meets the data distribution of specified type, the first data column are divided into dimension group.
4th grouping submodule 2024, the first data for will not be divided into index group or dimension group arrange, are divided into and lose
Abandon data.
Optionally, third grouping submodule 2023 can be used to implement following steps:
1) when the data type of the first data column is text type, every item data in the first data column is compiled
Number, wherein identical data number having the same.
2) input by the number of every item data as preset algorithm, it is numbered general with the institute for obtaining preset algorithm output
Rate distribution.
3) judge whether the numbered probability distribution of institute meets to be uniformly distributed.
4) when the numbered probability distribution satisfaction of institute is uniformly distributed, the first data column are divided into dimension group.
Fig. 9 is the block diagram of another chart generating means shown according to an exemplary embodiment, as shown in figure 9, generating
Module 203 includes:
It determines submodule 2031, for arranging according to the data in index group and latitude group, determines the finger of at least one chart
Parameter and latitude axis.
Display sub-module 2032, for showing index axis and the corresponding data of latitude axis at least one each chart
In.
About the device in above-described embodiment, wherein modules execute the concrete mode of operation in related this method
Embodiment in be described in detail, no detailed explanation will be given here.
In conclusion the disclosure obtains the data type of multiple data column in target list first, then successively according to multiple
The data type of each data column is grouped in data column, and each data column are divided into index group, dimension group or abandon data,
Finally, using data corresponding in index group as the corresponding data of index axis, using data corresponding in dimension group as latitude axis
Corresponding data, to generate the chart of target list.Number can be automatically generated under the premise of not needing user's participation design
The chart simplified is measured, to improve the efficiency and operability of chart generation.
Figure 10 is the block diagram of a kind of electronic equipment 300 shown according to an exemplary embodiment.As shown in Figure 10, the electronics
Equipment 300 may include: processor 301, memory 302.The electronic equipment 300 can also include multimedia component 303, defeated
Enter/export one or more of (I/O) interface 304 and communication component 305.
Wherein, processor 301 is used to control the integrated operation of the electronic equipment 300, to complete above-mentioned chart generation side
All or part of the steps in method.Memory 302 is for storing various types of data to support the behaviour in the electronic equipment 300
To make, these data for example may include the instruction of any application or method for operating on the electronic equipment 300, with
And the relevant data of application program, such as contact data, the message of transmitting-receiving, picture, audio, video etc..The memory 302
It can be realized by any kind of volatibility or non-volatile memory device or their combination, such as static random-access is deposited
Reservoir (Static Random Access Memory, abbreviation SRAM), electrically erasable programmable read-only memory
(Electrically Erasable Programmable Read-Only Memory, abbreviation EEPROM), erasable programmable
Read-only memory (Erasable Programmable Read-Only Memory, abbreviation EPROM), programmable read only memory
(Programmable Read-Only Memory, abbreviation PROM), and read-only memory (Read-Only Memory, referred to as
ROM), magnetic memory, flash memory, disk or CD.Multimedia component 303 may include screen and audio component.Wherein
Screen for example can be touch screen, and audio component is used for output and/or input audio signal.For example, audio component may include
One microphone, microphone is for receiving external audio signal.The received audio signal can be further stored in storage
Device 302 is sent by communication component 305.Audio component further includes at least one loudspeaker, is used for output audio signal.I/O
Interface 304 provides interface between processor 301 and other interface modules, other above-mentioned interface modules can be keyboard, mouse,
Button etc..These buttons can be virtual push button or entity button.Communication component 305 is for the electronic equipment 300 and other
Wired or wireless communication is carried out between equipment.Wireless communication, such as Wi-Fi, bluetooth, near-field communication (Near Field
Communication, abbreviation NFC), 2G, 3G or 4G or they one or more of combination, therefore corresponding communication
Component 305 may include: Wi-Fi module, bluetooth module, NFC module.
In one exemplary embodiment, electronic equipment 300 can be by one or more application specific integrated circuit
(Application Specific Integrated Circuit, abbreviation ASIC), digital signal processor (Digital
Signal Processor, abbreviation DSP), digital signal processing appts (Digital Signal Processing Device,
Abbreviation DSPD), programmable logic device (Programmable Logic Device, abbreviation PLD), field programmable gate array
(Field Programmable Gate Array, abbreviation FPGA), controller, microcontroller, microprocessor or other electronics member
Part is realized, for executing above-mentioned chart generation method.
In a further exemplary embodiment, a kind of computer readable storage medium including program instruction is additionally provided, it should
The step of above-mentioned chart generation method is realized when program instruction is executed by processor.For example, the computer readable storage medium
It can be the above-mentioned memory 302 including program instruction, above procedure instruction can be executed by the processor 301 of electronic equipment 300
To complete above-mentioned chart generation method.
In conclusion the disclosure obtains the data type of multiple data column in target list first, then successively according to multiple
The data type of each data column is grouped in data column, and each data column are divided into index group, dimension group or abandon data,
Finally, using data corresponding in index group as the corresponding data of index axis, using data corresponding in dimension group as latitude axis
Corresponding data, to generate the chart of target list.Number can be automatically generated under the premise of not needing user's participation design
The chart simplified is measured, to improve the efficiency and operability of chart generation.
The preferred embodiment of the disclosure is described in detail in conjunction with attached drawing above, still, the disclosure is not limited to above-mentioned reality
The detail in mode is applied, in the range of the technology design of the disclosure, those skilled in the art are considering specification and practice
After the disclosure, it is readily apparent that other embodiments of the disclosure, belongs to the protection scope of the disclosure.
It is further to note that specific technical features described in the above specific embodiments, in not lance
In the case where shield, it can be combined in any appropriate way.Simultaneously between a variety of different embodiments of the disclosure
Any combination can also be carried out, as long as it, without prejudice to the thought of the disclosure, equally should be considered as disclosure disclosure of that.
The disclosure is not limited to the precision architecture being described above out, and the scope of the present disclosure is only limited by the attached claims
System.
Claims (10)
1. a kind of chart generation method, which is characterized in that the described method includes:
Obtain the data type of multiple data column in target list；
According to the data type that the multiple data arrange, the multiple data column are grouped, the multiple data are arranged
It is divided into index group, dimension group or abandons data；
Chart according to the data column-generation chart in the index group and the dimension group, as the target list.
2. the method according to claim 1, wherein the data type arranged according to the multiple data, right
The multiple data column are grouped, and the multiple data column are divided into index group, dimension group or abandon data, comprising:
When the data type of the first data column is numeric type, first data column are divided into the index group, described the
One data are classified as any data column in the multiple data column；
When the data type of first data column is that type may be selected, first data column are divided into the dimension group,
The optional type includes: date type and classification drop-down type.
3. according to the method described in claim 2, it is characterized in that, the data type arranged according to the multiple data, right
The multiple data column are grouped, and the multiple data column are divided into index group, dimension group or abandon data, further includes:
When the data type of first data column is text type, and the probability distribution of the data in first data column is full
When the data distribution of sufficient specified type, first data column are divided into the dimension group；
First data column of the index group or the dimension group will be not divided into, be divided into discarding data.
4. according to the method described in claim 3, it is characterized in that, described when the data type of first data column is text
Type, and first data column are divided into institute when meeting the data distribution of specified type by the data in first data column
State dimension group, comprising:
When the data type of first data column is text type, every item data in first data column is compiled
Number, wherein identical data number having the same；
Input by the number of every item data as preset algorithm, it is numbered with the institute for obtaining the preset algorithm output
Probability distribution；
Judge whether the numbered probability distribution of institute meets to be uniformly distributed；
When the numbered probability distribution satisfaction of the institute is uniformly distributed, first data column are divided into the dimension group.
5. the method according to claim 1, wherein the number according in the index group and the dimension group
Chart according to column-generation chart, as the target list, comprising:
According to the data column in the index group and the latitude group, the index axis and latitude axis of at least one chart are determined；
The index axis and the corresponding data of the latitude axis are shown at least one each described chart.
6. a kind of chart generating means, which is characterized in that described device includes:
Module is obtained, for obtaining the data type of multiple data column in target list；
Grouping module, the data type for being arranged according to the multiple data are grouped the multiple data column, by institute
Multiple data column are stated to be divided into index group, dimension group or abandon data；
Generation module, for according to the data column-generation chart in the index group and the dimension group, as the object table
Single chart.
7. device according to claim 6, which is characterized in that the grouping module includes:
First grouping submodule, when the data type for arranging when the first data is numeric type, by first data column point
Enter the index group, first data are classified as any data column in the multiple data column；
Second packet submodule, the data type for arranging when first data are when type may be selected, by first number
It is divided into the dimension group according to column, the optional type includes: date type and classification drop-down type.
8. device according to claim 7, which is characterized in that the grouping module further include:
Third is grouped submodule, is also used to when the data type of first data column be text type, and first data
When the probability distribution of data in column meets the data distribution of specified type, first data column are divided into the dimension group；
4th grouping submodule, first data for will not be divided into the index group or the dimension group arrange, point
Enter to abandon data.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
The step of any one of claim 1-5 the method is realized when row.
10. a kind of electronic equipment characterized by comprising
Memory is stored thereon with computer program；
Processor, for executing the computer program in the memory, to realize described in any one of claim 1-5
The step of method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810975636.6A CN109145277A (en) | 2018-08-24 | 2018-08-24 | Chart generation method, device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810975636.6A CN109145277A (en) | 2018-08-24 | 2018-08-24 | Chart generation method, device, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109145277A true CN109145277A (en) | 2019-01-04 |
Family
ID=64828049
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810975636.6A Pending CN109145277A (en) | 2018-08-24 | 2018-08-24 | Chart generation method, device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109145277A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489449A (en) * | 2019-07-30 | 2019-11-22 | 北京百分点信息科技有限公司 | A kind of chart recommended method, device and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100153404A1 (en) * | 2007-06-01 | 2010-06-17 | Topsy Labs, Inc. | Ranking and selecting entities based on calculated reputation or influence scores |
| CN106598988A (en) * | 2015-10-16 | 2017-04-26 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN107527070A (en) * | 2017-08-25 | 2017-12-29 | 江苏赛睿信息科技股份有限公司 | Recognition methods, storage medium and the server of dimension data and achievement data |
-
2018
- 2018-08-24 CN CN201810975636.6A patent/CN109145277A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100153404A1 (en) * | 2007-06-01 | 2010-06-17 | Topsy Labs, Inc. | Ranking and selecting entities based on calculated reputation or influence scores |
| CN106598988A (en) * | 2015-10-16 | 2017-04-26 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN107527070A (en) * | 2017-08-25 | 2017-12-29 | 江苏赛睿信息科技股份有限公司 | Recognition methods, storage medium and the server of dimension data and achievement data |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489449A (en) * | 2019-07-30 | 2019-11-22 | 北京百分点信息科技有限公司 | A kind of chart recommended method, device and electronic equipment |
| CN110489449B (en) * | 2019-07-30 | 2022-02-22 | 北京百分点科技集团股份有限公司 | Chart recommendation method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Bind et al. | When possible, report a Fisher-exact P value and display its underlying null randomization distribution | |
| Yeh et al. | On-site building information retrieval by using projection-based augmented reality | |
| Hall et al. | Managing underperformance risk in project portfolio selection | |
| Ritter et al. | Pitfalls of normal-gamma stochastic frontier models | |
| Corrocher et al. | Schumpeterian patterns of innovative activity in the ICT field | |
| Norris et al. | If you build a political web site, will they come? | |
| CN107710249A (en) | Personalized forecast model | |
| Amant et al. | Model-based evaluation of expert cell phone menu interaction | |
| CN107766376A (en) | Data alignment method and device | |
| CN105446988B (en) | The method and apparatus for predicting classification | |
| CN106155699B (en) | A kind of management method and mobile terminal of background process | |
| CN110443618A (en) | The generation method and device of air control strategy | |
| CN109388674A (en) | Data processing method, device, equipment and readable storage medium storing program for executing | |
| Wongchai et al. | DEA metafrontier analysis on technical efficiency differences of national universities in Thailand | |
| US7983946B1 (en) | Systems and methods for identifying high complexity projects | |
| CN106294308A (en) | Name entity recognition method and device | |
| JP2020017197A (en) | Presentation method of information relating to basis of prediction value output by computing machine system and predictor | |
| CN108920370A (en) | Compatibility issue detection method, device and equipment | |
| CN109145277A (en) | Chart generation method, device, storage medium and electronic equipment | |
| Islam | Stringency-based ranking of normality tests | |
| CN111553749A (en) | Activity push strategy configuration method and device | |
| CN108154306A (en) | Task processing method, device, equipment and the computer readable storage medium of crowdsourcing model | |
| Anwar et al. | Arranged-demand irrigation scheduling with nonidentical discharges | |
| US8108238B1 (en) | Flexible project governance based on predictive analysis | |
| Zhang et al. | Role of subgraphs in epidemics over finite-size networks under the scaled SIS process |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190104 |