I need a Python 3.6 script for making XML's to CSV
- or -
Post a project like this2263
€20(approx. $22)
- Posted:
- Proposals: 4
- Remote
- #1872161
- Completed
Description
Experience Level: Expert
Estimated project duration: 1 day or less
General information for the business: Data manipulation
Description of requirements/functionality: I need a Python script that will do the following when run:
- check the folder for XML files
- select all XML files and output CSV files containing the data
For an experienced Python programmer, this is no more than an hour task.
Specific technologies required: XML, CSV, Python
Extra notes: Attached you will find an XML for this project, in which i have removed all the personal and identification data and replaced them with text describing what type of information each line contains.
If you read "text_string" it means that in there will be some name or other text in the full XML, if you read "integer" there will be some numbers in that line, etc.
The final script will be used in Windows computer by non-technical personnel, so inside the script add the following:
automatically select any XML file found in that directory and parse it to a CSV - Excel ready.
automatically add the string "_edited.csv" in the initial name of the XML file. If the original file was named "223344.xml" the CSV output file should be named "223344_edited.csv"
Data to be Parsed:
All the data starting from integer up to will be added in every new row.
So, every new row will always contain the same data ( up to ) and one PostenListen.
Next row again the same ( up to ) data and the next PostenListen. And this will continue for as many times as PostenListen records exist.
Description of requirements/functionality: I need a Python script that will do the following when run:
- check the folder for XML files
- select all XML files and output CSV files containing the data
For an experienced Python programmer, this is no more than an hour task.
Specific technologies required: XML, CSV, Python
Extra notes: Attached you will find an XML for this project, in which i have removed all the personal and identification data and replaced them with text describing what type of information each line contains.
If you read "text_string" it means that in there will be some name or other text in the full XML, if you read "integer" there will be some numbers in that line, etc.
The final script will be used in Windows computer by non-technical personnel, so inside the script add the following:
automatically select any XML file found in that directory and parse it to a CSV - Excel ready.
automatically add the string "_edited.csv" in the initial name of the XML file. If the original file was named "223344.xml" the CSV output file should be named "223344_edited.csv"
Data to be Parsed:
All the data starting from integer up to will be added in every new row.
So, every new row will always contain the same data ( up to ) and one PostenListen.
Next row again the same ( up to ) data and the next PostenListen. And this will continue for as many times as PostenListen records exist.
Theodor D.
100% (18)Projects Completed
18
Freelancers worked with
10
Projects awarded
53%
Last project
12 Feb 2020
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you offer a realistic budget?
580191
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies