On Wednesday, June 17, 2015 at 11:00:24 AM UTC-4, Saran A wrote:
> I would like to have this JSON object written out to a CSV file so that the
> keys are header fields (for each of the columns) and the values are values
> that are associated with each header field. Is there a best practice for
> working with this? Ideally I would like to recursively iterate through the
> key value pairs. Thank you in advance. I am using Python 3.4 on Windows. My
> editor is Sublime 2.
>
> {
> "CF": {
> "A": "5",
> "FEC": "1/1/0001 12:00:00 AM",
> "TE": null,
> "Locator": null,
> "Message": "Transfer Fee",
> "AT": null,
> "FT": null,
> "FR": "True",
> "FY": null,
> "FR": null,
> "FG": "0",
> "Comment": null,
> "FUD": null,
> "cID": null,
> "GEO": null,
> "ISO": null,
> "TRID": null,
> "XTY": "931083",
> "ANM": null,
> "NM": null
> },
> "CF": "Fee",
> "ID": "2"
> }
My apologies:
I originally parsed this from an XML file.
It really should be:
{
"Fee": {
"A": "5",
"FEC": "1/1/0001 12:00:00 AM",
"TE": null,
"Locator": null,
"Message": "Transfer Fee",
"AT": null,
"FT": null,
"FR": "True",
"FY": null,
"FR": null,
"FG": "0",
"Comment": null,
"FUD": null,
"cID": null,
"GEO": null,
"ISO": null,
"TRID": null,
"XTY": "931083",
"ANM": null,
"NM": null
},
"CF": "Fee",
"ID": "2"
}
The value, "Fee" associated with the key, "CF" does should not be included as a
column header.
The CSV file, when opened with an application such as MS Excel, should be as
follows:
(Column Header)----> CF A FEC
(Field Value)----> Fee 5 1/1/0001 12:00:00 AM
My apologies for an confusion.
--
https://mail.python.org/mailman/listinfo/python-list
