CN112612847A - Data processing method and device based on drill-down analysis scene - Google Patents
Data processing method and device based on drill-down analysis scene Download PDFInfo
- Publication number
- CN112612847A CN112612847A CN202011637211.8A CN202011637211A CN112612847A CN 112612847 A CN112612847 A CN 112612847A CN 202011637211 A CN202011637211 A CN 202011637211A CN 112612847 A CN112612847 A CN 112612847A
- Authority
- CN
- China
- Prior art keywords
- data
- magnitude
- data set
- absolute values
- minimum value
- 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.)
- Granted
Links
- 238000004458 analytical method Methods 0.000 title claims abstract description 37
- 238000003672 processing method Methods 0.000 title abstract description 7
- 238000013507 mapping Methods 0.000 claims abstract description 52
- 238000012545 processing Methods 0.000 claims description 44
- 238000009877 rendering Methods 0.000 claims description 29
- 230000000007 visual effect Effects 0.000 claims description 23
- 238000000034 method Methods 0.000 claims description 21
- 238000012800 visualization Methods 0.000 claims description 8
- 238000005553 drilling Methods 0.000 claims description 7
- 230000000694 effects Effects 0.000 abstract description 39
- 238000013461 design Methods 0.000 description 6
- 238000005259 measurement Methods 0.000 description 6
- 230000006978 adaptation Effects 0.000 description 4
- 238000007405 data analysis Methods 0.000 description 3
- 238000013079 data visualisation Methods 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000006467 substitution reaction 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Abstract
The embodiment of the application discloses a data processing method and device based on a drill-down analysis scene, which can acquire the type of a target display graph of original data, and if the type is a linear growth graph, the data which is not negative in the original data is used as a first data set, and the data which is negative in the original data is used as a second data set. And calculating to obtain a positive coordinate axis starting point according to the data in the first data set, and calculating to obtain a negative coordinate axis starting point according to the data in the second data set. And obtaining a first metric magnitude according to the minimum value of the absolute value of the data in the first data set and the magnitude mapping table, and obtaining a second metric magnitude according to the minimum value of the absolute value of the data in the second data set and the magnitude mapping table. Therefore, the data are processed automatically, the corresponding magnitude of the data and the starting point value of the coordinate axis are suitable, the processed data have a good display effect, and human resources and time cost are saved.
Description
Technical Field
The present application relates to the field of data processing, and in particular, to a method and an apparatus for data processing based on a drill-down analysis scenario.
Background
In the traditional data analysis, the interpretation of the data analysis result is generally presented on the computer terminal in a text and table manner, and a user needs to obtain potentially valuable information from an analysis report through text reading and table analysis. Then, in the current big data era, data analysis report results generated aiming at mass data are relatively complex, a user is difficult to put forward effective value information, and in order to enable the user to obtain effective information more conveniently, the presentation of complex analysis results generally depends on a data visualization technology. Common categories of data visualization are: bar charts, line charts, pie charts, radar charts, and the like. Pie charts generally represent the proportion of a category. In a computer system, the content of the display data in the visualization graph can be dimension data and measurement data, wherein the dimension data represents the view angle of the display of the graphic data information, and the measurement data represents the measurement value under the dimension view angle. On a computer, a general design developer of a visual graph can configure (bind) corresponding dimension and measurement data to a data axis of the graph according to business requirements, and adjust according to the business requirements and the current data magnitude, so that a relatively good display effect is achieved. However, in a multi-level aggregated graph, data drilling is often a rigid requirement, and in this case, a design developer of the graph only shows effect optimization at a certain level, it is difficult to satisfy the requirement of maintaining relatively consistent display effect in the multi-level drilling, or it takes more time and effort to adjust and optimize the display effect in a targeted manner, even because the data changes over time, it is difficult to predict that adjustment and optimization cannot be made for the data change.
That is, at present, in the drill-down analysis display scene of visual graphics, on different summarization levels, in order to keep data relatively good display effect, design developers need to perform frequent manual adaptation of data patterns on different summarization levels, i.e., perform manual adaptation adjustment in each layer to achieve good display effect, consume a large amount of human resources, and the manpower and time costs are high.
How to keep relatively good visualization graph display effect of data in different data summarization levels without spending much time and energy of design developers to adapt the styles is a problem to be solved in the field.
Disclosure of Invention
In order to solve the technical problem, the application provides a data processing method and device based on a drill-down analysis scene, which can automatically process the situation of the displayed data value to obtain the order of magnitude corresponding to the appropriate data and the starting point value of the coordinate axis, and the processed data and the visual image are rendered to have a good display effect, so that the human resources and the time cost are saved.
In order to achieve the purpose, the technical scheme is as follows:
in one aspect, an embodiment of the present application provides a data processing method based on a drill-down analysis scenario, where the method includes:
the method comprises the steps that data processing equipment obtains original data arranged from small to big in a drilling analysis and the type of a target display graph of the original data;
if the type is a linear growth graph, the data processing equipment takes the data which are not negative in the original data as a first data set, and takes the data which are negative in the original data as a second data set;
the data processing equipment calculates to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the first data set, and calculates to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the second data set;
the data processing equipment obtains a first metric magnitude according to the minimum value of the absolute value of the data in the first data set and the magnitude mapping table, and obtains a second metric magnitude according to the minimum value of the absolute value of the data in the second data set and the magnitude mapping table;
if the ratio of the first metric magnitude to the second metric magnitude is within a preset range, the data processing equipment takes the first metric magnitude or the second metric magnitude as a final magnitude, and divides the original data, the starting point of the positive coordinate axis and the starting point of the negative coordinate axis by the final magnitude to obtain final data;
if the ratio of the first metric magnitude to the second metric magnitude is not within the preset range, dividing the data in the first data set and the starting point of the positive coordinate axis by the first metric magnitude to obtain first final data, and dividing the data in the second data set and the starting point of the negative coordinate axis by the second metric magnitude to obtain second final data.
Optionally, the method further includes:
the data processing equipment combines the final data with a visual rendering template to render a final display graph; or; and the data processing equipment combines the first final data and a visual rendering template to render a first display graph, and combines the second final data and the visual rendering template to render a second display graph.
Optionally, the obtaining, by the data processing device, a first metric magnitude according to the minimum of the absolute values of the data in the first data set and the magnitude mapping table, and obtaining a second metric magnitude according to the minimum of the absolute values of the data in the second data set and the magnitude mapping table, includes:
if the magnitude of the minimum value of the absolute values of the data in the first data set is in the magnitude mapping table, taking the magnitude of the minimum value of the absolute values of the data in the first data set which is one-step higher as a first magnitude;
if the magnitude of the minimum value of the absolute values of the data in the first data set is not in the magnitude mapping table, taking the magnitude of the minimum value of the absolute values of the data in the first data set as a first magnitude;
if the order of magnitude of the minimum value of the absolute values of the data in the second data set is in the order of magnitude mapping table, taking the order of magnitude higher than the order of magnitude of the minimum value of the absolute values of the data in the second data set as a second order of magnitude;
and if the magnitude of the minimum value of the absolute values of the data in the second data set is not in the magnitude mapping table, taking the magnitude of the minimum value of the absolute values of the data in the second data set as a second magnitude.
Optionally, the data processing device obtains a positive coordinate axis starting point by calculating according to the minimum value and the maximum value of the absolute value of the data in the first data set, and obtains a negative coordinate axis starting point by calculating according to the minimum value and the maximum value of the absolute value of the data in the second data set, where the method includes:
the start is min- (max-min)/n-max { (max-min)/n, gap }, and if the min- (max-min)/n is less than or equal to 0, the start is 0;
wherein min is the minimum of the absolute values of the data in the first data set, or the minimum of the absolute values of the data in the second data set;
when min is the minimum value of the absolute values of the data in the first data set, max is the maximum value of the absolute values of the data in the first data set, and gap is the minimum interval between the data in the first data set after the data in the first data set are sequentially arranged;
when min is the minimum value of the absolute values of the data in the second data set, max is the maximum value of the absolute values of the data in the second data set, and gap is the minimum interval between the data in the second data set after the data in the second data set are sequentially arranged;
if min is the minimum value of the absolute values of the data in the first data set and max is the maximum value of the absolute values of the data in the first data set, start is the start point of the positive coordinate axis;
if min is the minimum value of the absolute values of the data in the second data set and max is the maximum value of the absolute values of the data in the second data set, then-start is the start of the negative coordinate axis;
n is more than or equal to 10 and less than or equal to 100, and n is an integer.
Optionally, the linear growth graph includes:
a linearly increasing line graph, a linearly increasing bar graph.
In another aspect, an embodiment of the present application provides an apparatus for data processing based on a drill-down analysis scenario, where the apparatus includes: the system comprises an acquisition unit, a display unit and a processing unit, wherein the acquisition unit is used for acquiring original data which are arranged from small to large in the drilling analysis and the type of a target display graph of the original data;
a set determining unit, configured to, when the type of the target display graph is a linear growth graph, use, by the data processing apparatus, data that is not a negative number in the original data as a first data set, and use data that is a negative number in the original data as a second data set;
the calculating unit is used for calculating to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the first data set, and calculating to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the second data set;
the order-of-magnitude determining unit is used for obtaining a first order of magnitude according to the minimum value of the absolute value of the data in the first data set and the order-of-magnitude mapping table, and obtaining a second order of magnitude according to the minimum value of the absolute value of the data in the second data set and the order-of-magnitude mapping table;
a first calculating unit, configured to, when a ratio of the first metric quantity level to the second metric quantity level is within a preset range, take the first metric quantity level or the second metric quantity level as a final magnitude level, and divide the original data, the starting point of the positive coordinate axis, and the starting point of the negative coordinate axis by the final magnitude level to obtain final data;
a second calculating unit, configured to, when a ratio of the first metric magnitude to the second metric magnitude is not within a preset range, divide the data in the first data set and the positive axis starting point by the first metric magnitude to obtain first final data, and divide the data in the second data set and the negative axis starting point by the second metric magnitude to obtain second final data.
Optionally, the apparatus further comprises:
the final display graph rendering unit is used for combining the final data and a visual rendering template to render a final display graph;
the first display graph rendering unit is used for combining the first final data with a visualization rendering template to render a first display graph;
and the second display graph rendering unit is used for combining the second final data with the visual rendering template to render a second display graph.
Optionally, the order of magnitude determining unit includes:
a first determining unit, configured to, when an order of magnitude of a minimum value of absolute values of data in the first data set is within the order of magnitude mapping table, take, as a first metric magnitude, a one-step higher order of magnitude of the minimum value of absolute values of data in the first data set;
a second determining unit, configured to, when the magnitude of the minimum value of the absolute values of the data in the first data set is not within the magnitude mapping table, take the magnitude of the minimum value of the absolute values of the data in the first data set as a first magnitude;
a third determining unit, configured to, when an order of magnitude of a minimum value of absolute values of data in the second data set is within the order of magnitude mapping table, take a higher order of magnitude of the minimum value of absolute values of data in the second data set as a second order of magnitude;
a fourth determining unit, configured to, when the magnitude of the minimum value of the absolute values of the data in the second data set is not within the magnitude mapping table, take the magnitude of the minimum value of the absolute values of the data in the second data set as a second magnitude.
Optionally, the data processing device obtains a positive coordinate axis starting point by calculating according to the minimum value and the maximum value of the absolute value of the data in the first data set, and obtains a negative coordinate axis starting point by calculating according to the minimum value and the maximum value of the absolute value of the data in the second data set, where the method includes:
the start is min- (max-min)/n-max { (max-min)/n, gap }, and if the min- (max-min)/n is less than or equal to 0, the start is 0;
wherein min is the minimum of the absolute values of the data in the first data set, or the minimum of the absolute values of the data in the second data set;
when min is the minimum value of the absolute values of the data in the first data set, max is the maximum value of the absolute values of the data in the first data set, and gap is the minimum interval between the data in the first data set after the data in the first data set are sequentially arranged;
when min is the minimum value of the absolute values of the data in the second data set, max is the maximum value of the absolute values of the data in the second data set, and gap is the minimum interval between the data in the second data set after the data in the second data set are sequentially arranged;
if min is the minimum value of the absolute values of the data in the first data set and max is the maximum value of the absolute values of the data in the first data set, start is the start point of the positive coordinate axis;
if min is the minimum value of the absolute values of the data in the second data set and max is the maximum value of the absolute values of the data in the second data set, then-start is the start of the negative coordinate axis;
n is more than or equal to 10 and less than or equal to 100, and n is an integer.
Optionally, the linear growth graph includes:
a linearly increasing line graph, a linearly increasing bar graph.
According to the technical scheme, the method and the device for processing the scene data based on the drill-down analysis can obtain the original data and the types of the target display graphs of the original data which are arranged from small to large, if the types are linear growth graphs, the data which are not negative in the original data are used as a first data set, and the data which are negative in the original data are used as a second data set. And calculating to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the first data set, and calculating to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the second data set. Therefore, a reasonable coordinate axis starting point can be determined, and the situation that the display effect is poor due to the fact that the data are too close to the coordinate axis starting point is avoided. Obtaining a first metric magnitude according to the minimum of the absolute values of the data in the first data set and a magnitude mapping table, and obtaining a second metric magnitude according to the minimum of the absolute values of the data in the second data set and the magnitude mapping table; and whether the ratio of the first metric magnitude to the second metric magnitude is within a preset range can be judged, so that whether the drill down analysis data effect is good when one graph is displayed or the drill down analysis scene data effect is good when two graphs are displayed can be known. If the ratio of the first metric magnitude to the second metric magnitude is within the preset range, the first metric magnitude or the second metric magnitude can be taken as the final magnitude, that is, the magnitudes of the non-negative number and the negative number data are close to each other, and a better display effect can be achieved through one-graph display. If the ratio of the magnitude of the first metric to the magnitude of the second metric is not within the preset range, it indicates that the magnitude difference between the non-negative data and the negative data is large, and at this time, two graphs are needed to display the negative data and the non-negative data respectively, so as to obtain a good display effect. Therefore, the data are processed automatically, the corresponding magnitude of the data and the starting point value of the coordinate axis are obtained, the processed data and the visual image are rendered, a good display effect is achieved, and human resources and time cost are saved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a data processing method based on a drill-down analysis scenario according to an embodiment of the present application;
fig. 2 is a schematic diagram of an apparatus for data processing based on a drill-down analysis scenario according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The inventor of this application discovers through research, at present, under the drilling analysis show scene of visual figure, on the level of summarizing of difference, in order to make data keep better bandwagon effect relatively, design developer need carry out the frequent artifical adaptation of data pattern on the level of summarizing of difference, carry out artifical adaptation adjustment in order to reach better bandwagon effect promptly in each layer, consume a large amount of manpower resources, manpower and time cost are higher.
How to keep relatively good visualization graph display effect of data in different data summarization levels without spending much time and energy of design developers to adapt the styles is a problem to be solved in the field.
In order to solve the above problem, in the embodiment of the present application, a method and an apparatus for processing scene data based on drill-down analysis are provided, where types of target display graphs of original data and original data arranged in order from small to large may be obtained, and if the type is a linear growth graph, data that is not negative in the original data is used as a first data set, and data that is negative in the original data is used as a second data set. And calculating to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the first data set, and calculating to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the second data set. Therefore, a reasonable coordinate axis starting point can be determined, and the situation that the display effect is poor due to the fact that the data are too close to the coordinate axis starting point is avoided. Obtaining a first metric magnitude according to the minimum of the absolute values of the data in the first data set and a magnitude mapping table, and obtaining a second metric magnitude according to the minimum of the absolute values of the data in the second data set and the magnitude mapping table; and whether the ratio of the first metric magnitude to the second metric magnitude is within a preset range can be judged, so that whether the drill down analysis data effect is good when one graph is displayed or the drill down analysis scene data effect is good when two graphs are displayed can be known. If the ratio of the first metric magnitude to the second metric magnitude is within the preset range, the first metric magnitude or the second metric magnitude can be taken as the final magnitude, that is, the magnitudes of the non-negative number and the negative number data are close to each other, and a better display effect can be achieved through one-graph display. If the ratio of the magnitude of the first metric to the magnitude of the second metric is not within the preset range, it indicates that the magnitude difference between the non-negative data and the negative data is large, and at this time, two graphs are needed to display the negative data and the non-negative data respectively, so as to obtain a good display effect. Therefore, the data are processed automatically, the corresponding magnitude of the data and the starting point value of the coordinate axis are obtained, the processed data and the visual image are rendered, a good display effect is achieved, and human resources and time cost are saved.
Various non-limiting embodiments of the present application are described in detail below with reference to the accompanying drawings.
Exemplary method
Referring to fig. 1, the figure is a flowchart of a data processing method based on a drill-down analysis scenario provided in the present application. As shown in fig. 1, may include:
s101, the data processing equipment acquires original data arranged from small to large in the drill-down analysis and the type of a target display graph of the original data.
In the embodiment of the application, the coordinate axis of the data display in the visualization graph is mainly processed to be a linearly increasing visualization graph, so that the data processing equipment acquires original data which are arranged from small to large in the drill-down analysis, and renders the original data into the linearly increasing graph, such as a linearly increasing line graph, a linearly increasing column graph and the like, so that the data can be displayed more intuitively to a user.
And S102, if the type is a linear growth graph, the data processing equipment takes the data which is not negative in the original data as a first data set, and takes the data which is negative in the original data as a second data set.
In the embodiment of the present application, the raw data may include both data that is not negative and data that is negative, for example, the income data of the local financial amount may be non-negative, and the expenditure data of the local financial amount may be negative, because the non-negative data and the negative data are not on the same coordinate axis, the non-negative data is on the positive coordinate axis, and the negative data is on the negative coordinate axis, the non-negative data and the negative data need to be processed separately, that is, the data that is non-negative in the raw data is used as the first data set, and the data that is negative in the raw data is used as the second data set.
S103, the data processing equipment calculates to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute value of the data in the first data set, and calculates to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute value of the data in the second data set.
In the embodiment of the present application, the minimum value and the maximum value of the absolute values of the data in the first data set and the minimum value and the maximum value of the absolute values of the data in the second data set may be calculated.
Calculating to obtain a positive coordinate axis starting point corresponding to the first data set and a negative coordinate axis starting point corresponding to the second data set according to the minimum and maximum values of the respective absolute values in the first data set and the second data set, which may specifically be:
the start is min- (max-min)/n-max { (max-min)/n, gap }, and if min- (max-min)/n is less than or equal to 0, the start is 0;
wherein min is the minimum of the absolute values of the data in the first data set, or the minimum of the absolute values of the data in the second data set;
when min is the minimum value of the absolute values of the data in the first data set, max is the maximum value of the absolute values of the data in the first data set, and gap is the minimum interval between the data in the first data set after the data in the first data set are sequentially arranged;
when min is the minimum value of the absolute values of the data in the second data set, max is the maximum value of the absolute values of the data in the second data set, and gap is the minimum interval between the data in the second data set after the data in the second data set are sequentially arranged;
if min is the minimum value of the absolute values of the data in the first data set and max is the maximum value of the absolute values of the data in the first data set, start is the start of the positive coordinate axis;
if min is the minimum value of the absolute values of the data in the second data set and max is the maximum value of the absolute values of the data in the second data set, then-start is the start of the negative coordinate axis;
n is more than or equal to 10 and less than or equal to 100, and n is an integer.
The positive coordinate axis starting point corresponding to the first data set and the negative coordinate axis starting point corresponding to the second data set can be obtained through the formula calculation, so that reasonable distances are kept between the data in the first data set and the data in the second data set and the respective coordinate axis starting points, and the graph obtained through subsequent rendering can have a good display effect.
And S104, the data processing equipment obtains a first metric magnitude according to the minimum value of the absolute value of the data in the first data set and the magnitude mapping table, and obtains a second metric magnitude according to the minimum value of the absolute value of the data in the second data set and the magnitude mapping table.
In the embodiment of the present application, the order mapping table may be map ═ { 1:', 10^4: "ten", 10^ 8: "hundred million", 10^ 12: trillion, wherein the unit corresponding to 1 may be determined according to an application scenario, for example, when the data is deposit data, the unit corresponding to 1 is a "element", and corresponds to different units according to different application scenarios, so that the map in the embodiment of the present application is not specifically limited, and may be adjusted according to an actual application scenario.
If the order of magnitude of the minimum value of the absolute values of the data in the first data set is within the order of magnitude mapping table, the order of magnitude of the minimum value of the absolute values of the data in the first data set is taken to be one order of magnitude higher than the order of magnitude of the minimum value of the absolute values of the data in the first data set as the first order of magnitude. For example, when the minimum value of the absolute values of the data in the first data set is in the order of "ten thousand", and it can be known by looking up the table that the order of "ten thousand" is in the order mapping table, the order of "one hundred thousand" higher than the "ten thousand" is taken as the first order of magnitude.
If the magnitude of the minimum of the absolute values of the data in the first data set is not in the magnitude mapping table, the magnitude of the minimum of the absolute values of the data in the first data set is taken as the first magnitude, for example, when the minimum of the absolute values of the data in the first data set is 0.0008, the first magnitude is taken as 10^ (-4).
Similarly, if the magnitude of the minimum value of the absolute values of the data in the second data set is within the magnitude mapping table, the magnitude of the minimum value of the absolute values of the data in the second data set that is one-step higher is taken as the second magnitude.
And if the magnitude of the minimum value of the absolute values of the data in the second data set is not in the magnitude mapping table, taking the magnitude of the minimum value of the absolute values of the data in the second data set as the second magnitude.
S105, if the ratio of the first metric magnitude to the second metric magnitude is within a preset range, the data processing equipment takes the first metric magnitude or the second metric magnitude as a final magnitude, and divides the original data, the starting point of the positive coordinate axis and the starting point of the negative coordinate axis by the final magnitude to obtain final data.
In this embodiment of the application, if the ratio of the first metric magnitude to the second metric magnitude is within the preset range, it may be considered that the difference between the first metric magnitude and the second metric magnitude is not large, and a better display effect can still be obtained by rendering the first data set and the second data set in the same graph. The preset range can be set by a person skilled in the art according to actual situations, for example, the number of the preset range can be [1,10], that is, if the first measurement is in the order of "ten thousand", and the second measurement is in the order of "thousand", the ratio of the two is in the preset range, and at this time, any one of "ten thousand" or "thousand" can be selected as the final order. And dividing the original data, the starting point of the positive coordinate axis and the starting point of the negative coordinate axis by the final order of magnitude to obtain final data. And the data processing equipment combines the final data with the visual rendering template to render a final display graph.
S106, if the ratio of the first metric magnitude to the second metric magnitude is not within a preset range, dividing the data in the first data set and the starting point of the positive coordinate axis by the first metric magnitude to obtain first final data, and dividing the data in the second data set and the starting point of the negative coordinate axis by the second metric magnitude to obtain second final data.
In this embodiment of the application, if the ratio of the first metric magnitude to the second metric magnitude is not within the preset range, it indicates that the difference between the first metric magnitude and the second metric magnitude is large, and if the first data set and the second data set are to be rendered in the same graph, the obtained display effect is poor, so at this time, the first data set and the second data set need to be rendered respectively, that is, two graphs are obtained, the data in the first data set and the positive coordinate axis starting point are divided by the first metric magnitude to obtain first final data, and the data in the second data set and the negative coordinate axis starting point are divided by the second metric magnitude to obtain second final data.
And combining the first final data with a visual rendering template to render a first display graph, and combining the second final data with the visual rendering template to render a second display graph.
The embodiment of the application provides a method for processing scene data based on drill-down analysis, which can acquire original data and types of target display graphs of the original data, wherein the original data and the types of the target display graphs of the original data are arranged from small to large, if the types are linear growth graphs, data which are not negative numbers in the original data are used as a first data set, and data which are negative numbers in the original data are used as a second data set. And calculating to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the first data set, and calculating to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the second data set. Therefore, a reasonable coordinate axis starting point can be determined, and the situation that the display effect is poor due to the fact that the data are too close to the coordinate axis starting point is avoided. Obtaining a first metric magnitude according to the minimum of the absolute values of the data in the first data set and a magnitude mapping table, and obtaining a second metric magnitude according to the minimum of the absolute values of the data in the second data set and the magnitude mapping table; and whether the ratio of the first metric magnitude to the second metric magnitude is within a preset range can be judged, so that whether the drill down analysis data effect is good when one graph is displayed or the drill down analysis scene data effect is good when two graphs are displayed can be known. If the ratio of the first metric magnitude to the second metric magnitude is within the preset range, the first metric magnitude or the second metric magnitude can be taken as the final magnitude, that is, the magnitudes of the non-negative number and the negative number data are close to each other, and a better display effect can be achieved through one-graph display. If the ratio of the magnitude of the first metric to the magnitude of the second metric is not within the preset range, it indicates that the magnitude difference between the non-negative data and the negative data is large, and at this time, two graphs are needed to display the negative data and the non-negative data respectively, so as to obtain a good display effect. Therefore, the data are processed automatically, the corresponding magnitude of the data and the starting point value of the coordinate axis are obtained, the processed data and the visual image are rendered, a good display effect is achieved, and human resources and time cost are saved.
Exemplary devices
Referring to fig. 2, an apparatus for processing scene data based on drill-down analysis provided in an embodiment of the present application may include:
an obtaining unit 201, configured to obtain original data arranged in a descending analysis in a descending order and types of target display graphs of the original data;
a set determining unit 202, configured to, when the type of the target display graph is a linear growth graph, use, by the data processing apparatus, data that is not a negative number in the original data as a first data set, and use data that is a negative number in the original data as a second data set;
a calculating unit 203, configured to calculate a positive coordinate axis starting point according to a minimum value and a maximum value of absolute values of the data in the first data set, and calculate a negative coordinate axis starting point according to a minimum value and a maximum value of absolute values of the data in the second data set;
a magnitude determining unit 204, configured to obtain a first magnitude according to the minimum of the absolute values of the data in the first data set and a magnitude mapping table, and obtain a second magnitude according to the minimum of the absolute values of the data in the second data set and the magnitude mapping table;
a first calculating unit 205, configured to, when a ratio of the first metric magnitude to the second metric magnitude is within a preset range, take the first metric magnitude or the second metric magnitude as a final magnitude, and divide the original data, the starting point of the positive coordinate axis, and the starting point of the negative coordinate axis by the final magnitude to obtain final data;
a second calculating unit 206, configured to, when a ratio of the first metric magnitude to the second metric magnitude is not within a preset range, divide the data in the first data set and the positive axis starting point by the first metric magnitude to obtain first final data, and divide the data in the second data set and the negative axis starting point by the second metric magnitude to obtain second final data.
In some embodiments, the apparatus further comprises:
the final display graph rendering unit is used for combining the final data and a visual rendering template to render a final display graph;
the first display graph rendering unit is used for combining the first final data with a visualization rendering template to render a first display graph;
and the second display graph rendering unit is used for combining the second final data with the visual rendering template to render a second display graph.
In some embodiments, the order of magnitude determination unit includes:
a first determining unit, configured to, when an order of magnitude of a minimum value of absolute values of data in the first data set is within the order of magnitude mapping table, take, as a first metric magnitude, a one-step higher order of magnitude of the minimum value of absolute values of data in the first data set;
a second determining unit, configured to, when the magnitude of the minimum value of the absolute values of the data in the first data set is not within the magnitude mapping table, take the magnitude of the minimum value of the absolute values of the data in the first data set as a first magnitude;
a third determining unit, configured to, when an order of magnitude of a minimum value of absolute values of data in the second data set is within the order of magnitude mapping table, take a higher order of magnitude of the minimum value of absolute values of data in the second data set as a second order of magnitude;
a fourth determining unit, configured to, when the magnitude of the minimum value of the absolute values of the data in the second data set is not within the magnitude mapping table, take the magnitude of the minimum value of the absolute values of the data in the second data set as a second magnitude.
In some embodiments, the data processing apparatus calculating a positive coordinate axis starting point from a minimum value and a maximum value of absolute values of data in the first data set, and calculating a negative coordinate axis starting point from a minimum value and a maximum value of absolute values of data in the second data set, includes:
the start is min- (max-min)/n-max { (max-min)/n, gap }, and if the min- (max-min)/n is less than or equal to 0, the start is 0;
wherein min is the minimum of the absolute values of the data in the first data set, or the minimum of the absolute values of the data in the second data set;
when min is the minimum value of the absolute values of the data in the first data set, max is the maximum value of the absolute values of the data in the first data set, and gap is the minimum interval between the data in the first data set after the data in the first data set are sequentially arranged;
when min is the minimum value of the absolute values of the data in the second data set, max is the maximum value of the absolute values of the data in the second data set, and gap is the minimum interval between the data in the second data set after the data in the second data set are sequentially arranged;
if min is the minimum value of the absolute values of the data in the first data set and max is the maximum value of the absolute values of the data in the first data set, start is the start point of the positive coordinate axis;
if min is the minimum value of the absolute values of the data in the second data set and max is the maximum value of the absolute values of the data in the second data set, then-start is the start of the negative coordinate axis;
n is more than or equal to 10 and less than or equal to 100, and n is an integer.
In some embodiments, the linear growth graph comprises:
a linearly increasing line graph, a linearly increasing bar graph.
The embodiment of the application provides a device for processing scene data based on drill-down analysis, which can acquire original data and types of target display graphs of the original data, wherein the original data and the types of the target display graphs of the original data are arranged from small to large, if the types are linear growth graphs, data which are not negative numbers in the original data are used as a first data set, and data which are negative numbers in the original data are used as a second data set. And calculating to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the first data set, and calculating to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the second data set. Therefore, a reasonable coordinate axis starting point can be determined, and the situation that the display effect is poor due to the fact that the data are too close to the coordinate axis starting point is avoided. Obtaining a first metric magnitude according to the minimum of the absolute values of the data in the first data set and a magnitude mapping table, and obtaining a second metric magnitude according to the minimum of the absolute values of the data in the second data set and the magnitude mapping table; and whether the ratio of the first metric magnitude to the second metric magnitude is within a preset range can be judged, so that whether the drill down analysis data effect is good when one graph is displayed or the drill down analysis scene data effect is good when two graphs are displayed can be known. If the ratio of the first metric magnitude to the second metric magnitude is within the preset range, the first metric magnitude or the second metric magnitude can be taken as the final magnitude, that is, the magnitudes of the non-negative number and the negative number data are close to each other, and a better display effect can be achieved through one-graph display. If the ratio of the magnitude of the first metric to the magnitude of the second metric is not within the preset range, it indicates that the magnitude difference between the non-negative data and the negative data is large, and at this time, two graphs are needed to display the negative data and the non-negative data respectively, so as to obtain a good display effect. Therefore, the data are processed automatically, the corresponding magnitude of the data and the starting point value of the coordinate axis are obtained, the processed data and the visual image are rendered, a good display effect is achieved, and human resources and time cost are saved.
The setting of each unit or module of the apparatus of the present application can be implemented by referring to the method shown in fig. 1, and is not described herein again.
It should be noted that, in the present specification, all the embodiments are described in a progressive manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the apparatus and system embodiments, since they are substantially similar to the method embodiments, they are described in a relatively simple manner, and reference may be made to some of the descriptions of the method embodiments for related points. The above-described embodiments of the apparatus and system are merely illustrative, and the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
The above description is only one specific embodiment of the present application, but the scope of the present application is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present application should be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (10)
1. A method for processing data based on a drill-down analysis scenario, the method comprising:
the method comprises the steps that data processing equipment obtains original data arranged from small to big in a drilling analysis and the type of a target display graph of the original data;
if the type is a linear growth graph, the data processing equipment takes the data which are not negative in the original data as a first data set, and takes the data which are negative in the original data as a second data set;
the data processing equipment calculates to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the first data set, and calculates to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the second data set;
the data processing equipment obtains a first metric magnitude according to the minimum value of the absolute value of the data in the first data set and the magnitude mapping table, and obtains a second metric magnitude according to the minimum value of the absolute value of the data in the second data set and the magnitude mapping table;
if the ratio of the first metric magnitude to the second metric magnitude is within a preset range, the data processing equipment takes the first metric magnitude or the second metric magnitude as a final magnitude, and divides the original data, the starting point of the positive coordinate axis and the starting point of the negative coordinate axis by the final magnitude to obtain final data;
if the ratio of the first metric magnitude to the second metric magnitude is not within the preset range, dividing the data in the first data set and the starting point of the positive coordinate axis by the first metric magnitude to obtain first final data, and dividing the data in the second data set and the starting point of the negative coordinate axis by the second metric magnitude to obtain second final data.
2. The method of claim 1, further comprising:
the data processing equipment combines the final data with a visual rendering template to render a final display graph; or; and the data processing equipment combines the first final data and a visual rendering template to render a first display graph, and combines the second final data and the visual rendering template to render a second display graph.
3. The method of claim 1, wherein the data processing device derives a first metric magnitude from the minimum of absolute values of the data in the first data set and a magnitude mapping table, and derives a second metric magnitude from the minimum of absolute values of the data in the second data set and a magnitude mapping table, comprising:
if the magnitude of the minimum value of the absolute values of the data in the first data set is in the magnitude mapping table, taking the magnitude of the minimum value of the absolute values of the data in the first data set which is one-step higher as a first magnitude;
if the magnitude of the minimum value of the absolute values of the data in the first data set is not in the magnitude mapping table, taking the magnitude of the minimum value of the absolute values of the data in the first data set as a first magnitude;
if the order of magnitude of the minimum value of the absolute values of the data in the second data set is in the order of magnitude mapping table, taking the order of magnitude higher than the order of magnitude of the minimum value of the absolute values of the data in the second data set as a second order of magnitude;
and if the magnitude of the minimum value of the absolute values of the data in the second data set is not in the magnitude mapping table, taking the magnitude of the minimum value of the absolute values of the data in the second data set as a second magnitude.
4. The method of claim 1, wherein the data processing device calculates a positive axis starting point from a minimum value and a maximum value of absolute values of the data in the first data set and calculates a negative axis starting point from a minimum value and a maximum value of absolute values of the data in the second data set, comprising:
the start is min- (max-min)/n-max { (max-min)/n, gap }, and if the min- (max-min)/n is less than or equal to 0, the start is 0;
wherein min is the minimum of the absolute values of the data in the first data set, or the minimum of the absolute values of the data in the second data set;
when min is the minimum value of the absolute values of the data in the first data set, max is the maximum value of the absolute values of the data in the first data set, and gap is the minimum interval between the data in the first data set after the data in the first data set are sequentially arranged;
when min is the minimum value of the absolute values of the data in the second data set, max is the maximum value of the absolute values of the data in the second data set, and gap is the minimum interval between the data in the second data set after the data in the second data set are sequentially arranged;
if min is the minimum value of the absolute values of the data in the first data set and max is the maximum value of the absolute values of the data in the first data set, start is the start point of the positive coordinate axis;
if min is the minimum value of the absolute values of the data in the second data set and max is the maximum value of the absolute values of the data in the second data set, then-start is the start of the negative coordinate axis;
n is more than or equal to 10 and less than or equal to 100, and n is an integer.
5. The method of claim 1, wherein the linear growth graph comprises:
a linearly increasing line graph, a linearly increasing bar graph.
6. A data processing apparatus based on a drill-down analysis scenario, the apparatus comprising:
the system comprises an acquisition unit, a display unit and a processing unit, wherein the acquisition unit is used for acquiring original data which are arranged from small to large in the drilling analysis and the type of a target display graph of the original data;
a set determining unit, configured to, when the type of the target display graph is a linear growth graph, use, by the data processing apparatus, data that is not a negative number in the original data as a first data set, and use data that is a negative number in the original data as a second data set;
the calculating unit is used for calculating to obtain a positive coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the first data set, and calculating to obtain a negative coordinate axis starting point according to the minimum value and the maximum value of the absolute values of the data in the second data set;
the order-of-magnitude determining unit is used for obtaining a first order of magnitude according to the minimum value of the absolute value of the data in the first data set and the order-of-magnitude mapping table, and obtaining a second order of magnitude according to the minimum value of the absolute value of the data in the second data set and the order-of-magnitude mapping table;
a first calculating unit, configured to, when a ratio of the first metric quantity level to the second metric quantity level is within a preset range, take the first metric quantity level or the second metric quantity level as a final magnitude level, and divide the original data, the starting point of the positive coordinate axis, and the starting point of the negative coordinate axis by the final magnitude level to obtain final data;
a second calculating unit, configured to, when a ratio of the first metric magnitude to the second metric magnitude is not within a preset range, divide the data in the first data set and the positive axis starting point by the first metric magnitude to obtain first final data, and divide the data in the second data set and the negative axis starting point by the second metric magnitude to obtain second final data.
7. The apparatus of claim 6, further comprising:
the final display graph rendering unit is used for combining the final data and a visual rendering template to render a final display graph;
the first display graph rendering unit is used for combining the first final data with a visualization rendering template to render a first display graph;
and the second display graph rendering unit is used for combining the second final data with the visual rendering template to render a second display graph.
8. The apparatus of claim 6, wherein the order of magnitude determination unit comprises:
a first determining unit, configured to, when an order of magnitude of a minimum value of absolute values of data in the first data set is within the order of magnitude mapping table, take, as a first metric magnitude, a one-step higher order of magnitude of the minimum value of absolute values of data in the first data set;
a second determining unit, configured to, when the magnitude of the minimum value of the absolute values of the data in the first data set is not within the magnitude mapping table, take the magnitude of the minimum value of the absolute values of the data in the first data set as a first magnitude;
a third determining unit, configured to, when an order of magnitude of a minimum value of absolute values of data in the second data set is within the order of magnitude mapping table, take a higher order of magnitude of the minimum value of absolute values of data in the second data set as a second order of magnitude;
a fourth determining unit, configured to, when the magnitude of the minimum value of the absolute values of the data in the second data set is not within the magnitude mapping table, take the magnitude of the minimum value of the absolute values of the data in the second data set as a second magnitude.
9. The apparatus of claim 6, wherein the data processing device calculates a positive axis starting point from a minimum value and a maximum value of absolute values of the data in the first data set, and calculates a negative axis starting point from a minimum value and a maximum value of absolute values of the data in the second data set, comprising:
the start is min- (max-min)/n-max { (max-min)/n, gap }, and if the min- (max-min)/n is less than or equal to 0, the start is 0;
wherein min is the minimum of the absolute values of the data in the first data set, or the minimum of the absolute values of the data in the second data set;
when min is the minimum value of the absolute values of the data in the first data set, max is the maximum value of the absolute values of the data in the first data set, and gap is the minimum interval between the data in the first data set after the data in the first data set are sequentially arranged;
when min is the minimum value of the absolute values of the data in the second data set, max is the maximum value of the absolute values of the data in the second data set, and gap is the minimum interval between the data in the second data set after the data in the second data set are sequentially arranged;
if min is the minimum value of the absolute values of the data in the first data set and max is the maximum value of the absolute values of the data in the first data set, start is the start point of the positive coordinate axis;
if min is the minimum value of the absolute values of the data in the second data set and max is the maximum value of the absolute values of the data in the second data set, then-start is the start of the negative coordinate axis;
n is more than or equal to 10 and less than or equal to 100, and n is an integer.
10. The apparatus of claim 6, wherein the linear growth graph comprises:
a linearly increasing line graph, a linearly increasing bar graph.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011637211.8A CN112612847B (en) | 2020-12-31 | 2020-12-31 | Method and device for processing data based on drill-down analysis scene |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011637211.8A CN112612847B (en) | 2020-12-31 | 2020-12-31 | Method and device for processing data based on drill-down analysis scene |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112612847A true CN112612847A (en) | 2021-04-06 |
| CN112612847B CN112612847B (en) | 2023-12-08 |
Family
ID=75253180
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011637211.8A Active CN112612847B (en) | 2020-12-31 | 2020-12-31 | Method and device for processing data based on drill-down analysis scene |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112612847B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101339665A (en) * | 2008-08-21 | 2009-01-07 | 金蝶软件（中国）有限公司 | Method and device for automatically creating radar graph |
| US10373058B1 (en) * | 2013-10-10 | 2019-08-06 | Jsonar, Inc. | Unstructured database analytics processing |
| CN110851522A (en) * | 2018-08-21 | 2020-02-28 | 北京京东尚科信息技术有限公司 | Method and device for displaying data |
-
2020
- 2020-12-31 CN CN202011637211.8A patent/CN112612847B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101339665A (en) * | 2008-08-21 | 2009-01-07 | 金蝶软件（中国）有限公司 | Method and device for automatically creating radar graph |
| US10373058B1 (en) * | 2013-10-10 | 2019-08-06 | Jsonar, Inc. | Unstructured database analytics processing |
| CN110851522A (en) * | 2018-08-21 | 2020-02-28 | 北京京东尚科信息技术有限公司 | Method and device for displaying data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112612847B (en) | 2023-12-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106327339B (en) | Second channel ranker for push notifications in social networks | |
| US9413807B1 (en) | Browser rendering and computation | |
| Stern et al. | On reconciling disparate studies of the sea-ice floe size distribution | |
| CN110675728B (en) | Generation method, device and equipment of thermodynamic diagram and computer readable storage medium | |
| CN105005980B (en) | Image processing method and device | |
| KR101721114B1 (en) | Method for Determining the Size of Grid for Clustering on Multi-Scale Web Map Services using Location-Based Point Data | |
| CN110865862B (en) | Page background setting method and device and electronic equipment | |
| US8947434B2 (en) | Process for determining, scaling, providing, comparative information in accurate, useful, easily recognized, and understandable manner | |
| CN110363837B (en) | Method and device for processing texture image in game, electronic equipment and storage medium | |
| CN104978407B (en) | System and method is presented in visualization for high dimensional data characteristic attribute variation tendency | |
| EP1246124A2 (en) | Image space display method and apparatus | |
| CN111930330A (en) | Method, device and system for synchronizing shared views | |
| CN105488470A (en) | Method and apparatus for determining character attribute information | |
| CN113516697B (en) | Image registration method, device, electronic equipment and computer readable storage medium | |
| CN107203312A (en) | Rendering intent, the storage device of mobile terminal and its picture | |
| US8139065B2 (en) | Machine-implemented method and electronic device for presenting a dual-axis graph | |
| KR101487454B1 (en) | method for parallel processing of LOD image | |
| CN112612847A (en) | Data processing method and device based on drill-down analysis scene | |
| CN107085521A (en) | A kind of icon display method and device | |
| CN113837181B (en) | Screening method, screening device, computer equipment and computer readable storage medium | |
| CN114610308A (en) | Application function layout adjusting method and device, electronic equipment and storage medium | |
| CN103092818B (en) | Thumbnail generation system and the reduced graph generating method of form | |
| CN106547891A (en) | For the quick visualization method of the pictured text message of palm display device | |
| WO2016069725A1 (en) | Apparatus and method for analyzing content posted in social media | |
| CN110764860A (en) | Project configuration method, device, server and storage medium in user interface |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |