有规律的复杂字段，运用正则表达式提取关键字段

最新推荐文章于 2021-11-02 11:44:13 发布

python_Allen

最新推荐文章于 2021-11-02 11:44:13 发布

阅读量446

点赞数

文章标签：正则表达式

本文链接：https://blog.youkuaiyun.com/python_Allen/article/details/106799623

版权

这篇博客介绍了如何利用正则表达式从一系列复杂的字段中提取`interCarriFreq`后面的数值。内容涉及到在Python中使用`re.findall()`函数，通过对数据帧的操作来获取目标数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

frlist2=[] #2维数组放置频点组
str=‘[{lbInterFreqPriority=254, perFCLBCUExeThrd=0, enDcPerQCIIFMeaGrpCfg=0, supportInterFHO4QCI1=0, softUpMigUETarFreqInd=0, interFreqULCASelfCfgInd=1, interFMeasBW=5, clbInterFreqPriority=0, interFreqSupCellType=0, interFreqANRInd=0, endcPccFreqPrio=255, interFreqMeasPerformance=0, enDcEutranFreqPSHOMeasInd=1, bigSRVHOTargetFreqPriDL=0, perFDLPDCCHCCELBExeThrd=0, perFULCLBPRBExeThrd=0, caReselInterFreqPriority=0, srvHOTargetFreqPriUL=0, eutranFreqPSHOMeasInd=1, scellFreqPriority=255, migBaseUEPosiTarFPri=0, offsetFreq=15, eutranFreqRdPriority=0, interCarriFreq=2585, hlMigrtEutranFreqPrio=0, lbInterFreqOfn=15, perFDLCLBPRBExeThrd=0, perFULPDCCHCCELBExeThrd=0, perFDLPRBLBExeThrd=0, perQCIInterFreqMeaGrpCfg=0, interFVoiceAbility=1, overlapDifferRSRPThd=0, eutranFreqVTHOMeasInd=1, voLTEQualHOFreqMeasPri=1, interFreqANRDelInd=0, perFULPRBLBExeThrd=0, interFreqCASCInd=1, perFLBCUExeThrd=0, freqBandInd=38}, {lbInterFreqPriority=254, perFCLBCUExeThrd=0, enDcPerQCIIFMeaGrpCfg=0, supportInterFHO4QCI1=0, softUpMigUETarFreqInd=0, interFreqULCASelfCfgInd=1, interFMeasBW=5, clbInterFreqPriority=0, interFreqSupCellType=0, interFreqANRInd=0, endcPccFreqPrio=255, interFreqMeasPerformance=0, enDcEutranFreqPSHOMeasInd=1, bigSRVHOTargetFreqPriDL=0, perFDLPDCCHCCELBExeThrd=0, perFULCLBPRBExeThrd=0, caReselInterFreqPriority=0, srvHOTargetFreqPriUL=0, eutranFreqPSHOMeasInd=1, scellFreqPriority=255, migBaseUEPosiTarFPri=0, offsetFreq=15, eutranFreqRdPriority=0, interCarriFreq=2330, hlMigrtEutranFreqPrio=0, lbInterFreqOfn=15, perFDLCLBPRBExeThrd=0, perFULPDCCHCCELBExeThrd=0, perFDLPRBLBExeThrd=0, perQCIInterFreqMeaGrpCfg=0, interFVoiceAbility=1, overlapDifferRSRPThd=0, eutranFreqVTHOMeasInd=1, voLTEQualHOFreqMeasPri=1, interFreqANRDelInd=0, perFULPRBLBExeThrd=0, interFreqCASCInd=1, perFLBCUExeThrd=0, freqBandInd=40}, {lbInterFreqPriority=254, perFCLBCUExeThrd=0, enDcPerQCIIFMeaGrpCfg=0, supportInterFHO4QCI1=0, softUpMigUETarFreqInd=0, interFreqULCASelfCfgInd=1, interFMeasBW=5, clbInterFreqPriority=0, interFreqSupCellType=0, interFreqANRInd=0, endcPccFreqPrio=255, interFreqMeasPerformance=0, enDcEutranFreqPSHOMeasInd=1, bigSRVHOTargetFreqPriDL=0, perFDLPDCCHCCELBExeThrd=0, perFULCLBPRBExeThrd=0, caReselInterFreqPriority=0, srvHOTargetFreqPriUL=0, eutranFreqPSHOMeasInd=1, scellFreqPriority=255, migBaseUEPosiTarFPri=0, offsetFreq=15, eutranFreqRdPriority=0, interCarriFreq=2604.8, hlMigrtEutranFreqPrio=0, lbInterFreqOfn=15, perFDLCLBPRBExeThrd=0, perFULPDCCHCCELBExeThrd=0, perFDLPRBLBExeThrd=0, perQCIInterFreqMeaGrpCfg=0, interFVoiceAbility=1, overlapDifferRSRPThd=0, eutranFreqVTHOMeasInd=1, voLTEQualHOFreqMeasPri=1, interFreqANRDelInd=0, perFULPRBLBExeThrd=0, interFreqCASCInd=1, perFLBCUExeThrd=0, freqBandInd=38}, {lbInterFreqPriority=255, perFCLBCUExeThrd=0, enDcPerQCIIFMeaGrpCfg=0, supportInterFHO4QCI1=0, softUpMigUETarFreqInd=0, interFreqULCASelfCfgInd=1, interFMeasBW=0, clbInterFreqPriority=255, interFreqSupCellType=0, interFreqANRInd=0, endcPccFreqPrio=255, interFreqMeasPerformance=0, enDcEutranFreqPSHOMeasInd=1, bigSRVHOTargetFreqPriDL=0, perFDLPDCCHCCELBExeThrd=0, perFULCLBPRBExeThrd=0, caReselInterFreqPriority=0, srvHOTargetFreqPriUL=0, eutranFreqPSHOMeasInd=1, scellFreqPriority=255, migBaseUEPosiTarFPri=0, offsetFreq=15, eutranFreqRdPriority=0, interCarriFreq=1815, hlMigrtEutranFreqPrio=0, lbInterFreqOfn=15, perFDLCLBPRBExeThrd=0, perFULPDCCHCCELBExeThrd=0, perFDLPRBLBExeThrd=0, perQCIInterFreqMeaGrpCfg=0, interFVoiceAbility=1, overlapDifferRSRPThd=-4.5, eutranFreqVTHOMeasInd=1, voLTEQualHOFreqMeasPri=1, interFreqANRDelInd=0, perFULPRBLBExeThrd=0, interFreqCASCInd=1, perFLBCUExeThrd=0, freqBandInd=3}, {lbInterFreqPriority=0, perFCLBCUExeThrd=0, enDcPerQCIIFMeaGrpCfg=0, supportInterFHO4QCI1=0, softUpMigUETarFreqInd=0, interFreqULCASelfCfgInd=1, interFMeasBW=2, clbInterFreqPriority=0, interFreqSupCellType=0, interFreqANRInd=0, endcPccFreqPrio=255, interFreqMeasPerformance=0, enDcEutranFreqPSHOMeasInd=1, bigSRVHOTargetFreqPriDL=0, perFDLPDCCHCCELBExeThrd=0, perFULCLBPRBExeThrd=0, caReselInterFreqPriority=0, srvHOTargetFreqPriUL=0, eutranFreqPSHOMeasInd=1, scellFreqPriority=255, migBaseUEPosiTarFPri=0, offsetFreq=15, eutranFreqRdPriority=0, interCarriFreq=939, hlMigrtEutranFreqPrio=0, lbInterFreqOfn=15, perFDLCLBPRBExeThrd=0, perFULPDCCHCCELBExeThrd=0, perFDLPRBLBExeThrd=0, perQCIInterFreqMeaGrpCfg=0, interFVoiceAbility=1, overlapDifferRSRPThd=0, eutranFreqVTHOMeasInd=1, voLTEQualHOFreqMeasPri=1, interFreqANRDelInd=0, perFULPRBLBExeThrd=0, interFreqCASCInd=1, perFLBCUExeThrd=0, freqBandInd=8}, {lbInterFreqPriority=254, perFCLBCUExeThrd=0, enDcPerQCIIFMeaGrpCfg=0, supportInterFHO4QCI1=0, softUpMigUETarFreqInd=0, interFreqULCASelfCfgInd=1, interFMeasBW=5, clbInterFreqPriority=0, interFreqSupCellType=0, interFreqANRInd=0, endcPccFreqPrio=255, interFreqMeasPerformance=0, enDcEutranFreqPSHOMeasInd=1, bigSRVHOTargetFreqPriDL=0, perFDLPDCCHCCELBExeThrd=0, perFULCLBPRBExeThrd=0, caReselInterFreqPriority=0, srvHOTargetFreqPriUL=0, eutranFreqPSHOMeasInd=1, scellFreqPriority=255, migBaseUEPosiTarFPri=0, offsetFreq=15, eutranFreqRdPriority=0, interCarriFreq=2349.8, hlMigrtEutranFreqPrio=0, lbInterFreqOfn=15, perFDLCLBPRBExeThrd=0, perFULPDCCHCCELBExeThrd=0, perFDLPRBLBExeThrd=0, perQCIInterFreqMeaGrpCfg=0, interFVoiceAbility=1, overlapDifferRSRPThd=0, eutranFreqVTHOMeasInd=1, voLTEQualHOFreqMeasPri=1, interFreqANRDelInd=0, perFULPRBLBExeThrd=0, interFreqCASCInd=1, perFLBCUExeThrd=0, freqBandInd=40}, {lbInterFreqPriority=255, perFCLBCUExeThrd=0, enDcPerQCIIFMeaGrpCfg=0, supportInterFHO4QCI1=0, softUpMigUETarFreqInd=0, interFreqULCASelfCfgInd=1, interFMeasBW=3, clbInterFreqPriority=255, interFreqSupCellType=0, interFreqANRInd=0, endcPccFreqPrio=255, interFreqMeasPerformance=0, enDcEutranFreqPSHOMeasInd=1, bigSRVHOTargetFreqPriDL=0, perFDLPDCCHCCELBExeThrd=0, perFULCLBPRBExeThrd=0, caReselInterFreqPriority=0, srvHOTargetFreqPriUL=0, eutranFreqPSHOMeasInd=1, scellFreqPriority=255, migBaseUEPosiTarFPri=0, offsetFreq=15, eutranFreqRdPriority=0, interCarriFreq=1909.4, hlMigrtEutranFreqPrio=0, lbInterFreqOfn=15, perFDLCLBPRBExeThrd=0, perFULPDCCHCCELBExeThrd=0, perFDLPRBLBExeThrd=0, perQCIInterFreqMeaGrpCfg=0, interFVoiceAbility=1, overlapDifferRSRPThd=0, eutranFreqVTHOMeasInd=1, voLTEQualHOFreqMeasPri=1, interFreqANRDelInd=0, perFULPRBLBExeThrd=0, interFreqCASCInd=1, perFLBCUExeThrd=0, freqBandInd=39}, {lbInterFreqPriority=254, perFCLBCUExeThrd=0, enDcPerQCIIFMeaGrpCfg=0, supportInterFHO4QCI1=0, softUpMigUETarFreqInd=0, interFreqULCASelfCfgInd=0, interFMeasBW=0, clbInterFreqPriority=0, interFreqSupCellType=0, interFreqANRInd=0, endcPccFreqPrio=255, interFreqMeasPerformance=0, enDcEutranFreqPSHOMeasInd=1, bigSRVHOTargetFreqPriDL=0, perFDLPDCCHCCELBExeThrd=0, perFULCLBPRBExeThrd=0, caReselInterFreqPriority=0, srvHOTargetFreqPriUL=0, eutranFreqPSHOMeasInd=1, scellFreqPriority=255, migBaseUEPosiTarFPri=0, offsetFreq=15, eutranFreqRdPriority=0, interCarriFreq=2624.6, hlMigrtEutranFreqPrio=0, lbInterFreqOfn=15, perFDLCLBPRBExeThrd=0, perFULPDCCHCCELBExeThrd=0, perFDLPRBLBExeThrd=0, perQCIInterFreqMeaGrpCfg=0, interFVoiceAbility=1, overlapDifferRSRPThd=-4.5, eutranFreqVTHOMeasInd=1, voLTEQualHOFreqMeasPri=1, interFreqANRDelInd=0, perFULPRBLBExeThrd=0, interFreqCASCInd=1, perFLBCUExeThrd=0, freqBandInd=41}]’

frlist2.append(re.findall(“interCarriFreq=(\d+.?\d)”,all_total.iloc[i,5]))

复杂字段，提取：interCarriFreq=之后的数字，用上述正则表达式完成