python - 尝试在熊猫数据框中追加时获得“真”值而不是实际值

Question

下面是我的 python 脚本。我正在尝试解析 xml 文件并尝试将值存储在 pandas 数据框中，以便以后可以将其更改为 csv 文件。

import os
import pandas as pd
import sys
import requests
import xml.etree.ElementTree as ET
from xml.dom import minidom

tree = ET.parse('schedule.xml')
FILENAME = sys.argv[1]
COL_NAMES = ['PODNAME', 'DC', 'Upgrade']
DF = pd.DataFrame(columns = COL_NAMES)
root = tree.getroot()

def parseXml(DF, filePath):

    xmldoc = minidom.parse(filePath)
    PODs= xmldoc.getElementsByTagName("POD")
    name=[]
    DC=[]
    deferUpgrade=[]
    for pod in PODs:
        if pod.hasAttribute("name") and pod.hasAttribute("DC") and pod.hasAttribute("deferUpgrade"):
            DF = DF.append({'PODNAME': pod.getAttribute("name"), 'DC': pod.hasAttribute("DC"), 'Upgrade': pod.hasAttribute("deferUpgrade")}, ignore_index=True)
    return(DF)


DF = parseXml(DF, FILENAME)

下面是 XML 文件

<Schedule xmlns="http://xmlns.xyz.com/fal/downtimeschedule/V1.0">
 <Downtime end="20181020000" id="10001197610_20181027000_201810000" mode="cold" start="20181020000"/>
 <PODS>
  <POD DC="US - Washing" deferUpgrade="true" name="ABCD" patching="Production" EndTime="20181028040000">
   <CR id="12345"/>
   <CR id="12346"/>
   <CR id="123"/>
  </POD>
  <POD DC="US - Washing" deferUpgrade="true" name="ABCD-TEST" patching="Production" EndTime="20181028040000">
   <CR id="12345"/>
   <CR id="12346"/>
   <CR id="123"/>
  </POD>
 </PODS>

当我以第一个参数作为文件名运行我的脚本时，我得到低于输出

     PODNAME    DC Upgrade
0       ABCD  True    True
1  ABCD-TEST  True    True

但是，我希望低于输出。

     PODNAME    DC            Upgrade
0       ABCD  US - Washing    true
1  ABCD-TEST  US - Washing    true

另外，我尝试使用 concat 来克服上述问题，但低于 ouotput

       PODNAME              DC Upgrade
0       [ABCD]  [US - Washing]  [true]
1  [ABCD-TEST]  [US - Washing]  [true]

标签： pythonpandasappend

Answer 1

正如 Nitin 和 Martin 回答的那样，在此处粘贴最终代码。

import os
import pandas as pd
import sys
import requests
import xml.etree.ElementTree as ET
from xml.dom import minidom

tree = ET.parse('schedule.xml')
FILENAME = sys.argv[1]
COL_NAMES = ['PODNAME', 'DC', 'Upgrade']
DF = pd.DataFrame(columns = COL_NAMES)
root = tree.getroot()

def parseXml(DF, filePath):

    xmldoc = minidom.parse(filePath)
    PODs= xmldoc.getElementsByTagName("POD")
    name=[]
    DC=[]
    deferUpgrade=[]
    for pod in PODs:
        if pod.hasAttribute("name") and pod.hasAttribute("DC") and pod.hasAttribute("deferUpgrade"):
            DF = DF.append({'PODNAME': pod.getAttribute("name"), 'DC': pod.getAttribute("DC"), 'Upgrade': pod.getAttribute("deferUpgrade")}, ignore_index=True)
    return(DF)


DF = parseXml(DF, FILENAME)