CN110826306A - Data acquisition method and device, computer readable storage medium and electronic equipment - Google Patents

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

Info

Publication number
CN110826306A
CN110826306A CN201911072146.6A CN201911072146A CN110826306A CN 110826306 A CN110826306 A CN 110826306A CN 201911072146 A CN201911072146 A CN 201911072146A CN 110826306 A CN110826306 A CN 110826306A
Authority
CN
China
Prior art keywords
data
determining
row
gauge
type
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
CN201911072146.6A
Other languages
Chinese (zh)
Other versions
CN110826306B (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.)
Taikang Insurance Group Co Ltd
Original Assignee
Taikang Insurance Group 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 Taikang Insurance Group Co Ltd filed Critical Taikang Insurance Group Co Ltd
Priority to CN201911072146.6A priority Critical patent/CN110826306B/en
Publication of CN110826306A publication Critical patent/CN110826306A/en
Application granted granted Critical
Publication of CN110826306B publication Critical patent/CN110826306B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Machine Translation (AREA)

Abstract

The present disclosure provides a data acquisition method, a data acquisition apparatus, a computer-readable storage medium, and an electronic device; relates to the technical field of data processing. The data acquisition method comprises the following steps: extracting row data in the original evaluation table, wherein the row data comprises column data; determining the data type of the line data, and determining a gauge control corresponding to the row of data according to the data type of the line data; and determining a gauge template corresponding to the original evaluation table based on the gauge control corresponding to the row of data so as to acquire data through the gauge template. The data acquisition method disclosed by the disclosure can overcome the problem of high time cost of manual template manufacturing to a certain extent, and further improves the data acquisition efficiency.

Description

Data acquisition method and device, computer readable storage medium and electronic equipment
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a data acquisition method, a data acquisition device, a computer-readable storage medium, and an electronic device.
Background
The questionnaire is the most direct method for collecting data and the most important link in the process of developing business. Under different business scenes, different tables can be designed to collect data so as to determine the intention of a user and the market demand, such as questionnaires about the health condition of residents, questionnaires about consumption level and the like.
The form of the questionnaire usually consists of a plurality of test questions, which are divided into a plurality of question types such as single-choice, multi-choice, blank filling and the like, and after the user fills the form, the data in the form needs to be recorded into a system to perform data analysis, calculation and other works. Currently, some evaluation systems provide tools for the fabrication of line tables. However, when the form is manufactured, a designer needs to design a form template first and then the manufacturer manufactures the form template into a structured template, and a lot of operations need to be repeated in the process, so that a lot of time is consumed.
It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present disclosure, and thus may include information that does not constitute prior art known to those of ordinary skill in the art.
Disclosure of Invention
The purpose of the present disclosure is to provide a data acquisition method, a data acquisition device, a computer-readable storage medium, and an electronic device, so as to overcome the problem that manual data table making needs to consume a high time cost to a certain extent, and further improve the efficiency of data acquisition.
Additional features and advantages of the disclosure will be set forth in the detailed description which follows, or in part will be obvious from the description, or may be learned by practice of the disclosure.
According to a first aspect of the present disclosure, there is provided a data acquisition method, including:
extracting row data in an original evaluation table, wherein the row data comprises column data;
determining the data type of the line data, and determining a gauge control corresponding to the row of data according to the data type of the line data;
and determining a gauge template corresponding to the original evaluation table based on the gauge control corresponding to the row of data so as to acquire data through the gauge template.
In an exemplary embodiment of the disclosure, the determining a data type of the column data includes:
analyzing whether the line data contains special characters or not, and if the line data does not contain the special characters, determining the data type of the line data as a first preset type;
and if the line data contains special characters, determining the data type of the line data as a second preset type.
In an exemplary embodiment of the present disclosure, the determining, according to the data type of the column data, a gauge control corresponding to the row of data includes:
determining the question type of the row of data according to special characters contained in the column data of the second preset type;
and acquiring a scale control corresponding to the title type.
In an exemplary embodiment of the present disclosure, the determining, based on the gauge control corresponding to the row of data, a gauge template corresponding to the original evaluation table includes:
taking the column data of the first preset type as a first text, and determining the first text as a title;
acquiring a second text except the special characters in the second preset type of line data, and determining the second text as a question stem;
and combining the question and the question stem by using the scale control to generate a scale template corresponding to the original evaluation table.
In an exemplary embodiment of the present disclosure, the determining, based on the gauge control corresponding to the row of data, a gauge template corresponding to the original evaluation table includes:
determining a gauge control corresponding to each row of data contained in the original evaluation gauge;
and combining the gauge controls according to the line sequence number of the line data to obtain the gauge template.
In an exemplary embodiment of the present disclosure, the collecting data through the scale template includes:
and sending the scale template to each client to receive the evaluation data of each client.
In an exemplary embodiment of the present disclosure, the extracting line data in the original evaluation table includes:
and performing character recognition on the image of the original evaluation table to acquire each line of data in the original evaluation table.
According to a second aspect of the present disclosure, there is provided a data acquisition apparatus comprising a data extraction module, a type determination module, and a template acquisition module, wherein:
and the data extraction module is used for extracting row data in the original evaluation table, wherein the row data comprises column data.
And the type determining module is used for determining the data type of the column data and determining the gauge control corresponding to the row of data according to the data type of the column data.
And the template acquisition module is used for determining the gauge template corresponding to the original evaluation table based on the gauge control corresponding to the row of data so as to acquire data through the gauge template.
In an exemplary embodiment of the present disclosure, the type determining module may include a first type judging unit and a second type judging unit, wherein:
the first type judging unit is used for analyzing whether the line data contains special characters or not, and if the line data does not contain the special characters, the data type of the line data is determined to be a first preset type.
And the second type judging unit is used for determining the data type of the line data as a second preset type if the line data contains special characters.
In an exemplary embodiment of the present disclosure, the type determining module may include a title determining unit and a control obtaining unit, wherein:
and the title determining unit is used for determining the title type of the row of data according to the special characters contained in the column data of the second preset type.
And the control acquiring unit is used for acquiring the gauge control corresponding to the title type.
In an exemplary embodiment of the present disclosure, the template obtaining module may include a first text determining unit, a second text determining unit, and a combining unit, wherein:
and the first text determining unit is used for determining the first text as a title by taking the first preset type of column data as the first text.
And the second text determining unit is used for acquiring a second text except the special characters in the second preset type of line data and determining the second text as a question stem.
And the combination unit is used for combining the question and the question stem by using the scale control so as to generate a scale template corresponding to the original evaluation table.
In an exemplary embodiment of the present disclosure, the template obtaining module may include a row determining unit and a control combining unit, wherein:
and the line determining unit is used for determining the gauge control corresponding to each line of data contained in the original evaluation table.
And the control combination unit is used for combining the gauge controls according to the line sequence number of the row of data to obtain the gauge template.
In an exemplary embodiment of the present disclosure, the template obtaining module may include a data collecting unit, configured to send the scale template to each client to receive evaluation data of each client.
In an exemplary embodiment of the disclosure, the data extraction module is configured to perform character recognition on the image of the original evaluation table to obtain each line of data in the original evaluation table.
According to a third aspect of the present disclosure, there is provided an electronic device comprising: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the method of any one of the above via execution of the executable instructions.
According to a fourth aspect of the present disclosure, there is provided a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the method of any one of the above.
Exemplary embodiments of the present disclosure may have some or all of the following benefits:
in the data acquisition method provided by an example embodiment of the present disclosure, by determining the scale control corresponding to each row in the original evaluation table, the scale template corresponding to the original evaluation table can be obtained by using the scale control, so that the original evaluation table designed by a designer can be automatically converted into a structured scale template, the automation degree of the data acquisition process is enhanced, and the data acquisition efficiency can be improved. And moreover, the data can be directly acquired into the system through the scale template, so that the data is convenient to process, and the data processing efficiency is improved. Meanwhile, an online template does not need to be generated manually, so that the process can be simplified, and the labor cost can be saved; in addition, the data unavailability caused by errors caused by manual template manufacturing can be avoided, and the effectiveness of the data is further improved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure. It is to be understood that the drawings in the following description are merely exemplary of the disclosure, and that other drawings may be derived from those drawings by one of ordinary skill in the art without the exercise of inventive faculty.
FIG. 1 schematically illustrates a flow diagram of a data acquisition method according to one embodiment of the present disclosure;
FIG. 2 schematically shows a diagram of an original evaluation table according to one embodiment of the present disclosure;
FIG. 3 schematically illustrates a flow diagram of a data acquisition method according to one embodiment of the present disclosure;
FIG. 4 schematically illustrates a flow diagram of a data acquisition method according to another embodiment of the present disclosure;
FIG. 5 schematically illustrates a flow diagram of a data collection method according to one embodiment of the present disclosure;
FIG. 6 schematically illustrates a flow diagram of a data acquisition method according to another embodiment of the present disclosure;
FIG. 7 schematically illustrates a flow diagram of a data collection method according to one embodiment of the present disclosure;
FIG. 8 schematically illustrates a gauge template diagram according to one embodiment of the present disclosure;
FIG. 9 schematically illustrates a block diagram of a data acquisition device according to one embodiment of the present disclosure;
FIG. 10 schematically illustrates a system architecture diagram for implementing the data acquisition method according to one embodiment of the present disclosure;
FIG. 11 illustrates a schematic structural diagram of a computer system suitable for use in implementing an electronic device of an embodiment of the present disclosure.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to give a thorough understanding of embodiments of the disclosure. One skilled in the relevant art will recognize, however, that the subject matter of the present disclosure can be practiced without one or more of the specific details, or with other methods, components, devices, steps, and the like. In other instances, well-known technical solutions have not been shown or described in detail to avoid obscuring aspects of the present disclosure.
Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.
The technical solution of the embodiment of the present disclosure is explained in detail below:
in the business of a rehabilitation hospital or an elderly community, admission evaluation of a patient is an indispensable operation, and staff such as doctors and nurses need to guide the next work according to the evaluation result. Each evaluation table can be composed of a plurality of test papers or test questions, and a template needs to be made in advance for each evaluation table. When the template is made, a business person needs to refer to a paper evaluation document used under the line, and then the template making is completed through a tool provided by the system. The service personnel need to analyze each item in the paper evaluation table one by one to judge what question type is used in the system. When the evaluation table has a plurality of test questions, the workload is huge, and the efficiency of manual production is low. Moreover, for designers of the evaluation form, it is difficult to express the paper test questions on the system by using the controls.
In view of one or more of the above problems, the present example embodiment first provides a data acquisition method. Referring to fig. 1, the data acquisition method may include the steps of:
step S110: and extracting row data in the original evaluation table, wherein the row data comprises a plurality of column data.
Step S120: and determining the data type of each column of data, and determining a gauge control corresponding to the row of data according to the data type of each column of data.
Step S130: and determining a gauge template corresponding to the original evaluation table based on the gauge control corresponding to the row of data so as to acquire data through the gauge template.
In the data acquisition method provided by an example embodiment of the present disclosure, by determining the scale control corresponding to each row in the original evaluation table, the scale template corresponding to the original evaluation table can be obtained by using the scale control, so that the original evaluation table designed by a designer can be automatically converted into a structured scale template, the automation degree of the data acquisition process is enhanced, and the data acquisition efficiency can be improved. And moreover, the data can be directly acquired into the system through the scale template, so that the data is convenient to process, and the data processing efficiency is improved. Meanwhile, an online template does not need to be generated manually, so that the process can be simplified, and the labor cost can be saved; in addition, the data unavailability caused by errors caused by manual template manufacturing can be avoided, and the effectiveness of the data is further improved.
The above steps of the present exemplary embodiment will be described in more detail below.
In step S110, a row of data in the original evaluation table is extracted, where the row of data includes column data.
The original evaluation table is a table including a plurality of test questions, for example, a single-choice question, a multiple-choice question, a null-fill question, and the like, as shown in fig. 2. Questionnaires can be conducted through the original evaluation table, and therefore the purpose of collecting data is achieved. Different evaluation tables can be designed according to different service scenes, for example, a user satisfaction evaluation table, a teacher teaching evaluation table and the like, so that the method and the system can be applied to various application scenes.
The original evaluation form may be a form file designed by a designer or an existing paper form. An image of the original evaluation table may be acquired by the image pickup apparatus, and then line data in the original evaluation table is extracted using the image. Specifically, character recognition may be performed on an image of the original evaluation table, so as to obtain the character content in each cell in the original evaluation table. The image of the original evaluation table may be subjected to character Recognition by a character Recognition tool, for example, an OCR (optical character Recognition) tool; alternatively, the image of the original evaluation table may be identified by other artificial intelligence algorithms, which is not particularly limited in this embodiment.
After the character content of each cell in the original evaluation table is recognized, the acquired characters can be stored in a row unit, that is, the cells belonging to the same row are stored in an associated manner, or the cells can be identified by a row sequence number, so that the identifiers of the cells in the same row are the same, and thus, a plurality of rows of data of the original evaluation table are acquired. Similarly, in other embodiments of the present disclosure, character recognition is performed on the image of the original evaluation table, and column data in the original evaluation table may also be extracted.
In step S120, a data type of the line data is determined, and a gauge control corresponding to the row of data is determined according to the data type of each line data.
The scale is a measuring tool, which can quantitatively measure subjective and abstract concepts, and characteristic variables of objects can be determined by adopting different measurement standards. The gauge control is a tool in a web page and can be displayed in a web form. The gauge control can enable a user to interact with the terminal equipment, so that information is input into the equipment.
In this embodiment, the row data may include one or more column data, and if the row data includes a plurality of column data, the data type of each column data is determined. Specifically, the method may include step S301 and step S302, as shown in fig. 3, where:
in step S301, whether the line data includes a special character is analyzed, and if the line data does not include the special character, the data type of the line data is determined as a first preset type. In this embodiment, the extracted character content of the cell in the original evaluation table is used, so that the column data included in each row of data can be subjected to character matching one by one, whether the column data includes a special character is determined, if the character included in the column data matches a special character, the column data is considered to include the special character, and if the character included in the column data does not match any special character, the column data is determined not to include the special character. And if the column data does not contain the special characters, determining that the data type of the column data is a first preset type.
In step S302, if the line data includes a special character, the data type of the line data is determined as a second preset type. It can be seen that the column data can be divided into a first predetermined type and a second predetermined type by whether the column data includes a special character. In addition, in this embodiment, the column data may be further divided in a more detailed manner, for example, the column data is divided according to special characters included in the column data, for example, if the column data includes "dots", the data type of the column data is determined as a third preset type, and the like, and this embodiment is not limited thereto. Also, the data types of the respective columns of data may be labeled, for example, the column data of the first preset type may be labeled as "a", and the column data of the second preset type may be labeled as "B". The labels of the first preset type and the second preset type may be set according to actual situations, for example, the first preset type is "topic", the second preset type is "topic stem", and the like, which is not particularly limited in this embodiment.
After the data type of each column of data is determined, the gauge control corresponding to the row of data can be determined according to the data type of the column of data. In the evaluation form, the contents to be filled in or selected by the user are generally represented by special characters, for example, the positions to be filled in by the user are generally represented by "long horizontal lines" in the form, and further, for example, the options that the user can select are represented by "boxes". Therefore, the type of the test question to which the column data belongs can be determined by using the special characters contained in the analyzed column data, so that the corresponding gauge control can be determined according to the type of the test question. As shown in fig. 4, the method may include step S401 and step S402, wherein:
in step S401, the title type of the row of data is determined according to the special characters included in the column data of the second preset type. Specifically, the column data is divided into a second preset type according to whether the column data contains special characters, and then the special characters contained in the column data are further subdivided, so that different special characters can correspond to different topic types. For example, the question type corresponding to each special character may be preset, for example, "long horizontal line" corresponds to "blank filling question", "square" corresponds to "round" corresponds to choice question, and the present embodiment is not limited to this.
One or more special characters can be included in a column of data, if the column of data includes multiple special characters, the topic type corresponding to the column of data can include multiple test questions combined by multiple topic types, such as a single-choice and multi-choice combination question, a blank-filling single-choice combination question, and the like. Each special character can correspond to a topic type, or multiple special characters can correspond to the same topic type, for example, "circle", "box", "triangle" can all correspond to "choice topic".
In step S420, a scale control corresponding to the topic type is obtained. If the topic type comprises a plurality of types, each topic type can correspond to a table control, for example, a radio topic can correspond to a button control, a fill-in-blank topic can correspond to an input box control, and the like. The gauge control may include a triggerable field and a text, such as a button and a button name displayed on the button. The scale control may be a control provided by the system, such as a form control, a button control, or the like, or, according to an actual requirement, the scale control may also be customized, for example, a scale control defining a choice question, or the like, which is not particularly limited in this embodiment. In addition, a scale numerical control library can be established, the self-defined scale control is stored through the scale control library, the collected self-defined scale control is more and more, and therefore the scale control corresponding to each cell in the evaluation table can be matched through the scale control library, and more template manufacturing requirements are met.
In the embodiment, the question type related in the table can be automatically determined by analyzing the special characters in the table, so that the corresponding table control is obtained according to the question type to generate the table template, the labor and time cost spent in manually judging the question type can be saved, the structured flow of the table is simplified, and the structured efficiency of the table is improved.
In step S130, a gauge template corresponding to the original evaluation table is determined based on the gauge control corresponding to the row data, so as to perform data acquisition through the gauge template.
And determining a gauge control corresponding to the row data, and generating a gauge template by using the gauge control. Specifically, the meter controls corresponding to the row data may include one or more meter controls, where each topic type may correspond to one meter control, and the meter template may be generated by combining text content included in the row data with the multiple meter controls. For example, the column data of the first preset type may be used as the text content of the scale control, and then the scale control is displayed in the page; or the text content contained in the row data and the corresponding gauge control are sent to an interface of the gauge making tool, so that the corresponding gauge template is generated.
In an alternative embodiment, the method may include steps S501 to S503, as shown in fig. 5, where:
in step S501, the first preset type of column data is used as a first text, and the first text is determined as a title. The first preset type of line data may be a first text if the first preset type of line data does not include a special character. The first text is determined as a title, which can be displayed directly as text in the page.
In step S502, a second text except for the special character in the second preset type of line data is obtained, and the second text is determined as a stem. In the second preset type of column data, other characters may be included besides the special characters, the other characters may be used as a second text, the second text may be obtained by removing the special characters in the column data, and the second text may also be displayed in a text format in the page.
In step S503, the question and the question stem are combined by using the scale control to generate a scale template corresponding to the original evaluation table. After the scale control corresponding to the line data is determined, the first text and the second text can be transmitted to an interface of the scale control, and the question stem are displayed through the scale control. For example, if the topic type corresponding to the line data is a single choice topic, the corresponding scale control may include a topic parameter and a stem parameter, and a first text is used as a value of the topic parameter, and a second text is used as a value of the stem parameter, and is transmitted into the scale control, so that the line data is displayed as a single choice topic in the web form. And for the scale control corresponding to the selection question, a plurality of question stem parameters can be introduced, and the number of the question stem parameters is the same as that of the options.
In an exemplary embodiment, the method may include steps S601 and S602, as shown in fig. 6, where the gauge template corresponding to the original evaluation table is determined based on the gauge control corresponding to the line data, and:
in step S601, a gauge control corresponding to each line of data included in the original evaluation table is determined. The original evaluation table may include a plurality of line data, the topic type corresponding to each line data may be different, and the table control corresponding to each line data may be determined according to the topic type corresponding to each line data, for example, the first line data in the original evaluation table may be a single-choice question, the second line data may be a null filling question, the third line data may be a multiple-choice question, and the like.
In step S602, the gauge controls are combined according to the line sequence number of each line of data to obtain the gauge template. And combining the gauge controls corresponding to each row according to the row serial number of each row of data in the original evaluation table, so that the arrangement sequence of the gauge controls is consistent with the sequence of each row of data in the original evaluation table. The obtained scale template comprises a plurality of scale controls, and a user can directly click the corresponding control in a page to perform operations such as selection, filling in a blank and the like, so that data are collected through the scale template. For example, the scale template may be sent to each client, the scale template is displayed in a browser page of the client, the user may perform template filling online, the client may store the scale information after the completion of the user filling, or send the scale information after the completion of the user filling to a server or other clients, so that data of each client may be collected, and various data processing such as data sorting and analysis may be performed.
As shown in fig. 7, the method further includes steps S701 to S70, as shown in fig. 7, wherein:
in step S701, an evaluation form of paper is recognized by an OCR technique. In step S702, the evaluation table is analyzed line by line, and the special characters in the cells are extracted. In step S703, a matched gauge control is obtained according to the extracted special character; each special character can correspond to a scale control, and a plurality of different special characters can correspond to the same scale control; according to the actual situation, the corresponding relation between the special characters and the gauge control can be preset and defined, for example, a square frame corresponds to a button control; the scale control can be customized according to the type of the required test question, for example, a user-defined option control is used for realizing the selection of a plurality of options in the test question, so that the customized scale control can be associated with the special characters to determine the corresponding relation. Taking the table in fig. 2 as an example, for the first row, it may be recognized that the first row includes four columns, where if no special character is included in the first column, the data in the first column is a first text, and the data in the other three columns includes a special character "□", so that it may be determined that the topic type corresponding to the row of data may be a "single-choice topic", and characters except the special character in the column data including the special character are used as second texts, three second texts may be obtained, and the first text and the second text are introduced into a table control corresponding to the "single-choice topic", so as to generate a template corresponding to the row of data, as shown in fig. 8. In step S704, combining the scale controls to generate a scale template; the sequence of the combination of the gauge controls is the same as the arrangement sequence of the rows in the original evaluation table, so that the gauge controls corresponding to each row can be identified through the row sequence numbers, and the gauge controls can be combined through the row sequence numbers. It should be noted that, each step in fig. 7 has been described in the foregoing embodiment, and therefore, the description is omitted here.
In the data acquisition device provided by the embodiment, when the template is manufactured, the complex test questions do not need to be manually input by manpower, so that the efficiency can be greatly improved, the time can be saved, and the labor cost can be saved; meanwhile, the error probability during manual entry of test questions can be reduced, and the correctness of data is improved.
Further, in the present exemplary embodiment, a data acquisition apparatus is also provided, which is configured to execute the data acquisition method of the present disclosure. The device can be applied to a server or terminal equipment.
Referring to fig. 9, the data acquisition apparatus 900 may include: a data extraction module 910, a type determination module 920, and a template acquisition module 930, wherein:
a data extracting module 910, configured to extract row data in the original evaluation table, where the row data includes column data.
The type determining module 920 is configured to determine a data type of the column data, and determine a gauge control corresponding to the row of data according to the data type of the column data.
The template obtaining module 930 is configured to determine, based on the gauge control corresponding to the line data, a gauge template corresponding to the original evaluation table, so as to perform data acquisition through the gauge template.
In an exemplary embodiment of the present disclosure, the type determining module 920 may include a first type judging unit and a second type judging unit, wherein:
the first type judging unit is used for analyzing whether the line data contains special characters or not, and if the line data does not contain the special characters, the data type of the line data is determined to be a first preset type.
And the second type judging unit is used for determining the data type of the line data as a second preset type if the line data contains special characters.
In an exemplary embodiment of the present disclosure, the type determining module 920 may include a title determining unit and a control obtaining unit, wherein:
and the title determining unit is used for determining the title type of the row of data according to the special characters contained in the column data of the second preset type.
And the control acquiring unit is used for acquiring the gauge control corresponding to the title type.
In an exemplary embodiment of the present disclosure, the template obtaining module 930 may include a first text determining unit, a second text determining unit, and a combining unit, wherein:
and the first text determining unit is used for determining the first text as a title by taking the first preset type of column data as the first text.
And the second text determining unit is used for acquiring a second text except the special characters in the second preset type of line data and determining the second text as a question stem.
And the combination unit is used for combining the question and the question stem by using the scale control so as to generate a scale template corresponding to the original evaluation table.
In an exemplary embodiment of the present disclosure, the template obtaining module 930 may include a row determining unit and a control combining unit, wherein:
and the line determining unit is used for determining the gauge control corresponding to each line of data contained in the original evaluation table.
And the control combination unit is used for combining the gauge controls according to the line sequence number of the row of data to obtain the gauge template.
In an exemplary embodiment of the present disclosure, the template obtaining module 930 may include a data collecting unit, configured to send the scale template to each client to receive evaluation data of each client.
In an exemplary embodiment of the disclosure, the data extraction module 910 may be configured to perform character recognition on the image of the original evaluation table to obtain each line of data in the original evaluation table.
For details that are not disclosed in the embodiments of the apparatus of the present disclosure, please refer to the embodiments of the data acquisition method of the present disclosure for the details that are not disclosed in the embodiments of the apparatus of the present disclosure.
Referring to fig. 10, fig. 10 is a schematic diagram illustrating a system architecture of an exemplary application environment to which a data acquisition method and a data acquisition apparatus according to an embodiment of the present disclosure may be applied.
As shown in fig. 10, the system architecture 1000 may include one or more of terminal devices 1001, 1002, 1003, a network 1004, and a server 1005. The network 1004 is used to provide a medium for communication links between the terminal devices 1001, 1002, 1003 and the server 1005. Network 1004 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.
The terminal devices 1001, 1002, 1003 may be various electronic devices having a display screen, including but not limited to desktop computers, portable computers, smart phones, tablet computers, and the like. It should be understood that the number of terminal devices, networks, and servers in fig. 10 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation. For example, the server 1005 may be a server cluster composed of a plurality of servers.
The data acquisition method provided by the embodiment of the present disclosure is generally executed by the server 1005, and accordingly, the data acquisition apparatus is generally disposed in the server 1005. However, it is easily understood by those skilled in the art that the data collection method provided in the embodiment of the present disclosure may also be executed by the terminal devices 1001, 1002, and 1003, and accordingly, the data collection device may also be disposed in the terminal devices 1001, 1002, and 1003, which is not particularly limited in this exemplary embodiment.
For example, in an exemplary embodiment, the server 1005 may receive the data acquisition requirement, extract row data in the original evaluation table according to the image of the original evaluation table, and determine a table control corresponding to the row data according to column data included in each row data, thereby generating a table template corresponding to the original evaluation table.
FIG. 11 illustrates a schematic structural diagram of a computer system suitable for use in implementing an electronic device of an embodiment of the present disclosure.
It should be noted that the computer system 1100 of the electronic device shown in fig. 11 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.
As shown in fig. 11, the computer system 1100 includes a Central Processing Unit (CPU)1101, which can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)1102 or a program loaded from a storage section 1108 into a Random Access Memory (RAM) 1103. In the RAM 1103, various programs and data necessary for system operation are also stored. The CPU 1101, ROM 1102, and RAM 1103 are connected to each other by a bus 1104. An input/output (I/O) interface 1105 is also connected to bus 1104.
The following components are connected to the I/O interface 1105: an input portion 1106 including a keyboard, mouse, and the like; an output portion 1107 including a signal output unit such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and a speaker; a storage section 1108 including a hard disk and the like; and a communication section 1109 including a network interface card such as a LAN card, a modem, or the like. The communication section 1109 performs communication processing via a network such as the internet. A driver 1110 is also connected to the I/O interface 1105 as necessary. A removable medium 1111 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 1110 as necessary, so that a computer program read out therefrom is mounted into the storage section 1108 as necessary.
In particular, the processes described below with reference to the flowcharts may be implemented as computer software programs, according to embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication portion 1109 and/or installed from the removable medium 1111. The computer program, when executed by a Central Processing Unit (CPU)1101, performs various functions defined in the methods and apparatus of the present application.
It should be noted that the computer readable media shown in the present disclosure may be computer readable signal media or computer readable storage media or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In contrast, in the present disclosure, a computer-readable signal medium may include a propagated data signal with computer-readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software, or may be implemented by hardware, and the described units may also be disposed in a processor. Wherein the names of the elements do not in some way constitute a limitation on the elements themselves.
As another aspect, the present application also provides a computer-readable medium, which may be contained in the electronic device described in the above embodiments; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs which, when executed by an electronic device, cause the electronic device to implement the method as described in the embodiments below. For example, the electronic device may implement the steps shown in fig. 1 and 2, and so on.
It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the present disclosure. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
It will be understood that the present disclosure is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims (10)

1. A method of data acquisition, comprising:
extracting row data in an original evaluation table, wherein the row data comprises column data;
determining the data type of the line data, and determining a gauge control corresponding to the row of data according to the data type of the line data;
and determining a gauge template corresponding to the original evaluation table based on the gauge control corresponding to the row of data so as to acquire data through the gauge template.
2. The method of claim 1, wherein the determining the data type of the column data comprises:
analyzing whether the line data contains special characters or not, and if the line data does not contain the special characters, determining the data type of the line data as a first preset type;
and if the line data contains special characters, determining the data type of the line data as a second preset type.
3. The method of claim 2, wherein the determining the gauge control corresponding to the row of data according to the data type of the column of data comprises:
determining the question type of the row of data according to special characters contained in the column data of the second preset type;
and acquiring a scale control corresponding to the title type.
4. The method of claim 2, wherein determining the gauge template corresponding to the original assessment table based on the gauge control corresponding to the row of data comprises:
taking the column data of the first preset type as a first text, and determining the first text as a title;
acquiring a second text except the special characters in the second preset type of line data, and determining the second text as a question stem;
and combining the question and the question stem by using the scale control to generate a scale template corresponding to the original evaluation table.
5. The method of claim 1, wherein determining the gauge template corresponding to the original assessment table based on the gauge control corresponding to the row of data comprises:
determining a gauge control corresponding to each row of data contained in the original evaluation gauge;
and combining the gauge controls according to the line sequence number of the line data to obtain the gauge template.
6. The method of claim 1, wherein the collecting data via the scale template comprises:
and sending the scale template to each client to receive the evaluation data of each client.
7. The method of claim 1, wherein extracting row data in the original evaluation table comprises:
and performing character recognition on the image of the original evaluation table to acquire each line of data in the original evaluation table.
8. A data acquisition device, comprising:
the data extraction module is used for extracting row data in an original evaluation table, wherein the row data comprises column data;
the type determining module is used for determining the data type of the column data and determining the gauge control corresponding to the row of data according to the data type of the column data;
and the template acquisition module is used for determining the gauge template corresponding to the original evaluation table based on the gauge control corresponding to the row of data so as to acquire data through the gauge template.
9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the method of any one of claims 1 to 7.
10. An electronic device, comprising:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the method of any of claims 1-7 via execution of the executable instructions.
CN201911072146.6A 2019-11-05 2019-11-05 Data acquisition method and device, computer readable storage medium and electronic equipment Active CN110826306B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911072146.6A CN110826306B (en) 2019-11-05 2019-11-05 Data acquisition method and device, computer readable storage medium and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911072146.6A CN110826306B (en) 2019-11-05 2019-11-05 Data acquisition method and device, computer readable storage medium and electronic equipment

Publications (2)

Publication Number Publication Date
CN110826306A true CN110826306A (en) 2020-02-21
CN110826306B CN110826306B (en) 2023-04-07

Family

ID=69552569

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911072146.6A Active CN110826306B (en) 2019-11-05 2019-11-05 Data acquisition method and device, computer readable storage medium and electronic equipment

Country Status (1)

Country Link
CN (1) CN110826306B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111916165A (en) * 2020-08-18 2020-11-10 泰康保险集团股份有限公司 Similarity evaluation method and device for evaluation scale
CN113033528A (en) * 2021-05-27 2021-06-25 明品云(北京)数据科技有限公司 Feedback scale evaluation method, system, device and medium

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2000242627A (en) * 1999-02-22 2000-09-08 Dainippon Printing Co Ltd Questionnaire information perusal system
CN101661512A (en) * 2009-09-25 2010-03-03 万斌 System and method for identifying traditional form information and establishing corresponding Web form
CN102662942A (en) * 2010-12-24 2012-09-12 通用电气公司 Metadata generation systems and methods
CN103440264A (en) * 2013-08-01 2013-12-11 广东电网公司 Method and system for implementing electric power field operation form
JP2015187846A (en) * 2014-03-12 2015-10-29 株式会社リコー Document processing system and document processor
CN106575360A (en) * 2014-08-21 2017-04-19 微软技术许可有限责任公司 Enhanced recognition of charted data
CN107578659A (en) * 2017-09-27 2018-01-12 广东小天才科技有限公司 Generation method, generating means and the terminal of electronics topic
CN109902670A (en) * 2017-12-08 2019-06-18 亿度慧达教育科技(北京)有限公司 Data entry method and system

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2000242627A (en) * 1999-02-22 2000-09-08 Dainippon Printing Co Ltd Questionnaire information perusal system
CN101661512A (en) * 2009-09-25 2010-03-03 万斌 System and method for identifying traditional form information and establishing corresponding Web form
CN102662942A (en) * 2010-12-24 2012-09-12 通用电气公司 Metadata generation systems and methods
CN103440264A (en) * 2013-08-01 2013-12-11 广东电网公司 Method and system for implementing electric power field operation form
JP2015187846A (en) * 2014-03-12 2015-10-29 株式会社リコー Document processing system and document processor
CN106575360A (en) * 2014-08-21 2017-04-19 微软技术许可有限责任公司 Enhanced recognition of charted data
CN107578659A (en) * 2017-09-27 2018-01-12 广东小天才科技有限公司 Generation method, generating means and the terminal of electronics topic
CN109902670A (en) * 2017-12-08 2019-06-18 亿度慧达教育科技(北京)有限公司 Data entry method and system

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111916165A (en) * 2020-08-18 2020-11-10 泰康保险集团股份有限公司 Similarity evaluation method and device for evaluation scale
CN113033528A (en) * 2021-05-27 2021-06-25 明品云(北京)数据科技有限公司 Feedback scale evaluation method, system, device and medium

Also Published As

Publication number Publication date
CN110826306B (en) 2023-04-07

Similar Documents

Publication Publication Date Title
CN105260782A (en) Method and device for processing reserved registration information
CN111369290B (en) Method and system for automatically generating data acquisition module
CN110826306B (en) Data acquisition method and device, computer readable storage medium and electronic equipment
CN104993962A (en) Method and system for obtaining use state of terminal
CN109840192B (en) Method and device for automatic testing
CN105225563A (en) A kind of learning data recommend method, device and Wearable facility for study
CN109472007B (en) Automatic question creating method and device for medical questionnaire, electronic equipment and storage medium
CN110659817A (en) Data processing method and device, machine readable medium and equipment
CN110647523B (en) Data quality analysis method and device, storage medium and electronic equipment
CN113342692B (en) Automatic test case generation method and device, electronic equipment and storage medium
CN115358203A (en) Test report method, test report device, electronic equipment and storage medium
CN110990527A (en) Automatic question answering method and device, storage medium and electronic equipment
CA3147341A1 (en) Category phrase recognition method, model training method, device and system
US11675756B2 (en) Data complementing system and data complementing method
CN115686280A (en) Deep learning model management system, method, computer device and storage medium
CN112241417B (en) Page data verification method and device, medium and electronic equipment
CN111581937A (en) Document generation method and device, computer readable medium and electronic equipment
CN110689285A (en) Test method, test device, electronic equipment and computer readable storage medium
CN112598202B (en) Test question difficulty evaluation method and device, storage medium and computing equipment
US20220300836A1 (en) Machine Learning Techniques for Generating Visualization Recommendations
CN108198106A (en) Job issuing method, equipment and computer readable storage medium
CN113569741A (en) Answer generation method and device for image test questions, electronic equipment and readable medium
CN112527278A (en) Smart form generating and issuing method, device, terminal and storage medium
TWI736250B (en) Data labeling system and data labeling method
CN109522210A (en) Interface testing parameters analysis method, device, electronic device 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