Good evening again,
I'm replying to your second post, because I replied to the first. This may be a more specific request than is typically handled on Python tutor. This involves specific knowledge of the xml.etree.ElementTree and pandas.DataFrame objects.
I would appreciate your feedback on whether I correctly wrote my XML. I am exporting a DataFrame and writing into a XML file. I used the ElementTree library. The DataFrame has 11 rows and 8 columns (excluding the index column).
Side note: Hard to know or give any advice without considerably more detail on the data involved. But....
#My schema assumption: #<list> #[<message> #<index>Some number row</index> #<date>Sample text </data> #</message>] #</list>
That shows 6 (XML) elements. This is neither 8 nor 11.
CODE: SELECT ALL <http://www.python-forum.org/viewtopic.php?f=6&t=15261#> document = ET.Element("list") def make_message(document, row): msg = ET.SubElement(document, "message") for field in row.index: field_element = ET.SubElement(msg, field) field_element.text = row[field] return msg def add_to_document(row): return make_message(document, row) #df.apply(add_to_document, axis=0) ---> if I were to import a DataFrame stored in the variable #"df", I would simply APPLY the add_to_document function and COMBINE this into a document ET.dump(document) Thank you, in advance for your help.
This is a more general inquiry and is probably better suited for the lxml (ElementTree) mailing list ...
https://mailman-mail5.webfaction.com/listinfo/lxml ... or maybe the Pandas mailing list: https://groups.google.com/forum/#!forum/pydata Best of luck, -Martin -- Martin A. Brown http://linux-ip.net/ _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
