I have a CSV file that has to be parsed and exported to a custom XML format with several conditional rules. Attached is a sample of the CSV.
Some custom XML rules include:
- if "Bad Landing" column is 1, export <BAD-LANDING>a</BAD-LANDING>
- if "Bad Landing" column is 2, export <BAD-LANDING>aa</BAD-LANDING>
- if GPS exists, export as a top level element
- if Boulder Name exists, export as a top level element
- if Consensus Grade is V0, V1, or V2, export using the tag <GRADE-EASY>
- if Consensus Grade is V3, V4, or V5, export using the tag <GRADE-MEDIUM>
- export a dummy element in each <TICKBOX>
There are about 15 of these simple rules. The script should be written in something I can easily modify and run locally, perhaps Python.
Hi there,
Quick and easy. I can have this script written in PHP.
I have a 99% project completion rate and a 4.99 reputation (out of 5.0 from over a thousand projects.
Thanks.
Regards,
Rajesh Soni.
I am well equip to this kind of task, can handle it pretty well. I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements.
What about php. I can do this easily in php but not python. Can we discuss further and proceed. I can comment each line so it will be easy for you to edit.. Thank you - JOHN
I have delivered many similar data processing tasks over the years, converting data to and from CSV. I'd be happy to write a Python script that would be easy for you to maintain and expand on.