Encerrado

Create Python script to combine XML files into JSON format

I have around 130 directories of files that all contain a standard set of XML files:

1. [url removed, login to view]

2. [url removed, login to view]

3. [url removed, login to view]

4. [url removed, login to view]

5. [url removed, login to view]

6. [url removed, login to view]

In total, this means there are 130 directories multiplied by 6 files = 780 files. This is too many files.

I want to take those individual files and combine them into six big JSON files so that each XML file will be packaged into one big JSON. Thus, there will be six JSON files:

1. [url removed, login to view] containing all 130 [url removed, login to view] data

2. [url removed, login to view] containing all 130 [url removed, login to view] data

3. [url removed, login to view] containing all 130 [url removed, login to view] data

4. [url removed, login to view] containing all 130 [url removed, login to view] data

5. [url removed, login to view] containing all 130 [url removed, login to view] data

6. [url removed, login to view] containing all 130 [url removed, login to view] data

In doing this - a new field needs to be added - the directory name so that I know from which directory the file came from.

I then need a seperate way to take those JSON files and convert those into 6 CSV files:

1. [url removed, login to view] containing all 130 [url removed, login to view] data becomes [url removed, login to view]

2. [url removed, login to view] containing all 130 [url removed, login to view] data becomes [url removed, login to view]

3. [url removed, login to view] containing all 130 [url removed, login to view] data becomes [url removed, login to view]

4. [url removed, login to view] containing all 130 [url removed, login to view] data becomes [url removed, login to view]

5. [url removed, login to view] containing all 130 [url removed, login to view] data becomes [url removed, login to view]

6. [url removed, login to view] containing all 130 [url removed, login to view] data becomes [url removed, login to view]

A reduced dataset containing 4 directories is provided for your testing.

The development will need to be completed within 3 hours.

Habilidades: Ciência de Dados, Python

Ver mais: new badges, data set testing, python csv to json, python script, python data, json script, combine, big data testing, json csv python, python json, csv xml python, json csv, convert json csv, format provided, csv json, script convert xml csv, python script convert file csv, python xml file, xml parsing python script, python script create simple mysql database, convert data xml csv format, convert file xml file, combine xml files, convert json file csv, convert json csv file

Acerca do Empregador:
( 5 comentários ) Brantford, Australia

ID do Projeto: #6827935

16 freelancers estão ofertando em média $66 para este trabalho

lafor

Hi there, I can write you a couple of Python scripts for the conversion you need (xml to json and json to csv). It's a fairly simple task, but due to timezone difference (it's evening now where I live) I wouldn't be Mais

$75 USD em 1 dia
(10 Comentários)
5.4
suraj99p

i have done vast amount of work in json, xml parsing. I have also worked with csv reader and writer in python. I have 5 years of experience.

$90 USD em 1 dia
(21 Comentários)
5.2
iticus

Hello, I'm using Python daily for most of my programming needs. I have experience with relevant Python modules such as os, csv, json, xml ElementTree, xml minidom. If you want I can build a quick demo project that Mais

$50 USD em 1 dia
(5 Comentários)
4.6
ghotbinima

Hi, here is my personal website and you can see some of project's here:[url removed, login to view] and if you like we can start discussing I want to improve my completion rate project to help you to reach the final decision. Mais

$30 USD em 1 dia
(6 Comentários)
4.6
dabing1205

Looks OK for me. ##########################################################################################

$55 USD in 2 dias
(10 Comentários)
3.9
stranac

A proposal has not yet been provided

$55 USD in 3 dias
(14 Comentários)
3.8
Fortut

A proposal has not yet been provided

$25 USD em 1 dia
(13 Comentários)
3.7
Darflow

A proposal has not yet been provided

$25 USD in 3 dias
(11 Comentários)
3.6
grammal

I can provide the two python scripts you requested, one to combine xml files in separate folders to 1 JSON file, and the other convert the JSON file to CSV. Input folders: XROOT/ FOLDER1/ [url removed, login to view] Comm Mais

$25 USD em 1 dia
(1 Comentário)
3.4
exansoft

Hello I'm python developer and ready to make your assignment within 3 hours. Could you please provide sample of result json file with a couple of merged xml files and a couple rows for each xml? I would like see how Mais

$50 USD in 0 dias
(1 Comentário)
3.0
bsoist

I am fluent in Python and write programs in it almost daily. Repurposing data like this is my specialty. I can get this done for you quickly. Let's talk details. You will not be disappointed with my work. Google Mais

$278 USD em 1 dia
(2 Comentários)
2.2
chaitanyaubijawe

Hi Sir, I am a expert in this kind of system application handling. I can handle this task for you with 100 % completion and within time. I have knowledge of working on Map reduce of Hadoop framework. Where we hav Mais

$45 USD in 2 dias
(1 Comentário)
0.8
sanjaykumar0407

A proposal has not yet been provided

$55 USD in 2 dias
(0 Comentários)
0.0
xtimesx

Hi, I will be able to do it in a day. I will have to write a Python script to convert the xml structure into json while also adding the directory name into the json object. The task to then convert it into 6 csv fi Mais

$55 USD em 1 dia
(0 Comentários)
0.0
astawiarski

I will make the script configurable via command line parameters. You will be able to run against individual files or whole directories producing results as expected in the original task.

$30 USD em 1 dia
(0 Comentários)
0.0
rkirmizi

A proposal has not yet been provided

$55 USD em 1 dia
(0 Comentários)
0.0
vw7864595vw

I work every day with python. I often process text data in many format including XML in order to extract information.

$83 USD in 3 dias
(0 Comentários)
0.0