Hi Patrick,

i've worked with Python+Pandas about a month ago, 1 line of code should almost do this job.

Official website: https://pandas.pydata.org/

An idea of the code:

import pandas as pd

pd.read_json(your_file_or_string).to_csv(export_file)

See you,

Marco

Il 2019-07-25 19:02 Patrick Ohnewein ha scritto:

Hi lugbz friends,

I have started looking for ways to convert json data into csv format.

For example to convert the json response provided by the Open Data Hub API about the list of accommodations:

http://tourism.opendatahub.bz.it/swagger/ui/index#/Accommodation/Accommodation_GetAccommodations

Looking for simple shell tools, I came across jq, which is a powerful tool to filter json streams.

http://manpages.ubuntu.com/manpages/bionic/man1/jq.1.html

Usually it has to be used on the shell, but for playing there is even a handy website providing an online installation of the tool:

https://jqplay.org/

Even if I haven't been able yet to convert the json into csv format, still, I think it is a cool tool and worthwhile to be shared with you.

Did someone on the list already use it?

Best regards
Patrick

_______________________________________________
http://lists.lugbz.org/cgi-bin/mailman/listinfo/lugbz-list