<pre><code>teststring1 = """Step 13 - Iteration 1 Failed: Action: <Update Latest CC Exp Date Record from Epay Account
{DBServer;UserName;Password='', DatabaseName='',Year Offset='-10'}> -> System.Data.SqlTypes.SqlNullValueException1:
Data is Null. This method or property cannotbecalled on Null values. -> System.Data.SqlTypes.SqlNullValueException2: Data is Null.
-> System.Data.SqlTypes.SqlNullValueException21: -> System.Data.SqlTypes.SqlNullValueException22: -> System.Data.SqlTypes.SqlNullValueException23:
-> System.Data.SqlTypes.SqlNullValueException24: """
teststring2 = """Step 13 - Iteration 1 Failed: Action: <Update Latest CC Exp Date Record from Epay Account
{DBServer;UserName;Password='', DatabaseName='',Year Offset='-10'}> -> System.Data.SqlTypes.SqlNullValueException3:
Data is Null. This method or property cannotbecalled on Null values. -> System.Data.SqlTypes.SqlNullValueException4: Data is Null."""
teststring3 = """Step 13 - Iteration 1 Failed: Action: <Update Latest CC Exp Date Record from Epay Account
{DBServer;UserName;Password='', DatabaseName='',Year Offset='-10'}> -> System.Data.SqlTypes.SqlNullValueException5:
Data is Null. This method or property cannotbecalled on Null values. -> System.Data.SqlTypes.SqlNullValueException6: Data is Null."""
teststring4 = """Step 13 - Iteration 1 Failed: Action: <Update Latest CC Exp Date Record from Epay Account
{DBServer;UserName;Password='', DatabaseName='',Year Offset='-10'}> -> System.Data.SqlTypes.SqlNullValueException7:
Data is Null. This method or property cannotbecalled on Null values. -> System.Data.SqlTypes.SqlNullValueException8: Data is Null."""
teststring5 = """Step 13 - Iteration 1 Failed: Action: <Update Latest CC Exp Date Record from Epay Account
{DBServer;UserName;Password='', DatabaseName='',Year Offset='-10'}> -> System.Data.SqlTypes.SqlNullValueException9:
Data is Null. This method or property cannotbecalled on Null values. -> System.Data.SqlTypes.SqlNullValueException10: Data is Null."""
teststring6 = """Step 13 - Iteration 1 Failed: Action: <Update Latest CC Exp Date Record from Epay Account
{DBServer;UserName;Password='', DatabaseName='',Year Offset='-10'}> -> System.Data.SqlTypes.SqlNullValueException11:
Data is Null. This method or property cannotbecalled on Null values. -> System.Data.SqlTypes.SqlNullValueException12: Data is Null."""
values = [[teststring1], [teststring2], [teststring3], [teststring4], [teststring5], [teststring6]]
header = ['ErrorMessage']
df = pd.DataFrame(values, columns=header)
exceptions = df['ErrorMessage'].str.extractall(r" -> ([^:]+): ")
</code></pre>
<p><strong>extractall返回一个新的多索引DataFrame,其中第一个索引将匹配原始DataFrame索引,第二个索引将是提取或匹配的次数。原始数据帧和新数据帧不兼容。</strong></p>
<pre><code> 0
match
0 0 System.Data.SqlTypes.SqlNullValueException1
1 System.Data.SqlTypes.SqlNullValueException2
2 System.Data.SqlTypes.SqlNullValueException21
3 System.Data.SqlTypes.SqlNullValueException22
4 System.Data.SqlTypes.SqlNullValueException23
5 System.Data.SqlTypes.SqlNullValueException24
1 0 System.Data.SqlTypes.SqlNullValueException3
1 System.Data.SqlTypes.SqlNullValueException4
2 0 System.Data.SqlTypes.SqlNullValueException5
1 System.Data.SqlTypes.SqlNullValueException6
3 0 System.Data.SqlTypes.SqlNullValueException7
1 System.Data.SqlTypes.SqlNullValueException8
4 0 System.Data.SqlTypes.SqlNullValueException9
1 System.Data.SqlTypes.SqlNullValueException10
5 0 System.Data.SqlTypes.SqlNullValueException11
1 System.Data.SqlTypes.SqlNullValueException12
</code></pre>