Breaking News: Grepper is joining You.com. Read the official announcement!

Dataframe to xml in python

Good Gecko answered on August 22, 2023 Popularity 5/10 Helpfulness 1/10

answer Dataframe to xml in python

related pandas dataframe to xml

Dataframe to xml in python

Comment

import io
import xml.etree.ElementTree as ET

import pandas as pd

def build_item_xml(row):
    item1 = ET.SubElement(items, 'Item')
    descriptors = ET.SubElement(item1, 'Descriptors')
    barcode= ET.SubElement(descriptors, 'Barcode')
    barcode.text=row["Descriptors.Barcode"]

    pricing = ET.SubElement(item1, 'Pricing')
    packetcost= ET.SubElement(pricing, 'PackCost')
    packetcost.text=str(row["Pricing.PackCost"])  # cast as without error cannot serialize 0.5625 (type float)
    # etc

    # add other attributes here

    # always return a result
    return row

# mock dataframe with 2 rows based on columns supplied
df = pd.DataFrame({
    "Descriptors.Barcode": ["9770307017919", "9770307017920"],
    "Descriptors.SupplierCode": ["030701791", "030701792"],
    "Descriptors.Description": ["Daily Express (Mon)", "Daily Express (Tues)"],
    "Descriptors.CommodityGroup": [1,2],
    "Pricing.PackCost": [0.5625, 0.5626],
    "Pricing.CostPricePerUnit": [0.5625, 0.5626],
    "Pricing.RetailPrice": [0.75, 0.75],
    "Pricing.ValidFrom": [44193, 44194],
    "Sizing.Packsize": [1, 2],
})

# https://docs.python.org/3/library/xml.etree.elementtree.html#building-xml-documents
import xml.etree.ElementTree as ET

items = ET.Element('Items')

df = df.apply(build_item_xml, axis=1). # this calls build_item_xml per row

ET.dump(items)

Popularity 5/10 Helpfulness 1/10 Language python

Source: www.reddit.com

Tags: dataframe python xml

Link to this answer
Share Copy Link

Contributed on Aug 22 2023

Good Gecko

0 Answers Avg Quality 2/10

Closely Related Answers

pandas dataframe to xml

Comment

import pandas as pd

df = pd.DataFrame([[1.3, 1.4, 5.2],
                   [2.6, 1.4, 4.6],
                   [2.1, 5.6, 4.6]],
                  columns=['A', 'B', 'C'],
                  index=['X', 'Y', 'Z'])

xml_data = ['<root>']
for column in df.columns:
    xml_data.append('<{}>'.format(column))  # Opening element tag
    for field in df.index:
        # writing sub-elements
        xml_data.append('<{0}>{1}</{0}>'.format(field, df[column][field]))
    xml_data.append('</{}>'.format(column))  # Closing element tag
xml_data.append('</root>')

with open('coordinates.xml', 'w') as f:  # Writing in XML file
    for line in xml_data:
        f.write(line)

Popularity 4/10 Helpfulness 1/10 Language python

Source: stackabuse.com

Tags: pandas xml dataframe python

Link to this answer
Share Copy Link

Contributed on Aug 22 2023

Good Gecko

0 Answers Avg Quality 2/10

Dataframe to xml in python

Contents

More Related Answers

Dataframe to xml in python

Closely Related Answers

pandas dataframe to xml

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.