CN112253236B - Method for cleaning data of mine electrical method monitoring data by utilizing correlation analysis - Google Patents

Method for cleaning data of mine electrical method monitoring data by utilizing correlation analysis Download PDF

Info

Publication number
CN112253236B
CN112253236B CN202011089172.2A CN202011089172A CN112253236B CN 112253236 B CN112253236 B CN 112253236B CN 202011089172 A CN202011089172 A CN 202011089172A CN 112253236 B CN112253236 B CN 112253236B
Authority
CN
China
Prior art keywords
data
monitoring
monitoring data
correlation
cleaning
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202011089172.2A
Other languages
Chinese (zh)
Other versions
CN112253236A (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.)
Xian Research Institute Co Ltd of CCTEG
Original Assignee
Xian Research Institute Co Ltd of CCTEG
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 Xian Research Institute Co Ltd of CCTEG filed Critical Xian Research Institute Co Ltd of CCTEG
Priority to CN202011089172.2A priority Critical patent/CN112253236B/en
Publication of CN112253236A publication Critical patent/CN112253236A/en
Application granted granted Critical
Publication of CN112253236B publication Critical patent/CN112253236B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • EFIXED CONSTRUCTIONS
    • E21EARTH OR ROCK DRILLING; MINING
    • E21FSAFETY DEVICES, TRANSPORT, FILLING-UP, RESCUE, VENTILATION, OR DRAINING IN OR OF MINES OR TUNNELS
    • E21F17/00Methods or devices for use in mines or tunnels, not covered elsewhere
    • EFIXED CONSTRUCTIONS
    • E21EARTH OR ROCK DRILLING; MINING
    • E21FSAFETY DEVICES, TRANSPORT, FILLING-UP, RESCUE, VENTILATION, OR DRAINING IN OR OF MINES OR TUNNELS
    • E21F17/00Methods or devices for use in mines or tunnels, not covered elsewhere
    • E21F17/18Special adaptations of signalling or alarm devices
    • 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
    • Y02ATECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
    • Y02A90/00Technologies having an indirect contribution to adaptation to climate change
    • Y02A90/30Assessment of water resources

Landscapes

  • Engineering & Computer Science (AREA)
  • Mining & Mineral Resources (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • General Life Sciences & Earth Sciences (AREA)
  • Geochemistry & Mineralogy (AREA)
  • Geology (AREA)
  • Geophysics And Detection Of Objects (AREA)

Abstract

The invention discloses a method for cleaning data of monitoring data of a mine electrical method by utilizing correlation analysis, which aims at the technical problem that the influence of a plurality of continuous abnormal data points in the monitoring data of the mine electrical method is difficult to eliminate by a conventional data cleaning method.

Description

Method for cleaning data of mine electrical method monitoring data by utilizing correlation analysis
Technical Field
The invention relates to a mine geophysical prospecting data cleaning method, belongs to the field of mine geophysical prospecting, and particularly relates to a method for cleaning mine electrical monitoring data by utilizing correlation analysis.
Background
The method is widely used for monitoring the damage of the top and bottom plates of the coal seam and monitoring water damage in the stoping process of the coal mine working face, and obtains good geological effect. Data acquired by the electrical prospecting of a mine are generally electric potentials or electric potential differences, and the influence of interference factors such as electromagnetic noise, roadway accumulated water, float coal, metal bodies and the like needs to be eliminated for interpreting useful geological information. In addition, in the process of monitoring the mine electricity method, the grounding condition of the monitoring electrode may change along with the time, the monitoring electrode itself may not work normally due to mining damage, all of which need to be considered in the process of data cleaning, otherwise, false abnormality may occur in the interpretation result.
In general, in the mine electrical monitoring, a plurality of monitoring electrodes are arranged around a target area in a coal mine, an artificial electric field is established by using a transmitting electrode to supply power to the underground, and a voltage signal is acquired by using a receiving electrode. When one transmitting electrode is powered, a plurality of receiving electrodes are generally used for signal acquisition. When the mine electrical method monitoring is carried out, a group of monitoring data can be collected at fixed intervals, the mine electrical method monitoring data are continuously generated along with the time, and the data volume is very large. The conventional data cleaning method generally adopts measures such as outlier correction, smooth filtering and the like, and the method can eliminate or correct isolated abnormal data points caused by electromagnetic noise, roadway accumulated water, float coal, metal bodies and the like. However, when a certain transmitting electrode is seriously interfered in the mining process, the signal acquired by the receiving electrode contains more interference information, and a plurality of continuous receiving data corresponding to the transmitting electrode belong to abnormal data. In this case, a plurality of consecutive abnormal data points are formed in the monitoring data, and it is generally difficult to eliminate the influence of such interference information by using the conventional data cleaning method. If a manual identification method is adopted to process the abnormal data, a great deal of manpower and time are consumed, and the processing result is not time-efficient.
Disclosure of Invention
The invention mainly solves the technical problem that the influence of a plurality of continuous abnormal data points in the mine electrical method monitoring data is difficult to eliminate in the prior art, and provides a method for cleaning the mine electrical method monitoring data by utilizing correlation analysis. The method utilizes the characteristic that the mine electrical method monitoring data has time series correlation, carries out correlation analysis on the monitoring data at different times, eliminates the influence of a plurality of continuous abnormal data points by identifying and correcting the data with low correlation degree or irrelevant data, and realizes the data cleaning of the mine electrical method monitoring data.
The technical scheme adopted by the invention for solving the technical problems is as follows:
a method for data cleaning of electromechanically monitored mine data using correlation analysis, comprising:
grouping data corresponding to the same transmitting electrode and different receiving electrodes in each monitoring period;
carrying out normalization processing on the grouped monitoring data;
calculating a correlation coefficient matrix of monitoring data in two adjacent time periods based on the data after normalization processing;
and cleaning the monitoring data based on the correlation coefficient matrix.
Preferably, the method for performing data cleaning on the monitoring data of the mining electrical method by using correlation analysis, wherein the grouping of the data corresponding to the same transmitting electrode and different receiving electrodes in each monitoring period includes:
recording monitoring data of an ith monitoring period as T (i), wherein i is 0,1, … … and n, wherein T (0) is initial monitoring data;
grouping data corresponding to the same transmitting electrode and different receiving electrodes into a group, and marking the group as D (i, j), wherein j is the serial number of the transmitting electrode;
recording data collected by the same transmitting electrode and the same receiving electrode in the monitoring data T (i) as d (i, j, k), wherein k is the number of the receiving electrode;
wherein, T (i), D (i, j) and D (i, j, k) are as follows:
Figure BDA0002721406300000021
in the formula, ms is the number of transmitting electrodes, and mr is the number of receiving electrodes.
Preferably, in the method for performing data cleaning on the monitoring data by the mining electrical method by using the correlation analysis, the initial monitoring data T (0) is acquired under the condition that all monitoring electrodes of the monitoring system work normally.
Preferably, in the method for cleaning the data of the monitoring data of the mining electrical method by using the correlation analysis, outlier correction and smooth filtering are performed on the grouped data corresponding to the same transmitting electrode and different receiving electrodes, so that isolated abnormal point data is eliminated.
Preferably, in the method for performing data cleaning on the monitoring data by the mining electrical method by using correlation analysis, the correlation coefficient matrix of the monitoring data in two adjacent time periods is calculated based on the following formula:
Figure BDA0002721406300000022
wherein s (i-1, i, j) is the covariance of D (i-1, j) and D (i, j), and c (i-1, j) and c (i, j) are the standard deviation of D (i-1, j) and D (i, j), respectively; r (i-1, i) represents a correlation coefficient matrix of the monitoring data T (i-1) and the monitoring data T (i).
Preferably, in the method for performing data cleaning on the monitoring data of the mining electrical method by using the correlation analysis, the covariance s (i-1, i, j) of D (i-1, j) and D (i, j) is calculated based on the following formula:
Figure BDA0002721406300000023
preferably, in the method for performing data cleaning on the monitoring data of the mining electrical method by using correlation analysis, the standard deviation c (i-1, j) and c (i, j) are calculated based on the following formula:
Figure BDA0002721406300000024
Figure BDA0002721406300000031
preferably, the method for performing data cleaning on the monitoring data of the mining electrical method by using correlation analysis is performed when R (i-1, i) (i)>0) In the presence of a correlation coefficient r (i-1, i, j) 0 ) 0, wherein 1 ≦ j 0 Ms or less, adding j in T (i) 0 Reception data D (i, j) corresponding to each transmission electrode 0 ) The abnormal data that are regarded as irrelevant are marked,it is corrected based on the following formula:
Figure BDA0002721406300000032
preferably, the method for performing data cleaning on the monitoring data of the mining electrical method by using correlation analysis is performed when R (i-1, i) (i)>0) In the presence of a correlation coefficient of 0<|r(i-1,i,j 1 )|<ε(1≤j 1 Ms) or less, adding j in T (i) 1 Received data D (i, j) corresponding to each transmitting electrode 1 ) Abnormal data labeled as low in correlation, which is corrected based on the following formula:
D(i,j 1 )=r(i-1,i,j 1 )D(i,j 1 )+(1-r(i-1,i,j 1 ))D(i-1,j 1 ) (i≥1)。
preferably, in the method for performing data cleaning on the monitoring data of the mining electrical method by using the correlation analysis, if all elements of R (i-1, i) satisfy | R (i-1, i, j) | ≧ epsilon (j ═ 1, … …, ms), which indicates that the monitoring data T (i) and T (i-1) have correlation, the monitoring data of the next period are cleaned.
The method has the advantages that the monitoring data in the current time period and the monitoring data in the previous time period are subjected to correlation analysis, abnormal data with low or irrelevant correlation degree are identified according to the given correlation coefficient threshold, the monitoring data can be analyzed and processed in real time in the monitoring process, and the timeliness is high; the abnormal data is corrected by utilizing the monitoring data in the previous period or the previous period instead of being directly deleted, so that the data information which is useful for the later geological interpretation can be kept as much as possible while the influence of a plurality of continuous abnormal data points is eliminated.
Drawings
FIG. 1 is a schematic diagram of an embodiment of the present invention.
Detailed Description
The following further describes embodiments of the present invention with reference to the drawings.
In the process of monitoring by the mining electrical method, the grounding condition of the monitoring electrode may change along with the time, and the monitoring electrode cannot normally work due to mining damage. When a certain transmitting electrode is seriously interfered in the mining process, a plurality of continuous abnormal data points can be formed in the monitoring data, and the influence of interference information is generally difficult to eliminate by adopting a conventional data cleaning method. If a manual identification method is adopted to process the abnormal data, a large amount of labor and time are consumed, and the processing result is not time-efficient.
The invention provides a method for cleaning monitoring data of a mine electrical method by utilizing correlation analysis, aiming at the technical problem that the influence of a plurality of continuous abnormal data points in the monitoring data of the mine electrical method is difficult to eliminate in the prior art. The method utilizes the characteristic that the mine electrical method monitoring data has time series correlation, carries out correlation analysis on the monitoring data at different times, eliminates the influence of a plurality of continuous abnormal data points by identifying and correcting the data with low correlation degree or irrelevant data, and realizes the data cleaning of the mine electrical method monitoring data. The specific implementation mode is as follows:
each monitoring time interval has ms transmitting electrodes and mr receiving electrodes to carry out data acquisition, when one transmitting electrode carries out signal transmission, mr receiving electrodes carry out signal acquisition in sequence, and when the ms transmitting electrodes finish one-time signal transmission and corresponding data acquisition, a group of monitoring data acquisition is finished. For the sake of distinction, the monitored data of the ith monitoring period is denoted as T (i) (0,1, … …, n), where T (0) is the initial monitored data and T (n) is the last set of monitored data.
The embodiment comprises the following steps:
(1) recording monitoring data of the ith monitoring period as T (i) (i ═ 0,1, … …, n), wherein T (0) is initial monitoring data, and T (n) is a last group of monitoring data; grouping monitoring data T (i) according to different transmitting electrodes, grouping data corresponding to the same transmitting electrode and different receiving electrodes into a group, and recording the group as D (i, j) (j is 1, … … and ms, and ms is the number of the transmitting electrodes); recording data collected by the same transmitting electrode and the same receiving electrode in the monitoring data t (i) as d (i, j, k) (k is 1, … …, mr is the number of receiving electrodes); t (i), D (i, j) and D (i, j, k) are as follows:
Figure BDA0002721406300000041
(2) the initial monitoring data T (0) needs to be collected under the condition that all monitoring electrodes of the monitoring system are working normally.
(3) And (3) performing outlier correction and smooth filtering on the monitoring data T (i) (i is 0,1, … … and n) and the elements D (i, j) (j is 1, … … and ms) respectively to eliminate isolated abnormal data points.
(4) The average values of the elements D (i, j) (j is 1, … …, ms) of the monitoring data t (i) (i is 0,1, … …, n) are calculated, and D (i, j) is normalized by the average values, as shown in the following formula:
Figure BDA0002721406300000042
(5) performing correlation analysis on the monitoring data T (i-1) and T (i) (i >0), and calculating correlation coefficients of two groups of data D (i-1, j) and D (i, j) (j is 1, … … and ms) respectively, wherein the formula is as follows:
Figure BDA0002721406300000043
where s (i-1, i, j) is the covariance of D (i-1, j) and D (i, j), and c (i-1, j) and c (i, j) are the standard deviations of D (i-1, j) and D (i, j), respectively, in the following specific forms:
Figure BDA0002721406300000044
Figure BDA0002721406300000051
Figure BDA0002721406300000052
(6) the threshold value epsilon of the correlation coefficient is given, the value range of the threshold value epsilon is more than or equal to 0 and less than or equal to 0.5, and the specific value can be selected according to the actual situation.
(7) If R (i-1, i) (i)>0) In the presence of a correlation coefficient r (i-1, i, j) 0 )=0(1≤j 0 Ms) indicates the j-th element in T (i) 0 Received data D (i, j) corresponding to each transmitting electrode 0 ) With the data D (i-1, j) of the previous period 0 ) If the data is completely irrelevant, the data can be regarded as irrelevant abnormal data to be marked, and the abnormal data is corrected by utilizing the early monitoring data, and the formula is as follows:
Figure BDA0002721406300000053
(8) if R (i-1, i) (i)>0) In the presence of a correlation coefficient of 0<|r(i-1,i,j 1 )|<ε(1≤j 1 Ms) indicates the j-th element in T (i) 1 Reception data D (i, j) corresponding to each transmission electrode 1 ) With the data D (i-1, j) of the previous period 1 ) The partial data can be regarded as abnormal data with low correlation degree to be marked, and the abnormal data with low correlation degree can be corrected by utilizing the monitoring data of the previous time interval, and the formula is as follows:
D(i,j 1 )=r(i-1,i,j 1 )D(i,j 1 )+(1-r(i-1,i,j 1 ))D(i-1,j 1 )(i≥1)
(9) if all elements of R (i-1, i) (i >0) satisfy | R (i-1, i, j) | ≧ epsilon (j ═ 1, … …, ms), it indicates that there is a correlation between the monitored data T (i) and T (i-1), and the cleaning of the monitored data in the next period can be continued without abnormal data marking.
As shown in fig. 1, after the monitoring starts, let i be 0, and the initial monitoring data T (0) needs to be collected when all monitoring electrodes of the monitoring system are working normally. In order to ensure higher data quality, multiple times of acquisition can be carried out under the condition that the monitoring target area is not influenced by mining, and the average value of the multiple acquisition results is taken as initial monitoring data T (0).
As shown in fig. 1, initial monitor data T (0) is read, and the monitor data T (0) is grouped according to the difference of the transmitting electrodes, and data corresponding to the same transmitting electrode and the different receiving electrodes are grouped into one group, which is denoted as D (0, j) (j is 1, … …, ms). Data collected by the same transmitting electrode and the same receiving electrode in the monitoring data T (0) are denoted as d (0, j, k) (k is 1, … …, mr). T (0), D (0, j) and D (0, j, k) are as follows:
Figure BDA0002721406300000054
as shown in fig. 1, outlier correction and smooth filtering are performed on D (0, j) (j is 1, … …, ms), and this step can eliminate or correct isolated abnormal data points caused by electromagnetic noise, roadway water, float coal, metal bodies, etc., so as to avoid affecting the subsequent correlation analysis. Next, an average value of D (0, j) (j is 1, … …, ms) is calculated and normalized by the average value, and the formula is as follows:
Figure BDA0002721406300000055
the influence of the amplitude change of the transmitting current and the receiving voltage on the subsequent correlation analysis can be eliminated through the normalization processing.
As shown in fig. 1, after the initial monitoring data T (0) is preprocessed, i is set to 1, and the monitoring data T (1) in the next period is read. D (1, j) (j is 1, … …, ms) is obtained by grouping T (1) into data packets, and has the following form:
Figure BDA0002721406300000061
outlier correction and smooth filtering were performed on D (1, j) (j ═ 1, … …, ms), respectively, to eliminate isolated outlier data points. Further, D (1, j) (j is 1, … …, ms) is normalized by the average value, and the formula is as follows:
Figure BDA0002721406300000062
as shown in fig. 1, correlation analysis is performed on the monitoring data T (0) and T (1), and correlation coefficients of two sets of data D (0, j) and D (1, j) (j ═ 1, … …, ms) are calculated, respectively, according to the following formula:
Figure BDA0002721406300000063
where s (0,1, j) is the covariance of D (0, j) and D (1, j), and c (0, j) and c (1, j) are the standard deviations of D (0, j) and D (1, j), respectively, and are as follows:
Figure BDA0002721406300000064
Figure BDA0002721406300000065
Figure BDA0002721406300000066
the threshold value epsilon of the correlation coefficient is given, the value range of the threshold value epsilon is more than or equal to 0 and less than or equal to 0.5, and the specific value can be selected according to the actual situation. As shown in FIG. 1, if there is a correlation coefficient r (0,1, j) 0 )=0(1≤j 0 Ms is less than or equal to) is determined, the j-th time in T (1) is indicated 0 Reception data D (1, j) corresponding to each transmission electrode 0 ) And D (0, j) in the initial monitoring data 0 ) If the data is totally irrelevant, the data can be regarded as irrelevant abnormal data to be marked, and the data is corrected by using the initial monitoring data, and the formula is as follows:
D(1,j 0 )=D(0,j 0 )
if there is a correlation coefficient of 0<|r(0,1,j 1 )|<ε(1≤j 1 Ms ≦ m), it indicates the jth of T (1) 1 Reception data D (1, j) corresponding to each transmission electrode 1 ) And data D (0, j) in the initial monitoring data 1 ) If the correlation is low, the partial data can be regarded as abnormal data with low correlation to be marked, and the abnormal data is corrected by using the initial monitoring data, and the formula is as follows:
D(1,j 1 )=r(0,1,j 1 )D(1,j 1 )+(1-r(0,1,j 1 ))D(0,j 1 )
if all elements of R (0, 1) satisfy | R (0,1, j) | ≧ epsilon (j ═ 1, … …, ms), it indicates that there is a correlation between the monitored data T (1) and T (0), and no abnormal data marking is needed, so that i ═ 2 can be made, and data cleaning continues to be performed on the monitored data T (2) in the next period.
After all the abnormal data in the monitoring data T (1) are corrected, i may be set to 2, and the data cleaning may be continued on the monitoring data T (2) in the next period.
As shown in fig. 1, when data cleaning is performed on monitoring data t (i) (i >1) in any subsequent time period i, the monitoring data t (i) are grouped according to different transmitting electrodes, and data corresponding to the same transmitting electrode and different receiving electrodes are grouped into one group, which is denoted as D (i, j) (j is 1, … …, ms); recording data collected by the same transmitting electrode and the same receiving electrode in the monitoring data T (i) as d (i, j, k) (k is 1, … … and mr); t (i), D (i, j) and D (i, j, k) are as follows:
Figure BDA0002721406300000071
outlier correction and smooth filtering were performed on D (i, j) (j ═ 1, … …, ms), respectively, to eliminate isolated outlier data points. The average values of D (i, j) (j is 1, … …, ms) are calculated, and D (i, j) is normalized by the average values, and the formula is as follows:
Figure BDA0002721406300000072
performing correlation analysis on the monitoring data T (i-1) and T (i), and calculating correlation coefficients of two groups of data D (i-1, j) and D (i, j) (j is 1, … …, ms) respectively, wherein the formula is as follows:
Figure BDA0002721406300000073
wherein s (i-1, i, j) is the covariance of D (i-1, j) and D (i, j), and c (i-1, j) and c (i, j) are the standard deviation of D (i-1, j) and D (i, j), respectively, and the specific form is as follows:
Figure BDA0002721406300000074
Figure BDA0002721406300000075
Figure BDA0002721406300000076
the threshold value epsilon of the correlation coefficient is given, the value range of the threshold value epsilon is more than or equal to 0 and less than or equal to 0.5, and the specific value can be selected according to the actual situation. If the correlation coefficient r (i-1, i, j) exists 0 )=0(1≤j 0 Ms) indicates the j-th element in T (i) 0 Reception data D (i, j) corresponding to each transmission electrode 0 ) With the data D (i-1, j) of the previous period 0 ) If the data is completely irrelevant, the data can be regarded as irrelevant abnormal data to be marked, and the abnormal data is corrected by utilizing the early monitoring data, and the formula is as follows:
Figure BDA0002721406300000077
if there is a correlation coefficient of 0<|r(i-1,i,j 1 )|<ε(1≤j 1 Ms) indicates the j-th element in T (i) 1 Reception data D (i, j) corresponding to each transmission electrode 1 ) And the data D (i-1, j) of the previous time interval 1 ) The degree of correlation is low, and the part of data can be regarded as low degree of correlationThe abnormal data of (2) is marked and corrected by using the monitoring data of the previous time interval, and the formula is as follows:
D(i,j 1 )=r(i-1,i,j 1 )D(i,j 1 )+(1-r(i-1,i,j 1 ))D(i-1,j 1 )(i>1)
if all elements of R (i-1, i) (i >0) satisfy | R (i-1, i, j) | ≧ epsilon (j ═ 1, … …, ms), which indicates that there is a correlation between the monitored data T (i) and T (i-1), and the cleaning of the monitored data in the next period can be continued without marking abnormal data. After the correction of all abnormal data in the monitoring data of the current time period is completed, the cleaning of the monitoring data of the next time period can be continued.

Claims (5)

1. A method for data cleaning of borehole electrical monitoring data using correlation analysis, comprising:
grouping data corresponding to the same transmitting electrode and different receiving electrodes in each monitoring period;
carrying out normalization processing on the grouped monitoring data;
calculating a correlation coefficient matrix of monitoring data in two adjacent time periods based on the data after normalization processing;
cleaning monitoring data based on the correlation coefficient matrix;
wherein, the grouping of the data corresponding to the same transmitting electrode and different receiving electrodes in each monitoring period comprises:
recording monitoring data of an ith monitoring period as T (i), wherein i is 0,1, … … and n, wherein T (0) is initial monitoring data;
grouping data corresponding to the same transmitting electrode and different receiving electrodes into a group, and recording the group as D (i, j), wherein j is the serial number of the transmitting electrode;
recording data collected by the same transmitting electrode and the same receiving electrode in the monitoring data T (i) as d (i, j, k), wherein k is the number of the receiving electrode;
wherein, T (i), D (i, j) and D (i, j, k) are as follows:
Figure FDA0003772075110000011
in the formula, ms is the number of transmitting electrodes, and mr is the number of receiving electrodes;
when calculating the correlation coefficient matrix of the monitoring data in two adjacent time periods based on the data after the normalization processing, calculating the correlation coefficient matrix of the monitoring data in two adjacent time periods based on the following formula:
Figure FDA0003772075110000012
wherein s (i-1, i, j) is the covariance of D (i-1, j) and D (i, j), and c (i-1, j) and c (i, j) are the standard deviation of D (i-1, j) and D (i, j), respectively; r (i-1, i) represents a correlation coefficient matrix of the monitoring data T (i-1) and the monitoring data T (i);
wherein cleaning the monitoring data based on the correlation coefficient matrix comprises: if R (i-1, i) (i)>0) In the presence of a correlation coefficient r (i-1, i, j) 0 ) 0, wherein 1 is not more than j 0 Ms or less, adding j in T (i) 0 Received data D (i, j) corresponding to each transmitting electrode 0 ) Anomalous data, considered irrelevant, are labeled and corrected based on:
Figure FDA0003772075110000013
if R (i-1, i) (i)>0) In the presence of a correlation coefficient of 0<|r(i-1,i,j 1 )|<ε(1≤j 1 Ms) or less, adding j in T (i) 1 Reception data D (i, j) corresponding to each transmission electrode 1 ) Abnormal data labeled as low in correlation, which is corrected based on the following formula:
D(i,j 1 )=r(i-1,i,j 1 )D(i,j 1 )+(1-r(i-1,i,j 1 ))D(i-1,j 1 )(i≥1)
and if all elements of R (i-1, i) meet | R (i-1, i, j) | ≧ epsilon (j ═ 1, … …, ms), which indicates that the monitoring data T (i) and T (i-1) have correlation, cleaning the monitoring data in the next period, and giving a threshold value epsilon of the correlation coefficient, wherein the value range is more than or equal to 0 and less than or equal to 0.5.
2. The method for data cleansing of borehole electrical monitoring data using correlation analysis as claimed in claim 1 wherein the initial monitoring data T (0) is collected in case all monitoring electrodes of the monitoring system are working properly.
3. The method for performing data cleaning on the monitoring data of the mining electrical method by utilizing correlation analysis as claimed in claim 1, wherein outlier correction and smooth filtering are performed on the grouped data corresponding to the same transmitting electrode and different receiving electrodes, so as to eliminate isolated abnormal point data.
4. The method of claim 1, wherein the covariance s (i-1, i, j) of D (i-1, j) and D (i, j) is calculated based on the following equation:
Figure FDA0003772075110000021
5. the method for data cleansing of electrodeionization data using correlation analysis of claim 1, wherein the standard deviations c (i-1, j) and c (i, j) are calculated based on the formula:
Figure FDA0003772075110000022
Figure FDA0003772075110000023
CN202011089172.2A 2020-10-13 2020-10-13 Method for cleaning data of mine electrical method monitoring data by utilizing correlation analysis Active CN112253236B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011089172.2A CN112253236B (en) 2020-10-13 2020-10-13 Method for cleaning data of mine electrical method monitoring data by utilizing correlation analysis

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011089172.2A CN112253236B (en) 2020-10-13 2020-10-13 Method for cleaning data of mine electrical method monitoring data by utilizing correlation analysis

Publications (2)

Publication Number Publication Date
CN112253236A CN112253236A (en) 2021-01-22
CN112253236B true CN112253236B (en) 2022-09-23

Family

ID=74243120

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011089172.2A Active CN112253236B (en) 2020-10-13 2020-10-13 Method for cleaning data of mine electrical method monitoring data by utilizing correlation analysis

Country Status (1)

Country Link
CN (1) CN112253236B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113466951B (en) * 2021-06-24 2023-05-12 中煤科工集团西安研究院有限公司 Mine electrical method resistivity abnormal response monitoring rapid identification method

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102819682A (en) * 2012-08-02 2012-12-12 清华大学 Data cleaning and recovering algorithm of floating car related to multi-threshold space
CN105550700A (en) * 2015-12-08 2016-05-04 国网山东省电力公司电力科学研究院 Time series data cleaning method based on correlation analysis and principal component analysis
CN106296435A (en) * 2016-08-18 2017-01-04 西安科技大学 A kind of mine gas monitoring disorder data recognition method
CN108104876A (en) * 2017-12-05 2018-06-01 中煤科工集团西安研究院有限公司 Water damage real-time graded method for early warning and system based on mine electric method monitoring
CN110297034A (en) * 2019-06-12 2019-10-01 重庆工商大学融智学院 A kind of dynamic change and prediction technique of urban ecological environment

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102819682A (en) * 2012-08-02 2012-12-12 清华大学 Data cleaning and recovering algorithm of floating car related to multi-threshold space
CN105550700A (en) * 2015-12-08 2016-05-04 国网山东省电力公司电力科学研究院 Time series data cleaning method based on correlation analysis and principal component analysis
CN106296435A (en) * 2016-08-18 2017-01-04 西安科技大学 A kind of mine gas monitoring disorder data recognition method
CN108104876A (en) * 2017-12-05 2018-06-01 中煤科工集团西安研究院有限公司 Water damage real-time graded method for early warning and system based on mine electric method monitoring
CN110297034A (en) * 2019-06-12 2019-10-01 重庆工商大学融智学院 A kind of dynamic change and prediction technique of urban ecological environment

Also Published As

Publication number Publication date
CN112253236A (en) 2021-01-22

Similar Documents

Publication Publication Date Title
CN104459779B (en) A kind of method and apparatus of the automatic identification in Unusual Seismic road
CN112253236B (en) Method for cleaning data of mine electrical method monitoring data by utilizing correlation analysis
CN111507155A (en) U-Net + + and UDA combined microseism effective signal first-arrival pickup method and device
CN109343131B (en) Lateral power supply ground well direct current method detection method and device
CN111352163B (en) Magnetotelluric depth sounding-based static effect correction method and system
Zhuang et al. Preliminary analysis of observations on the ultra-low frequency electric field in the Beijing region
CN104977602A (en) Control method and apparatus for earthquake data acquisition construction
CN108088488B (en) Target range telemetry data splicing method
CN111796333A (en) Micro-resistivity imaging data electric buckle balancing method based on sliding window
CN110146920B (en) Microseismic event detection method and system based on relative change of amplitude
CN110146918B (en) Grouping-based microseismic event detection method and system
CN117665925A (en) Stratum longitudinal wave time difference extraction method and system with dynamically adjusted time difference search range
CN110376436B (en) Multi-scale noise power spectral line spectrum detection method
CN110058318B (en) One-dimensional direction correction method of natural electric field based on measurement electrode coordinates
CN105277981A (en) Non-consistent time-lapse seismic bin matching method based on wave field continuation compensation
CN113805250A (en) High-density earthquake and electrical method combined detection and identification method for open-pit mine goaf
CN110161560B (en) Method and device for detecting microseismic event
CN110703319B (en) Microseismic event detection method and system based on Khichin-Einstein theorem
CN113466951B (en) Mine electrical method resistivity abnormal response monitoring rapid identification method
CN111123356B (en) Abnormal track intelligent identification method based on first arrival information
CN112859182A (en) Mine audio frequency electric perspective inversion imaging false anomaly suppression method
CN114790549B (en) Periodic dynamic DC interference analysis method
CN110703324A (en) Microseismic event detection method and system represented by random dictionary
CN112257560B (en) Microseismic event detection method and system by utilizing cumulative similarity
CN110333530B (en) Microseismic event detection method and system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
CB03 Change of inventor or designer information

Inventor after: Lu Jingjin

Inventor after: Nan Hanchen

Inventor after: Li Deshan

Inventor after: Wang Bingchun

Inventor after: Lin Duibo

Inventor after: Duan Jianhua

Inventor after: Cui Weixiong

Inventor after: Yan Wenchao

Inventor before: Lu Jingjin

Inventor before: Nan Hanchen

Inventor before: Li Deshan

Inventor before: Wang Bingchun

Inventor before: Lin Duiru

Inventor before: Duan Jianhua

Inventor before: Cui Weixiong

Inventor before: Yan Wenchao

CB03 Change of inventor or designer information
GR01 Patent grant
GR01 Patent grant