Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #89988

Re: Writing list of dictionaries to CSV

Path csiph.com!usenet.pasdenom.info!news.redatomik.org!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path <skip.montanaro@gmail.com>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.016
X-Spam-Evidence '*H*': 0.97; '*S*': 0.00; 'mrab': 0.05; 'assuming': 0.09; 'cc:addr:python-list': 0.11; 'csv': 0.16; 'displaying': 0.16; 'editor,': 0.16; 'inputs': 0.16; 'rules.': 0.16; 'subject:CSV': 0.16; 'subject:Writing': 0.16; 'subject:dictionaries': 0.16; 'wrote:': 0.18; 'trying': 0.19; 'cc:addr:python.org': 0.22; 'skip': 0.24; 'looks': 0.24; 'cc:2**0': 0.24; 'header:In-Reply-To:1': 0.27; 'subject:list': 0.30; 'message-id:@mail.gmail.com': 0.30; "i'm": 0.30; 'file': 0.32; 'text': 0.33; 'received:google.com': 0.35; 'dates': 0.36; 'application': 0.37; 'pm,': 0.38; 'according': 0.40; "you're": 0.61; 'more': 0.64; 'default': 0.69; '2015': 0.84; 'excel,': 0.84; 'spreadsheet': 0.84
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=6cG86wAS83bQnGD05NHFiheJ/jEK+flhiGk/hAowG48=; b=f8w7AmMdNCxreIiwjqV5+Mt7OYFswYGsO2hV/w8V2vEVpyPEW4sCcGRIQe4x85wCT3 PGTU/llgItJ5PjBBaVtBP4zNK8H1Mff1Z9h9pe9tOvR9RGZQibSafXtcgql0fOvZN9W8 OSDmm7aFdcUUGOYz2sNdCEk70TsIS9vVw/Hbx9v8UmnXHYhR7cGddUqacG5t9J3uIZ96 127z7D5hQK3GMVnW1YF9Yrwh/sglplXrw0tBPHtXSHisID5jPwueJ/9Tj/FsBfl7hRE0 qSb+rmpljee8F/vE7mxghHCXBpMJD1jDAJml5bli82iEiX2V3vtORrJtXvg3AlHZmHec iANw==
MIME-Version 1.0
X-Received by 10.60.52.209 with SMTP id v17mr23867321oeo.68.1430850332646; Tue, 05 May 2015 11:25:32 -0700 (PDT)
In-Reply-To <554907BD.4040804@mrabarnett.plus.com>
References <5bd0afb3-d2d4-469f-be39-5869f01adc92@googlegroups.com> <554907BD.4040804@mrabarnett.plus.com>
Date Tue, 5 May 2015 13:25:32 -0500
Subject Re: Writing list of dictionaries to CSV
From Skip Montanaro <skip.montanaro@gmail.com>
To MRAB <python@mrabarnett.plus.com>
Cc Python <python-list@python.org>
Content-Type text/plain; charset=UTF-8
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.20+
Precedence list
List-Id General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list/>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups comp.lang.python
Message-ID <mailman.134.1430850336.12865.python-list@python.org> (permalink)
Lines 11
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1430850336 news.xs4all.nl 2850 [2001:888:2000:d::a6]:57300
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:89988

Show key headers only | View raw

On Tue, May 5, 2015 at 1:11 PM, MRAB <python@mrabarnett.plus.com> wrote:
> I'm assuming that you're reading the CSV file in a text editor, not
> some other application that might be trying to be "clever" by
> "interpreting" what it thinks looks a date as a date and then
> displaying it differently...

More likely, viewing the CSV file in Excel, Gnumeric, or some other
spreadsheet which interprets some inputs as dates and formats them
according to its default rules.

Skip

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Writing list of dictionaries to CSV Kashif Rana <kashifrana84@gmail.com> - 2015-05-05 10:09 -0700
  Re: Writing list of dictionaries to CSV MRAB <python@mrabarnett.plus.com> - 2015-05-05 19:11 +0100
  Re: Writing list of dictionaries to CSV Skip Montanaro <skip.montanaro@gmail.com> - 2015-05-05 13:25 -0500
  Re: Writing list of dictionaries to CSV Cecil Westerhof <Cecil@decebal.nl> - 2015-05-05 20:44 +0200
  Re: Writing list of dictionaries to CSV Matthew Ruffalo <mmr15@case.edu> - 2015-05-05 15:43 -0400
  Re: Writing list of dictionaries to CSV Tim Chase <python.list@tim.thechases.com> - 2015-05-05 12:34 -0500
  Re: Writing list of dictionaries to CSV Kashif Rana <kashifrana84@gmail.com> - 2015-05-05 22:32 -0700
    Re: Writing list of dictionaries to CSV Chris Angelico <rosuav@gmail.com> - 2015-05-06 16:34 +1000
    Re: Writing list of dictionaries to CSV Cecil Westerhof <Cecil@decebal.nl> - 2015-05-06 08:50 +0200
    Re: Writing list of dictionaries to CSV Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2015-05-06 09:14 -0400
    Re: Writing list of dictionaries to CSV MRAB <python@mrabarnett.plus.com> - 2015-05-06 19:08 +0100
    Re: Writing list of dictionaries to CSV Tim Chase <python.list@tim.thechases.com> - 2015-05-06 13:22 -0500
    Re: Writing list of dictionaries to CSV Ian Kelly <ian.g.kelly@gmail.com> - 2015-05-06 12:27 -0600
    Re: Writing list of dictionaries to CSV Tim Chase <python.list@tim.thechases.com> - 2015-05-06 13:37 -0500
    Re: Writing list of dictionaries to CSV Denis McMahon <denismfmcmahon@gmail.com> - 2015-05-06 23:31 +0000
      Re: Writing list of dictionaries to CSV Tim Chase <python.list@tim.thechases.com> - 2015-05-06 20:22 -0500
      Re: Writing list of dictionaries to CSV Jon Ribbens <jon+usenet@unequivocal.co.uk> - 2015-05-07 01:55 +0000
      Re: Writing list of dictionaries to CSV [correction] Tim Chase <python.list@tim.thechases.com> - 2015-05-06 20:52 -0500

csiph-web