CN111178021A - Project alignment marking tool creating method and system - Google Patents
Project alignment marking tool creating method and system Download PDFInfo
- Publication number
- CN111178021A CN111178021A CN201911199434.8A CN201911199434A CN111178021A CN 111178021 A CN111178021 A CN 111178021A CN 201911199434 A CN201911199434 A CN 201911199434A CN 111178021 A CN111178021 A CN 111178021A
- Authority
- CN
- China
- Prior art keywords
- project
- data
- creating
- project data
- parent
- 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.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for creating a project alignment marking tool, which comprises the following steps: s1: acquiring original data for creating a project data hierarchical structure; s2: creating at least one level of project data and defining the range of the project data; s3: and defining a project summary for creating the project labels, and outputting values corresponding to the project data to the project summary. Compared with the prior art, the method can realize multi-project marking, and has light weight, convenient operation and higher safety.
Description
Technical Field
The invention relates to the field of medical science and beauty, in particular to a method and a system for creating a project alignment marking tool.
Background
In the simulation marketing robot, item identification is one of important bases for the robot to reply. And the robot extracts the corresponding dialect from the knowledge base according to the item and the intention of the visitor and replies. Whether the project identification is accurate or not is related to the accuracy of the robot answer, and the experience of a user is directly influenced. Particularly in the medical and aesthetic fields, the number of items related to the robot can be hundreds, and wrong item identification can cause wrong calling of the robot in the conversation, so that the robot can give no questions and even cannot reply. On the other hand, each item, although having a canonical name, is called differently in the guest portal. For example, the term "double eyelid cutting" may be expressed as "double eyelid making", "double eyelid pulling", etc., which raises the problem of item alignment. Item alignment is the mapping of an item's unnormal call to a canonical call. If the item alignment fails, the situation of finding no operation still occurs. However, project alignment requires a large amount of data to be collected and a large amount of annotating personnel or even outsourcing to be annotated, so that a reasonable annotating tool is designed to support the whole annotating process.
Disclosure of Invention
In order to solve the problems in the prior art, the invention selects the characteristic vocabulary representative text with good selectivity to calculate the similarity by calculating the information gain of the words contained in the text, thereby achieving the purpose of quickly and accurately calculating the similarity of the text. A method and a system for creating a project alignment marking tool are provided. The method comprises the following specific steps:
a method for creating a project alignment marking tool comprises the following steps:
s1: acquiring original data for creating a project data hierarchical structure;
s2: creating at least one level of project data and defining the range of the project data;
s3: and defining a project summary for creating the project labels, and outputting values corresponding to the project data to the project summary.
Preferably, the step S2 further includes:
s2-1: creating parent project data and determining the range of child project data corresponding to each parent project data;
s2-2: it is determined whether the child item data in S2-1 includes child item data of the next level, and if so, the creation of child item data of the next level is continued.
Preferably, the step S3 further includes: and adding command buttons and defining corresponding execution functions by using the macro compiling function of Excel, and displaying all sub-item data corresponding to the marked items in cells corresponding to the item summary during operation.
Preferably, the creating parent project data includes: and adding pull-down content to the parent project data by utilizing the data effectiveness of Excel, and determining the corresponding parent project data range.
Preferably, the determining the range of the child item data corresponding to each parent item data includes: and setting the value of the child project data correspondingly linked with the parent project data by utilizing the data validity of Excel.
A project alignment annotation tool creation system, comprising:
the system comprises an acquisition unit, a storage unit and a processing unit, wherein the acquisition unit is used for acquiring original data which is used for creating a project data hierarchical structure;
the creating unit is used for creating at least one level of project data and defining the range of the project data;
and the definition unit is used for defining the project summary for creating the project labels and outputting the values corresponding to the project data to the project summary.
Preferably, the creating unit further includes:
creating parent project data and determining the range of child project data corresponding to each parent project data; and judging whether the sub-project data in S2-1 contains the next-level sub-project data, if yes, continuing to create the next-level sub-project data.
Preferably, the defining unit further includes: and adding command buttons and defining corresponding execution functions by using the macro compiling function of Excel, and displaying all sub-item data corresponding to the marked items in cells corresponding to the item summary during operation.
Preferably, the creating parent project data includes: and adding pull-down content to the parent project data by utilizing the data effectiveness of Excel, and determining the corresponding parent project data range.
Preferably, the determining the range of the child item data corresponding to each parent item data includes: and setting the value of the child project data correspondingly linked with the parent project data by utilizing the data validity of Excel.
Compared with the prior art, the invention has the following advantages:
1. the design method of the simple and reliable item alignment marking tool is provided, and the tool built on the basis of excel is simple and easy to use.
2. The multi-level linkage list is convenient for marking personnel to quickly find target items from hundreds of labels, and document multi-item marking is supported.
3. The encryption and the limitation of the original data are supported, the safety is ensured, and the transmission, the screening and the retrieval are convenient.
4. And encrypting and protecting the project hierarchy table by using the hidden worksheet and the data protection function of the excel.
Drawings
The following describes a method and a system for creating a project alignment marking tool according to the present invention with reference to the accompanying drawings.
FIG. 1 is a flow chart of a method for creating a project alignment annotation tool of the present invention;
FIG. 2 is a screenshot of a portion of a display interface for building parent project data according to an embodiment of the invention;
FIG. 3 is a partial display interface screenshot of building sub-project data according to an embodiment of the present invention;
FIG. 4 is a screenshot of a results display of a project summary of an embodiment of the invention;
FIG. 5 is a block diagram of the construction of the project alignment annotation tool creation system of the present invention.
Detailed Description
Fig. 1 is a flowchart of a method for creating a project alignment marking tool according to the present invention, and the method modifies a document by using a macro compilation function of an Excel document to become a marking tool meeting functional requirements. The tools involved include Excel, two-level linkage, and VBA compiler.
The method for creating the project alignment marking tool specifically comprises the following steps:
(1) one or more project hierarchy tables are created based on existing data, the first row (title) of the tables is each parent project, and the following is a child project corresponding to each parent project. This table is stored in a sheet named "first-order relationship table". The document part contents of the project data are shown in the following table:
| autologous fat filling | Washing embroidery | Chest shaping | ... |
| Autologous fat plump apple flesh | Eyebrow tattooing device | Chest lift | ... |
| Fat body-enlarging cheek | Washing tattoo | Breast enlarging device | ... |
| ... | ... | ... | ... |
(2) A parent item data drop-down column is established. The newly-built sheet is named as an operation interface and serves as a main interface for marking operation. Referring to the partial content display screen shot shown in fig. 2. And a first column of 'main items' is newly established, pull-down content is added to the main item column by utilizing the data effectiveness of excel, the range of the main items is defined, and the range of the main items is a title part in the primary relation table.
(3) The child data drop-down column is established. As shown with reference to fig. 3. And adding a 'sub-item column' beside the main item column, and defining the data range of the sub-item column as a value in the item hierarchy table linked with the corresponding value in the cell of the main item column by utilizing the excel data validity function.
If there is a higher level of classification for the item, steps (2) - (3) may be repeated to build a sufficient number of linked columns.
(4) As shown with reference to fig. 4. And selecting a column as a project summary column named as 'project summary', adding a command button and writing a corresponding execution code by using a macro compiling function of excel, so that the excel executes the operation of 'adding data of a sub-project column into a corresponding cell of the project summary column' when the button is clicked. Thus, after different projects are repeatedly selected, a plurality of projects can be accumulated to a project summary column, and the next project is labeled.
(5) And encrypting and protecting the project hierarchy table by using the hidden worksheet and the data protection function of the excel.
FIG. 5 is a block diagram illustrating a system for creating a project alignment annotation tool according to an embodiment of the present invention. The method comprises the following steps:
the system comprises an acquisition unit, a storage unit and a processing unit, wherein the acquisition unit is used for acquiring original data which is used for creating a project data hierarchical structure;
the creating unit is used for creating at least one level of project data and defining the range of the project data;
and the definition unit is used for defining the project summary for creating the project labels and outputting the values corresponding to the project data to the project summary.
Preferably, the creating unit further includes:
creating parent project data and determining the range of child project data corresponding to each parent project data; and
it is determined whether the child item data in S2-1 includes child item data of the next level, and if so, the creation of child item data of the next level is continued.
Preferably, the defining unit further includes: and adding command buttons and defining corresponding execution functions by using the macro compiling function of Excel, and displaying all sub-item data corresponding to the marked items in cells corresponding to the item summary during operation.
Preferably, the creating parent project data includes: and adding pull-down content to the parent project data by utilizing the data effectiveness of Excel, and determining the corresponding parent project data range.
Preferably, the determining the range of the child item data corresponding to each parent item data includes: and setting the value of the child project data correspondingly linked with the parent project data by utilizing the data validity of Excel.
Compared with the prior art, the scheme of the invention has the following advantages:
1. the operation is convenient; the marking tool has to be simple and convenient to operate on an interface, so that a marking person can quickly get on the hand, and the time cost and the operation obstacle caused by the process of being familiar with the tool are reduced. And structural design is reasonable, makes things convenient for the marking personnel to find the target item fast from several hundreds of labels.
2. A light weight; the marking tool needs to be frequently transmitted at several places of data issuing personnel, marking personnel, auditors and data recovery personnel, so that the tool size is small enough, and data transmission and recovery are facilitated.
3. The searching and calling are convenient; the tool is required to support various searching and screening, so that the marking personnel and the auditors can conveniently search and modify the content at any time, and the analysts can easily and directly call the content.
4. The safety is high; the encryption and the limitation of the original data are required to be supported, and the security is ensured.
5. Realizing multi-item labeling; a plurality of items exist in a part of sentences, and all the items existing in the sentences are required to be marked.
The embodiments in the above embodiments can be further combined or replaced, and the embodiments are only used for describing the preferred embodiments of the present invention, and do not limit the concept and scope of the present invention, and various changes and modifications made to the technical solution of the present invention by those skilled in the art without departing from the design idea of the present invention belong to the protection scope of the present invention.
Claims (10)
1. A method for creating a project alignment marking tool is characterized by comprising the following steps:
s1: acquiring original data for creating a project data hierarchical structure;
s2: creating at least one level of project data and defining the range of the project data;
s3: and defining a project summary for creating the project labels, and outputting values corresponding to the project data to the project summary.
2. The method for creating a project alignment marking tool according to claim 1, wherein the step S2 further comprises:
s2-1: creating parent project data and determining the range of child project data corresponding to each parent project data;
s2-2: it is determined whether the child item data in S2-1 includes child item data of the next level, and if so, the creation of child item data of the next level is continued.
3. The method for creating a project alignment marking tool according to claim 1, wherein the step S3 further comprises: and adding command buttons and defining corresponding execution functions by using the macro compiling function of Excel, and displaying all sub-item data corresponding to the marked items in cells corresponding to the item summary during operation.
4. The method of claim 2, wherein the creating parent project data comprises: and adding pull-down content to the parent project data by utilizing the data effectiveness of Excel, and determining the corresponding parent project data range.
5. The method for creating the project alignment marking tool according to claim 2, wherein the determining the range of the child project data corresponding to each parent project data comprises: and setting the value of the child project data correspondingly linked with the parent project data by utilizing the data validity of Excel.
6. A system for creating a project alignment annotation tool, comprising:
the system comprises an acquisition unit, a storage unit and a processing unit, wherein the acquisition unit is used for acquiring original data which is used for creating a project data hierarchical structure;
the creating unit is used for creating at least one level of project data and defining the range of the project data;
and the definition unit is used for defining the project summary for creating the project labels and outputting the values corresponding to the project data to the project summary.
7. The system of claim 6, wherein the creating unit further comprises:
creating parent project data and determining the range of child project data corresponding to each parent project data; and
it is determined whether the child item data in S2-1 includes child item data of the next level, and if so, the creation of child item data of the next level is continued.
8. The system of claim 6, wherein the definition unit further comprises: and adding command buttons and defining corresponding execution functions by using the macro compiling function of Excel, and displaying all sub-item data corresponding to the marked items in cells corresponding to the item summary during operation.
9. The system of claim 7, wherein the creating parent project data comprises: and adding pull-down content to the parent project data by utilizing the data effectiveness of Excel, and determining the corresponding parent project data range.
10. The system for creating a project alignment annotation tool as claimed in claim 7, wherein said determining the scope of the child project data corresponding to each parent project data comprises: and setting the value of the child project data correspondingly linked with the parent project data by utilizing the data validity of Excel.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911199434.8A CN111178021A (en) | 2019-11-29 | 2019-11-29 | Project alignment marking tool creating method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911199434.8A CN111178021A (en) | 2019-11-29 | 2019-11-29 | Project alignment marking tool creating method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111178021A true CN111178021A (en) | 2020-05-19 |
Family
ID=70656445
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911199434.8A Pending CN111178021A (en) | 2019-11-29 | 2019-11-29 | Project alignment marking tool creating method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111178021A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102662930A (en) * | 2012-04-16 | 2012-09-12 | 乐山师范学院 | Corpus tagging method and corpus tagging device |
| CN108875020A (en) * | 2018-06-20 | 2018-11-23 | 第四范式（北京）技术有限公司 | For realizing the method, apparatus, equipment and storage medium of mark |
| CN108897869A (en) * | 2018-06-29 | 2018-11-27 | 北京百度网讯科技有限公司 | Corpus labeling method, device, equipment and storage medium |
| CN109408788A (en) * | 2018-09-26 | 2019-03-01 | 南京大学 | A kind of text marking method towards judgement document |
| JP2019192247A (en) * | 2018-04-20 | 2019-10-31 | 株式会社Ｎｔｔドコモ | Sentence labeling method and sentence labeling device |
-
2019
- 2019-11-29 CN CN201911199434.8A patent/CN111178021A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102662930A (en) * | 2012-04-16 | 2012-09-12 | 乐山师范学院 | Corpus tagging method and corpus tagging device |
| JP2019192247A (en) * | 2018-04-20 | 2019-10-31 | 株式会社Ｎｔｔドコモ | Sentence labeling method and sentence labeling device |
| CN108875020A (en) * | 2018-06-20 | 2018-11-23 | 第四范式（北京）技术有限公司 | For realizing the method, apparatus, equipment and storage medium of mark |
| CN108897869A (en) * | 2018-06-29 | 2018-11-27 | 北京百度网讯科技有限公司 | Corpus labeling method, device, equipment and storage medium |
| CN109408788A (en) * | 2018-09-26 | 2019-03-01 | 南京大学 | A kind of text marking method towards judgement document |
Non-Patent Citations (3)
| Title |
|---|
| DUANLIANVIP: "人工智能训练数据-Excel打标签、数据清洗", HTTPS://BLOG.CSDN.NET/DUANLIANVIP/ARTICLE/DETAILS/90371744, pages 1 - 7 * |
| 伊尔夏提・吐尔贡 等: "维吾尔文情感语料库的构建与分析" * |
| 伊尔夏提・吐尔贡;吾守尔・斯拉木;热西旦木・吐尔洪太;于清;: "维吾尔文情感语料库的构建与分析", 计算机与现代化, no. 04, pages 67 - 72 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Carl et al. | New directions in empirical translation process research | |
| Kalmegh | Analysis of weka data mining algorithm reptree, simple cart and randomtree for classification of indian news | |
| US7735068B2 (en) | Automated relationship traceability between software design artifacts | |
| CN104679826B (en) | The method and system of context identification based on disaggregated model | |
| Shigarov | Table understanding using a rule engine | |
| Anthony | Visualisation in corpus-based discourse studies | |
| Pereira et al. | Business process modeling languages: A comparative framework | |
| CN107807968B (en) | Question answering device and method based on Bayesian network and storage medium | |
| CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
| CN108701292A (en) | Recommendation is provided based on job change instruction | |
| CN107992476B (en) | Corpus generation method and system for sentence-level biological relation network extraction | |
| CN111656453A (en) | Hierarchical entity recognition and semantic modeling framework for information extraction | |
| CN111125524A (en) | Data analysis and data push method based on knowledge graph | |
| US20080059437A1 (en) | Data mining system | |
| CN104598510A (en) | Event trigger word recognition method and device | |
| CN112445894A (en) | Business intelligent system based on artificial intelligence and analysis method thereof | |
| WO2014008304A2 (en) | Extensibility for sales predictor (spe) | |
| CN111191429A (en) | System and method for automatic filling of data table | |
| US11720596B2 (en) | Identifying content and structure of OLAP dimensions from a spreadsheet | |
| CN102662929A (en) | Method and device for intelligent problem analyzing and processing based on ontology | |
| CN103903210A (en) | Case feature series-parallel analysis method | |
| CN117708157A (en) | SQL sentence generation method and device | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| CN117420998A (en) | Client UI interaction component generation method, device, terminal and medium | |
| CN111178021A (en) | Project alignment marking tool creating method and system |
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 |