将XML上的逗号替换为CSV分析器

问题描述：

我将只包含我尝试实现新功能的部分代码

I’m only going to include the part of the code that I’m trying to implement a new feature

            for counter, st in enumerate( sn.findall('.//SetData') ):
                for k,v in st.attrib.items():
                    if v.startswith("-"):      #If a string startes with - it removes it
                        v = v.replace("-","",1)
                    row['set_data_'+ str(k)] = v
                row["Counter"] = counter        #just a counter in another colummn
                row_data = [row[i] for i in headers]
                writer.writerow(row_data)
                row = defaultdict(str)

要解析的元素之一具有十进制数字，这些数字用逗号而不是点分隔，从而使它们成为字符串

One of the elements that is being parsed has decimals numbers that are separated by a comma and not a dot and thus making them a string

因此，当解析元素时，我希望像这样55,4而不是55.4

So instead when the element is being parsed I wanted the values to be parsed like this 55,4 instead 55.4

当数字之间用点分隔时，它们仍然是整数，这使得进一步使用变得更容易.

When the numbers are separated by dot they are still integers which makes it easier for further use.

答

，您可以根据您的语言环境设置来解析数字.

you can parse the number according to you locale settings.

import locale

locale.setlocale(locale.LC_ALL, 'danish')

s = '1.237,5'
locale.atof(s)

这会将字符串s解析为具有值1237.5

this will parse the string s to a float with value 1237.5

要列出可用的语言环境，请使用:locale.locale_alias

To list available locales use: locale.locale_alias

将XML上的逗号替换为CSV分析器

相关推荐