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.
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,