英文:
Perform multiple regex operations on each line of text file and store extracted data in respective column
问题
以下是您要的翻译部分：
import pandas as pd
import re
columns = ['Request Type', 'Channel', 'AG']
exp = re.compile(r'<(.*)\s+xmlns'
r'<Channel>(.*?)</Channel>'
r'<Param Name="AG">.*?<Value>(.*?)</Value>')
final = []
with open("test.txt") as f:
for line in f:
result = re.search(exp, line)
final.append(result)
df = pd.DataFrame(final, columns)
print(df)
import pandas as pd
import re
columns = ['Request Type', 'Channel', 'AG']
exp = re.compile(r'<(.*)\s+xmlns'
r'<Channel>(.*?)</Channel>'
r'<Param Name="AG">.*?<Value>(.*?)</Value>')
final = []
with open("test.txt") as f:
for line in f:
result = re.search(exp, line)
final.append(result)
df = pd.DataFrame(final, columns)
print(df)
您的代码用于从文本文件中提取数据，并创建一个带有请求类型、通道和AG的DataFrame。希望这有助于您实现预期的输出。
英文:
Data in test.txt
<ServiceRQ xmlns:xsi="http://"><SaleInfo><CityCode>DXB</CityCode><CountryCode>EG</CountryCode><Currency>USD</Currency><Channel>TA</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>95HAJSTI</Value></Param></CustomParams></Pricing></ServiceRQ>
<SearchRQ xmlns:xsi="http://"><SaleInfo><CityCode>CPT</CityCode><CountryCode>US</CountryCode><Currency>USD</Currency><Channel>AY</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>56ASJSTS</Value></Param></CustomParams></Pricing></SearchRQ>
<ServiceRQ xmlns:xsi="http://"><SaleInfo><CityCode>BOM</CityCode><CountryCode>AU</CountryCode><Currency>USD</Currency><Channel>QA</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>85ATAKSQ</Value></Param></CustomParams></Pricing></ServiceRQ>
<ServiceRQ ......
<SearchRQ ........
My code:
import pandas as pd
import re
columns = ['Request Type','Channel','AG']
# data = pd.DataFrame
exp = re.compile(r'<(.*)\s+xmlns'
r'<Channel>(.*)</Channel>'
r'<Param Name="AG">.*?<Value>(.*?)</Value>')
final = []
with open(r"test.txt") as f:
for line in f:
result = re.search(exp,line)
final.append(result)
df = pd.DataFrame(final, columns)
print(df)
My expected output is
I want to iterate through each line and to perform the 3 regex operation and extract data from each line in text file
1. r'<(.*)\s+xmlns'
2. r'<Channel>(.*)</Channel>'
3. r'<Param Name="AG">.*?<Value>(.*?)</Value>')
Each regex extract respective data from single line
like
- extract the type of request
- extract the name of channel
- extract the value present for AG
My expected output ExcelSheet
Request Type Channel AG
ServiceRQ TA 95HAJSTI
SearchRQ AY 56ASJSTS
ServiceRQ QA 85ATAKSQ
... ... .....
... .... .....
and so on..
How can I achieve expected output.
答案1
得分: 1
尝试使用这个re，实际上我不知道你的文本内容的其余部分是什么样的，但根据我目前所见，这将适用。result.groups() 将提取所有组的匹配元素，然后在附加之前返回一个元组。
exp = re.compile(r'<(\w+)\s+xmlns.*?>.*?'
r'<Channel>(.*?)</Channel>.*?'
r'<Param Name="AG"><Value>(.*?)</Value></Param>')
final = []
with open("test.txt") as f:
for line in f:
result = re.search(exp, line)
if result:
final.append(result.groups())
df = pd.DataFrame(final, columns=columns)
print(df)
测试代码:
import pandas as pd
import re
columns = ['Request Type', 'Channel', 'AG']
file_data = """
<ServiceRQ xmlns:xsi="http://"><SaleInfo><CityCode>DXB</CityCode><CountryCode>EG</CountryCode><Currency>USD</Currency><Channel>TA</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>95HAJSTI</Value></Param></CustomParams></Pricing></ServiceRQ>
<SearchRQ xmlns:xsi="http://"><SaleInfo><CityCode>CPT</CityCode><CountryCode>US</CountryCode><Currency>USD</Currency><Channel>AY</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>56ASJSTS</Value></Param></CustomParams></Pricing></SearchRQ>
<ServiceRQ xmlns:xsi="http://"><SaleInfo><CityCode>BOM</CityCode><CountryCode>AU</CountryCode><Currency>USD</Currency><Channel>QA</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>85ATAKSQ</Value></Param></CustomParams></Pricing></ServiceRQ>
"""
exp = re.compile(r'<(\w+)\s+xmlns.*?>.*?'
r'<Channel>(.*?)</Channel>.*?'
r'<Param Name="AG"><Value>(.*?)</Value></Param>')
final = []
for line in file_data.splitlines():
result = re.search(exp, line)
if result:
final.append(result.groups())
df = pd.DataFrame(final, columns=columns)
print(df)
Request Type Channel AG
0 ServiceRQ TA 95HAJSTI
1 SearchRQ AY 56ASJSTS
2 ServiceRQ QA 85ATAKSQ
英文:
Try this re, actually I don't Know how the rest of your text content looks like, but this will work with what I have seen so far.<br>
result.groups() will extract matching elements of all groups then return a tuple before appending.
exp = re.compile(r'<(\w+)\s+xmlns.*?>.*?'
r'<Channel>(.*?)</Channel>.*?'
r'<Param Name="AG"><Value>(.*?)</Value>')
final = []
with open(r"test.txt") as f:
for line in f:
result = re.search(exp,line)
if result:
final.append(result.groups())
df = pd.DataFrame(final, columns=columns)
print(df)
Test code:
import pandas as pd
import re
columns = ['Request Type','Channel','AG']
file_data = """
<ServiceRQ xmlns:xsi="http://"><SaleInfo><CityCode>DXB</CityCode><CountryCode>EG</CountryCode><Currency>USD</Currency><Channel>TA</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>95HAJSTI</Value></Param></CustomParams></Pricing></ServiceRQ>
<SearchRQ xmlns:xsi="http://"><SaleInfo><CityCode>CPT</CityCode><CountryCode>US</CountryCode><Currency>USD</Currency><Channel>AY</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>56ASJSTS</Value></Param></CustomParams></Pricing></SearchRQ>
<ServiceRQ xmlns:xsi="http://"><SaleInfo><CityCode>BOM</CityCode><CountryCode>AU</CountryCode><Currency>USD</Currency><Channel>QA</Channel></SaleInfo><Pricing><CustomParams><Param Name="AG"><Value>85ATAKSQ</Value></Param></CustomParams></Pricing></ServiceRQ>
"""
exp = re.compile(r'<(\w+)\s+xmlns.*?>.*?'
r'<Channel>(.*?)</Channel>.*?'
r'<Param Name="AG"><Value>(.*?)</Value>')
final = []
for line in file_data.splitlines():
result = re.search(exp,line)
if result:
final.append(result.groups())
df = pd.DataFrame(final, columns=columns)
print(df)
Request Type Channel AG
0 ServiceRQ TA 95HAJSTI
1 SearchRQ AY 56ASJSTS
2 ServiceRQ QA 85ATAKSQ
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论