Re: enumerate XML tags (keys that will become headers) along with text (values) and write to CSV in one row (as opposed to "stacked" values with one header)

2015-06-29 Thread Sahlusar
On Sunday, 28 June 2015 03:46:56 UTC-4, Stefan Behnel wrote: > Denis McMahon schrieb am 26.06.2015 um 09:44: > > xml data is an unordered list, and are trying to assign an order to it. > > > > If the xml data was ordered, either each tag would be different, or each > > tag would have an attribut

To write headers once with different values in separate row in CSV

2015-06-23 Thread Sahlusar
I have the following script for writing out to CSV two items in a list to a CSV in such a format, such that if we have: L = [('A', 1), ('B', 2), ('C', 3), ('D', 4),('A', 5), ('B', 6), ('D', 8)] we want A B C D 1 2 3 4 5 6 8 And with this L = [('A', 1), ('B', 2), ('C', 3), ('D', 4),('D', 5)

Re: JSON Object to CSV File Troubleshooting

2015-06-23 Thread Sahlusar
On Tuesday, June 23, 2015 at 2:35:50 AM UTC-4, Denis McMahon wrote: > On Sun, 21 Jun 2015 16:56:27 -0700, Sahlusar wrote: > > > Here is an example XML document that I am working with: > > > You are welcome to contribute and provide me with feedback. Thank you > > for

Re: JSON Object to CSV File Troubleshooting

2015-06-21 Thread Sahlusar
On Sunday, June 21, 2015 at 7:34:47 PM UTC-4, Denis McMahon wrote: > On Mon, 22 Jun 2015 00:55:11 +0300, Joonas Liik wrote: > > > In xml for instance this is valid: > > > > > 1 > > > > .. and so is this: > > > > 1 2 > > > > What the OP needs to do is sit down with the XML and work out how

Re: JSON Object to CSV File Troubleshooting

2015-06-21 Thread Sahlusar
On Sunday, June 21, 2015 at 5:56:00 PM UTC-4, Waffle wrote: > On 21 June 2015 at 17:38, Sahlusar wrote: > > > > [snip] > > I do agree with you Denis that this is an unconventional approach. I was > > wondering then that perhaps I should add additional functionality a

Re: JSON Object to CSV file

2015-06-21 Thread Sahlusar
On Sunday, June 21, 2015 at 4:54:27 PM UTC-4, Denis McMahon wrote: > On Sun, 21 Jun 2015 06:57:01 -0700, sahluwalia wrote: > > > On Sunday, 21 June 2015 02:47:31 UTC-4, Denis McMahon wrote: > >> On Wed, 17 Jun 2015 08:00:11 -0700, Saran A wrote: > >> > >> > I would like to have this JSON object

Re: JSON Object to CSV file

2015-06-21 Thread Sahlusar
On Sunday, 21 June 2015 11:31:44 UTC-4, Ned Batchelder wrote: > On Sunday, June 21, 2015 at 10:54:44 AM UTC-4, Sahlusar wrote: > > > This is a duplicate to the post titled: JSON to CSV Troubleshooting: > > Please don't do that. > > --Ned. My apologies - is it

Re: JSON Object to CSV file

2015-06-21 Thread Sahlusar
On Sunday, June 21, 2015 at 2:47:31 AM UTC-4, Denis McMahon wrote: > On Wed, 17 Jun 2015 08:00:11 -0700, 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 asso

Re: JSON Object to CSV File Troubleshooting

2015-06-21 Thread Sahlusar
It is difficult to explain this to someone asynchronously and without an in person meeting. Moreover, the strict guidelines for disclosing information make it difficult for me to explain the client's requirements and the problems that they face. I do agree with you Denis that this is an uncon

Re: JSON Object to CSV file

2015-06-21 Thread Sahlusar
On Sunday, June 21, 2015 at 2:47:31 AM UTC-4, Denis McMahon wrote: > On Wed, 17 Jun 2015 08:00:11 -0700, 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 asso

Re: JSON Object to CSV File Troubleshooting

2015-06-21 Thread Sahlusar
On Sunday, 21 June 2015 02:54:48 UTC-4, Denis McMahon wrote: > On Thu, 18 Jun 2015 18:47:30 -0700, Sahlusar wrote: > > > I have a conundrum regarding JSON objects and converting them to CSV: > > I think your conundrum is that you've taken on a coding task beyond your &g

Re: JSON Object to CSV Question

2015-06-19 Thread Sahlusar
On Friday, June 19, 2015 at 8:47:25 AM UTC-4, Sahlusar wrote: > On Friday, June 19, 2015 at 6:16:40 AM UTC-4, Cecil Westerhof wrote: > > Top posting is frowned upon. Could you put your reply under where you > > reply on next time? > > > > On Friday 19 Jun 2015 11:50

Re: JSON Object to CSV Question

2015-06-19 Thread Sahlusar
On Friday, June 19, 2015 at 6:16:40 AM UTC-4, Cecil Westerhof wrote: > Top posting is frowned upon. Could you put your reply under where you > reply on next time? > > On Friday 19 Jun 2015 11:50 CEST, Saran Ahluwalia wrote: > > > No I am not a troll. I am attempting to clarify an evolving problem

JSON Object to CSV File Troubleshooting

2015-06-18 Thread Sahlusar
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": {

Reassigning keys in dictionary of lists and then writing out to CSV file?

2015-06-18 Thread Sahlusar
I am currently attempting to work on converting a fairly sizeable JSON object and convert it into a CSV format. However, when I attempt to do so, using a conventional approach (that seems to work with other files). I am presented with a "ValueError: too many values to unpack" I have tried to fl

Re: JSON Object to CSV file

2015-06-18 Thread Sahlusar
On Wednesday, June 17, 2015 at 2:21:05 PM UTC-4, Peter Otten wrote: > Sahlusar wrote: > > > 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

Re: JSON Object to CSV file

2015-06-17 Thread Sahlusar
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 >