XML loader returns text? about dataknead HOT 3 CLOSED

Maybe you're directly feeding the URL to Knead()? Unfortunately dataknead doesn't do anything with URLs, you need to use them in tandem with a HTTP request library, like requests. This works for with me (converting to JSON):

from dataknead import Knead
import requests

req = requests.get("http://www.nvon-biologie-itembank.nl/xml/nvon.xml")
Knead(req.text, parse_as = "xml").write("data.json", indent = 4)

from dataknead.

Sorry I did not explain well. The file mentioned was downloaded before I loaded it into Knead.
So:
from dataknead import Knead
file_in = "nvon.xml"
file_out = "test.csv"

Knead(file_in).write(file_out)

The output test.csv on my machine reads:
metadata

"OrderedDict([('subject', [OrderedDict([('text', 'Ademhaling = ah'), ('subsubject', [OrderedDict([('text', 'ademhaling - bloed = ab')]), OrderedDict([('text', 'ademhaling - bloed alcohol = aba')]) etcetera

from dataknead.

Ah yes, now i get it. Unfortunately, this is expected behaviour. CSV is inherently a two-dimensional format (rows and columns), while XML and JSON are nested. No library is going to solve that for you. You either need to write a mapping on how the nested data is going to be transformed to CSV, or use a nested structure like JSON or XML.

Knead does give you a couple of utilities for that, but mostly you'll want to use Python features like list comprehensions. Note that you can do:

data = Knead(in_file).data()

To get your input XML data as a native Python data structure. After that you can do something like:

Knead(data).write(out_file)

from dataknead.