Oct-15-2022, 02:20 PM
Hi,
I generated xml string and want to add root node:
#lets create a dataframe
df=pd.DataFrame({'A':[1,2,3],'B':['a','b','c']})
<A>1</A>
<B>a</B
</item>
<item>
<A>2</A>
<B>b</B>
</item>
<item>
<A>3</A>
<B>c</B>
</item>
...
========================
Add root node:
I generated xml string and want to add root node:
#lets create a dataframe
df=pd.DataFrame({'A':[1,2,3],'B':['a','b','c']})
def to_xml(df): def row_xml(row): xml = ['<item>'] for i, col_name in enumerate(row.index): xml.append(' <{0}>{1}</{0}>'.format(col_name, row.iloc[i])) xml.append('</item>') return '\n'.join(xml) res = '\n'.join(df.apply(row_xml, axis=1)) return(res) 1 to_xml(df)<item>
<A>1</A>
<B>a</B
</item>
<item>
<A>2</A>
<B>b</B>
</item>
<item>
<A>3</A>
<B>c</B>
</item>
...
========================
Add root node:
<Header> <Name></Names> <Release><</software> <Header> <Values> <item> <A>1</A> <B>a</B </item> <item> <A>2</A> <B>b</B> </item> <item> <A>3</A> <B>c</B> </item> <Values>