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>
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

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