从 x.dat 解析到 x.csv 时将字符串更改为特定整数？

Question

我在 x.dat 中有如下数据：1::F::1::10::480672::M::56::16::700723::M::25::15::55117我想通过将M转换为1和F转换为2来转换为x.csv，因此csv中的新结果是：1,2,1,10,480672,1,56,16,700723,1,25,15,55117如何在 Python 中做到这一点？

Answer 1

使用replace功能：

with open("x.csv", "w") as fw:

    with open("x.dat", "r") as fr:

        for line in fr:

            new_line = line.replace("::", ",").replace("F", "2").replace("M", "1")

            fw.write(new_line)

使用re模块：

import re

rep = {

    "F": "2",

    "M": "1",

    "::": ",",

}

rep = dict((re.escape(k), v) for k, v in rep.iteritems())

pattern = re.compile("|".join(rep.keys()))

with open("x.csv", "w") as fw:

    with open("x.dat", "r") as fr:

        for line in fr:

            new_line = pattern.sub(lambda m: rep[re.escape(m.group(0))], line)

            fw.write(new_line)

Answer 2

这应该有效：

with open("x.dat") as f:

    with open("x.csv", "w") as f1:

        for line in f:

            m= line.split("::")

            if(m[1]=='M'):

                m[1]=1

            else:

                m[1]=2

            for ele in m:

                f1.write(str(ele)+',')