[go: up one dir, main page]
More Web Proxy on the site http://driver.im/

CN112308406A - Data sorting method, device, equipment and computer readable storage medium - Google Patents

Data sorting method, device, equipment and computer readable storage medium Download PDF

Info

Publication number
CN112308406A
CN112308406A CN202011184664.XA CN202011184664A CN112308406A CN 112308406 A CN112308406 A CN 112308406A CN 202011184664 A CN202011184664 A CN 202011184664A CN 112308406 A CN112308406 A CN 112308406A
Authority
CN
China
Prior art keywords
bank
data
sorting
index
ranking
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
Application number
CN202011184664.XA
Other languages
Chinese (zh)
Other versions
CN112308406B (en
Inventor
刘强强
李�权
陈天健
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
WeBank Co Ltd
Original Assignee
WeBank Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by WeBank Co Ltd filed Critical WeBank Co Ltd
Priority to CN202011184664.XA priority Critical patent/CN112308406B/en
Publication of CN112308406A publication Critical patent/CN112308406A/en
Application granted granted Critical
Publication of CN112308406B publication Critical patent/CN112308406B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0639Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • G06Q10/06393Score-carding, benchmarking or key performance indicator [KPI] analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance

Landscapes

  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • Finance (AREA)
  • Accounting & Taxation (AREA)
  • Educational Administration (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Game Theory and Decision Science (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Technology Law (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本发明公开了一种数据排序方法,包括以下步骤:获取排序指令对应的各种银行指标数据以及各种银行指标数据对应的指标权重;基于指标权重以及各种银行指标数据,确定各个银行对应的投影图;基于指标权重以及各种银行指标数据,确定各个银行的排序对应的排序图;在展示界面展示投影图以及排序图;确定选中指令对应的目标银行,并分别在投影图以及排序图高亮显示所述目标银行。本发明还公开了一种数据排序装置、设备及计算机可读存储介质。本发明通过根据指标权重以及银行指标数据展示各个银行的投影图以及排序图,以便于通过投影图理解排序图的排序结果以及查看选择的银行对应的数据,提高了排序图中各个银行排序的可解释性。

Figure 202011184664

The invention discloses a data sorting method, comprising the following steps: obtaining various bank index data corresponding to a sorting instruction and index weights corresponding to the various bank index data; determining the corresponding bank index data based on the index weights and various bank index data Projection chart; based on the index weight and various bank index data, determine the ranking chart corresponding to the ranking of each bank; display the projection chart and the ranking chart on the display interface; determine the target bank corresponding to the selected command, and display the height of the projection chart and the ranking chart respectively. Highlight the target bank. The invention also discloses a data sorting device, equipment and a computer-readable storage medium. The present invention displays the projection map and the ranking map of each bank according to the index weight and the bank index data, so as to understand the ranking result of the ranking map and view the data corresponding to the selected bank through the projection map, and improve the possibility of sorting each bank in the ranking map. explanatory.

Figure 202011184664

Description

Data sorting method, device, equipment and computer readable storage medium
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data sorting method, apparatus, device, and computer-readable storage medium.
Background
At present, banks are often required to be ranked and graded in the banking industry, data of each bank has dozens of attribute dimensions, a large amount of labor cost is required for classifying the banks, and manual ranking by comparing different attribute dimensions easily causes errors.
At present, the sorting of banks is performed through excel or some common multi-attribute sorting algorithms, but the sorting modes are numerical results, and results given by mathematical sorting cannot give reasonable explanations to let users convince, so that the interpretability of sorting results is poor. Meanwhile, in the sorting process, in order to avoid interference of data (such as asset size) with large differences in data of each bank, the data of the bank is often normalized. However, the normalized data may make the weights between the multiple attribute data difficult to scale.
The above is only for the purpose of assisting understanding of the technical aspects of the present invention, and does not represent an admission that the above is prior art.
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.
Drawings
FIG. 1 is a schematic structural diagram of a data sorting device in a hardware operating environment according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating a data sorting method according to a first embodiment of the present invention;
FIG. 3 is a schematic diagram illustrating a display interface in the data sorting method according to the present invention;
fig. 4 is a functional block diagram of an embodiment of a data sorting apparatus according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As shown in fig. 1, fig. 1 is a schematic structural diagram of a 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.

Claims (10)

1.一种数据排序方法,其特征在于,所述数据排序方法包括以下步骤:1. A data sorting method, wherein the data sorting method comprises the following steps: 在接收到基于展示界面触发的排序指令时,获取排序指令对应的各种银行指标数据以及各种银行指标数据对应的指标权重,其中,所述银行指标数据包括多个银行的数据;When receiving a sorting instruction triggered based on the display interface, obtain various bank indicator data corresponding to the sorting instruction and indicator weights corresponding to various bank indicator data, wherein the bank indicator data includes data of multiple banks; 基于所述指标权重以及各种银行指标数据,确定各个银行对应的投影图;Determine the projection map corresponding to each bank based on the indicator weight and various bank indicator data; 基于所述指标权重以及各种银行指标数据,确定各个银行的排序对应的排序图;Based on the indicator weights and various bank indicator data, determine a ranking map corresponding to the ranking of each bank; 在所述展示界面展示所述投影图以及所述排序图;Display the projection map and the sorting map on the display interface; 在接收到基于展示界面触发的选中指令时,确定所述选中指令对应的目标银行,并分别在所述投影图以及所述排序图高亮显示所述目标银行。When a selection instruction triggered based on the display interface is received, a target bank corresponding to the selection instruction is determined, and the target bank is highlighted on the projection map and the sorting map respectively. 2.如权利要求1所述的数据排序方法,其特征在于,所述基于所述指标权重以及各种银行指标数据,确定各个银行对应的投影图的步骤包括:2. The data sorting method according to claim 1, wherein the step of determining the projection map corresponding to each bank based on the indicator weight and various bank indicator data comprises: 基于各种银行指标数据,确定各个银行对应的各年份的区间指标数据;Based on various bank indicator data, determine the interval indicator data for each year corresponding to each bank; 基于所述指标权重以及区间指标数据,通过tsne算法确定各个银行对应的距离,并基于所述距离确定各个银行对应的各年份的投影图。Based on the index weight and interval index data, the distance corresponding to each bank is determined by the tsne algorithm, and the projection map of each year corresponding to each bank is determined based on the distance. 3.如权利要求1所述的数据排序方法,其特征在于,所述基于所述指标权重以及各种银行指标数据,确定各个银行的排序对应的排序图的步骤包括:3. The data sorting method according to claim 1, wherein the step of determining the sorting diagram corresponding to the sorting of each bank based on the indicator weight and various bank indicator data comprises: 基于所述指标权重以及各种银行指标数据,通过topsis算法确定各个银行对应的指标和值;Based on the indicator weights and various bank indicator data, the indicators and values corresponding to each bank are determined by the topsis algorithm; 基于所述指标和值确定各个银行之间的排序对应的排序图。A ranking map corresponding to the ranking among the various banks is determined based on the index and the value. 4.如权利要求1所述的数据排序方法,其特征在于,所述在所述展示界面展示所述投影图以及所述排序图的步骤之后,所述数据排序方法还包括:4. The data sorting method according to claim 1, wherein after the step of displaying the projection map and the sorting map on the display interface, the data sorting method further comprises: 基于各种银行指标数据,确定各个银行对应的坐标视图,并在所述展示界面展示所述坐标视图。Based on various bank index data, a coordinate view corresponding to each bank is determined, and the coordinate view is displayed on the display interface. 5.如权利要求4所述的数据排序方法,其特征在于,所述在接收到基于展示界面触发的选中指令时,确定所述选中指令对应的目标银行,并分别在所述投影图以及所述排序图高亮显示所述目标银行的步骤包括:5 . The data sorting method according to claim 4 , wherein, when receiving a selection instruction triggered by a display interface, determine the target bank corresponding to the selection instruction, and display the corresponding target bank in the projection map and the selected instruction respectively. 6 . The steps of highlighting the target bank in the ranking diagram include: 在接收到基于展示界面触发的选中指令时,确定所述选中指令对应的目标银行;When receiving a selection instruction triggered based on the display interface, determine the target bank corresponding to the selection instruction; 分别在所述投影图、所述排序图以及所述坐标视图中高亮显示所述目标银行。The target bank is highlighted in the projection map, the ranking map, and the coordinate view, respectively. 6.如权利要求1所述的数据排序方法,其特征在于,所述银行指标数据包括资产规模、资本充足率、逾贷比资产利润率、资本利润率、成本收入比。6 . The data sorting method according to claim 1 , wherein the bank indicator data includes asset scale, capital adequacy ratio, over-loan ratio, asset profit ratio, capital profit ratio, and cost-to-income ratio. 7 . 7.如权利要求1至6任一项所述的数据排序方法,其特征在于,所述在所述展示界面展示所述投影图以及所述排序图的步骤之后,所述数据排序方法还包括:7. The data sorting method according to any one of claims 1 to 6, wherein after the step of displaying the projection map and the sorting map on the display interface, the data sorting method further comprises: : 在接收到权重保存请求时,存储所述指标权重。When a weight saving request is received, the indicator weight is stored. 8.一种数据排序装置,其特征在于,所述数据排序装置包括:8. A data sorting device, wherein the data sorting device comprises: 获取模块,用于在接收到基于展示界面触发的排序指令时,获取排序指令对应的各种银行指标数据以及各种银行指标数据对应的指标权重,其中,所述银行指标数据包括多个银行的数据;The obtaining module is configured to obtain various bank index data corresponding to the sorting command and the index weights corresponding to the various bank index data when receiving the sorting instruction triggered based on the display interface, wherein the bank index data includes the data of a plurality of banks. data; 第一确定模块,用于基于所述指标权重以及各种银行指标数据,确定各个银行对应的投影图;a first determination module, configured to determine the projection map corresponding to each bank based on the indicator weight and various bank indicator data; 第二确定模块,用于基于所述指标权重以及各种银行指标数据,确定各个银行的排序对应的排序图;The second determination module is configured to determine the sorting diagram corresponding to the sorting of each bank based on the indicator weight and various bank indicator data; 展示模块,用于在所述展示界面展示所述投影图以及所述排序图;a display module, configured to display the projection map and the sequence map on the display interface; 显示模块,用于在接收到基于展示界面触发的选中指令时,确定所述选中指令对应的目标银行,并分别在所述投影图以及所述排序图高亮显示所述目标银行。The display module is configured to determine a target bank corresponding to the selection instruction when receiving a selection instruction triggered based on the display interface, and highlight the target bank on the projection map and the sorting map respectively. 9.一种数据排序设备,其特征在于,所述数据排序设备包括:存储器、处理器及存储在所述存储器上并可在所述处理器上运行的数据排序程序,所述数据排序程序被所述处理器执行时实现如权利要求1至7中任一项所述的数据排序方法的步骤。9. A data sorting device, characterized in that the data sorting device comprises: a memory, a processor, and a data sorting program stored on the memory and running on the processor, the data sorting program being The processor implements the steps of the data sorting method according to any one of claims 1 to 7 when executed. 10.一种计算机可读存储介质,其特征在于,所述计算机可读存储介质上存储有数据排序程序,所述数据排序程序被处理器执行时实现如权利要求1至7中任一项所述的数据排序方法的步骤。10. A computer-readable storage medium, characterized in that, a data sorting program is stored on the computer-readable storage medium, and when the data sorting program is executed by a processor, the method according to any one of claims 1 to 7 is implemented. The steps of the data sorting method described above.
CN202011184664.XA 2020-10-29 2020-10-29 Data ordering method, device, equipment and computer readable storage medium Active CN112308406B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011184664.XA CN112308406B (en) 2020-10-29 2020-10-29 Data ordering method, device, equipment and computer readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011184664.XA CN112308406B (en) 2020-10-29 2020-10-29 Data ordering method, device, equipment and computer readable storage medium

Publications (2)

Publication Number Publication Date
CN112308406A true CN112308406A (en) 2021-02-02
CN112308406B CN112308406B (en) 2024-06-11

Family

ID=74331823

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011184664.XA Active CN112308406B (en) 2020-10-29 2020-10-29 Data ordering method, device, equipment and computer readable storage medium

Country Status (1)

Country Link
CN (1) CN112308406B (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110196808A1 (en) * 2009-08-03 2011-08-11 Kamal Mustafa System and Method for Directors and Officers Risk Assessment
CN107562966A (en) * 2017-10-23 2018-01-09 郑州大学 The optimization system and method based on intelligence learning for web page interlinkage retrieval ordering
CN107967624A (en) * 2017-11-24 2018-04-27 四川长虹电器股份有限公司 A kind of evaluation method of business activity Sale Forecasting Model
CN108415921A (en) * 2017-09-25 2018-08-17 平安科技(深圳)有限公司 Supplier recommends method, apparatus and computer readable storage medium
CN111178377A (en) * 2019-10-12 2020-05-19 未鲲(上海)科技服务有限公司 Visual feature screening method, server and storage medium
CN111428092A (en) * 2020-03-20 2020-07-17 北京中亦安图科技股份有限公司 Accurate bank marketing method based on graph model

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110196808A1 (en) * 2009-08-03 2011-08-11 Kamal Mustafa System and Method for Directors and Officers Risk Assessment
CN108415921A (en) * 2017-09-25 2018-08-17 平安科技(深圳)有限公司 Supplier recommends method, apparatus and computer readable storage medium
CN107562966A (en) * 2017-10-23 2018-01-09 郑州大学 The optimization system and method based on intelligence learning for web page interlinkage retrieval ordering
CN107967624A (en) * 2017-11-24 2018-04-27 四川长虹电器股份有限公司 A kind of evaluation method of business activity Sale Forecasting Model
CN111178377A (en) * 2019-10-12 2020-05-19 未鲲(上海)科技服务有限公司 Visual feature screening method, server and storage medium
CN111428092A (en) * 2020-03-20 2020-07-17 北京中亦安图科技股份有限公司 Accurate bank marketing method based on graph model

Also Published As

Publication number Publication date
CN112308406B (en) 2024-06-11

Similar Documents

Publication Publication Date Title
CN107909466B (en) Customer relationship network display method, device, equipment and readable storage medium
CN107818492B (en) Product recommendation apparatus, method and computer-readable storage medium
CN107506499B (en) Method, device and server for establishing logical relationship between interest point and building
CN111210071B (en) Business object prediction method, device, equipment and readable storage medium
CN110717806B (en) Product information pushing method, device, equipment and storage medium
CN111782758A (en) Drawing review result viewing method based on CAD and related device
CN114022702A (en) Intelligent warehouse management method and device, electronic equipment and storage medium
CN110472162B (en) Evaluation method, system, terminal and readable storage medium
CN113360790A (en) Information recommendation method and device and electronic equipment
CN114880310A (en) User behavior analysis method and device, computer equipment and storage medium
CN111368045A (en) User intention identification method, device, equipment and computer readable storage medium
CN111581091B (en) Page testing method and device, readable medium and electronic equipment
WO2018102141A1 (en) System and method for determining best venue for selling a vehicle
CN114925153B (en) Service-based geographic information data quality detection method, device and equipment
CN114020755B (en) Image map tile publishing method, image map tile generating method and device
CN112308406A (en) Data sorting method, device, equipment and computer readable storage medium
CN112612989A (en) Data display method and device, computer equipment and storage medium
CN112669142A (en) Modeling method, device and equipment of high-dimensional behavior data and readable storage medium
CN111832251B (en) Method and related device for displaying aesthetic drawing record
CN113065071B (en) Product information recommendation method and computer equipment
CN115857741A (en) Recommendation method and device for shortcut switch and electronic equipment
CN114757712A (en) Site selection recommendation method and device, electronic equipment and readable storage medium
CN113568741B (en) Service expansion and contraction method, device, equipment and storage medium of distributed system
CN116932553A (en) Method, device, equipment and storage medium for constructing due-job questionnaire list
KR102402491B1 (en) Method for displaying information on data fluctuation and apparatus thereof

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