CN110688363A - Data standardization processing method and system, electronic equipment and storage medium - Google Patents
Data standardization processing method and system, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN110688363A CN110688363A CN201910822839.6A CN201910822839A CN110688363A CN 110688363 A CN110688363 A CN 110688363A CN 201910822839 A CN201910822839 A CN 201910822839A CN 110688363 A CN110688363 A CN 110688363A
- Authority
- CN
- China
- Prior art keywords
- data
- compared
- individual value
- period
- target
- 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
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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the technical field of data processing, and discloses a data standardization processing method and system, electronic equipment and a storage medium. The method comprises the following steps: determining data of a specified period as standard data; converting individual values to be compared in the data to be compared according to a preset standard conversion mode to obtain conversion values corresponding to the individual values to be compared, wherein the data to be compared is data of a period to be compared; determining a target individual value corresponding to the individual value to be compared from the standard data; and comparing the conversion value corresponding to the individual value to be compared with the target individual value to realize the transverse comparison of the individual value to be compared with the target individual value. Therefore, by implementing the method and the device, the data can be standardized, the data generated in different periods can be transversely compared, and effective differences can be analyzed.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and a system for standardized processing of data, an electronic device, and a storage medium.
Background
Data are obtained by observation, experiment or calculation, and the data have various forms, and the simplest form is numerical value. Data is ubiquitous in life, and the states of things from which the data derives can be known by analyzing the data. For example, the development trend of the object can be known by comparing the data of different periods of the same object. However, it is generally difficult to perform a horizontal comparison between data in different periods, for example, the test score of a student in the Chinese subject period is 90, and the test paper difficulty of the middle test and the test paper difficulty of the end test are not consistent, so that it is not possible to directly determine whether the student's Chinese subject has advanced by comparing the scores of two tests. It can be seen that two data at different periods cannot be compared transversely, so that effective differences cannot be analyzed.
Disclosure of Invention
In order to solve the problem that two data in different periods cannot be transversely compared in the related art, the invention provides a data standardization processing method and system, an electronic device and a storage medium.
The first aspect of the embodiments of the present invention discloses a method for standardizing data, which includes:
determining data of a specified period as standard data;
converting individual values to be compared in data to be compared according to a preset standardized conversion mode to obtain conversion values corresponding to the individual values to be compared; the data to be compared is data of a period to be compared;
determining a target individual value corresponding to the individual value to be compared from the standard data according to the attribute information of the individual value to be compared, wherein the attribute information of the individual value to be compared is the same as the attribute information of the target individual value;
and comparing the conversion value corresponding to the individual value to be compared with the target individual value to realize the transverse comparison of the individual value to be compared with the target individual value.
As an optional implementation manner, in the first aspect of the embodiment of the present invention, after the comparing the converted value corresponding to the individual value to be compared with the target individual value to achieve the transverse comparison between the individual value to be compared and the target individual value, the method further includes:
and acquiring a conversion value corresponding to each individual value in the data to be compared so as to convert the distribution form of the data to be compared into a standard distribution form, wherein the standard distribution form is the distribution form of the standard data.
As an optional implementation manner, in the first aspect of the embodiment of the present invention, the preset standardized conversion manner is calculated by using a preset formula, where the preset formula is:
wherein, X is a conversion value corresponding to the individual value to be compared, a is the individual value to be compared, b is the average value of the data to be compared, c is the standard deviation of the data to be compared, d is the standard deviation of the standard data, and e is the average value of the standard data.
As an optional implementation manner, in the first aspect of this embodiment of the present invention, the method further includes:
acquiring conversion data corresponding to data of a history period, wherein the conversion data corresponding to the data of the history period comprises a conversion value corresponding to each individual value in the data of the history period;
acquiring personnel information corresponding to each individual value in the data of the historical period;
storing a conversion value corresponding to each individual value in the data of the historical period and the personnel information corresponding to each individual value in the data of the historical period in a database in an associated manner to serve as the data information of the historical period;
when score inquiry request information sent by a user terminal is received, searching the database to obtain a conversion value corresponding to a target individual value of a target person in a target period; the grading inquiry request information comprises information of the target period and information of the target personnel, wherein the information of the target personnel comprises attributes of the target personnel;
obtaining a scoring weight according to the attribute of the target person;
and taking the product of the grading weight and a conversion value corresponding to the target individual value as a target score, and sending the target score to the user terminal.
As an optional implementation manner, in the first aspect of the embodiment of the present invention, when receiving scoring query request information sent by a user terminal, searching the database to obtain a conversion value corresponding to a target individual value of a target person in a target period includes:
when receiving grading inquiry request information sent by a user terminal, judging whether a user corresponding to the user terminal has inquiry authority or not;
if yes, searching the database to obtain a conversion value corresponding to the target individual value of the target person in the target period.
As an optional implementation manner, in the first aspect of the embodiment of the present invention, after the associating and storing the conversion value corresponding to each individual value in the data of the history period and the person information corresponding to each individual value in the data of the history period in a database as the data information of the history period, the method further includes:
when contrast request information sent by a user terminal is received, searching the database to obtain the data information of the first contrast period and the data information of the second contrast period; the comparison request information at least comprises a first comparison period and a second comparison period;
generating a comparison result according to the data information of the first comparison period and the data information of the second comparison period;
and sending the comparison result to the user terminal.
As an optional implementation manner, in the first aspect of the embodiment of the present invention, before sending the comparison result to the user terminal, the method includes:
drawing the data information of the first comparison period and the data information of the second comparison period in a data chart to generate a comparison chart;
the sending the comparison result to the user terminal includes:
and sending the comparison result and the comparison chart to the user terminal.
The second aspect of the embodiments of the present invention discloses a data normalization processing system, which includes:
a first determination unit configured to determine that data of a specified period is standard data;
the conversion unit is used for converting the individual value to be compared in the data to be compared according to a preset standard conversion mode to obtain a conversion value corresponding to the individual value to be compared; the data to be compared is data of a period to be compared;
a second determining unit, configured to determine, according to the attribute information of the individual value to be compared, a target individual value corresponding to the individual value to be compared from the standard data, where the attribute information of the individual value to be compared is the same as the attribute information of the target individual value;
and the comparison unit is used for comparing the conversion value corresponding to the individual value to be compared with the target individual value so as to realize the transverse comparison of the individual value to be compared with the target individual value.
A third aspect of an embodiment of the present invention discloses an electronic device, including:
a processor;
a memory, on which computer readable instructions are stored, and when the computer readable instructions are executed by the processor, the method for standardizing data disclosed in the first aspect of the embodiments of the present invention is implemented.
A fourth aspect of the embodiments of the present invention discloses a computer-readable storage medium that stores a computer program, where the computer program causes a computer to execute the method for standardized processing of data disclosed in the first aspect of the embodiments of the present invention.
The technical scheme provided by the embodiment of the invention can have the following beneficial effects:
the data standardization processing method provided by the invention comprises the following steps:
determining data of a specified period as standard data; converting individual values to be compared in the data to be compared according to a preset standard conversion mode to obtain conversion values corresponding to the individual values to be compared, wherein the data to be compared is data of a period to be compared; determining a target individual value corresponding to the individual value to be compared from the standard data; and comparing the conversion value corresponding to the individual value to be compared with the target individual value to realize the transverse comparison of the individual value to be compared with the target individual value.
In the method, data of a specified period is taken as standard data, the individual value to be compared in the data to be compared is subjected to standardized conversion to obtain a conversion value corresponding to the individual value to be compared, a target individual value corresponding to the individual value to be compared is determined in the standard data, then the conversion value corresponding to the individual value to be compared is compared with the target individual value, and transverse comparison between the individual value to be compared and the target individual value can be realized. Therefore, by implementing the method and the device, the data generated in different periods can be transversely compared, and further effective difference can be analyzed.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention, as claimed.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention.
FIG. 1 is a schematic structural diagram of an apparatus according to an embodiment of the present invention;
FIG. 2 is a flow chart of a method for normalizing data according to an embodiment of the present invention;
FIG. 3 is a flow chart of another method for normalizing data according to the disclosure;
FIG. 4 is a schematic structural diagram of a data normalization processing system according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of another data normalization processing system disclosed in the embodiment of the present invention.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present invention. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the invention, as detailed in the appended claims.
Example one
The implementation environment of the invention may be an electronic device, such as a smartphone, a tablet computer, a desktop computer.
Fig. 1 is a schematic structural diagram of an apparatus according to an embodiment of the present invention. The apparatus 100 may be the electronic device described above. As shown in fig. 1, the apparatus 100 may include one or more of the following components: a processing component 102, a memory 104, a power component 106, a multimedia component 108, an audio component 110, a sensor component 114, and a communication component 116.
The processing component 102 generally controls overall operation of the device 100, such as operations associated with display, telephone calls, data communications, camera operations, and recording operations, among others. The processing components 102 may include one or more processors 118 to execute instructions to perform all or a portion of the steps of the methods described below. Further, the processing component 102 can include one or more modules for facilitating interaction between the processing component 102 and other components. For example, the processing component 102 can include a multimedia module for facilitating interaction between the multimedia component 108 and the processing component 102.
The memory 104 is configured to store various types of data to support operations at the apparatus 100. Examples of such data include instructions for any application or method operating on the device 100. The Memory 104 may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as Static Random Access Memory (SRAM), Electrically erasable Programmable Read-Only Memory (EEPROM), erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk or optical disk. Also stored in memory 104 are one or more modules for execution by the one or more processors 118 to perform all or a portion of the steps of the methods described below.
The power supply component 106 provides power to the various components of the device 100. The power components 106 may include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power for the device 100.
The multimedia component 108 includes a screen that provides an output interface between the device 100 and the user. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a touch panel. If the screen includes a touch panel, the screen may be implemented as a touch screen to receive an input signal from a user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundary of a touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. The screen may further include an Organic Light Emitting Display (OLED for short).
The audio component 110 is configured to output and/or input audio signals. For example, the audio component 110 includes a Microphone (MIC) configured to receive external audio signals when the device 100 is in an operational mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signal may further be stored in the memory 104 or transmitted via the communication component 116. In some embodiments, the audio component 110 further comprises a speaker for outputting audio signals.
The sensor assembly 114 includes one or more sensors for providing various aspects of status assessment for the device 100. For example, the sensor assembly 114 may detect the open/closed status of the device 100, the relative positioning of the components, the sensor assembly 114 may also detect a change in position of the device 100 or a component of the device 100, and a change in temperature of the device 100. In some embodiments, the sensor assembly 114 may also include a magnetic sensor, a pressure sensor, or a temperature sensor.
The communication component 116 is configured to facilitate wired or wireless communication between the apparatus 100 and other devices. The device 100 may access a Wireless network based on a communication standard, such as WiFi (Wireless-Fidelity). In an embodiment of the present invention, the communication component 116 receives a broadcast signal or broadcast related information from an external broadcast management system via a broadcast channel. In the embodiment of the present invention, the Communication component 116 further includes a Near Field Communication (NFC) module for facilitating short-range Communication. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, Infrared Data Association (IrDA) technology, Ultra Wideband (UWB) technology, bluetooth technology, and other technologies.
In an exemplary embodiment, the apparatus 100 may be implemented by one or more Application Specific Integrated Circuits (ASICs), digital signal processors, digital signal processing devices, programmable logic devices, field programmable gate arrays, controllers, microcontrollers, microprocessors or other electronic components for performing the methods described below.
Example two
Referring to fig. 2, fig. 2 is a schematic flow chart of a data normalization processing method according to an embodiment of the invention. The method for normalizing the data as shown in fig. 2 may include the steps of:
201. and determining the data of the specified period as standard data.
In the embodiment of the present invention, it can be understood that the specified period may be one week, one month, one year, and the like, and the embodiment of the present invention is not limited. The data for the given period may be a set of several of all individual values generated for the given period. Such as a data set of the number of sales each realized in spring for all the clerks of a business department, or a set of scores each taken by all the students of a class during the term, etc.
202. And converting the individual value to be compared in the data to be compared according to a preset standard conversion mode to obtain a conversion value corresponding to the individual value to be compared, wherein the data to be compared is data of a period to be compared.
In the embodiment of the present invention, it can be understood that the data of the period to be compared may be a set composed of a plurality of all individual values generated in the period to be compared; the individual value to be compared in the data to be compared can be any one individual value in the data to be compared; the period to be compared may be one week, one month, one year, etc., and the embodiment of the present invention is not limited.
203. And determining a target individual value corresponding to the individual value to be compared from the standard data according to the attribute information of the individual value to be compared, wherein the attribute information of the individual value to be compared is the same as the attribute information of the target individual value.
In the embodiment of the invention, it can be understood that one individual value in the data to be compared has one individual value corresponding to the standard data, and one attribute information is matched with different individual values in different time periods, so that a target individual value corresponding to the individual value to be compared can be determined according to the attribute information of the individual value to be compared. Taking business data as an example, the data of a business department is composed of sales values of each business member individual of the business department, names of business members can be used as attribute information, the names of the business members have corresponding sales values in different months, the sales data of the business department in month 1 are determined to be standard data, the data in month 6 are data to be compared, if the individual value to be compared is the sales value X of the business member A in month 6, the attribute information of the X can be 'A', a value Y corresponding to the X can be determined in the data in month 1 according to the 'A', wherein the attribute information of the Y is 'A', namely the sales value of the business member A in month 1 is Y.
204. And comparing the conversion value corresponding to the individual value to be compared with the target individual value to realize the transverse comparison of the individual value to be compared with the target individual value.
In the embodiment of the invention, it can be understood that data of different periods cannot be transversely compared, taking the sales data of a business department as an example, assuming that 1 month is a slack season for product sales, and 6 months is a busy season for product sales, one business employee sells 3000 products in 1 month, and 5000 products in 6 months, if the sales performance of the business employee in two months is compared directly by the number of the sold products of the business employee to 3 months and 6 months, such comparison is meaningless, so that the sales data of 1 month can be determined as standard data, 5000 can be converted according to a preset standardized conversion mode to obtain a conversion value according with the data characteristics of 1 month, and then the conversion value of 5000 is compared with 3000, so the sales performance of the business employee in two months can be compared.
As an alternative implementation, the method described in this embodiment of the present invention may further include the following steps:
setting a plurality of marker post values according to the standard data to realize interval division, and setting a label for each interval; carrying out interval matching on conversion values corresponding to the individual values to be compared to obtain a target interval; and adding a label corresponding to the target interval for the conversion value corresponding to the individual value to be compared.
For example, taking sales data of a business department as an example, taking sales data of 1 month as standard data, a plurality of benchmarking values can be set according to the numerical values of all individual values of sales data of 1 month, for example, setting 1000 as a qualified benchmarking value, 2500 as a good benchmarking value, 3000 as an excellent benchmarking value, that is, dividing the data into four intervals: [0,100), [1000,2500), [2500,3000), [3000, + ∞). It can be seen that, by implementing this embodiment, a tag can be set for each interval according to the characteristics of each interval, and after obtaining the conversion value corresponding to the individual value to be compared, a corresponding tag is added thereto, so that the numerical significance of the conversion value corresponding to the individual value to be compared can be simply and clearly shown.
It can be seen that, when the method described in fig. 2 is implemented, data of a specified period is used as standard data, the individual value to be compared in the data to be compared is subjected to standardized conversion, a conversion value corresponding to the individual value to be compared is obtained, and a target individual value corresponding to the individual value to be compared is determined in the standard data.
EXAMPLE III
Referring to fig. 3, fig. 3 is a schematic flow chart of another data normalization processing method according to an embodiment of the invention. As shown in fig. 3, the data normalization processing method may include the following steps:
301. and determining the data of the specified period as standard data.
302. And converting the individual value to be compared in the data to be compared according to a preset standard conversion mode to obtain a conversion value corresponding to the individual value to be compared, wherein the data to be compared is data of a period to be compared.
In the embodiment of the present invention, it can be understood that the preset standardized conversion manner is calculated by using a preset formula, where the preset formula is:
wherein, X is a conversion value corresponding to the individual value to be compared, a is the individual value to be compared, b is the average value of the data to be compared, c is the standard deviation of the data to be compared, d is the standard deviation of the standard data, and e is the average value of the standard data.
It is understood that the standard deviation is the measure of the degree of statistical distribution most commonly used in probability statistics. The standard deviation definition is the square root of the arithmetic mean of the standard values of the units of the population squared with their mean. Which can reflect the degree of dispersion of a data set.
303. And determining a target individual value corresponding to the individual value to be compared from the standard data according to the attribute information of the individual value to be compared, wherein the attribute information of the individual value to be compared is the same as the attribute information of the target individual value.
304. And comparing the conversion value corresponding to the individual value to be compared with the target individual value to realize the transverse comparison of the individual value to be compared with the target individual value.
As an optional implementation manner, after step 304, the following steps may be further included:
and acquiring a conversion value corresponding to each individual value in the data to be compared so as to convert the distribution form of the data to be compared into a standard distribution form, wherein the standard distribution form is the distribution form of the standard data.
In this embodiment, the sales data of the business department in month 1 is taken as the standard data, the distribution form of the sales data in month 1 is taken as the standard distribution form, the sales data in month 6 is taken as the data to be compared, then each individual value in the sales data in month 6 is subjected to standard conversion according to a predetermined standard conversion mode, and then the distribution form of the conversion value corresponding to each individual value in the sales data in month 6 is taken as the standard distribution form. Therefore, by implementing the embodiment, the distribution form of the data to be compared is converted into the distribution form of the standard data, and the transverse comparison between the data to be compared and the standard data can be further realized.
305. And acquiring conversion data corresponding to the data of the history period, wherein the conversion data corresponding to the data of the history period comprises a conversion value corresponding to each individual value in the data of the history period.
In the embodiment of the present invention, it can be understood that the history cycle may be one week, one month, one year, and the like, and the embodiment of the present invention is not limited. The data specifying the history may be a set of a number of all individual values generated during the history period.
306. And acquiring personnel information corresponding to each individual value in the data of the historical period.
In this embodiment of the present invention, the staff information may include at least one of information such as name, age, occupation, and position, and the embodiment of the present invention is not limited thereto.
307. And storing the conversion value corresponding to each individual value in the data of the historical period and the personnel information corresponding to each individual value in the data of the historical period in a database in an associated manner to serve as the data information of the historical period.
In the embodiment of the invention, the data information of the history period is stored in the database and can be used for subsequent query and other work.
308. When score inquiry request information sent by a user terminal is received, searching a database to obtain a conversion value corresponding to a target individual value of a target person in a target period; the grading inquiry request information comprises information of a target period and information of target personnel, and the information of the target personnel comprises attributes of the target personnel.
As an optional implementation manner, when receiving scoring query request information sent by a user terminal, the searching a database to obtain a conversion value corresponding to a target individual value of a target person in a target period may include:
when receiving grading inquiry request information sent by a user terminal, judging whether a user corresponding to the user terminal has inquiry authority or not;
if yes, searching a database to obtain a conversion value corresponding to the target individual value of the target person in the target period.
Further optionally, the determining whether the user corresponding to the user terminal has the query right may include:
detecting whether the grading inquiry request information comprises an inquiry password, wherein the inquiry password can be a digital password, a voiceprint password or a fingerprint password and the like; if the grading inquiry request information comprises an inquiry password, checking whether the inquiry password is matched with a preset inquiry password.
By implementing the embodiment, when the grading inquiry request information is received, the authority verification is carried out, the data security can be improved, in addition, whether the user has the inquiry authority or not is judged by verifying the inquiry password, and the security is higher.
309. Obtaining a scoring weight according to the attribute of the target person; and taking the product of the grading weight and the conversion value corresponding to the target individual value as a target score, and sending the target score to the user terminal.
The steps 308 to 309 can be implemented to score by using the standardized data, and can be applied to score card items and the like.
310. When receiving the comparison request information sent by the user terminal, searching the database to obtain the data information of the first comparison period and the data information of the second comparison period, wherein the comparison request information at least comprises the first comparison period and the second comparison period.
As an optional implementation manner, the searching the database when receiving the comparison request information sent by the user terminal to obtain the data information of the first comparison period and the data information of the second comparison period may include:
when receiving comparison request information sent by a user terminal, judging whether a user corresponding to the user terminal has a comparison authority or not; if yes, searching the database to obtain the data information of the first comparison period and the data information of the second comparison period.
Further optionally, the determining whether the user corresponding to the user terminal has the comparison right may include:
detecting whether the comparison request information comprises a comparison password, wherein the comparison password can be a digital password, a voiceprint password or a fingerprint password and the like; if the grading inquiry request information comprises a comparison password, checking whether the comparison password is matched with a preset comparison password.
By implementing the embodiment, when the grading inquiry request information is received, the authority verification is carried out, the data security can be improved, in addition, whether the user has the inquiry authority or not is judged by verifying the comparison password, and the security is higher.
311. And generating a comparison result according to the data information of the first comparison period and the data information of the second comparison period, and sending the comparison result to the user terminal.
It can be understood that the database stores data information of historical periods, and data of each historical period is subjected to standardization processing, so that transverse comparison can be performed. The step 308-309 is implemented, the comparison result can be directly generated, the user does not need to perform comparison operation, the operation of the user is simplified, and the user experience can be improved.
As an optional implementation manner, before the sending the comparison result to the user terminal, the following steps may be further included:
drawing the data information of the first comparison period and the data information of the second comparison period in a data chart to generate a comparison chart;
the sending the comparison result to the user terminal may include:
and sending the comparison result and the comparison chart to the user terminal.
Optionally, the drawing the data information of the first comparison period and the data information of the second comparison period in the data chart to generate the comparison chart includes:
analyzing the comparison request information to detect whether the comparison request information comprises a target chart type; if so, drawing the data information of the first comparison period and the data information of the second comparison period in a data chart of the target chart type to generate a comparison chart; if not, the data information of the first comparison period and the data information of the second comparison period are drawn in a data chart of a preset chart type to generate a comparison chart.
It is to be understood that the target chart type may be a chart type such as a bar chart, a line chart, or a pie chart, and the embodiment of the present invention is not limited thereto.
As can be seen, by implementing the present embodiment, the data information of the first comparison period and the data information of the second comparison period are plotted in the data chart, so that the user can more intuitively know the difference between the data of the two periods; in addition, a comparison chart corresponding to the target chart type included in the comparison request information can be generated, and user experience is further improved.
It can be seen that by implementing the method described in fig. 3, the conversion value corresponding to the individual value to be compared is compared with the target individual value, so that the data generated in different periods can be compared transversely, and further the effective difference can be analyzed. In addition, the distribution form of the data to be compared is converted into the distribution form of the standard data, and then the transverse comparison of the data to be compared and the standard data can be realized. In addition, the individual values can be converted and then scored, so that the final score has objective comparability, and when the scoring query request information is received, the authority verification is carried out, so that the data security can be improved. In addition, the data information of the first comparison period and the data information of the second comparison period are drawn in the data chart, so that a user can know the difference between the data of the two periods more intuitively, and the user experience is further improved.
Example four
Referring to fig. 4, fig. 4 is a schematic structural diagram of a data normalization processing system according to an embodiment of the present invention. As shown in fig. 4, the data normalization processing system may include: a first determining unit 401, a converting unit 402, a second determining unit 403, and a comparing unit 404, wherein,
a first determining unit 401, configured to determine that data of a specified period is standard data;
a conversion unit 402, configured to convert the individual value to be compared in the data to be compared according to a preset standardized conversion manner, so as to obtain a conversion value corresponding to the individual value to be compared; the data to be compared is data of a period to be compared;
in the embodiment of the present invention, it can be understood that the preset standardized conversion manner is calculated by using a preset formula, where the preset formula is:
wherein, X is a conversion value corresponding to the individual value to be compared, a is the individual value to be compared, b is the average value of the data to be compared, c is the standard deviation of the data to be compared, d is the standard deviation of the standard data, and e is the average value of the standard data.
A second determining unit 403, configured to determine, according to the attribute information of the individual value to be compared, a target individual value corresponding to the individual value to be compared from the standard data, where the attribute information of the individual value to be compared is the same as the attribute information of the target individual value;
a comparing unit 404, configured to compare the conversion value corresponding to the individual value to be compared with the target individual value, so as to implement a lateral comparison between the individual value to be compared and the target individual value.
As an alternative implementation, the system described in this embodiment of the present invention may further include the following units that are not illustrated:
the setting unit is used for setting a plurality of marker post values according to the standard data to realize interval division and setting labels for each interval;
the matching unit is used for carrying out interval matching on the conversion values corresponding to the individual values to be compared so as to obtain a target interval; and adding a label corresponding to the target interval for the conversion value corresponding to the individual value to be compared.
It can be seen that, by implementing this embodiment, a tag can be set for each interval according to the characteristics of each interval, and after obtaining the conversion value corresponding to the individual value to be compared, a corresponding tag is added thereto, so that the numerical significance of the conversion value corresponding to the individual value to be compared can be simply and clearly shown.
It can be seen that, by implementing the data normalization processing system described in fig. 4, with data of a specified period as standard data, the individual value to be compared in the data to be compared is subjected to normalization conversion to obtain a conversion value corresponding to the individual value to be compared, and a target individual value corresponding to the individual value to be compared is determined in the standard data.
EXAMPLE five
Referring to fig. 5, fig. 5 is a schematic structural diagram of another data normalization processing system according to an embodiment of the disclosure. The data normalization processing system shown in fig. 5 is optimized by the data normalization processing system shown in fig. 4. Compared with the data normalization processing system shown in fig. 4, the data normalization processing system shown in fig. 5 may further include: a first acquisition unit 405, a storage unit 406, a lookup unit 407, a second acquisition unit 408, a transmission unit 409, a third acquisition unit 410, a generation unit 411, and a drawing unit 412, wherein,
a first obtaining unit 405, configured to obtain conversion data corresponding to data of a history cycle, where the conversion data corresponding to the data of the history cycle includes a conversion value corresponding to each individual value in the data of the history cycle;
the first obtaining unit 405 is further configured to obtain person information corresponding to each individual value in the data of the history period;
the storage unit 406 is configured to store the conversion value corresponding to each individual value in the data of the history period and the person information corresponding to each individual value in the data of the history period in an associated manner in the database to serve as the data information of the history period;
the searching unit 407 is configured to, when receiving score query request information sent by a user terminal, search a database to obtain a conversion value corresponding to a target individual value of a target person in a target period; the grading query request information comprises information of a target period and information of target personnel, wherein the information of the target personnel comprises attributes of the target personnel;
a second obtaining unit 408, configured to obtain a scoring weight according to an attribute of the target person;
a sending unit 409, configured to take a product of the scoring weight and a conversion value corresponding to the target individual value as a target score, and send the target score to the user terminal.
As an alternative implementation, the lookup unit 407 may include:
a judging subunit 4071, configured to, when receiving score query request information sent by the user terminal, judge whether a user corresponding to the user terminal has a query right;
further optionally, the manner that the determining subunit 4071 is configured to determine whether the user corresponding to the user terminal has the query authority may specifically be:
detecting whether the grading inquiry request information comprises an inquiry password, wherein the inquiry password can be a digital password, a voiceprint password or a fingerprint password and the like; if the grading inquiry request information comprises an inquiry password, checking whether the inquiry password is matched with a preset inquiry password.
The searching subunit 4072 is configured to, after the determining subunit 4071 determines whether the user corresponding to the user terminal has the query authority, search the database to obtain the conversion value corresponding to the target individual value of the target person in the target period.
By implementing the embodiment, when the grading inquiry request information is received, the authority verification is carried out, the data security can be improved, in addition, whether the user has the inquiry authority or not is judged by verifying the inquiry password, and the security is higher.
As an alternative embodiment, the data normalization processing system shown in fig. 5 may further include:
a third obtaining unit 410, configured to, after the comparing unit 404 compares the conversion value corresponding to the individual value to be compared with the target individual value to implement the transverse comparison between the individual value to be compared and the target individual value, obtain the conversion value corresponding to each individual value in the data to be compared to implement conversion of the distribution form of the data to be compared into a standard distribution form, where the standard distribution form is a distribution form of standard data.
Therefore, by implementing the embodiment, the distribution form of the data to be compared is converted into the distribution form of the standard data, and the transverse comparison between the data to be compared and the standard data can be further realized.
The searching unit 407 is further configured to, after the storage unit 406 stores the conversion value corresponding to each individual value in the data of the history period and the person information corresponding to each individual value in the data of the history period in association with the database to serve as the data information of the history period, when receiving the comparison request information sent by the user terminal, search the database to obtain the data information of the first comparison period and the data information of the second comparison period; the comparison request information at least comprises a first comparison period and a second comparison period;
as an optional implementation manner, the searching unit 407 is configured to search the database when receiving the comparison request information sent by the user terminal, and a manner of obtaining the data information of the first comparison period and the data information of the second comparison period may specifically be:
the searching unit 407 is configured to, when receiving comparison request information sent by a user terminal, determine whether a user corresponding to the user terminal has a comparison right; if yes, searching the database to obtain the data information of the first comparison period and the data information of the second comparison period.
Further optionally, the determining whether the user corresponding to the user terminal has the comparison right may include:
detecting whether the comparison request information comprises a comparison password, wherein the comparison password can be a digital password, a voiceprint password or a fingerprint password and the like; if the grading inquiry request information comprises a comparison password, checking whether the comparison password is matched with a preset comparison password.
By implementing the embodiment, when the grading inquiry request information is received, the authority verification is carried out, the data security can be improved, in addition, whether the user has the inquiry authority or not is judged by verifying the comparison password, and the security is higher.
A generating unit 411 configured to generate a comparison result according to the data information of the first comparison period and the data information of the second comparison period;
the sending unit 409 is further configured to send the comparison result to the user terminal.
As an alternative embodiment, the data normalization processing system shown in fig. 5 may further include:
a drawing unit 412, configured to draw the data information of the first comparison period and the data information of the second comparison period in a data chart to generate a comparison chart before the sending unit 409 sends the comparison result to the user terminal;
the sending unit 409 is configured to send the comparison result to the user terminal in a specific manner:
a sending unit 409, configured to send the comparison result and the comparison chart to the user terminal.
Optionally, the manner that the drawing unit 412 is used to draw the data information of the first comparison period and the data information of the second comparison period in the data chart to generate the comparison chart may specifically be:
a drawing unit 412, configured to parse the comparison request information to detect whether the comparison request information includes a target chart type; if so, drawing the data information of the first comparison period and the data information of the second comparison period in a data chart of the target chart type to generate a comparison chart; if not, the data information of the first comparison period and the data information of the second comparison period are drawn in a data chart of a preset chart type to generate a comparison chart.
It is to be understood that the target chart type may be a chart type such as a bar chart, a line chart, or a pie chart, and the embodiment of the present invention is not limited thereto.
As can be seen, by implementing the present embodiment, the data information of the first comparison period and the data information of the second comparison period are plotted in the data chart, so that the user can more intuitively know the difference between the data of the two periods; in addition, a comparison chart corresponding to the target chart type included in the comparison request information can be generated, and user experience is further improved.
It can be seen that by implementing the data normalization processing system described in fig. 5, the conversion value corresponding to the individual value to be compared is compared with the target individual value, so that the data generated in different periods can be compared transversely, and further, effective differences can be analyzed. In addition, the distribution form of the data to be compared is converted into the distribution form of the standard data, and then the transverse comparison of the data to be compared and the standard data can be realized. In addition, the individual values can be converted and then scored, so that the final score has objective comparability, and when the scoring query request information is received, the authority verification is carried out, so that the data security can be improved. In addition, the data information of the first comparison period and the data information of the second comparison period are drawn in the data chart, so that a user can know the difference between the data of the two periods more intuitively, and the user experience is further improved.
The present invention also provides an electronic device, including:
a processor;
a memory having stored thereon computer readable instructions which, when executed by the processor, implement the method of standardized processing of data as previously described.
The electronic device may be the apparatus 100 shown in fig. 1.
In an exemplary embodiment, the present invention also provides a computer-readable storage medium on which a computer program is stored, which, when executed by a processor, implements the method of standardized processing of data as previously described.
It will be understood that the invention is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the invention is limited only by the appended claims.
Claims (10)
1. A method for normalizing data, the method comprising:
determining data of a specified period as standard data;
converting individual values to be compared in data to be compared according to a preset standardized conversion mode to obtain conversion values corresponding to the individual values to be compared; the data to be compared is data of a period to be compared;
determining a target individual value corresponding to the individual value to be compared from the standard data according to the attribute information of the individual value to be compared, wherein the attribute information of the individual value to be compared is the same as the attribute information of the target individual value;
and comparing the conversion value corresponding to the individual value to be compared with the target individual value to realize the transverse comparison of the individual value to be compared with the target individual value.
2. The method according to claim 1, wherein after comparing the converted value corresponding to the individual value to be compared with the target individual value to achieve the lateral comparison of the individual value to be compared with the target individual value, the method further comprises:
and acquiring a conversion value corresponding to each individual value in the data to be compared so as to convert the distribution form of the data to be compared into a standard distribution form, wherein the standard distribution form is the distribution form of the standard data.
3. The method according to claim 1, wherein the predetermined standardized transformation is calculated by using a predetermined formula, and the predetermined formula is:
wherein, X is a conversion value corresponding to the individual value to be compared, a is the individual value to be compared, b is the average value of the data to be compared, c is the standard deviation of the data to be compared, d is the standard deviation of the standard data, and e is the average value of the standard data.
4. The method according to claim 1 or 3, characterized in that the method further comprises:
acquiring conversion data corresponding to data of a history period, wherein the conversion data corresponding to the data of the history period comprises a conversion value corresponding to each individual value in the data of the history period;
acquiring personnel information corresponding to each individual value in the data of the historical period;
storing a conversion value corresponding to each individual value in the data of the historical period and the personnel information corresponding to each individual value in the data of the historical period in a database in an associated manner to serve as the data information of the historical period;
when score inquiry request information sent by a user terminal is received, searching the database to obtain a conversion value corresponding to a target individual value of a target person in a target period; the grading inquiry request information comprises information of the target period and information of the target personnel, wherein the information of the target personnel comprises attributes of the target personnel;
obtaining a scoring weight according to the attribute of the target person;
and taking the product of the grading weight and a conversion value corresponding to the target individual value as a target score, and sending the target score to the user terminal.
5. The method according to claim 4, wherein when receiving scoring query request information sent by a user terminal, searching the database to obtain a conversion value corresponding to a target individual value of a target person in a target period comprises:
when receiving grading inquiry request information sent by a user terminal, judging whether a user corresponding to the user terminal has inquiry authority or not;
if yes, searching the database to obtain a conversion value corresponding to the target individual value of the target person in the target period.
6. The method according to claim 4 or 5, wherein after the conversion value corresponding to each individual value in the data of the history period and the personnel information corresponding to each individual value in the data of the history period are stored in a database in an associated manner to serve as the data information of the history period, the method further comprises:
when contrast request information sent by a user terminal is received, searching the database to obtain the data information of the first contrast period and the data information of the second contrast period; the comparison request information at least comprises a first comparison period and a second comparison period;
generating a comparison result according to the data information of the first comparison period and the data information of the second comparison period;
and sending the comparison result to the user terminal.
7. The method according to claim 6, wherein before sending the comparison result to the user terminal, the method comprises:
drawing the data information of the first comparison period and the data information of the second comparison period in a data chart to generate a comparison chart;
the sending the comparison result to the user terminal includes:
and sending the comparison result and the comparison chart to the user terminal.
8. A system for standardized processing of data, the system comprising:
a first determination unit configured to determine that data of a specified period is standard data;
the conversion unit is used for converting the individual value to be compared in the data to be compared according to a preset standard conversion mode to obtain a conversion value corresponding to the individual value to be compared; the data to be compared is data of a period to be compared;
a second determining unit, configured to determine, according to the attribute information of the individual value to be compared, a target individual value corresponding to the individual value to be compared from the standard data, where the attribute information of the individual value to be compared is the same as the attribute information of the target individual value;
and the comparison unit is used for comparing the conversion value corresponding to the individual value to be compared with the target individual value so as to realize the transverse comparison of the individual value to be compared with the target individual value.
9. An electronic device comprising a memory and a processor, the memory storing a computer program, wherein the processor when executing the computer program implements the steps of the method of any of claims 1-7.
10. A computer-readable storage medium characterized by storing a computer program that causes a computer to execute the method of standardizing data according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910822839.6A CN110688363B (en) | 2019-09-02 | 2019-09-02 | Standardized processing method and system for data, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910822839.6A CN110688363B (en) | 2019-09-02 | 2019-09-02 | Standardized processing method and system for data, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110688363A true CN110688363A (en) | 2020-01-14 |
| CN110688363B CN110688363B (en) | 2023-07-21 |
Family
ID=69108781
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910822839.6A Active CN110688363B (en) | 2019-09-02 | 2019-09-02 | Standardized processing method and system for data, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110688363B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160042044A1 (en) * | 2001-12-10 | 2016-02-11 | Patrick J. Coyne | Method and System for the Management of Professional Services Project Information |
| CN108241722A (en) * | 2016-12-23 | 2018-07-03 | 北京金山云网络技术有限公司 | A kind of data processing system, method and device |
| US20190108164A1 (en) * | 2016-05-12 | 2019-04-11 | International Business Machines Corporation | Data standardization and validation across different data systems |
| CN109815480A (en) * | 2018-12-14 | 2019-05-28 | 平安科技（深圳）有限公司 | A kind of data processing method and device and storage medium |
| CN109840278A (en) * | 2019-01-28 | 2019-06-04 | 平安科技（深圳）有限公司 | Histogram data switching control method, device, computer equipment and storage medium |
-
2019
- 2019-09-02 CN CN201910822839.6A patent/CN110688363B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160042044A1 (en) * | 2001-12-10 | 2016-02-11 | Patrick J. Coyne | Method and System for the Management of Professional Services Project Information |
| US20190108164A1 (en) * | 2016-05-12 | 2019-04-11 | International Business Machines Corporation | Data standardization and validation across different data systems |
| CN108241722A (en) * | 2016-12-23 | 2018-07-03 | 北京金山云网络技术有限公司 | A kind of data processing system, method and device |
| CN109815480A (en) * | 2018-12-14 | 2019-05-28 | 平安科技（深圳）有限公司 | A kind of data processing method and device and storage medium |
| CN109840278A (en) * | 2019-01-28 | 2019-06-04 | 平安科技（深圳）有限公司 | Histogram data switching control method, device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110688363B (en) | 2023-07-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10395451B2 (en) | Mobile device attendance verification with international mobile equipment identity | |
| CN111383101B (en) | Post-credit risk monitoring method, post-credit risk monitoring device, post-credit risk monitoring equipment and computer readable storage medium | |
| US20110129806A1 (en) | System for training | |
| US20210264437A1 (en) | Heuristic identity authentication engine | |
| US20140074645A1 (en) | Bid Assessment Analytics | |
| Thein et al. | Students’ attendance management system based on RFID and fingerprint reader | |
| CN109951512B (en) | User preference determination method, system, electronic device and storage medium | |
| KR20160087675A (en) | System for managing entrance and exit of employee by WiFi access point and mobile device | |
| CN110570097A (en) | business personnel risk identification method and device based on big data and storage medium | |
| CN111476689A (en) | Online training method and system | |
| CN110717509A (en) | Data sample analysis method and device based on tree splitting algorithm | |
| WO2019058997A1 (en) | Information processing device, information processing method and recording medium | |
| CN111461949A (en) | Community correction scheme intelligent generation system based on big data | |
| CN115641101A (en) | Intelligent recruitment method, device and computer readable medium | |
| CN210924624U (en) | Intelligent management device for electric power safety tools | |
| CN111144512B (en) | Occupation guidance method and device based on EMLo pre-training model and storage medium | |
| CN110688363A (en) | Data standardization processing method and system, electronic equipment and storage medium | |
| CN115293867A (en) | Financial reimbursement user portrait optimization method, device, equipment and storage medium | |
| KR20100071504A (en) | Seeker and offerer matching system of the job in internet and the mehtod thereof | |
| JP6983372B2 (en) | Information processing equipment, information processing methods, and programs | |
| CN110942124A (en) | Intelligent management method and device for electric power safety tools | |
| CN110378217A (en) | Application verification method, device and electronic equipment based on optical character identification | |
| CN111177283A (en) | Intelligent personnel model construction method and device based on reinforcement learning | |
| CN118037250B (en) | Data mining method and system applying text informatization system | |
| JP6156942B2 (en) | Control device, information management system, information management method, and program |
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 |