使用Python解析文本文件 [英] Parsing text files using Python

问题描述

我对Python非常陌生，希望使用它来解析文本文件.该文件具有以下格式的250-300行:

I am very new to Python and am looking to use it to parse a text file. The file has between 250-300 lines of the following format:

---- Mark Grey ([e-mail]) changed status from Busy to Available @ 14/07/2010 16:32:36 ----
----  Silvia Pablo ([e-mail]) became Available @ 14/07/2010 16:32:39 ----

我需要将以下信息存储到该文件中所有条目的另一个文件(excel或文本)中

I need to store the following information into another file (excel or text) for all the entries from this file

UserName/ID  Previous Status New Status Date Time

因此，对于上面输入的内容，我的结果文件应该看起来像这样

So my result file should look like this for the above entried

Mark Grey/[e-mail]  Busy Available 14/07/2010 16:32:36
Silvia Pablo/[e-mail]  NaN  Available 14/07/2010 16:32:39

预先感谢

任何帮助将不胜感激

推荐答案

让您入门:

result = []
regex = re.compile(
    r"""^-*\s+
    (?P<name>.*?)\s+
    \((?P<email>.*?)\)\s+
    (?:changed\s+status\s+from\s+(?P<previous>.*?)\s+to|became)\s+
    (?P<new>.*?)\s+@\s+
    (?P<date>\S+)\s+
    (?P<time>\S+)\s+
    -*$""", re.VERBOSE)
with open("inputfile") as f:
    for line in f:
        match = regex.match(line)
        if match:
            result.append([
                match.group("name"),
                match.group("email"),
                match.group("previous")
                # etc.
            ])
        else:
            # Match attempt failed

将为您提供比赛各部分的数组.然后，建议您使用 csv module 以标准格式存储结果

will get you an array of the parts of the match. I'd then suggest you use the csv module to store the results in a standard format.

这篇关于使用Python解析文本文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！