How to convert a pandas Dataframe to a xml tree format like pattern

Question

I have a Dataframe ,you can have it by running :

import pandas as pd
from io import StringIO

df = """    
Name        Type     Format
loan1        i       type:num;width:10
loan2        a       type:char;width:2
loan3        i       type:date;width:8;dec:0

"""
df= pd.read_csv(StringIO(df.strip()), sep='\s\s+', engine='python')

I want to receive something like this:

<th name="loan1" type="i" format="type:num;width:10">loan1</th>
<th name="loan2" type="a" format="type:char;width:2">loan2</th>
<th name="loan3" type="i" format="type:date;width:8;dec:0">loan3</th>

It can be either string in txt or a xml file , Any friend can help ?

Answer 1

Create a format template then map each record in the dataframe to the format template and write the formatted record to the file

with open('data.txt', 'w') as file:
    fmt = '<th name="{Name}" type="{Type}" format="{Format}">{Name}</th>\n'
    for r in df.to_dict('records'):
        file.write(fmt.format_map(r))

Result

# data.txt
<th name="loan1" type="i" format="type:num;width:10">loan1</th>
<th name="loan2" type="a" format="type:char;width:2">loan2</th>
<th name="loan3" type="i" format="type:date;width:8;dec:0">loan3</th>