Disclosure of Invention
The invention mainly aims to provide a data sorting method, a data sorting device, data sorting equipment and a computer readable storage medium, and aims to solve the technical problems that the interpretability of existing bank results is poor and the weight among data is difficult to measure due to normalized data.
In order to achieve the above object, the present invention provides a data sorting method, including the steps of:
when a sorting instruction triggered based on a display interface is received, acquiring various bank index data corresponding to the sorting instruction and index weights corresponding to the various bank index data, wherein the bank index data comprises data of a plurality of banks;
determining projection graphs corresponding to all banks based on the index weights and various bank index data;
determining a ranking graph corresponding to the ranking of each bank based on the index weight and various bank index data;
displaying the projection drawing and the sequencing drawing on the display interface;
and when a selection instruction triggered based on a display interface is received, determining a target bank corresponding to the selection instruction, and highlighting the target bank in the projection drawing and the sequencing drawing respectively.
Further, in an embodiment, the step of determining the projection graph corresponding to each bank based on the index weight and various kinds of bank index data includes:
determining interval index data of each year corresponding to each bank based on various bank index data;
and determining the distance corresponding to each bank through a tsne algorithm based on the index weight and the interval index data, and determining the projection graph of each year corresponding to each bank based on the distance.
Further, in an embodiment, the step of determining a ranking graph corresponding to the ranking of each bank based on the index weight and various kinds of bank index data includes:
determining indexes and values corresponding to all banks through a topsis algorithm based on the index weight and various bank index data;
and determining a ranking graph corresponding to the ranking among the banks based on the indexes and the values.
Further, in an embodiment, after the step of displaying the projection drawing and the sorting drawing on the display interface, the data sorting method further includes:
and determining the coordinate view corresponding to each bank based on various bank index data, and displaying the coordinate view on the display interface.
Further, in an embodiment, the step of determining a target bank corresponding to a selected instruction when the selected instruction triggered based on the display interface is received, and highlighting the target bank in the projection drawing and the ordering drawing respectively includes:
when a selection instruction triggered based on a display interface is received, determining a target bank corresponding to the selection instruction;
highlighting the target bank in the projection view, the ranking view and the coordinate view, respectively.
Further, in one embodiment, the bank indicator data includes asset size, capital abundance, excess loan ratio asset profit margin, capital profit margin, cost to income ratio.
Further, in an embodiment, after the step of displaying the projection drawing and the sorting drawing on the display interface, the data sorting method further includes:
storing the index weight upon receiving a weight save request.
In addition, to achieve the above object, the present invention further provides a data sorting apparatus, including:
the system comprises an acquisition module, a display interface and a display module, wherein the acquisition module is used for acquiring various bank index data corresponding to a sorting instruction and index weights corresponding to the various bank index data when the sorting instruction triggered based on the display interface is received, and the bank index data comprises data of a plurality of banks;
the first determining module is used for determining the projection graph corresponding to each bank based on the index weight and various bank index data;
the second determining module is used for determining a ranking graph corresponding to the ranking of each bank based on the index weight and various bank index data;
the display module is used for displaying the projection drawing and the sequencing drawing on the display interface;
and the display module is used for determining a target bank corresponding to the selection instruction when receiving the selection instruction triggered based on the display interface, and highlighting the target bank in the projection drawing and the sequencing drawing respectively.
In addition, to achieve the above object, the present invention also provides a data sorting apparatus, including: the data sorting system comprises a memory, a processor and a data sorting program which is stored on the memory and can run on the processor, wherein the data sorting program realizes the steps of the data sorting method when being executed by the processor.
In addition, to achieve the above object, the present invention further provides a computer readable storage medium, having a data sorting program stored thereon, which when executed by a processor implements the steps of the aforementioned data sorting method.
When a sorting instruction triggered based on a display interface is received, various bank index data corresponding to the sorting instruction and index weights corresponding to the various bank index data are obtained, wherein the bank index data comprise data of a plurality of banks; then determining projection drawings corresponding to all banks based on the index weight and various bank index data; then determining a ranking graph corresponding to the ranking of each bank based on the index weight and various bank index data; and then displaying the projection drawing and the sequencing drawing on the display interface, finally determining a target bank corresponding to the selected instruction when the selected instruction triggered based on the display interface is received, highlighting the target bank on the projection drawing and the sequencing drawing respectively, and displaying the projection drawing and the sequencing drawing of each bank according to the index weight and the bank index data so as to facilitate understanding of the sequencing result of the sequencing drawing and viewing of the data corresponding to the selected bank through the projection drawing and improve the interpretability of the sequencing of each bank in the sequencing drawing.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As shown in fig. 1, fig. 1 is a schematic structural diagram of a data sorting apparatus in a hardware operating environment according to an embodiment of the present invention.
The data sorting device in the embodiment of the present invention may be a PC, or may be a mobile terminal device having a display function, such as a smart phone, a tablet computer, an electronic book reader, an MP3(Moving Picture Experts Group Audio Layer III, motion video Experts compression standard Audio Layer 3) player, an MP4(Moving Picture Experts Group Audio Layer IV, motion video Experts compression standard Audio Layer 4) player, a portable computer, and the like.
As shown in fig. 1, the data sorting apparatus may include: a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, a communication bus 1002. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a non-volatile memory (e.g., a magnetic disk memory). The memory 1005 may alternatively be a storage device separate from the processor 1001.
Optionally, the data sorting device may further include a camera, a Radio Frequency (RF) circuit, a sensor, an audio circuit, a WiFi module, and the like. Of course, the data sorting device may also be configured with other sensors such as a gyroscope, a barometer, a hygrometer, a thermometer, an infrared sensor, and so on, which are not described herein again.
Those skilled in the art will appreciate that the terminal architecture shown in fig. 1 does not constitute a limitation of the data sorting apparatus and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, a memory 1005, which is a kind of computer storage medium, may include therein an operating system, a network communication module, a user interface module, and a data sorting program.
In the data sorting apparatus shown in fig. 1, the network interface 1004 is mainly used for connecting to a background server and performing data communication with the background server; the user interface 1003 is mainly used for connecting a client (user side) and performing data communication with the client; and the processor 1001 may be used to invoke a data sorting program stored in the memory 1005.
In this embodiment, the data sorting apparatus includes: the system comprises a memory 1005, a processor 1001 and a data sorting program which is stored on the memory 1005 and can run on the processor 1001, wherein when the processor 1001 calls the data sorting program stored in the memory 1005, the steps of the data sorting method in each embodiment are executed.
The invention also provides a data sorting method, and referring to fig. 2, fig. 2 is a schematic flow chart of a first embodiment of the data sorting method of the invention.
In this embodiment, the data sorting method includes the following steps:
step S101, when a sorting instruction triggered based on a display interface is received, acquiring various bank index data corresponding to the sorting instruction and index weights corresponding to the various bank index data, wherein the bank index data comprises data of a plurality of banks;
in this embodiment, the display interface includes a weight setting window, the weight setting window includes various bank index data and weight setting areas, the various bank index data is data of each dimension of each bank, the bank index data includes data of original grading, asset scale, capital abundance, core first-level capital abundance, loan weight, reject rate, attention rate, bad + attention rate, overdue loan ratio (overdue loan ratio), equipment coverage rate, absorbed deposit weight, liquidity ratio, asset profit rate, capital profit rate, cost income ratio, first customer, top ten customers, and the like; the user can set the index weight of each bank index data through the weight setting window according to expert experience, and when finishing setting the index weight, the user selects to start the sorting operation through the interval for setting the bank index data, namely, triggers the sorting instruction.
In this embodiment, when a sorting instruction triggered based on a display interface is received, various kinds of bank index data corresponding to the sorting instruction are obtained, that is, various kinds of bank index data of each bank in a time interval corresponding to the sorting instruction are obtained, and index weights corresponding to the various kinds of bank index data, that is, index weights set by a user are obtained, where the bank index data includes data of a plurality of banks, so that sorting among the banks is realized based on the index weights and the bank index data.
Step S102, determining projection graphs corresponding to banks based on the index weights and various bank index data;
in this embodiment, when the index weight and various kinds of bank index data are obtained, a shadow map corresponding to each bank is determined based on the index weight and various kinds of bank index data, specifically, a distance between banks is determined first, and each distance determines the projection map, that is, the projection map includes projections of each bank, referring to fig. 3, fig. 3(b) includes projection maps of each bank in 2016, 2017, and 2018, each bank is represented by a circle in the projection map, and in other embodiments, each bank may also be represented by a triangle, a square, or the like, and a distance between circles is a distance between the banks corresponding to each circle.
Step S103, determining a ranking chart corresponding to the ranking of each bank based on the index weight and various bank index data;
in this embodiment, when the index weight and various kinds of bank index data are obtained, the rank of each bank is determined according to the index weight and various kinds of bank index data, and a rank chart including the ranks among the banks and the bank index data corresponding to each bank is determined according to the rank, referring to fig. 3, where fig. 3(d) is a rank chart corresponding to each bank.
And step S104, displaying the projection drawing and the sequencing drawing on the display interface.
In this embodiment, after the projection drawing and the ranking drawing corresponding to each bank are obtained, the projection drawing and the ranking drawing are displayed on the display interface, so that a user can understand the ranking result of the ranking drawing according to the projection drawing when viewing the ranking of each bank in the ranking drawing, and the interpretability of the ranking drawing is improved. Referring to fig. 3, when viewing the ranking chart of fig. 3(d), a user can understand the ranking result in the ranking chart through the projection chart of fig. 3(b) so as to understand the ranking result and further know the reason of the ranking result, so as to explain the ranking chart of fig. 3(d) through fig. 3(b), thereby improving the interpretability of the ranking chart of fig. 3 (d). Meanwhile, the complexity and the error rate of manual understanding and analysis of data are reduced through the automatic display operation.
And step S105, when a selection instruction triggered based on a display interface is received, determining a target bank corresponding to the selection instruction, and highlighting the target bank in the projection drawing and the sequencing drawing respectively.
In this embodiment, after the projection drawing and the ranking drawing are displayed on the display interface, if a user needs to check data of some banks in each bank, specifically, a certain bank or certain banks may be selected through the projection drawing or the ranking drawing to trigger a selection instruction.
In this embodiment, when a selection instruction triggered based on a display interface is received, a target bank corresponding to the selection instruction is determined, and then the target bank is highlighted in the projection drawing and the coordinate view respectively so as to represent the selected bank in the projection drawing and the sorting drawing respectively, so that data corresponding to the selected bank can be conveniently viewed, for example, distances between a plurality of selected banks are determined through the projection drawing to judge similarity of index data of the banks corresponding to the banks, and interpretability of sorting of the banks in the sorting drawing is further improved.
Further, in an embodiment, after step S104, the data sorting method further includes:
step a, determining a coordinate view corresponding to each bank based on various bank index data, and displaying the coordinate view on the display interface.
In this embodiment, after the bank index data is obtained, a coordinate view corresponding to each bank may be determined according to various bank index data, where the coordinate view includes the bank and the bank index data of each bank, referring to fig. 3, each column in fig. 3(c) corresponds to one bank index data, the bank index data of each column includes all data of the bank index data of each bank, the various bank index data of each bank is connected into one line to represent each bank, each line includes the bank index data of the corresponding bank, and then the coordinate view is displayed on a display interface, so that the sorting result of the sorting diagram is understood through the coordinate view, and the interpretability of the sorting of each bank in the sorting diagram is further improved.
Further, in another embodiment, after step S104, the data sorting method further includes:
and b, storing the index weight when a weight storage request is received.
In this embodiment, a user may trigger a weight saving request through the display interface, and when receiving the weight saving request, the index weight is stored, so as to directly call the saved index weight subsequently, for example, when receiving an index calling instruction, a corresponding weight index is displayed in a weight area in a weight setting window (refer to fig. 3(a)) of the display interface, and the user may directly perform bank sorting according to the currently displayed weight index, or perform fine tuning and bank sorting based on the currently displayed weight index, so as to help the group user understand the result of the ranking and determine which indexes cause the change of the ranking.
In the data sorting method provided by this embodiment, when a sorting instruction triggered based on a display interface is received, various kinds of bank index data corresponding to the sorting instruction and index weights corresponding to the various kinds of bank index data are obtained, where the bank index data includes data of multiple banks; then determining projection drawings corresponding to all banks based on the index weight and various bank index data; then determining a ranking graph corresponding to the ranking of each bank based on the index weight and various bank index data; and then displaying the projection drawing and the sequencing drawing on the display interface, finally determining a target bank corresponding to the selected instruction when the selected instruction triggered based on the display interface is received, highlighting the target bank on the projection drawing and the sequencing drawing respectively, and displaying the projection drawing and the sequencing drawing of each bank according to the index weight and the bank index data so as to facilitate understanding of the sequencing result of the sequencing drawing and viewing of the data corresponding to the selected bank through the projection drawing and improve the interpretability of the sequencing of each bank in the sequencing drawing.
Based on the first embodiment, a second embodiment of the data sorting method of the present invention is provided, in this embodiment, step S102 includes:
step S201, determining interval index data of each year corresponding to each bank based on index data of each bank;
and S202, determining the distance corresponding to each bank through a tsne algorithm based on the index weight and the interval index data, and determining the projection graph of each year corresponding to each bank based on the distance.
In this embodiment, when the index weight and various kinds of bank index data are acquired, the section index data of each year corresponding to each bank is determined based on the various kinds of bank index data, and as can be seen from the projection diagram of fig. 3(b) with reference to fig. 3, the bank index data in fig. 3 includes the bank index data of each bank in each year of 2016, 2017, and 2018.
Then, based on the index weight and the interval index data, determining the distance corresponding to each bank through a tsne algorithm, namely, the similarity between the banks is determined by the tsne algorithm based on the index weight and the interval index data, determining the distance corresponding to each bank according to the similarity, for example, taking the similarity between the banks as the distance between the corresponding banks, then determining the projection drawing of each year corresponding to each bank based on the distance, that is, the icons corresponding to the banks are set in the projection view according to the distance between the banks, so that the distance between the icons of the banks in the projection view is the distance between the banks or is in the same proportion as the distance between the banks, referring to fig. 3, in the projection diagram, each bank is represented by a circle, and in other embodiments, each bank can also be represented by a triangle, a square, and the like, and the distance between each circle is the distance between each corresponding bank.
In the data sorting method provided by this embodiment, the interval index data of each year corresponding to each bank is determined based on the index data of each bank; and then determining the distance corresponding to each bank through a tsne algorithm based on the index weight and the interval index data, determining the projection graph of each year corresponding to each bank based on the distance, and accurately obtaining the projection graph of each year corresponding to each bank according to the distance corresponding to each bank, so that the accuracy of the projection graph is improved, the sequencing result of the sequencing graph is conveniently understood through the projection graph, and the interpretability of the sequencing of each bank in the sequencing graph is further improved.
Based on the first embodiment, a third embodiment of the data sorting method of the present invention is provided, in this embodiment, step S103 includes:
step S301, determining indexes and values corresponding to banks through a topsis algorithm based on the index weight and various bank index data;
step S302, determining a ranking graph corresponding to the ranking among the banks based on the indexes and the values.
In this embodiment, when the index weight and various kinds of bank index data are obtained, the index and the value corresponding to each bank are determined through a topsis algorithm based on the index weight and various kinds of bank index data, that is, the index weight and various kinds of bank index data are calculated through the topsis algorithm to obtain the index and the value corresponding to each bank, then a ranking map corresponding to the ranking between the banks is determined based on the index and the value, specifically, the banks are ranked according to the index and the value, a ranking map corresponding to the ranking between the banks is obtained according to the ranking result, the ranking map includes the ranking between the banks and the bank index data corresponding to the banks, and fig. 3(d) is a ranking map corresponding to each bank.
In the data sorting method provided by this embodiment, indexes and values corresponding to banks are determined by a topsis algorithm based on the index weight and various bank index data; and then, determining ordering diagrams corresponding to the ordering among the banks based on the indexes and the values, and accurately obtaining the ordering diagrams corresponding to the banks through the indexes and the values, so that the accuracy of the ordering diagrams is improved, and the interpretability of the ordering of the banks in the ordering diagrams is further improved.
Based on the first embodiment, a fourth embodiment of the data sorting method of the present invention is proposed, in this embodiment, step S105 includes:
step S401, when a selection instruction triggered based on a display interface is received, determining a target bank corresponding to the selection instruction;
step S402, highlighting the target bank in the projection view, the ranking graph and the coordinate view respectively.
In this embodiment, after the projection view, the coordinate view, and the ranking view are displayed on the display interface, if a user needs to check data of some banks in each bank, specifically, a certain bank or several banks may be selected through the projection view, the coordinate view, or the ranking view to trigger a selection instruction.
In this embodiment, when a selection instruction triggered based on a display interface is received, a target bank corresponding to the selection instruction is determined, and then the target bank is highlighted in the projection diagram, the sort diagram and the coordinate view respectively to represent the selected bank in the projection diagram, the sort diagram and the coordinate view respectively, so that data corresponding to the selected bank can be conveniently viewed, for example, distances among a plurality of selected banks are determined through the projection diagram to judge similarity of bank index data corresponding to each bank, or the bank index data of the selected bank are viewed through the coordinate view, so that a ranking result can be conveniently understood, and interpretability of sorting of each bank in the sort diagram is further improved.
According to the data sorting method provided by the embodiment, when a selection instruction triggered based on a display interface is received, a target bank corresponding to the selection instruction is determined; and then, the target bank is highlighted in the projection drawing, the ordering drawing and the coordinate view respectively, so that data corresponding to the selected bank can be conveniently viewed, for example, the distance between a plurality of selected banks is determined through the projection drawing to judge the similarity of the bank index data corresponding to each bank, or the bank index data of the selected banks is viewed through the coordinate view, so that the ranking result can be conveniently understood, and the interpretability of the ordering of each bank in the ordering drawing is further improved.
An embodiment of the present invention further provides a data sorting apparatus, and referring to fig. 4, fig. 4 is a schematic diagram of functional modules of an embodiment of the data sorting apparatus of the present invention, where the data sorting apparatus includes:
the acquiring module 100 is configured to acquire various kinds of bank index data corresponding to a sorting instruction and index weights corresponding to the various kinds of bank index data when the sorting instruction triggered based on the display interface is received, where the bank index data includes data of multiple banks;
a first determining module 200, configured to determine, based on the index weight and various kinds of bank index data, a projection graph corresponding to each bank;
a second determining module 300, configured to determine, based on the index weight and various kinds of bank index data, a ranking map corresponding to the ranking of each bank;
a display module 400, configured to display the projection drawing and the ranking drawing on the display interface;
and the display module 500 is used for determining a target bank corresponding to the selected instruction when the selected instruction triggered based on the display interface is received, and highlighting the target bank in the projection drawing and the sequencing drawing respectively.
Further, the first determining module 200 is further configured to:
determining interval index data of each year corresponding to each bank based on various bank index data;
and determining the distance corresponding to each bank through a tsne algorithm based on the index weight and the interval index data, and determining the projection graph of each year corresponding to each bank based on the distance.
Further, the second determining module 300 is further configured to:
determining indexes and values corresponding to all banks through a topsis algorithm based on the index weight and various bank index data;
and determining a ranking graph corresponding to the ranking among the banks based on the indexes and the values.
Further, the data sorting device further comprises:
and determining the coordinate view corresponding to each bank based on various bank index data, and displaying the coordinate view on the display interface.
Further, the display module 500 is further configured to:
when a selection instruction triggered based on a display interface is received, determining a target bank corresponding to the selection instruction;
highlighting the target bank in the projection view, the ranking view and the coordinate view, respectively.
Further, the data sorting device further comprises:
storing the index weight upon receiving a weight save request.
In addition, an embodiment of the present invention further provides a storage medium, where the storage medium is a computer-readable storage medium, and the storage medium stores a data sorting program, where the data sorting program, when executed by a processor, implements the steps of the data sorting method described above.
The method implemented when the data sorting program running on the processor is executed may refer to each embodiment of the data sorting method of the present invention, and details are not described here.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.