On 07/13/2012 05:09 AM, susana moreno colomer wrote:
>
>
> Hi!
> I am sorry, but still I don't get it!
1) please don't top-post. Put your new comments AFTER the part you're
quoting. Or don't bother quoting, if you think your stuff stands alone.
2) please do a Reply-all, or equivalent. Anyway
Please always reply to the list!
>
> Hi!
> I am sorry, but still I don't get it!
> I am trying with this (the code is attached)
>
> csv_out=csv.writer(open('out1.csv', 'wb'), delimiter=' ',
> quoting=csv.QUOTE_ALL, dialect='excel')
> and
> csv_out=csv.writer(open('out1.csv', 'wb'), dialect='exce
27;), dialect='excel-tab')
When I open out1 with text editor, I get 6 columns, but when I open it with
excel I get one column (6 numbers on each cell, how can I separate it it???)
The files from wich I get the columns are txt files.
Many thanks!!
Date: Fri, 13 Jul 2012 00:
On Fri, Jul 13, 2012 at 5:21 AM, Marc Tompkins wrote:
> Reply to the group, please!
>
> On Fri, Jul 13, 2012 at 2:09 AM, susana moreno colomer
> wrote:
>>
>>
>> Hi!
>> I am sorry, but still I don't get it!
>> I am trying with this (the code is attached)
>>
>> csv_out=csv.writer(open('out1.csv', '
Reply to the group, please!
On Fri, Jul 13, 2012 at 2:09 AM, susana moreno colomer <
susana...@hotmail.com> wrote:
>
> Hi!
> I am sorry, but still I don't get it!
> I am trying with this (the code is attached)
>
> csv_out=csv.writer(open('out1.csv', 'wb'), delimiter=' ',
> quoting=csv.QUOTE_ALL,
On Thu, Jul 12, 2012 at 11:36 PM, susana moreno colomer <
susana...@hotmail.com> wrote:
> Hi!
> I am trying this, but still I get 6 numbers per cell. The only one
> difference is that I get a comma between numbers instead an space.
> I am opening the document also with excel
> Many thanks,
> Susa
Hi!
I am trying this, but still I get 6 numbers per cell. The only one difference
is that I get a comma between numbers instead an space.
I am opening the document also with excel
Many thanks,
Susana
Subject: Re: [Tutor] get columns from txt file
From: dfjenni...@gmail.com
Date: Thu, 12
> >> csv_out=csv.writer(open('out14.csv', 'wb'), dialect='excel')
> >
> > The default dialect is excel but it is important to also open
> > the file using Excel as it may default to a text editor.
>
> In the context we're talking about here this makes no sense to me so can
> you please explain.
>
Sorry if this shows up twice
On 12/07/2012 17:18, Prasad, Ramit wrote:
csv_out=csv.writer(open('out14.csv', 'wb'), dialect='excel')
The default dialect is excel but it is important to also open
the file using Excel as it may default to a text editor.
In the context we're talking about here
On 7/12/2012 9:06 AM susana moreno colomer said...
Hi!
This code is working fine!
The only one little thing is that the 6 columns appear together in one
column, what means, in eac cell I get 6 numbers. How can I get tit in 6
excel columns?
You're creating a list (output) with only one column
>> Hi!
>> This code is working fine!
>> The only one little thing is that the 6 columns appear togetherĀ in one
>> column, what means, in eac cell I get 6 numbers. How can I get tit in 6
>> excel columns?
> Programming is hard, so don't feel bad that I'm having to tell you again to
> specify the
On Jul 12, 2012, at 12:06 PM, susana moreno colomer wrote:
>
> Hi!
> This code is working fine!
> The only one little thing is that the 6 columns appear together in one
> column, what means, in eac cell I get 6 numbers. How can I get tit in 6 excel
> columns?
Programming is hard, so don't fee
Hi!
This code is working fine!
The only one little thing is that the 6 columns appear together in one column,
what means, in eac cell I get 6 numbers. How can I get tit in 6 excel columns?
Many thanks,
Susana
Subject: Re: [Tutor] get columns from txt file
From: dfjenni...@gmail.com
Date
On Jul 12, 2012, at 11:10 AM, susana moreno colomer wrote:
> Hi!
> It is attached on the email, called myprogram.txt
and, here are the contents of that file:
> #! /usr/bin/env python
>
>
> import os
> import fnmatch
> import csv
>
>
> path = '//../my_working_folder/'
> csv_out=csv.writer(op
Hi!
It is attached on the email, called myprogram.txt
Thank you!
Subject: Re: [Tutor] get columns from txt file
From: dfjenni...@gmail.com
Date: Thu, 12 Jul 2012 11:07:53 -0400
CC: tutor@python.org
To: susana...@hotmail.com
On Jul 12, 2012, at 10:55 AM, susana moreno colomer wrote:
Hi
On Jul 12, 2012, at 10:55 AM, susana moreno colomer wrote:
> Hi!
>
> I have a group of files in a directory:
> bb_1.txt
> bb_2.txt
> bb_3.txt
> bb_4.txt
> bb_5.txt
> bb_6.txt
> ss_1.txt
>
> I want to extract from files whose names start with bb_ column number 5
> to an excel file. I have
code is working,with the following errors:
I get the data in only one column, instead of six
Many thanks!
Subject: Re: [Tutor] get columns from txt file
From: dfjenni...@gmail.com
Date: Thu, 12 Jul 2012 10:26:30 -0400
CC: tutor@python.org
To: susana...@hotmail.com
Oops! Still you forgot to
Oops! Still you forgot to cc: the tutor list. It's really important because if
someone (like me, for instance) steers you in the wrong direction, others will
jump in with corrections.
On Jul 12, 2012, at 9:48 AM, susana moreno colomer wrote:
> Hi!
> Many thanks!
You're welcome. I see that you
(Please use reply all so the message gets posted for all to see :>)
On Jul 12, 2012, at 7:14 AM, susana moreno colomer wrote:
> Hi!
> Many thanks for your help.
> Now I am trying this, but I get a blank excel document
Not surprising as there are several errors in your code. In fact, I'm surprise
> I have a group of files in a directory.
> I want to extract from files whose names start with bb_ column number 5 to
> an excel file. I have 6 bb_ files, therefore I want to get 6 columns (5th
> column from each file)
> This code is working,with the following errors:
> * I get the data in o
On Jul 11, 2012, at 10:21 AM, tutor-requ...@python.org wrote:
>
> Message: 4
> Date: Wed, 11 Jul 2012 16:20:05 +0200
> From: susana moreno colomer
> To:
> Subject: [Tutor] get columns from txt file
> Message-ID:
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> Hi!
>
> I have a group o
21 matches
Mail list logo