Re: [Tutor] Attacking this problem (2 parts):JSON object to CSV file

2015-06-19 Thread Peter Otten
Alan Gauld wrote: > On 19/06/15 02:44, Saran Ahluwalia wrote: > >> However with the example JSON object (above) i receive the following >> error when applying this function: >> >> ValueError: too many values to unpack >> > > Please always include the full error trace not just the final line. >

Re: [Tutor] Attacking this problem (2 parts):JSON object to CSV file

2015-06-19 Thread Alan Gauld
On 19/06/15 02:44, Saran Ahluwalia wrote: However with the example JSON object (above) i receive the following error when applying this function: ValueError: too many values to unpack Please always include the full error trace not just the final line. Also, since this is quite an advanced q

Re: [Tutor] Deleting a Row From Excel

2015-06-19 Thread Alan Gauld
On 19/06/15 02:28, Phillip Pugh wrote: I need to delete the first row from each document (multi tabs per document). Do you mean you need to delete the first row from each tab? Or the first row from the first tab? I don't see a method in the openpyxl library (using Python 3.4). > am I missing

[Tutor] Deleting a Row From Excel

2015-06-19 Thread Phillip Pugh
I receive several Excel documents each week. I need to delete the first row from each document (multi tabs per document). I don't see a method in the openpyxl library (using Python 3.4). am I missing something? Is there a way to delete a row from Excel. Thanks Phillip ___

[Tutor] Attacking this problem (2 parts):JSON object to CSV file

2015-06-19 Thread Saran Ahluwalia
Good Evening, I have a conundrum regarding JSON objects and converting them to CSV: *Context* - I am converting XML files to a JSON object (please see snippet below) and then finally producing a CSV file. Here is a an example JSON object: "PAC": { "Account": [{ "PC": "0", "CMC": "0", "W