A method and system for continuous processing of water regime data in tabular text format

Abstract

The present application discloses a method and system for processing water situation data continuity in a tabular text format, which involves data analysis and data processing technology, including: extracting several keywords in advance based on the description data of the target watershed; obtaining the water situation table data to be processed, and combining them to form fused water situation table data based on the extracted keywords; obtaining at least one water situation related item selected by the user, and determining an adapted prompt text based on the water situation related item; prompting a pre-trained large model based on the prompt text, so as to generate description information using the large model in a corresponding time sequence; and presenting the generated description information based on the water situation table data, and highlighting the selected water situation related item in the presented description information and the water situation table data at the same time. The method of the present application combines the large model to realize the generation of description information based on the water situation data table, greatly improving the auxiliary effect on the user's analysis of water situation.

Description

Technical Field

[0001] The present application relates to the technical field of data analysis and data processing, and in particular to a method and system for processing water situation data in a continuous manner in a tabular text format. Background Art

[0002] As an important power production enterprise, large hydropower stations have the characteristics of large installed capacity, which not only affects the regional power supply, but also puts higher requirements on the operation and maintenance of the power station. Intrusion into the waters of the hydropower station may cause the hydropower station to malfunction and seriously affect the normal life of residents in the corresponding area.

[0003] Existing water situation data is generally presented to users in the form of tables, but existing tables require users to manually analyze the data, which is heavily dependent on user experience. In addition, since tables generally only record a few items, such as the water level value at a certain time, users need to spend more time organizing and analyzing data, which is inefficient. Summary of the invention

[0004] The embodiment of the present application provides a method and system for processing water situation data continuity in a tabular text format, which is used to realize the generation of descriptive information based on the water situation data table in combination with a large model, and to discover more related factors, thereby greatly improving the auxiliary effect on users' analysis of water situation.

[0005] The present application embodiment proposes a method for processing water regime data continuity in a tabular text format, including:

[0006] Several keywords are extracted in advance based on the descriptive data of the target watershed;

[0007] Acquire water condition table data to be processed, and combine to form fused water condition table data based on the extracted keywords, wherein the fused water condition table data includes water condition related items, wherein the water condition related items include expanded items formed based on the extracted keywords, and the fused water condition table data includes multiple rows of water condition data arranged in chronological order, and any column of data has the same column attribute;

[0008] Acquire at least one water condition related item selected by the user, and determine an adapted prompt text based on the water condition related item;

[0009] According to the prompt text, prompt a pre-trained large model to generate description information according to the corresponding time sequence using the large model; and

[0010] The generated description information is presented based on the water condition table data, and the selected water condition related item is highlighted in the presented description information and the water condition table data at the same time.

[0011] Optionally, several keywords are extracted in advance based on the description data of the target watershed, including:

[0012] Acquire a first text of a target watershed and a second text input by a user, so as to obtain the description data based on a combination of the first text and the second text;

[0013] Extracting several participles from the description data;

[0014] Based on the extracted segmented words, the similarity between any segmented word and the preset possible keywords is calculated;

[0015] When it is determined that the similarity between the extracted word segment and the preset possible keyword is greater than a preset threshold, the corresponding possible keyword is determined as the extracted keyword.

[0016] Optionally, obtaining water condition table data to be processed, and combining and forming fused water condition table data based on the extracted keywords includes:

[0017] Acquire water condition table data to be processed, and determine water condition change information of the water condition table data;

[0018] According to any extracted keyword, obtain the variable information under the corresponding keyword;

[0019] Determine the association relationship between the variable information and the water regime change information, and configure a corresponding weight coefficient for any of the keywords according to the association relationship;

[0020] According to the weight coefficient, each keyword is sequentially inserted after the water condition table data as an expansion item, and corresponding variable information is filled in each column in chronological order to form expansion item information.

[0021] Optionally, obtaining at least one water condition related item selected by the user includes: providing a selection box in each row and column of the fused water condition table data, so that when the selection box is checked, the item or augmented item corresponding to the corresponding row or column is selected as the water condition related item.

[0022] Optionally, it also includes providing a trigger item based on the selected data in the fused water condition table data, so as to deselect the row or column of the corresponding water condition related item based on the trigger item.

[0023] Optionally, the water condition related item includes the original item and the expanded item, and the adapted prompt text determined based on the water condition related item includes:

[0024] Providing a plurality of prompt templates, wherein vacant positions are reserved in the prompt templates;

[0025] The selected water condition related item is determined, and the selected water condition related item is filled into the vacant position of the prompt template selected by the user to form an adaptive prompt text.

[0026] Optionally, generating description information using the large model in a corresponding time sequence includes:

[0027] When the input prompt text contains multiple selected water condition related items, the description information is generated in sections according to the order of the corresponding weight coefficients of the water condition related items.

[0028] Optionally, the generated description information includes a description text of the water condition related item;

[0029] The water condition related items selected in the presented description information and the water condition table data are highlighted at the same time and include:

[0030] Setting corresponding highlighting background colors for water condition-related items of different weights, so that the text of the water condition-related items is displayed based on the highlighting background colors in the generated description information; and,

[0031] Determine the numerical information related to the water condition related items within a corresponding time range;

[0032] Establishing a chart layer based on the numerical information, and hiding the chart layer by default;

[0033] When the pointer enters the text display range of any of the water condition related items, the hidden chart layer is displayed in association.

[0034] An embodiment of the present application also proposes a water situation data continuity processing system in tabular text format, comprising a processor and a memory, wherein the memory stores a computer program, and when the computer program is executed by the processor, the steps of the water situation data continuity processing method in tabular text format as described above are implemented.

[0035] The method of the embodiment of the present application can specify a time period in a table for processing according to user needs, for example, and combine with a large model to realize the generation of descriptive text based on the water situation data table. The present application can discover more related factors and greatly improve the auxiliary effect on users' analysis of water conditions.

[0036] The above description is only an overview of the technical solution of the present application. In order to more clearly understand the technical means of the present application, it can be implemented in accordance with the contents of the specification. In order to make the above and other purposes, features and advantages of the present application more obvious and easy to understand, the specific implementation methods of the present invention are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] Various other advantages and benefits will become apparent to those of ordinary skill in the art by reading the detailed description of the preferred embodiments below. The accompanying drawings are only for the purpose of illustrating the preferred embodiments and are not to be considered as limiting the present invention. Moreover, the same reference symbols are used throughout the accompanying drawings to represent the same components. In the accompanying drawings:

[0038] Figure 1 The basic process flow of the method for continuous processing of water regime data in the form of a tabular text in this embodiment is shown in FIG. DETAILED DESCRIPTION

[0039] The exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although the exemplary embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided to enable a more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0040] This application embodiment proposes a method for processing water regime data continuity in a tabular text format, such as Figure 1 As shown, the following steps are included:

[0041] In step S101, a number of keywords are extracted in advance based on the description data of the target watershed. In some embodiments, a number of keywords adapted to the target watershed can be extracted based on, for example, the description data of the watershed in a public text or the description data input by a user.

[0042] In step S102, the water condition table data to be processed is obtained, and based on the extracted several keywords, the fused water condition table data is combined to form a fused water condition table data, wherein the fused water condition table data includes water condition related items, wherein the water condition related items include expansion items formed based on the extracted several keywords, and the fused water condition table data includes multiple rows of water condition data arranged in chronological order, and any column data has the same column attribute. In some specific examples, the water condition table data to be processed can be a conventional water condition data table, which can include table items such as time, water level, water inflow, and upstream power generation.

[0043] In step S103, at least one water condition related item selected by the user is obtained, and an adapted prompt text is determined based on the water condition related item. The water condition data continuity processing method of the embodiment of the present application is processed based on a table format. For example, a user interface can be provided to import water condition table data, and then process it. The format of the table can be xls, xlsx, etc. The imported water condition table data includes time, water level, water inflow and other items and corresponding numerical values, such as the water level value at a certain time. In a specific example, the user can select the related items that need to be analyzed, such as the relationship between the water level and the water inflow and the power generation, and then select the corresponding items and time range to further determine the prompt text. In some specific examples, the prompt text is a text used to prompt a large model to perform a corresponding action. The large model can be a large language model LLM, MT5, etc.

[0044] In step S104, the pre-trained large model is prompted according to the prompt text to generate description information using the large model in a corresponding time sequence. The large model is prompted to perform processing through the prompt text to generate description information such as the relationship between water level and water inflow and power generation.

[0045] In step S105, the generated description information is presented based on the water condition table data, and the selected water condition related items are highlighted in the presented description information and the water condition table data. For example, the generated description information can be directly filled into the blank column, and the selected items such as water level and water inflow, power generation, etc. can be highlighted in the description information. More specifically, the data after processing the water level, water inflow and other data, such as the increase or decrease of the water level and water inflow, can also be highlighted together, so that the user does not need to perform complex table operations, and can realize continuous processing and analysis of water condition data, greatly improving the efficiency of water condition data analysis and processing.

[0046] The method of the embodiment of the present application can specify a time period in a table for processing according to user needs, for example, and combine with a large model to realize the generation of descriptive text based on the water situation data table. The present application can discover more related factors. In particular, the scheme of the present application can condense the water situation related items and water situation changes in the selected time period, greatly improving the auxiliary effect on users' analysis of water conditions.

[0047] In some embodiments, several keywords are extracted in advance based on the description data of the target watershed, including:

[0048] The first text of the target watershed and the second text input by the user are obtained to obtain the description data based on the combination of the first text and the second text. In some embodiments, the first text of the target watershed can be determined in combination with public information, and the user can also input the second text of the user's interest.

[0049] Extract several participles in the description data, and calculate the similarity between any participle and the preset possible keywords according to the extracted participles. In some embodiments, possible keywords such as weather, tributary, etc. can be set in advance according to various river basins.

[0050] When it is determined that the similarity between the extracted word segmentation and the preset possible keywords is greater than the preset threshold, the corresponding possible keywords are determined as the extracted keywords. In the embodiment of the present application, the text obtained or input by the user can be a colloquial description, and the preset possible keywords are used as the extracted keywords, which can ensure the standardization of the fused water situation table data.

[0051] In some embodiments, obtaining water condition table data to be processed, and combining to form fused water condition table data based on the extracted keywords includes:

[0052] The water condition table data to be processed is obtained, and the water condition change information of the water condition table data is determined.

[0053] According to any extracted keyword, variable information under the corresponding keyword is obtained. In some embodiments, for example, power generation information can be obtained based on power generation data of a turbine, and rainfall information can be obtained based on weather data.

[0054] Determine the correlation between the variable information and the water regime change information, and configure a corresponding weight coefficient for any of the keywords according to the correlation. This example uses water level as the main water regime change information for illustration. In the specific example, the correlation between water level and power generation, weather (rainfall), tributaries, etc. can be roughly determined by time period. For example, in the rainy season, weather can be determined as the main factor, and in other time periods, upstream water inflow and power generation can be the main factors.

[0055] According to the weight coefficient, each keyword is inserted after the water condition table data as an augmented item, and corresponding variable information is filled in each column in chronological order to form augmented item information. After amplification, the fused water condition table data includes the original item and the augmented item, both of which are water condition related items.

[0056] In some embodiments, obtaining at least one water condition-related item selected by a user includes: providing a selection box in each row and column of the fused water condition table data, so that when the selection box is checked, the item or augmented item corresponding to the corresponding row or column is selected as the water condition-related item. In some specific examples, a selection box can be provided directly based on both sides of the fused water condition table data to implement this function.

[0057] In some embodiments, it also includes providing a trigger item based on the selected data in the fused water condition table data, so as to deselect the row or column of the corresponding water condition related item based on the trigger item.

[0058] In some embodiments, the water condition related item includes the original item and the augmented item, and the adapted prompt text determined based on the water condition related item includes:

[0059] A plurality of prompt templates are provided, wherein vacant positions are reserved in the prompt templates. In some embodiments, the prompt templates may be “analyzing the water level change from X / X / X to X / X / X”, “analyzing the rainfall from X / X / X to X / X / X”, “analyzing the impact of XX on water level change from X / X / X to X / X / X”, etc., where X represents a vacant position.

[0060] The selected water condition related item is determined, and the selected water condition related item is filled into the vacant position of the prompt template selected by the user to form an adapted prompt text. After the vacant position is filled with the keywords contained in the water condition related item, the adapted prompt text is formed.

[0061] In some embodiments, generating the description information using the large model in a corresponding time sequence includes: when the input prompt text contains multiple selected water condition related items, generating the description information in segments according to the size order of the corresponding weight coefficients of the water condition related items. That is, in a specific example, for the case where different water condition related items are selected, the corresponding description information is generated in segments.

[0062] In some embodiments, the generated description information includes a description text of the water condition related item. The water condition related item selected is highlighted in the presented description information and the water condition table data at the same time, including:

[0063] Corresponding highlight background colors are set for water condition-related items of different weights, so that the text of the water condition-related items can be displayed in the generated description information based on the highlight background color. That is, in a specific example, the keyword positions of multiple water condition-related items in the fused water condition table data can be configured with corresponding display background colors, so that the text of the water condition-related items in the generated description information also follows the background color. For example, if the water condition-related item is weather, then in the description information, the corresponding rainfall and rainfall intensity are both highlighted with the same background color.

[0064] Within the corresponding time range, the numerical information related to the water condition related item is determined. Further, for example, the numerical information of the rainfall intensity within the time range can be determined.

[0065] A chart layer is established based on the numerical information, and the chart layer is hidden by default, that is, the chart established based on the weather rainfall information is formed into a layer and hidden. The established chart may include weather change trends, water level increase and decrease trends, etc.

[0066] When the pointer enters the text display range of any of the water condition related items, the hidden chart layer is displayed in association. In some examples, when the mouse pointer enters the description information range covered by the weather, the chart is displayed in association.

[0067] The method of the present application allows users to describe water situation data in the form of text, and further combine it with charts, which greatly improves the user's analysis efficiency of water situation.

[0068] An embodiment of the present application also proposes a water situation data continuity processing system in tabular text format, comprising a processor and a memory, wherein the memory stores a computer program, and when the computer program is executed by the processor, the steps of the water situation data continuity processing method in tabular text format as described above are implemented.

[0069] In addition, although exemplary embodiments have been described herein, the scope includes any and all embodiments based on the present disclosure with equivalent elements, modifications, omissions, combinations (e.g., various embodiments intersecting schemes), adaptations or changes. It is not limited to the examples described in this specification or during the implementation of this application, and its examples will be interpreted as non-exclusive.

[0070] The above description is intended to be illustrative rather than restrictive. For example, the above examples (or one or more of them) can be used in combination with each other. For example, those of ordinary skill in the art may use other embodiments when reading the above description.

[0071] The above embodiments are merely exemplary embodiments of the present disclosure. Those skilled in the art may make various modifications or equivalent substitutions to the present invention within the essence and protection scope of the present disclosure, and such modifications or equivalent substitutions shall also be deemed to fall within the protection scope of the present invention.

Claims

1. A method for processing water regime data continuity in a tabular text format, characterized in that: include: Several keywords are extracted in advance based on the descriptive data of the target watershed; Acquire water condition table data to be processed, and combine to form fused water condition table data based on the extracted keywords, wherein the fused water condition table data includes water condition related items, wherein the water condition related items include expanded items formed based on the extracted keywords, and the fused water condition table data includes multiple rows of water condition data arranged in chronological order, and any column of data has the same column attribute; Acquire at least one water condition related item selected by the user, and determine an adapted prompt text based on the water condition related item; According to the prompt text, prompt a pre-trained large model to generate description information according to the corresponding time sequence using the large model; as well as, Presenting the generated description information based on the water condition table data, and highlighting the selected water condition related item in the presented description information and the water condition table data at the same time; The water situation table data to be processed is obtained, and based on the extracted keywords, the fused water situation table data is combined to include: Acquire water condition table data to be processed, and determine water condition change information of the water condition table data; According to any extracted keyword, obtain the variable information under the corresponding keyword; Determine the association relationship between the variable information and the water regime change information, and configure a corresponding weight coefficient for any of the keywords according to the association relationship; According to the weight coefficient, each keyword is sequentially inserted after the water condition table data as an expansion item, and corresponding variable information is filled in each column in chronological order to form expansion item information.

2. The method for processing water regime data continuity in a tabular text format as claimed in claim 1, characterized in that: Based on the description data of the target watershed, several keywords are extracted in advance, including: Acquire a first text of a target watershed and a second text input by a user, so as to obtain the description data based on a combination of the first text and the second text; Extracting several participles from the description data; Based on the extracted segmented words, calculate the similarity between any segmented word and the preset keyword; When it is determined that the similarity between the extracted word segment and the preset keyword is greater than a preset threshold, the corresponding keyword is determined as the extracted keyword.

3. The method for processing water regime data continuity in a tabular text format as claimed in claim 1, characterized in that: Acquiring at least one water condition related item selected by the user includes: providing a selection box in each row and column of the fused water condition table data, so that when the selection box is checked, the item or augmented item corresponding to the corresponding row or column is selected as the water condition related item.

4. The method for processing the continuity of water regime data in a tabular text format as claimed in claim 3, characterized in that: It also includes providing a trigger item based on the selected data in the fused water condition table data, so as to deselect the row or column of the corresponding water condition related item based on the trigger item.

5. The method for processing water regime data continuity in a table text format as claimed in claim 3, characterized in that: The water condition related items include the original items and the expanded items, and the adapted prompt text determined based on the water condition related items includes: Providing a plurality of prompt templates, wherein vacant positions are reserved in the prompt templates; The selected water condition related item is determined, and the selected water condition related item is filled into the vacant position of the prompt template selected by the user to form an adaptive prompt text.

6. The method for processing the continuity of water regime data in the form of a table text as claimed in claim 5, characterized in that: Using the large model in a corresponding time sequence, generating description information includes: When the input prompt text contains multiple selected water condition related items, the description information is generated in sections according to the order of the corresponding weight coefficients of the water condition related items.

7. The method for processing water regime data continuity in a table text format as claimed in claim 5, characterized in that: The generated description information includes a description text of the water condition related item; The water condition related items selected in the presented description information and the water condition table data are highlighted at the same time and include: Setting corresponding highlighting background colors for water condition-related items of different weights, so that the text of the water condition-related items is displayed based on the highlighting background colors in the generated description information; and, Determine the numerical information related to the water condition related items within a corresponding time range; Establishing a chart layer based on the numerical information, and hiding the chart layer by default; When the pointer enters the text display range of any of the water condition related items, the hidden chart layer is displayed in association.

8. A continuous processing system for water regime data in a tabular text format, characterized in that: It comprises a processor and a memory, wherein a computer program is stored in the memory, and when the computer program is executed by the processor, the steps of the method for continuous processing of water situation data in the form of a tabular text as described in any one of claims 1 to 7 are implemented.

Images