A data processing method and device, electronic equipment and storage medium

Abstract

The application discloses a data processing method and device, electronic equipment and storage medium. The method comprises the following steps: in response to an analysis and test report processing event of an oil and gas exploration well being triggered, opening an analysis and test report table file of the oil and gas exploration well; when a triggering operation of a user on a data extraction button in the analysis and test report table file is detected, a data extraction window is displayed in the analysis and test report table file; wherein the data extraction window comprises at least one in-place editing block control, and each in-place editing block control represents different cell data; a target control selected by the user is determined from the at least one in-place editing block control, and an interactive interface comprising cell data corresponding to the target control is displayed; and according to a cell data point selection operation of the user on the interactive interface, an analysis and test summary table is generated. According to the scheme, only a simple point selection operation is required to complete the extraction of complex oil and gas exploration analysis and test data, and the analysis and test summary table is generated.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of oil and gas exploration data processing, and particularly relates to a data processing method and device, electronic equipment and a storage medium. BACKGROUND

[0002] In the field of oil and gas exploration, with the increase in the number of exploration wells, the analysis and test data (such as thin section identification data, heavy mineral data, mercury injection data, powder particle size, pore characteristics, mercury injection, thin section particle size data, etc.) also increases exponentially. The massive analysis and test data brings new discoveries to exploration engineers, but also greatly increases the effort consumed in sorting data.

[0003] Since each type of analysis and test data is entrusted to different laboratories for detection, it results in not only a large number of analysis and test types, but also inconsistent formats of the same analysis and test: some are Word documents; some are Excel tables; some store multiple samples in the same file; some samples are composed of multiple files, each sample occupies a Sheet, and each Sheet exists in a separate file; some samples are composed of multiple files, but multiple samples occupy multiple Sheets and are stored in multiple files. Based on the above reasons, the number of original reports of analysis and test data is extremely large, the formats are various, and the difficulty of sorting and summarizing data also increases explosively.

[0004] First-hand information without screening, classification, editing and other operations is often the most comprehensive and accurate information. The development of exploration work is often accompanied by the summary of original report data of analysis and test data. At present, manual copying of data is low in efficiency, which occupies a large amount of working time for processing of original report data of analysis and test data. Even if the formula method of Excel is used, it is also necessary to customize the formula for each different format of analysis and test, and the spacing between reports must be completely consistent to extract in batches. The learning cost of this data summarizing method through Excel formula is relatively high, and it is difficult to promote. SUMMARY

[0005] The present application provides a data processing method, device, electronic equipment and storage medium, which does not require users to learn formulas, programming and other complex operations, and only needs simple point selection operation to complete the extraction work of complex oil and gas exploration analysis and test data, and generate analysis and test summary table.

[0006] According to an aspect of the present application, a data processing method is provided, comprising:

[0007] In response to an analysis and test report processing event of an oil and gas exploration well being triggered, opening an analysis and test report table file of the oil and gas exploration well;

[0008] When a triggering operation of a data extraction button in the analysis test report form file is detected, a data extraction window is displayed in the analysis test report form file; wherein the data extraction window comprises at least one in-situ editing block control, and each in-situ editing block control represents different cell data.

[0009] A target control is determined from the at least one in-situ editing block control according to a user selection, and an interactive interface containing cell data corresponding to the target control is displayed.

[0010] According to a cell data point selection operation of the user in the interactive interface, an analysis test summary table is generated.

[0011] According to another aspect of the present application, a data processing apparatus is provided, comprising:

[0012] A report form file opening module is configured to open an analysis test report form file of a hydrocarbon exploration well in response to an analysis test report processing event of the hydrocarbon exploration well being triggered.

[0013] A data extraction window display module is configured to display a data extraction window in the analysis test report form file when a triggering operation of a data extraction button in the analysis test report form file is detected; wherein the data extraction window comprises at least one in-situ editing block control, and each in-situ editing block control represents different cell data.

[0014] An interactive interface display module is configured to determine a target control from the at least one in-situ editing block control according to a user selection, and display an interactive interface containing cell data corresponding to the target control.

[0015] An analysis test summary table generation module is configured to generate an analysis test summary table according to a cell data point selection operation of the user in the interactive interface.

[0016] According to another aspect of the present application, an electronic device is provided, comprising:

[0017] At least one processor; and

[0018] A memory in communication connection with the at least one processor; wherein,

[0019] The memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor to enable the at least one processor to execute the data processing method according to any one of the embodiments of the present application.

[0020] According to another aspect of the present application, there is provided a computer readable storage medium storing computer instructions for causing a processor to implement the data processing method according to any of the embodiments of the present application when executed.

[0021] The data processing scheme of the embodiment of the present application opens the analysis and testing report table file of the oil and gas exploration well in response to the analysis and testing report processing event of the oil and gas exploration well being triggered; when it is detected that the user triggers the data extraction button in the analysis and testing report table file, a data extraction window is displayed in the analysis and testing report table file; wherein the data extraction window contains at least one in-place editing block control, and each in-place editing block control represents different cell data; the target control selected by the user is determined from the at least one in-place editing block control, and an interactive interface containing the cell data corresponding to the target control is displayed; and according to the cell data point selection operation of the user in the interactive interface, an analysis and testing summary table is generated. Through the technical scheme provided by the embodiment of the present application, the user does not need to learn complex operations such as formulas and programming, and only needs to perform simple point selection operation to complete the extraction of complex oil and gas exploration analysis and testing data, generate an analysis and testing summary table, and facilitate researchers to perform big data analysis, machine learning and other operations.

[0022] It should be understood that the content described in this part is not intended to identify the key or important features of the embodiments of the present application, nor is it used to limit the scope of the present application. Other features of the present application will become apparent from the following description. BRIEF DESCRIPTION OF DRAWINGS

[0023] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the following will briefly introduce the drawings needed to be used in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can also be obtained by those skilled in the art without creative labor.

[0024] Figure 1 A flowchart of a data processing method provided for the first embodiment of the present application;

[0025] Figure 2 A schematic diagram of a Word file merging button in a Word type test report file provided for the embodiment of the present application;

[0026] Figure 3 A schematic diagram of a table file merging button in an Excel type test report file provided for the embodiment of the present application;

[0027] Figure 4A schematic view of a data extraction button in an analysis test report form provided by the embodiment of the present application is shown in the figure;

[0028] Figure 5 A schematic view of a data extraction window provided by the embodiment of the present application is shown in the figure;

[0029] Figure 6 A schematic view of an interactive interface provided by the embodiment of the present application is shown in the figure;

[0030] Figure 7 A schematic view of a display of an analysis test summary table provided by the embodiment of the present application is shown in the figure;

[0031] Figure 8 A schematic view of a data processing device provided by the second embodiment of the present application is shown in the figure;

[0032] Figure 9 A schematic view of an electronic device for implementing the data processing method of the embodiment of the present application is shown in the figure. DETAILED DESCRIPTION

[0033] In order to make the person skilled in the art better understand the present application, the technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, but not all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by the person skilled in the art without creative labor should belong to the protection scope of the present application.

[0034] It should be noted that the terms "first", "second" and the like in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and do not necessarily indicate a specific order or a chronological sequence. It should be understood that the data thus used can be interchanged under appropriate circumstances, so that the embodiments of the present application described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device including a series of steps or units does not necessarily have to be limited to those steps or units clearly listed, but can include other steps or units not clearly listed or inherent to the process, method, product or device.

[0035] Embodiment one

[0036] Figure 1A flowchart of a data processing method is provided for the first embodiment of the present application. The embodiment can be applied to processing of oil and gas exploration analysis and testing data. The method can be executed by a data processing device, which can be implemented in the form of hardware and / or software, and can be configured in an electronic device. As shown in FIG. 8, the method comprises the following steps. Figure 1

[0037] In response to an analysis and testing report processing event of an oil and gas exploration well being triggered, an analysis and testing report table file of the oil and gas exploration well is opened.

[0038] In the embodiment of the present application, when a user inputs an analysis and testing report processing instruction of an oil and gas exploration well, it is determined that an analysis and testing report processing event of the oil and gas exploration well is triggered. For example, when a user inputs an analysis and testing report table file opening instruction of an oil and gas exploration well, an analysis and testing report table file of the oil and gas exploration well is opened. The analysis and testing report table file is an Excel table file generated by summarizing at least one testing report file corresponding to analysis and testing data of the oil and gas exploration well.

[0039] Optionally, before opening the analysis and testing report table file of the oil and gas exploration well in response to the analysis and testing report processing event of the oil and gas exploration well being triggered, the method further comprises the following steps: obtaining at least one testing report file corresponding to analysis and testing data of the oil and gas exploration well, and determining a file type of each testing report file; wherein the file type comprises a Word file and an Excel file; and generating the analysis and testing report table file of the oil and gas exploration well according to the file type and the at least one testing report file. In this way, the analysis and testing reports corresponding to various analysis and testing data of the oil and gas exploration well can be merged to generate a summary table file, which is convenient for archiving and file searching.

[0040] In the embodiment of the present application, various analysis and testing data of an oil and gas exploration well is obtained, and a testing report file corresponding to the analysis and testing data is obtained. The testing report file is a report file obtained by entrusting analysis and testing data to different laboratories for detection. The analysis and testing data comprises thin section identification data, heavy mineral data, mercury injection data, powder particle size, pore characteristics, mercury injection, and thin section particle size data. The file type of each testing report file is determined, wherein the file type of the testing report file is the storage type of the testing report file, and the file type comprises a Word file and an Excel file. The processing mode of the at least one testing report file is determined according to the file type of the testing report file, and the at least one testing report file is merged based on the processing mode to generate an analysis and testing report table file of the oil and gas exploration well, wherein the analysis and testing report table file is an Excel table file. ​

[0041] Optionally, generating the analysis report table file for the oil and gas exploration well based on the file type and the at least one test report file includes: displaying a Word file selection dialog box when a user triggers the Word file merge button; determining the target Word test report file selected by the user in the Word file selection dialog box, merging the target Word test report files to generate a summary Word file; converting the summary Word file into a first Excel spreadsheet file, and using the first Excel spreadsheet file as the analysis report table file for the oil and gas exploration well. For example, if at least one test report file contains a Word file, any Word type test report file can be opened according to the user's open instruction. The test report file's add-in includes a Word file merge button, and if a user triggers the Word file merge button, a Word file selection dialog box is displayed. For example, Figure 2 This is a schematic diagram of a Word file merge button in a Word-type laboratory report file, provided as an embodiment of the present invention. Figure 2 The "Merge Word Files - CNOOC" button refers to the Word file merging button. If the user clicks it... Figure 2 The "Merge Word Files - CNOOC" button can detect user interaction with the Word file merging button. This button can open a Word file selection dialog box via the FileDialog property of the Application object in VBA, with the parameter msoFileDialogFilePicker. This dialog box contains dialog boxes for all Word type test report files, allowing the user to select the Word type test report files to be merged. The selected target Word test report files are identified in the dialog box, and they are concatenated to generate a summary Word file. The summary Word file is then converted into an Excel spreadsheet file. For ease of description, the Excel spreadsheet file generated from the summary Word file is referred to as the first Excel spreadsheet file, and this first Excel spreadsheet file will be used as the analysis and test report spreadsheet file for oil and gas exploration wells.

[0042] Optionally, if the target Word test report file contains a large number of pictures, text boxes and other objects, it will cause the merging and summarizing of the target Word test report file to take a long time to convert into the first Excel table file. Therefore, before merging the target Word test report file, the target Word test report file can be backed up and the pictures and text boxes and other objects in the target Word test report file can be appropriately compressed or deleted. For example, the pictures and text boxes and other objects in the target Word test report file can be deleted by clicking the button of "Delete all pictures and text boxes in this Word - CNOOC" in the target Word test report file. Figure 2 The button of "Delete all pictures and text boxes in this Word - CNOOC" is used to delete the pictures and text boxes and other objects in the target Word test report file. The function of the button is to batch select InlineShape and Shape objects and delete them.

[0043] Optionally, according to the file type and the at least one test report file, the analysis test report table file of the oil and gas exploration well is generated, which includes: when detecting the triggering operation of the user on the table file merging button, a table file selection dialog box is displayed; the target table test report file selected by the user in the table file selection dialog box is determined, and the target table test report file is merged to generate a summary table file; all Sheet tables in the summary table file are merged into the same Sheet table to generate a second Excel table file, and the second Excel table file is used as the analysis test report table file of the oil and gas exploration well. For example, if the at least one test report file contains an Excel file, any one Excel type test report file can be opened according to the opening instruction of the user, wherein the test report file loading item contains a table file merging button, and if the triggering operation of the user on the table file merging button is detected, a table file selection dialog box is displayed. For example, the table file merging button in an Excel type test report file is shown in the figure. Figure 3 For example, the table file merging button in an Excel type test report file is shown in the figure. Figure 3 The "Merge table file - CNOOC" button is a table file merging button. If the user clicks the "Merge table file - CNOOC" button, a table file selection dialog box is displayed. Figure 3The "Merge Spreadsheet Files - CNOOC" button can detect user interaction with the merging function. This button opens a spreadsheet file selection dialog box via the FileDialog property of the Application object in VBA, with the parameter msoFileDialogFilePicker. This dialog box contains dialog boxes for all types of test report files, allowing the user to select the types of test report files to be merged. The system then selects the target spreadsheet test report files and merges them, meaning it combines every sheet from all selected target spreadsheet test report files into a single summary Excel document, generating a summary spreadsheet file. The number of sheets in the summary spreadsheet file is the sum of the number of sheets in all the target spreadsheet test report files. When user interaction with the merging function is detected... Figure 3 When the "Merge Current File Sheet - CNOOC" button is triggered, it iterates through all the Sheet tables in the summary table file, concatenates the data from all Sheet tables, merges them into a single Sheet table, and generates a second Excel spreadsheet file. This second Excel spreadsheet file is then used as the analysis and testing report file for oil and gas exploration wells.

[0044] S120. When a user triggers the data extraction button in the analysis and testing report table file, a data extraction window is displayed in the analysis and testing report table file; wherein, the data extraction window contains at least one in-place edit block control, and each in-place edit block control represents different cell data.

[0045] In this embodiment of the invention, after opening the analysis and testing report form file of the oil and gas exploration well, the data loading items in the analysis and testing report form file include a data extraction button. For example, Figure 4 This is a schematic diagram of a data extraction button in an analytical laboratory report form file, provided as an embodiment of the present invention. Figure 4 The "Data Extraction - CNOOC" button is a data extraction button; if the user clicks it... Figure 4 The "Data Extraction - CNOOC" button in the analysis report table can detect user interaction with the data extraction button, at which point a data extraction window will be displayed in the analysis report table. This data extraction window contains at least one in-place edit block control, each representing different cell data. For example, Figure 5 This is a schematic diagram of a data extraction window provided in an embodiment of the present invention. Figure 5As shown, the data extraction window contains a plurality of RefEdit controls for data interaction, which can pass the selected cells to the background, so that the background can intelligently analyze the overall structure of the table according to the content, and each RefEdit control has a brief text box above it, which is used to prompt the user to select the required cells for each RefEdit control, that is, each RefEdit control represents different cell data, such as the Report Title cell, the Well Name cell, the Depth cell, and the Custom cell, etc. Figure 5 As shown, the data extraction window can also include a brief operation prompt part, which is convenient for first-time users to understand the use method of the data extraction window; in addition, the data extraction window can also include a "select complete" button, which can intelligently extract and summarize data after the user clicks the "select complete" button.

[0046] S130, determining the target control selected by the user from the at least one in-place editing block control, and displaying an interaction interface containing cell data corresponding to the target control.

[0047] In the embodiment of the present application, the data extraction window contains at least one in-place editing block control, and the user can randomly select any one or more in-place editing block controls from all the in-place editing block controls in the data extraction window. Figure 5 As shown, the data extraction window contains at least one in-place editing block control, and the user can randomly select any one or more in-place editing block controls from all the in-place editing block controls in the data extraction window. Figure 5 As shown, the data extraction window contains at least one in-place editing block control, and the user can randomly select any one or more in-place editing block controls from all the in-place editing block controls in the data extraction window. Figure 6 An interaction interface provided in the embodiment of the present application is shown in the figure.

[0048] S140, generating an analysis and test summary table according to the point selection operation of the user on the cell data in the interaction interface.

[0049] In the embodiment of the present application, the user can point and click any one or more cells in the interactive interface, and generate an analysis and test summary table according to the cell data selected by the user in the interactive interface. It can be understood that the report title, well name, depth, custom data 1, custom data 2 and other cell data are sequentially transmitted into the interactive interface through the user interaction with the RefEdit control. After the user clicks the "select complete" button in the data extraction window, the background recognizes the information and intelligently judges the table structure. At this time, a new Sheet table is automatically created. In the new Sheet table, each row contains test point data of a plurality of indexes, and each column is the same index data of a plurality of test points arranged in order. Such row and column combination is the analysis and test summary table. Exemplarily, Figure 7 A display schematic diagram of an analysis and test summary table provided by the embodiment of the present application.

[0050] Optionally, the analysis and test summary table is generated according to the point and click operation of the user on the cell data in the interactive interface, including: determining at least one keyword corresponding to the target cell data selected by the user in the interactive interface; extracting the target data corresponding to the at least one keyword, and generating the analysis and test summary table based on the target data. Exemplarily, at least one keyword corresponding to the target cell data selected by the user in the interactive interface is determined, wherein the keyword is generally a title. The target data corresponding to the keyword is extracted by traversing at least one keyword in the interactive interface, and all the extracted target data are summarized into an Excel table to generate the analysis and test summary table.

[0051] Optionally, the target data corresponding to the at least one keyword is extracted, including: traversing the at least one keyword, determining the keyword cell position corresponding to the keyword, and extracting the target data corresponding to the keyword at the keyword cell position. Optionally, before traversing the at least one keyword to determine the keyword cell position corresponding to the keyword, it further includes: determining the title corresponding to the target cell data, and determining the title cell position corresponding to the title; traversing the at least one keyword to determine the keyword cell position corresponding to the keyword includes: traversing the at least one keyword to determine the relative positional relationship between the keyword and the title; determining the keyword cell position corresponding to the keyword according to the relative positional relationship and the title cell position.

[0052] It can be understood that the relative positions of the target cell data selected by the user in the interactive interface are determined, and the analysis and test format framework is intelligently judged to determine the key information such as "index content", "cell position", "relative distance from the title" and the like. Exemplarily, Table 1 is a key information table provided by the embodiment of the present application:

[0053] Table 1 Key Information Table

[0054]

[0055] Traverse the entire sheet to search for keywords, usually the title, and determine the keyword cell position after each traversal of the keyword, and extract the target data corresponding to the keyword according to the keyword cell position. The example. Determine the title corresponding to the target cell data selected by the user, and determine the title cell position corresponding to the title, traverse each keyword, determine the relative position relationship between the keyword and the title, and determine the keyword cell position corresponding to the keyword according to the relative position relationship and the title cell position. For example, the title position is A18, the depth value is Q19, and the relative distance is (16, 1). When traversing the keyword, if the next keyword (title) position is A52, combine the relative distance (16, 1) in Table 1, which means that the depth value needs to be moved 1 column to the right and 16 rows down. The calculated depth value cell is Q53. Then store the Q53 cell content in the summary table, which completes the summary of one indicator of a report. Repeat until all selected indicators in all reports are summarized.

[0056] The data processing method of the embodiment of the present application responds to the analysis and test report processing event of the oil and gas exploration well being triggered, opens the analysis and test report table file of the oil and gas exploration well; when detecting that the user triggers the data extraction button in the analysis and test report table file, a data extraction window is displayed in the analysis and test report table file; wherein the data extraction window contains at least one in-place editing block control, and each in-place editing block control represents different cell data; determine the target control selected by the user from the at least one in-place editing block control, and display an interactive interface containing the cell data corresponding to the target control; according to the user's single-click operation on the cell data in the interactive interface, generate an analysis and test summary table. Through the technical scheme provided by the embodiment of the present application, the user does not need to learn complex operations such as formulas and programming, and only needs to perform simple single-click operations to complete the extraction of complex oil and gas exploration analysis and test data, generate an analysis and test summary table, and facilitate scientific researchers to perform big data analysis, machine learning and other operations.

[0057] Embodiment two

[0058] Figure 8 A structural schematic diagram of a data processing device provided by the second embodiment of the present application is shown in FIG. 2. As shown in the figure, the device comprises: Figure 8

[0059] ​The report form file opening module 810 is configured to open the analysis test report form file of the oil and gas exploration well in response to the analysis test report processing event of the oil and gas exploration well being triggered.

[0060] The data extraction window display module 820 is configured to display a data extraction window in the analysis test report form file when it is detected that the user triggers the data extraction button in the analysis test report form file.

[0061] The interactive interface display module 830 is configured to determine a target control selected by the user from the at least one in-situ editing block control, and display an interactive interface containing the cell data corresponding to the target control.

[0062] The analysis test summary table generation module 840 is configured to generate an analysis test summary table according to the cell data point selection operation of the user in the interactive interface.

[0063] Optionally, the device further comprises:

[0064] The file type determination module is configured to, before opening the analysis test report form file of the oil and gas exploration well in response to the analysis test report processing event of the oil and gas exploration well being triggered, acquire at least one test report file corresponding to the analysis test data of the oil and gas exploration well, and determine the file type of each test report file. The file type includes a Word file and an Excel file.

[0065] The analysis test report form file generation module is configured to generate the analysis test report form file of the oil and gas exploration well according to the file type and the at least one test report file.

[0066] Optionally, the analysis test report form file generation module is configured to:

[0067] When it is detected that the user triggers the Word file merging button, a Word file selection dialog box is displayed.

[0068] The target Word test report file selected by the user in the Word file selection dialog box is determined, and the target Word test report file is merged to generate a summary Word file.

[0069] The summary Word file is converted into a first Excel form file, and the first Excel form file is taken as the analysis test report form file of the oil and gas exploration well.

[0070] Optionally, the analysis test report form file generation module is configured to:

[0071] When a triggering operation of a table file merging button by a user is detected, a table file selection dialog box is displayed;

[0072] A target tabular test report file selected by the user in the table file selection dialog box is determined, and the target tabular test report file is merged to generate a summary table file;

[0073] All Sheet tables in the summary table file are merged into a same Sheet table to generate a second Excel table file, and the second Excel table file is taken as an analysis test report table file of the oil and gas exploration well.

[0074] Optionally, the analysis test summary table generation module comprises:

[0075] A keyword determination unit is configured to determine at least one keyword corresponding to target cell data selected by the user in the interactive interface;

[0076] An analysis test summary table generation unit is configured to extract target data corresponding to the at least one keyword based on the at least one keyword, and generate an analysis test summary table based on the target data.

[0077] Optionally, the analysis test summary table generation unit comprises:

[0078] An analysis test summary table generation subunit is configured to traverse the at least one keyword, determine a keyword cell position corresponding to the keyword, and extract target data corresponding to the keyword at the keyword cell position.

[0079] Optionally, the method further comprises:

[0080] A title cell position module is configured to, before traversing the at least one keyword and determining a keyword cell position corresponding to the keyword, determine a title corresponding to the target cell data, and determine a title cell position corresponding to the title.

[0081] The analysis test summary table generation subunit is configured to:

[0082] Traverse the at least one keyword to determine a relative positional relationship between the keyword and the title;

[0083] Determine a keyword cell position corresponding to the keyword according to the relative positional relationship and the title cell position.

[0084] The data processing apparatus provided in the embodiments of the present application can execute the data processing method provided in any of the embodiments of the present application, and has the corresponding functional modules and beneficial effects of the execution method.

[0085] Example Three

[0086] Figure 9 A structural diagram of an electronic device 10 that can be used to implement embodiments of the present application is shown. The electronic device is intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. The electronic device can also represent various forms of mobile devices, such as personal digital processors, cellular telephones, smart phones, wearable devices (e.g., headsets, glasses, watches, etc.), and other similar computing devices. The components shown here, their connections and relationships, and their functions, are meant to be examples only, and are not meant to limit implementations of the present application described and / or claimed in this document.

[0087] As Figure 9 shown, the electronic device 10 includes at least one processor 11, and memory, such as read-only memory (ROM) 12, random access memory (RAM) 13, etc., that is communicatively coupled with the at least one processor 11, where the memory stores computer programs that are executable by the at least one processor 11, and the processor 11 can perform various appropriate actions and processes according to the computer programs stored in the read-only memory (ROM) 12 or loaded into the random access memory (RAM) 13 from the storage unit 18. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0088] Various components in the electronic device 10 are connected to the I / O interface 15, including an input unit 16, such as a keyboard, a mouse, etc., an output unit 17, such as various types of displays, a speaker, etc., a storage unit 18, such as a magnetic disk, an optical disk, etc., and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network, such as the Internet, and / or various telecommunication networks.

[0089] The processor 11 can be various general and / or special purpose processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various specialized artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 11 performs various methods and processes described above, such as a data processing method.

[0090] In some embodiments, the data processing method can be implemented as a computer program tangibly embodied in a computer readable storage medium, e.g., storage unit 18. In some embodiments, parts or all of the computer program can be loaded and / or installed onto electronic device 10 via, e.g., ROM 12 and / or communication unit 19. When the computer program is loaded onto RAM 13 and executed by processor 11, one or more steps of the data processing method described above can be performed. Alternatively, in other embodiments, processor 11 can be configured to perform the data processing method by way of other means, e.g., with the aid of firmware.

[0091] Various implementations of the systems and techniques described above can be realized in digital electronic circuitry, integrated circuitry, a field programmable gate array (FPGA), an application specific integrated circuit (ASIC), a system on a chip (SOC), a programmable logic device (PLD), a computer hardware, firmware, software, and / or combinations thereof. These various implementations can include implementation in one or more computer programs that are executable and / or interpretable on a programmable system including at least one programmable processor, which can be special or general purpose, coupled to receive data and instructions from, and to transmit data and instructions to, a storage system, at least one input device, and at least one output device.

[0092] Computer programs used to implement the methods of the present application can be written in any combination of one or more programming languages. These computer programs can be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the computer program, when executed by the processor of the machine, implements the functions / acts specified in the flowcharts and / or block diagrams. The computer program can be executed entirely on a machine, partially on a machine, partially on a machine as part of a standalone software package, or entirely on a remote machine or server.

[0093] In the context of the present application, a computer-readable storage medium can be a tangible medium that can contain or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. A computer-readable storage medium can include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium can be a machine-readable signal medium. More specific examples of a machine-readable storage medium will include one or more lines of a program of instructions in a transitory signal, 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.

[0094] To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user and a keyboard and a pointing device (e.g., a mouse or a trackball) by which the user can provide input to the electronic device. Other kinds of devices can be used to provide for interaction with a user as well; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form, including acoustic, speech, or tactile input.

[0095] The systems and techniques described here can be implemented in a computing system that includes a back end component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front end component (e.g., a user computer having a graphical user interface or a Web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such back end, middleware, or front end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0096] The computing system can include clients and servers. A client and server are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system, to solve the defects of large management difficulty and weak business scalability in traditional physical host and VPS service.

[0097] It should be understood that the various forms of flow shown above can be used to reorder, add or delete steps. For example, each step described in the present application can be executed in parallel, sequentially or in a different order, as long as the desired results of the technical solutions of the present application can be achieved, which is not limited herein.

[0098] The above detailed description does not constitute a limitation on the scope of protection of the present application. Those skilled in the art should understand that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modifications, equivalent replacements and improvements made within the spirit and principles of the present application shall be included in the scope of protection of the present application.

Claims

1. A data processing method, characterized by, The method comprises the following steps: In response to an analysis report processing event of an oil and gas exploration well being triggered, opening an analysis report table file of the oil and gas exploration well; When detecting a triggering operation of a data extraction button in the analysis report table file by a user, displaying a data extraction window in the analysis report table file; wherein the data extraction window comprises at least one in-place editing block control, and each in-place editing block control represents different cell data; Determining a target control selected by the user from the at least one in-place editing block control, and displaying an interactive interface comprising cell data corresponding to the target control; According to a cell data point selection operation in the interactive interface by the user, generating an analysis summary table; The method of generating an analysis summary table according to a cell data point selection operation in the interactive interface by the user comprises the following steps: Determining at least one keyword corresponding to the target cell data selected by the user in the interactive interface; Extracting target data corresponding to the at least one keyword based on the at least one keyword, and generating an analysis summary table based on the target data; The method of extracting target data corresponding to the at least one keyword based on the at least one keyword comprises the following steps: Traversing the at least one keyword, determining a keyword cell position corresponding to the keyword, and extracting target data corresponding to the keyword at the keyword cell position; Before traversing the at least one keyword, determining a keyword cell position corresponding to the keyword, the method further comprises the following steps: Determining a title corresponding to the target cell data, and determining a title cell position corresponding to the title; Traversing the at least one keyword, determining a keyword cell position corresponding to the keyword, comprises the following steps: Traversing the at least one keyword, determining a relative position relationship between the keyword and the title; According to the relative position relationship and the title cell position, determining a keyword cell position corresponding to the keyword.

2. The method of claim 1, wherein, Before opening an analysis report table file of an oil and gas exploration well in response to an analysis report processing event of the oil and gas exploration well being triggered, the method further comprises the following steps: Obtaining at least one analysis report file corresponding to analysis data of the oil and gas exploration well, and determining a file type of each analysis report file; wherein the file type comprises a Word file and an Excel file; According to the file type and the at least one analysis report file, generating the analysis report table file of the oil and gas exploration well.

3. The method of claim 2, wherein, According to the file type and the at least one analysis report file, generating the analysis report table file of the oil and gas exploration well comprises the following steps: When detecting a triggering operation of a Word file merging button by a user, displaying a Word file selection dialog box; Determining a target Word analysis report file selected by the user in the Word file selection dialog box, and merging the target Word analysis report file to generate a summary Word file; convert the summary Word file into a first Excel file, and take the first Excel file as the analysis and test report table file of the oil and gas exploration well.

4. The method of claim 2, wherein, According to the file type and the at least one test report file, generate the analysis and test report table file of the oil and gas exploration well, including: When detecting that a user triggers an operation on a table file merging button, a table file selection dialog box is displayed; Determine the target table test report file selected by the user in the table file selection dialog box, and merge the target table test report file to generate a summary table file; Merge all Sheet tables in the summary table file into a same Sheet table, generate a second Excel table file, and take the second Excel table file as the analysis and test report table file of the oil and gas exploration well.

5. A data processing apparatus, characterized by, Including: A report table file opening module is configured to open the analysis and test report table file of the oil and gas exploration well in response to an analysis and test report processing event of the oil and gas exploration well being triggered; A data extraction window display module is configured to display a data extraction window in the analysis and test report table file when detecting that a user triggers an operation on a data extraction button in the analysis and test report table file; the data extraction window includes at least one in-place editing block control, and each in-place editing block control represents different cell data; An interactive interface display module is configured to determine a target control selected by a user from the at least one in-place editing block control, and display an interactive interface including cell data corresponding to the target control; An analysis and test summary table generation module is configured to generate an analysis and test summary table according to a cell data point selection operation of a user in the interactive interface; The analysis and test summary table generation module includes: A keyword determination unit is configured to determine at least one keyword corresponding to target cell data selected by a user in the interactive interface; An analysis and test summary table generation unit is configured to extract target data based on the at least one keyword, and generate an analysis and test summary table based on the target data; The analysis and test summary table generation unit includes: An analysis and test summary table generation subunit is configured to traverse the at least one keyword, determine a keyword cell position corresponding to the keyword, and extract target data corresponding to the keyword at the keyword cell position; The device further includes: A title cell position module is configured to determine a title corresponding to the target cell data, and determine a title cell position corresponding to the title, before traversing the at least one keyword to determine a keyword cell position corresponding to the keyword; The analysis and test summary table generation subunit is configured to: Traverse the at least one keyword to determine a relative position relationship between the keyword and the title; Determine a keyword cell position corresponding to the keyword according to the relative position relationship and the title cell position.

6. An electronic device, comprising: The electronic device includes: at least one processor; and a memory connected with the at least one processor in communication; wherein the memory stores a computer program executable by the at least one processor, and the computer program is executed by the at least one processor to enable the at least one processor to perform the data processing method of any one of claims 1-4.

7. A computer-readable storage medium, characterized in that, The computer readable storage medium stores computer instructions for causing a processor to implement the data processing method of any one of claims 1-4 when executed.

Images