XML to JSON in python

Asked Feb 10 '22 at 08:28

Active Feb 10 '22 at 14:43

Viewed 181 times

I have been trying to convert a dataset file in xml format to json. I tried many solutions, non worked. I always got the same error:

ExpatError: not well-formed (invalid token): line 67667, column 103

I tried untangle, xmltodict, pandas_read_xml

This is my code for my attempt with pandas_read_xml:

import pandas_read_xml as pdx
df = pdx.read_xml("Ryiadh_utf_8.xml")

edited Feb 10 '22 at 14:43

buddemat

asked Feb 10 '22 at 08:28

ahad

better use some xml library to parse, then to json. `lmxl` is an option. – Lei Yang Feb 10 '22 at 08:30
1

Jason or JSON?? – luk2302 Feb 10 '22 at 08:31
Yor xml is invalid - fix it – balderman Feb 10 '22 at 09:29
1

There seems to be something wrong in your input, check the error message: https://docs.python.org/3/library/pyexpat.html#xml.parsers.expat.errors.messages – buddemat Feb 10 '22 at 14:47
@luk2302 sorry it's JSON – ahad Feb 14 '22 at 11:46
@balderman How ? – ahad Feb 14 '22 at 11:46
@ahad Navigate to line 67667, column 103 and see what is wrong there. – balderman Feb 14 '22 at 12:01

0 Answers0