Convert Python's pickled data into XML, or excel format

Hello folks,

I have multiple data files, stored in python's .pkl format. I need to create some utility, which would unpickle data, decode them and save in XML or any other readable format (or into MS Excel), so it could be later imported into Oracle database.

A test file which needs to be converted is attached.

As an output is expected, an utility (script) which will read all files in selected directory and converts them to desired formats (xml) into output directory.

Should be an easy task for somebody who is familiar with python.



A basic script to start:

import pprint, pickle, json

pkl_file = open('[url removed, login to view]', 'rb')

data1 = [url removed, login to view](pkl_file)

[url removed, login to view](data1) >> print unpickled structired data. This output needs to be converted into XML format

data_json = [url removed, login to view](data1) >> this fails

[url removed, login to view]()

Import into Oracle database in not part of this project.

Beceriler: Excel, Oracle, Python, XML

Daha fazlasını gör: formats in excel, xml excel, RB, python task, python excel, oracle data, i need to load json, excel python, excel format, database in excel format, python read, convert excel python, json format excel, load excel, python json, convert json xml, import xml oracle, excel file convert, save excel read, python json database, excel create xml, xml excel format, excel convert json, python convert file, need excel format

İşveren Hakkında:
( 2 değerlendirme ) Uherske Hradište, Czech Republic

Proje NO: #6516871



Hello, I am a python developer. I will be glad to help. I can use openpyxl package to create excel output file for you. Or using lxml library for xml generation. Regards,

%selectedBids___i_period_sub_7% gün içinde 40%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(19 Değerlendirme)