To write headers once with different values in separate row in CSV
kbtyo
ahlusar.ahluwalia at gmail.com
Wed Jun 24 07:31:23 EDT 2015
On Tuesday, June 23, 2015 at 3:12:40 PM UTC-4, John Gordon wrote:
> In <c0ea6bec-b6b1-48fd-9291-0fedcda7b76c at googlegroups.com> Sahlusar <ahlusar.ahluwalia at gmail.com> writes:
>
> > However, when I extrapolate this same logic with a list like:
>
> > ('Response.MemberO.PMembers.PMembers.Member.CurrentEmployer.EmployerAddress
> > .TimeAtPreviousAddress.', None), where the headers/columns are the first
> > item (only to be written out once) with different values. I receive an
> > output CSV with repeating headers and values all printed in one long string
>
> First, I would try to determine if the problem is in the makerows()
> function, or if the problem is elsewhere.
>
> Have you tried creating some dummy data by hand and seeing how makerows()
> handles it?
>
> (By the way, if your post had included some sample data that illustrates
> the problem, it would have been much easier to figure out a solution.
> Instead, we are left guessing at your XML format, and at the particular
> implementation of flatten_dict().)
>
> --
> John Gordon A is for Amy, who fell down the stairs
> gordon at panix.com B is for Basil, assaulted by bears
> -- Edward Gorey, "The Gashlycrumb Tinies"
On Tuesday, June 23, 2015 at 3:12:40 PM UTC-4, John Gordon wrote:
> In <c0ea6bec-b6b1-48fd-9291-0fedcda7b76c at googlegroups.com> Sahlusar <ahlusar.ahluwalia at gmail.com> writes:
>
> > However, when I extrapolate this same logic with a list like:
>
> > ('Response.MemberO.PMembers.PMembers.Member.CurrentEmployer.EmployerAddress
> > .TimeAtPreviousAddress.', None), where the headers/columns are the first
> > item (only to be written out once) with different values. I receive an
> > output CSV with repeating headers and values all printed in one long string
>
> First, I would try to determine if the problem is in the makerows()
> function, or if the problem is elsewhere.
>
> Have you tried creating some dummy data by hand and seeing how makerows()
> handles it?
>
Yes I did do this.
> (By the way, if your post had included some sample data that illustrates
> the problem, it would have been much easier to figure out a solution.
> Instead, we are left guessing at your XML format, and at the particular
> implementation of flatten_dict().)
Yes, unfortunately, due to NDA protocols I cannot share this.
>
> --
> John Gordon A is for Amy, who fell down the stairs
> gordon at panix.com B is for Basil, assaulted by bears
> -- Edward Gorey, "The Gashlycrumb Tinies"
More information about the Python-list
mailing list