python - 使用标签构建 CSV 文件

Question

首先，我需要理论部分的帮助。(如果有人已经遇到过这个问题并且有示例代码，我们将不胜感激)

假设您有一种产品，例如肥皂。内部描述将有很多标签(内部文本文件)。

line 1 productName:SOAP1, productCategory:Bath, productSubCategory: Soap, bla, bla, bla
line 2 productName:SOAP2, productCategory:Bath, productSubCategory: Soap, bla, bla, bla
line 3 productName:SOAP3, productCategory:Bath, productSubCategory: Soap, bla, bla, bla

列都将具有“:”

我需要使用 python 代码将这些标签转换为 CSV，如下所示:

productName    productCategory    productSubCategory
  SOAP1             Bath                 Soap
  SOAP2             Bath                 Soap
  SOAP3             Bath                 Soap

我不确定最好的方法是什么。

Answer 1

这允许您拥有动态 header 。

import pandas as pd

df = pd.read_csv(r'yourfile.txt',header=None)
print (df)
#                0                     1                         2
#productName:SOAP1, productCategory:Bath, productSubCategory: Soap
#productName:SOAP2, productCategory:Bath, productSubCategory: Soap
#productName:SOAP3, productCategory:Bath, productSubCategory: Soap

headerlist = []
for x in df.loc[0,:]:
    headerlist.append(x.split(':')[0])

for x in df.index:
    for y in df.columns:
        df.loc[x,y] = df.loc[x,y].split(':')[1]
df.columns = headerlist

print (df)
#  productName  productCategory  productSubCategory
#0       SOAP1             Bath                Soap
#1       SOAP2             Bath                Soap
#2       SOAP3             Bath                Soap