{"id":126224,"date":"2022-07-03T09:44:31","date_gmt":"2022-07-03T09:44:31","guid":{"rendered":"https:\/\/blog.finxter.com\/?p=452015"},"modified":"2022-07-03T09:44:31","modified_gmt":"2022-07-03T09:44:31","slug":"csv-to-xml-how-to-convert-in-python","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2022\/07\/03\/csv-to-xml-how-to-convert-in-python\/","title":{"rendered":"CSV to XML \u2013 How to Convert in Python?"},"content":{"rendered":"
\n
\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n
4\/5 – (1 vote) <\/div>\n<\/div>\n

Problem Formulation<\/h2>\n
\n
\"python<\/figure>\n<\/div>\n

Input<\/strong>: You have some data in a CSV file stored in 'my_file.csv'<\/code> where the first row is the header and the remaining rows are values associated to the column names in the header.<\/p>\n

Name,Job,Age,Income<\/strong>\nAlice,Programmer,23,110000\nBob,Executive,34,90000\nCarl,Sales,45,50000<\/code><\/pre>\n
Desired Output<\/strong>: You want to store the data in an XML file 'my_file.xml'<\/code> so that each row is represented by an XML <row><\/code> tag and each column value is associated with a specific column header tag. <\/p>\n
<data> <row id='Alice'><\/code>\n <Name>Alice<\/Name><\/code>\n <Job>Programmer<\/Job><\/code>\n <Age>23<\/Age><\/code>\n <Income>110000<\/Income> <\/row>\n <row id='Bob'><\/code>\n <Name>Bob<\/Name><\/code>\n <Job>Executive<\/Job><\/code>\n <Age>34<\/Age><\/code>\n <Income>90000<\/Income> <\/row><\/code><\/code>\n <row id='Carl'><\/code>\n <Name>Carl<\/Name><\/code>\n <Job>Sales<\/Job><\/code>\n <Age>45<\/Age><\/code>\n <Income>50000<\/Income> <\/row>\n<\/data><\/code><\/pre>\n
Python CSV to XML – Basic Example<\/h2>\n
You can convert a CSV to an XML using the following approach:<\/p>\n