CN114722787B - Tag matching method based on Excel cascading and related equipment thereof - Google Patents
Tag matching method based on Excel cascading and related equipment thereof Download PDFInfo
- Publication number
- CN114722787B CN114722787B CN202210367952.1A CN202210367952A CN114722787B CN 114722787 B CN114722787 B CN 114722787B CN 202210367952 A CN202210367952 A CN 202210367952A CN 114722787 B CN114722787 B CN 114722787B
- Authority
- CN
- China
- Prior art keywords
- level
- tag
- target
- display area
- labels
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 47
- 238000006243 chemical reaction Methods 0.000 claims description 11
- 238000000605 extraction Methods 0.000 claims description 6
- 238000010276 construction Methods 0.000 claims description 3
- 238000012163 sequencing technique Methods 0.000 claims 1
- 238000013473 artificial intelligence Methods 0.000 abstract description 5
- 238000005516 engineering process Methods 0.000 abstract description 3
- 230000008569 process Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000006835 compression Effects 0.000 description 2
- 238000007906 compression Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000012549 training Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Software Systems (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the application belongs to the field of artificial intelligence and big data, and relates to a tag matching method based on Excel cascading, which comprises the steps of receiving a lower-level tag display instruction, and extracting a target display area and an upper-level tag from the lower-level tag display instruction, wherein the upper-level tag comprises special characters; matching target identifiers corresponding to the upper-level tags through a text matching model, and acquiring all lower-level tags corresponding to the target identifiers from a preset database; and displaying all the lower-level labels in the target display area. The application also provides a tag matching device, computer equipment and a storage medium based on Excel cascading. In addition, the present application also relates to blockchain technology, wherein the above-mentioned superior label, inferior label and target identifier can be stored in the blockchain. The method and the device realize matching of all lower-level labels corresponding to the upper-level label with the special character, enrich the displayable content of the upper-level label and the applicable scene of Excel cascading.
Description
Technical Field
The application relates to the technical field of artificial intelligence and big data, in particular to a tag matching method based on Excel cascading and related equipment thereof.
Background
At present, in the process of matching the inferior labels of Excel cascade, all the inferior labels corresponding to the superior labels are firstly matched from a database set by a name manager, and then all the obtained inferior labels are displayed; however, in the related process of the upper-level tag and the lower-level tag, if the upper-level tag has special characters (such as numbers, mathematical symbols and the like), a prompt that the upper-level tag and the lower-level tag are failed to be related is made, or text content in the related upper-level tag cannot be normally displayed in practical application, so that the upper-level tag with the special characters cannot be matched with the lower-level tag, excel cascading displayable content is limited, and the display is weak and the universality is poor.
Disclosure of Invention
The embodiment of the application aims to provide a tag matching method based on Excel cascading and related equipment thereof, so as to solve the problem that the prior art cannot realize that an upper-level tag with special characters is matched with a lower-level tag.
In order to solve the above technical problems, the embodiment of the present application provides an Excel cascade-based tag matching, which adopts the following technical scheme:
receiving a lower-level tag display instruction, and extracting a target display area and an upper-level tag from the lower-level tag display instruction, wherein the upper-level tag comprises special characters;
matching target identifiers corresponding to the upper-level tags through a text matching model, and acquiring all lower-level tags corresponding to the target identifiers from a preset database;
and displaying all the lower-level labels in the target display area.
Further, before the step of obtaining all the subordinate tags corresponding to the target identifier from the preset database, the method further includes:
displaying the target mark in the target display area;
the step of obtaining all subordinate labels corresponding to the target identifier from a preset database comprises the following steps:
when the target display area displays the target identifier, acquiring all lower-level labels corresponding to the target identifier from a preset database.
Further, before the step of matching the target identifier corresponding to the upper level tag through the text matching model and obtaining all the lower level tags corresponding to the target identifier from a preset database, the method further comprises:
acquiring tag data, and extracting an upper-level tag, a lower-level tag and a target identifier to be associated from the tag data;
respectively establishing a first corresponding relation between an upper-level label to be associated and a target identifier and a second corresponding relation between a lower-level label to be associated and the target identifier;
and constructing a text matching model according to the first corresponding relation, and constructing a preset database according to the second corresponding relation.
Further, before the step of establishing the first correspondence between the superior label to be associated and the target identifier and the second correspondence between the subordinate label to be associated and the target identifier, the method further includes:
and creating a hidden worksheet, and importing the upper-level tag, the lower-level tag and the target identifier into the hidden worksheet.
Further, the step of displaying all the lower-level labels in the target display area includes:
and acquiring a preset ordering rule of the lower-level labels, and sequentially displaying all the lower-level labels in the target display area according to the preset ordering rule.
Further, the preset ordering rule is a click rate rule; the step of sequentially displaying all the subordinate tags in the target display area according to the preset ordering rule comprises the following steps:
reordering all the lower labels according to the clicked quantity of each lower label according to the click quantity rule;
and displaying all the reordered lower labels in the target display area in sequence.
Further, the step of displaying all the lower-level labels in the target display area includes:
acquiring a preset configuration format, and performing format conversion on each lower-level tag according to the preset configuration format;
and displaying all the lower-level labels after format conversion in the target display area.
In order to solve the technical problem, the embodiment of the application also provides a tag matching device based on Excel cascading, which adopts the following technical scheme:
the extraction module is used for receiving a lower-level tag display instruction, and extracting a target display area and an upper-level tag from the lower-level tag display instruction, wherein the upper-level tag comprises special characters;
the first acquisition module is used for matching the target identifier corresponding to the upper-level tag through a text matching model and acquiring all lower-level tags corresponding to the target identifier from a preset database; and
and the first display module is used for displaying all the lower-level labels in the target display area.
In order to solve the above technical problems, the embodiments of the present application further provide a computer device, which adopts the following technical schemes:
the tag matching method comprises a memory and a processor, wherein the memory stores computer readable instructions, and the processor executes the computer readable instructions to realize the steps of the tag matching method based on Excel cascading.
In order to solve the above technical problems, embodiments of the present application further provide a computer readable storage medium, which adopts the following technical solutions:
the computer readable storage medium has stored thereon computer readable instructions which when executed by a processor implement the steps of the Excel cascade based tag matching method as described above.
Compared with the prior art, the embodiment of the application has the following main beneficial effects: the method comprises the steps of receiving a lower-level tag display instruction, and extracting a target display area and an upper-level tag from the lower-level tag display instruction, wherein the upper-level tag comprises special characters; matching target identifiers corresponding to the upper-level tags through a text matching model, and acquiring all lower-level tags corresponding to the target identifiers from a preset database; and displaying all the lower-level labels in the target display area. The matching model is adopted to match the target identifier corresponding to the upper-level tag, and then all lower-level tags corresponding to the target identifier are acquired from a preset database, so that even if special characters are arranged in the upper-level tag, all lower-level tags corresponding to the upper-level tag can be matched, the displayable content of the upper-level tag and the applicable scene of Excel cascading are enriched, and the universality is strong.
Drawings
For a clearer description of the solution in the present application, a brief description will be given below of the drawings that are needed in the description of the embodiments of the present application, it being obvious that the drawings in the following description are some embodiments of the present application, and that other drawings may be obtained from these drawings without inventive effort for a person of ordinary skill in the art.
FIG. 1 is an exemplary system architecture diagram in which the present application may be applied;
FIG. 2 is a flow chart of one embodiment of an Excel cascade-based tag matching method according to the present application;
FIG. 3 is a schematic structural view of one embodiment of an Excel cascade-based tag matching apparatus in accordance with the present application;
FIG. 4 is a schematic structural diagram of one embodiment of a computer device according to the present application.
Detailed Description
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs; the terminology used in the description of the applications herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application; the terms "comprising" and "having" and any variations thereof in the description and claims of the present application and in the description of the figures above are intended to cover non-exclusive inclusions. The terms first, second and the like in the description and in the claims or in the above-described figures, are used for distinguishing between different objects and not necessarily for describing a sequential or chronological order.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the present application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.
In order to better understand the technical solutions of the present application, the following description will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the accompanying drawings.
As shown in fig. 1, a system architecture 100 may include terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 is used as a medium to provide communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
The user may interact with the server 105 via the network 104 using the terminal devices 101, 102, 103 to receive or send messages or the like. Various communication client applications, such as a web browser application, a shopping class application, a search class application, an instant messaging tool, a mailbox client, social platform software, etc., may be installed on the terminal devices 101, 102, 103.
The terminal devices 101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablet computers, electronic book readers, MP3 players (Moving Picture Experts Group Audio Layer III, dynamic video expert compression standard audio plane 3), MP4 (Moving Picture Experts Group Audio Layer IV, dynamic video expert compression standard audio plane 4) players, laptop and desktop computers, and the like.
The server 105 may be a server providing various services, such as a background server providing support for pages displayed on the terminal devices 101, 102, 103.
It should be noted that, the tag matching method based on Excel cascade provided in the embodiments of the present application is generally executed by a server/terminal device, and accordingly, the tag matching device based on Excel cascade is generally set in the server/terminal device.
It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
With continued reference to FIG. 2, a flow chart of one embodiment of a method of Excel cascade-based tag matching in accordance with the present application is shown. The Excel cascade-based tag matching method comprises the following steps:
step S201, receiving a lower-level tag display instruction, and extracting a target display area and an upper-level tag from the lower-level tag display instruction, wherein the upper-level tag comprises special characters.
In this embodiment, the electronic device (for example, the server/terminal device shown in fig. 1) on which the tag matching method based on Excel cascade operates may receive the lower-level tag display instruction through a wired connection manner or a wireless connection manner. It should be noted that the wireless connection may include, but is not limited to, 3G/4G/5G connection, wiFi connection, bluetooth connection, wiMAX connection, zigbee connection, UWB (ultra wideband) connection, and other now known or later developed wireless connection.
The lower-level tag display instruction can be generated after clicking by a user, for example, after the user selects an upper-level tag and clicks a display button for displaying the lower-level tag, the lower-level tag display instruction is generated; the lower-level tag display instruction can also be automatically generated after the user selects the upper-level tag.
The target display area is used for displaying the lower-level labels.
The upper label may include a special character, for example, in the financial field, the upper label may be "insurance & claim", where "&" is a special character, and for example, the upper label may be "this", where "" is a special character.
Step S202, matching the target identification corresponding to the upper-level label through a text matching model, and acquiring all lower-level labels corresponding to the target identification from a preset database.
In this embodiment, the target identifier may be text, or a combination of text and number, such as "first level identifier", "first level 0".
The text matching model forms a data set by pre-training a first corresponding relation (specifically please refer to the description below) between the superior label and the target label, and in practical application, the target label corresponding to the superior label is matched from the data set; it should be noted that the text matching model is not built in Excel.
The preset database is built in Excel, specifically a name manager tool built in Excel, and matching of the target identifier and the lower-level tag is achieved according to the association content of a second corresponding relation (specifically please refer to the description below) between the lower-level tag and the target identifier, which is preset in the name manager.
And step S203, displaying all the lower-level labels in the target display area.
In this embodiment, when the target display area displays the lower-level tags, the target display area may directly display all lower-level tags, or may display only a part of lower-level tags, and realize that a part of lower-level tags are switched to another part of lower-level tags by means of dragging up and down by a scroll bar; in addition, the sorting mode of the lower-level labels can be used for paging display (for example, 10 lower-level labels are displayed on each page), and the effect of switching part of lower-level labels to the other part of lower-level labels can be achieved.
In practical applications, the Excel cascade may include a hidden worksheet (see the description below), and a display worksheet, where the superior label, the subordinate label, and the target identifier are located on the hidden worksheet, and the target display area is located on the display worksheet, so as to distinguish the data (i.e., the superior label, the subordinate label, and the target identifier) from the target display area, so as to facilitate management and display of the data.
According to the method and the device, the matching model is adopted to match the target identifier corresponding to the upper-level tag, and then all lower-level tags corresponding to the target identifier are acquired from the preset database, so that even if special characters are carried in the upper-level tag, all lower-level tags corresponding to the upper-level tag can be matched, the displayable content of the upper-level tag and the applicable scene of Excel cascading are enriched, and the universality is strong.
In some optional implementations of this embodiment, step 202, before the step of obtaining, from the preset database, all the lower-level tags corresponding to the target identifier, further includes:
displaying the target mark in the target display area;
in the step 202, the step of obtaining all the lower-level tags corresponding to the target identifier from the preset database includes:
when the target display area displays the target identifier, acquiring all lower-level labels corresponding to the target identifier from a preset database.
In this embodiment, the target display area is a matching point, when the target identifier is displayed in the target display area, a lower-level tag obtaining instruction is formed, the target identifier is obtained from the matching point according to the lower-level tag obtaining instruction, and all lower-level tags corresponding to the target identifier are obtained from a preset database, so that the matching of the upper-level tag with special characters with the lower-level tag is realized.
Further, when the target mark is displayed in the target display area, the target mark may be displayed in a hidden manner (not visible to the user) or may be displayed in a non-hidden manner (visible to the user).
In some optional implementations of this embodiment, before the step of matching, by the text matching model, the target identifier corresponding to the upper-level tag and obtaining, from a preset database, all the lower-level tags corresponding to the target identifier in the step S202, the method further includes:
acquiring tag data, and extracting an upper-level tag, a lower-level tag and a target identifier to be associated from the tag data;
respectively establishing a first corresponding relation between an upper-level label to be associated and a target identifier and a second corresponding relation between a lower-level label to be associated and the target identifier;
and constructing a text matching model according to the first corresponding relation, and constructing a preset database according to the second corresponding relation.
In this embodiment, in the Excel table, the upper-level tag, the lower-level tag, and the target identifier may be set in the same row/column, and a first correspondence between the upper-level tag to be associated and the target identifier, and a second correspondence between the lower-level tag to be associated and the target identifier may be respectively established; for example, an upper-level tag may be set in column a of row 1, lower-level tags may be set in columns B to O of row 1 (specifically, the number of actual columns may be determined according to the number of lower-level tags), and a target identifier may be set in column Q of row 1; similarly, the upper-level tag may be set in the 1 st row of the a column, the lower-level tags may be set in the 2 nd to 10 th rows of the a column (specifically, the actual column number may be determined according to the number of the lower-level tags), and the target identifier may be set in the 12 th row of the a column.
After the upper-level tag, the lower-level tag and the target identifier are arranged in an Excel table, a text matching model is pre-trained according to the first corresponding relation, a first corresponding relation between the upper-level tag and the target identifier is established, a text matching model is established according to the first corresponding relation, a second corresponding relation between the lower-level tag and the target identifier is established through a name manager built in the Excel, and a preset database is established according to the second corresponding relation component text matching model.
In some optional implementations of this embodiment, before the step of establishing the first correspondence between the superior label to be associated and the target identifier and the second correspondence between the subordinate label to be associated and the target identifier, the method further includes:
and creating a hidden worksheet, and importing the upper-level tag, the lower-level tag and the target identifier into the hidden worksheet.
In this embodiment, the hidden worksheets are non-exposed worksheets of an Excel cascade; for example, in the process of actual Excel cascade display, the hidden worksheet is not displayed, for example, the display worksheet for Excel cascade display is Sheet1, and the hidden worksheet is Sheet2; the hidden worksheet is used for storing, so that the worksheets for displaying and the hidden worksheets for storing the data are divided according to the functionality, and subsequent management and maintenance are facilitated.
Furthermore, a password can be set in the hidden worksheet, namely when the hidden worksheet is entered, the data of the upper-level tag, the lower-level tag and the target identifier in the hidden worksheet can be checked only by inputting the password for verification, so that the data security of the upper-level tag, the lower-level tag and the target identifier in the hidden worksheet is ensured.
In some optional implementations of this embodiment, the step of displaying all the subordinate tags in the target display area includes:
and acquiring a preset ordering rule of the lower-level labels, and sequentially displaying all the lower-level labels in the target display area according to the preset ordering rule.
In this embodiment, the preset sorting rule may be a click rate sorting rule, and sort the lower tags by the click rate, which is described in detail below.
The preset sorting rule may also be an initial sorting rule; the first letter sorting rule is specifically that sorting is performed according to the first letters of pinyin of the first word in each lower-level label, for example, sorting is performed on each lower-level label from a to z.
The preset sorting rule may be a grouping sorting rule, specifically, all the labels to be displayed are grouped according to a preset standard, for example, in the financial field, stock is group a, loan is group B, money is group C, and the labels are sequentially displayed according to the order of group a, group B and group C.
And a preset ordering rule is adopted, so that a user can conveniently find the lower label of the target, and the user experience is improved.
In some optional implementations of this embodiment, the preset ordering rule is a click volume rule; the step of sequentially displaying all the subordinate tags in the target display area according to the preset ordering rule comprises the following steps:
reordering all the lower labels according to the clicked quantity of each lower label according to the click quantity rule;
and displaying all the reordered lower labels in the target display area in sequence.
In this embodiment, the preset sorting rule may be a click rate sorting rule, specifically, after each time of displaying the lower label, the click rate of each lower label is counted (when the lower label is clicked, the click rate is increased by one), and all lower labels are reordered according to the click rate of each lower label, so that when the same lower label is displayed next time, the reordered lower labels are displayed in order, so that the lower label for searching the target is facilitated.
When each lower label is displayed for the first time, the lower labels are displayed after being ordered according to the initial ordering rule.
In some optional implementations of this embodiment, the step of displaying all the subordinate tags in the target display area includes:
acquiring a preset configuration format, and performing format conversion on each lower-level tag according to the preset configuration format;
and displaying all the lower-level labels after format conversion in the target display area.
In this embodiment, the preset configuration format is obtained according to obtaining the existing superior label/subordinate label/other text content (such as a worksheet title, a cascading menu name) in the exhibition worksheet (see the description about the exhibition worksheet above), where the preset configuration format includes a font, a font size, a font format (such as a bold, underlined, font color, etc. font format), and the like.
In the actual lower label display, format conversion is carried out on each lower label according to a preset configuration format, so that fonts of each lower label in a display form and other texts (such as other lower labels, upper labels, preset text information and the like) are unified, and the overall consistency of the fonts in the worksheet is ensured.
It should be emphasized that, to further ensure the privacy and security of the above-mentioned superior label, inferior label and target identifier, the above-mentioned superior label, inferior label and target identifier may also be stored in a node of a blockchain.
The blockchain referred to in the application is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, encryption algorithm and the like. The Blockchain (Blockchain), which is essentially a decentralised database, is a string of data blocks that are generated by cryptographic means in association, each data block containing a batch of information of network transactions for verifying the validity of the information (anti-counterfeiting) and generating the next block. The blockchain may include a blockchain underlying platform, a platform product services layer, an application services layer, and the like.
The embodiment of the application can acquire and process the related data based on the artificial intelligence technology. Among these, artificial intelligence (Artificial Intelligence, AI) is the theory, method, technique and application system that uses a digital computer or a digital computer-controlled machine to simulate, extend and extend human intelligence, sense the environment, acquire knowledge and use knowledge to obtain optimal results.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by computer readable instructions stored in a computer readable storage medium that, when executed, may comprise the steps of the embodiments of the methods described above. The storage medium may be a nonvolatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a random access Memory (Random Access Memory, RAM).
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited in order and may be performed in other orders, unless explicitly stated herein. Moreover, at least some of the steps in the flowcharts of the figures may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order of their execution not necessarily being sequential, but may be performed in turn or alternately with other steps or at least a portion of the other steps or stages.
With further reference to fig. 3, as an implementation of the method shown in fig. 2, the present application provides an embodiment of a tag matching apparatus based on Excel cascading, where an embodiment of the apparatus corresponds to the embodiment of the method shown in fig. 2, and the apparatus may be specifically applied in various electronic devices.
As shown in fig. 3, the tag matching apparatus 300 based on Excel cascade according to the present embodiment includes: the device comprises an extraction module 301, a first acquisition module 302 and a first display module 303.
Wherein:
the extracting module 301 is configured to receive a lower-level tag display instruction, and extract a target display area and an upper-level tag from the lower-level tag display instruction, where the upper-level tag includes a special character;
the first obtaining module 302 is configured to match, through a text matching model, a target identifier corresponding to the upper level tag, and obtain, from a preset database, all lower level tags corresponding to the target identifier;
and the first display module 303 is configured to display all the lower-level tags in the target display area.
According to the method and the device, the matching model is adopted to match the target identifier corresponding to the upper-level tag, and then all lower-level tags corresponding to the target identifier are acquired from the preset database, so that even if special characters are carried in the upper-level tag, all lower-level tags corresponding to the upper-level tag can be matched, the displayable content of the upper-level tag and the applicable scene of Excel cascading are enriched, and the universality is strong.
In some optional implementations of this embodiment, the Excel cascade-based tag matching apparatus further includes a second display module. Wherein:
and the second display module is used for displaying the target mark in the target display area.
The first acquisition module 302 includes an acquisition unit. Wherein:
the acquisition unit is used for acquiring all lower-level labels corresponding to the target identification from a preset database when the target identification is displayed in the target display area.
In some optional implementations of this embodiment, the Excel cascade-based tag matching apparatus further includes a second extraction module, a relationship establishment module, and a construction module. Wherein:
the second extraction module is used for acquiring tag data and extracting an upper-level tag, a lower-level tag and a target identifier to be associated from the tag data;
the relation establishing module is used for respectively establishing a first corresponding relation between the superior label to be associated and the target identifier and a second corresponding relation between the subordinate label to be associated and the target identifier;
the construction module is used for constructing a text matching model according to the first corresponding relation and constructing a preset database according to the second corresponding relation.
In some optional implementations of this embodiment, the Excel cascade-based tag matching apparatus further includes an import module. Wherein:
and the importing module is used for creating a hidden worksheet and importing the upper-level tag, the lower-level tag and the target identifier into the hidden worksheet.
In some alternative implementations of this embodiment, the first display module 303 includes a first display unit. Wherein:
the first display unit is used for acquiring a preset ordering rule of the lower-level labels, and sequentially displaying all the lower-level labels in the target display area according to the preset ordering rule.
In some optional implementations of this embodiment, the first display unit includes a sorting subunit and a display subunit. Wherein:
a sorting subunit, configured to reorder, according to the click rate rule, all the lower labels according to the clicked rate of each lower label;
and the display subunit displays all the reordered lower-level labels in the target display area in sequence.
In some optional implementations of this embodiment, the first display module 303 includes a format conversion unit and a second display unit. Wherein:
the format conversion unit is used for acquiring a preset configuration format and carrying out format conversion on each lower-level tag according to the preset configuration format;
and the second display unit is used for displaying all the lower-level labels after format conversion in the target display area.
In order to solve the technical problems, the embodiment of the application also provides computer equipment. Referring specifically to fig. 4, fig. 4 is a basic structural block diagram of a computer device according to the present embodiment.
The computer device 4 comprises a memory 41, a processor 42, a network interface 43 which are communicatively connected to each other via a system bus. It should be noted that only computer device 4 having components 41-43 is shown in the figures, but it should be understood that not all of the illustrated components are required to be implemented and that more or fewer components may be implemented instead. It will be appreciated by those skilled in the art that the computer device herein is a device capable of automatically performing numerical calculations and/or information processing in accordance with predetermined or stored instructions, the hardware of which includes, but is not limited to, microprocessors, application specific integrated circuits (Application Specific Integrated Circuit, ASICs), programmable gate arrays (fields-Programmable Gate Array, FPGAs), digital processors (Digital Signal Processor, DSPs), embedded devices, etc.
The computer equipment can be a desktop computer, a notebook computer, a palm computer, a cloud server and other computing equipment. The computer equipment can perform man-machine interaction with a user through a keyboard, a mouse, a remote controller, a touch pad or voice control equipment and the like.
The memory 41 includes at least one type of readable storage medium including flash memory, hard disk, multimedia card, card memory (e.g., SD or DX memory, etc.), random Access Memory (RAM), static Random Access Memory (SRAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), programmable Read Only Memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the storage 41 may be an internal storage unit of the computer device 4, such as a hard disk or a memory of the computer device 4. In other embodiments, the memory 41 may also be an external storage device of the computer device 4, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash Card (Flash Card) or the like, which are provided on the computer device 4. Of course, the memory 41 may also comprise both an internal memory unit of the computer device 4 and an external memory device. In this embodiment, the memory 41 is generally used to store an operating system and various application software installed on the computer device 4, such as computer readable instructions of an Excel cascade-based tag matching method. Further, the memory 41 may be used to temporarily store various types of data that have been output or are to be output.
The processor 42 may be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 42 is typically used to control the overall operation of the computer device 4. In this embodiment, the processor 42 is configured to execute computer readable instructions stored in the memory 41 or process data, for example, execute computer readable instructions of the tag matching method based on Excel cascade.
The network interface 43 may comprise a wireless network interface or a wired network interface, which network interface 43 is typically used for establishing a communication connection between the computer device 4 and other electronic devices.
According to the method and the device, the matching model is adopted to match the target identifier corresponding to the upper-level tag, and then all lower-level tags corresponding to the target identifier are acquired from the preset database, so that even if special characters are carried in the upper-level tag, all lower-level tags corresponding to the upper-level tag can be matched, the displayable content of the upper-level tag and the applicable scene of Excel cascading are enriched, and the universality is strong.
The present application also provides another embodiment, namely, a computer-readable storage medium, where computer-readable instructions are stored, where the computer-readable instructions are executable by at least one processor to cause the at least one processor to perform the steps of the Excel cascade-based tag matching method as described above.
According to the method and the device, the matching model is adopted to match the target identifier corresponding to the upper-level tag, and then all lower-level tags corresponding to the target identifier are acquired from the preset database, so that even if special characters are carried in the upper-level tag, all lower-level tags corresponding to the upper-level tag can be matched, the displayable content of the upper-level tag and the applicable scene of Excel cascading are enriched, and the universality is strong.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk), comprising several instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method described in the embodiments of the present application.
It is apparent that the embodiments described above are only some embodiments of the present application, but not all embodiments, the preferred embodiments of the present application are given in the drawings, but not limiting the patent scope of the present application. This application may be embodied in many different forms, but rather, embodiments are provided in order to provide a more thorough understanding of the present disclosure. Although the present application has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that modifications may be made to the embodiments described in the foregoing, or equivalents may be substituted for elements thereof. All equivalent structures made by the specification and the drawings of the application are directly or indirectly applied to other related technical fields, and are also within the protection scope of the application.
Claims (7)
1. The Excel cascade-based tag matching method is characterized by comprising the following steps of:
receiving a lower-level tag display instruction, and extracting a target display area and an upper-level tag from the lower-level tag display instruction, wherein the upper-level tag comprises special characters;
matching target identifiers corresponding to the upper-level tags through a text matching model, and acquiring all lower-level tags corresponding to the target identifiers from a preset database;
displaying all the lower-level labels in the target display area;
before the step of matching the target identifier corresponding to the upper-level tag through the text matching model and acquiring all lower-level tags corresponding to the target identifier from a preset database, the method further comprises the following steps:
acquiring tag data, and extracting an upper-level tag, a lower-level tag and a target identifier to be associated from the tag data;
respectively establishing a first corresponding relation between an upper-level label to be associated and a target identifier and a second corresponding relation between a lower-level label to be associated and the target identifier;
constructing a text matching model according to the first corresponding relation, and constructing a preset database according to the second corresponding relation;
the step of displaying all the subordinate labels in the target display area comprises the following steps:
acquiring a preset ordering rule of the lower-level labels, and sequentially displaying all the lower-level labels in the target display area according to the preset ordering rule;
wherein, the preset ordering rule is a click rate rule; the step of sequentially displaying all the subordinate tags in the target display area according to the preset ordering rule comprises the following steps:
reordering all the lower labels according to the clicked quantity of each lower label according to the click quantity rule;
and displaying all the reordered lower labels in the target display area in sequence.
2. The Excel cascade-based tag matching method according to claim 1, further comprising, before the step of obtaining all the lower-level tags corresponding to the target identifier from the preset database:
displaying the target mark in the target display area;
the step of obtaining all subordinate labels corresponding to the target identifier from a preset database comprises the following steps:
when the target display area displays the target identifier, acquiring all lower-level labels corresponding to the target identifier from a preset database.
3. The Excel cascade-based tag matching method according to claim 1, further comprising, before the step of establishing a first correspondence between the superior tag to be associated and the target identifier and a second correspondence between the inferior tag to be associated and the target identifier, respectively:
and creating a hidden worksheet, and importing the upper-level tag, the lower-level tag and the target identifier into the hidden worksheet.
4. The Excel cascade-based tag matching method of any one of claims 1 to 3, the step of displaying all the subordinate tags in the target display area comprising:
acquiring a preset configuration format, and performing format conversion on each lower-level tag according to the preset configuration format;
and displaying all the lower-level labels after format conversion in the target display area.
5. An Excel cascade-based tag matching apparatus, comprising:
the extraction module is used for receiving a lower-level tag display instruction, and extracting a target display area and an upper-level tag from the lower-level tag display instruction, wherein the upper-level tag comprises special characters;
the first acquisition module is used for matching the target identifier corresponding to the upper-level tag through a text matching model and acquiring all lower-level tags corresponding to the target identifier from a preset database; and
the first display module is used for displaying all the lower-level labels in the target display area;
the second extraction module is used for acquiring tag data and extracting an upper-level tag, a lower-level tag and a target identifier to be associated from the tag data;
the relation establishing module is used for respectively establishing a first corresponding relation between the superior label to be associated and the target identifier and a second corresponding relation between the subordinate label to be associated and the target identifier;
the construction module is used for constructing a text matching model according to the first corresponding relation and constructing a preset database according to the second corresponding relation;
the first display module comprises a first display unit, wherein the first display unit is used for acquiring a preset ordering rule of the lower-level labels, and sequentially displaying all the lower-level labels in the target display area according to the preset ordering rule;
the first display unit comprises a sequencing subunit and a display subunit; the sorting subunit is used for reordering all the lower-level labels according to the clicked quantity of each lower-level label according to the click quantity rule; and the display subunit is used for displaying all the reordered lower-level labels in the target display area in sequence.
6. A computer device comprising a memory and a processor, the memory having stored therein computer readable instructions which when executed by the processor implement the steps of the Excel cascade based tag matching method of any of claims 1 to 4.
7. A computer readable storage medium having stored thereon computer readable instructions which when executed by a processor implement the steps of the Excel cascade based tag matching method of any of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210367952.1A CN114722787B (en) | 2022-04-08 | 2022-04-08 | Tag matching method based on Excel cascading and related equipment thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210367952.1A CN114722787B (en) | 2022-04-08 | 2022-04-08 | Tag matching method based on Excel cascading and related equipment thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114722787A CN114722787A (en) | 2022-07-08 |
| CN114722787B true CN114722787B (en) | 2024-02-06 |
Family
ID=82242443
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210367952.1A Active CN114722787B (en) | 2022-04-08 | 2022-04-08 | Tag matching method based on Excel cascading and related equipment thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114722787B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103389988A (en) * | 2012-05-10 | 2013-11-13 | 腾讯科技（深圳）有限公司 | Method and device for guiding user to carry out information search |
| JP2020009273A (en) * | 2018-07-10 | 2020-01-16 | 株式会社医用工学研究所 | Search system |
| WO2020103183A1 (en) * | 2018-11-22 | 2020-05-28 | Beijing Didi Infinity Technology And Development Co., Ltd. | System and method for constructing database |
| CN111639156A (en) * | 2020-05-13 | 2020-09-08 | 广州国音智能科技有限公司 | Query method, device, equipment and storage medium based on hierarchical label |
| CN113779422A (en) * | 2021-08-23 | 2021-12-10 | 北京达佳互联信息技术有限公司 | Method and device for realizing relation chain label, electronic equipment and storage medium |
| CN114168874A (en) * | 2021-12-03 | 2022-03-11 | 北京达佳互联信息技术有限公司 | Information display method and device, electronic equipment and storage medium |
-
2022
- 2022-04-08 CN CN202210367952.1A patent/CN114722787B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103389988A (en) * | 2012-05-10 | 2013-11-13 | 腾讯科技（深圳）有限公司 | Method and device for guiding user to carry out information search |
| JP2020009273A (en) * | 2018-07-10 | 2020-01-16 | 株式会社医用工学研究所 | Search system |
| WO2020103183A1 (en) * | 2018-11-22 | 2020-05-28 | Beijing Didi Infinity Technology And Development Co., Ltd. | System and method for constructing database |
| CN111639156A (en) * | 2020-05-13 | 2020-09-08 | 广州国音智能科技有限公司 | Query method, device, equipment and storage medium based on hierarchical label |
| CN113779422A (en) * | 2021-08-23 | 2021-12-10 | 北京达佳互联信息技术有限公司 | Method and device for realizing relation chain label, electronic equipment and storage medium |
| CN114168874A (en) * | 2021-12-03 | 2022-03-11 | 北京达佳互联信息技术有限公司 | Information display method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114722787A (en) | 2022-07-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112016273A (en) | Document directory generation method and device, electronic equipment and readable storage medium | |
| CN113220734A (en) | Course recommendation method and device, computer equipment and storage medium | |
| CN112632278A (en) | Labeling method, device, equipment and storage medium based on multi-label classification | |
| CN111475700A (en) | Data extraction method and related equipment | |
| CN111625567A (en) | Data model matching method, device, computer system and readable storage medium | |
| CN112507141A (en) | Investigation task generation method and device, computer equipment and storage medium | |
| CN117195886A (en) | Text data processing method, device, equipment and medium based on artificial intelligence | |
| CN116956326A (en) | Authority data processing method and device, computer equipment and storage medium | |
| CN114722787B (en) | Tag matching method based on Excel cascading and related equipment thereof | |
| CN115756692A (en) | Method for automatically combining and displaying pages based on style attributes and related equipment thereof | |
| CN114626352B (en) | Report automatic generation method, device, computer equipment and storage medium | |
| CN113268949B (en) | Form display method and device based on dynamic fields, computer equipment and medium | |
| CN114637831A (en) | Data query method based on semantic analysis and related equipment thereof | |
| CN112069807A (en) | Text data theme extraction method and device, computer equipment and storage medium | |
| CN116628128B (en) | Method, device and equipment for standardization of supply chain data and storage medium thereof | |
| CN114510916B (en) | Template loading method and device, computer equipment and storage medium | |
| CN111190818B (en) | Front-end code analysis method, front-end code analysis device, computer equipment and storage medium | |
| CN113254622B (en) | Knowledge point query method, knowledge point query device and knowledge point query server | |
| CN116776838A (en) | Text processing method, device, computer equipment and storage medium | |
| CN116166858A (en) | Information recommendation method, device, equipment and storage medium based on artificial intelligence | |
| CN116933733A (en) | Text input display method, device, equipment and storage medium thereof | |
| CN115544282A (en) | Data processing method, device and equipment based on graph database and storage medium | |
| CN116431149A (en) | Page typesetting method, device, computer equipment and storage medium | |
| CN115826973A (en) | List page generation method and device, computer equipment and storage medium | |
| CN112966085A (en) | Intelligent control method and device for human-computer conversation, electronic equipment and storage medium |
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 |