Re: [Tutor] import openpyxl throws error in-spite I have python-openpyxl installed.

2016-06-08 Thread Joseph John
Like to give the status I have messed up my Python installation, now I remember there was the default python installation from the OS installed and "Canopy" version which I had setup in my home directories. Because of this reason import openpyxl was not working for the shell ( I tested it by loggi

[Tutor] import openpyxl throws error in-spite I have python-openpyxl installed.

2016-06-08 Thread Joseph John
Hi All, I am trying to explore python, trying to read from excel file. I am using Ubuntu 16.04 As a first step I mae sure that I have the package installed “python-openpyxl” Now in the python command line when I tried to import openpyxl it throws error. >>> import openpyxl Traceback (most recent

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Alex Hall
Thanks for all the responses, everyone, what you all said makes sense. I also understand what you mean by the tone of an "urgent" message coming across as demanding. On Wed, Jun 8, 2016 at 1:19 PM, Tim Golden wrote: > On 08/06/2016 14:54, Alex Hall wrote: > > All, > > I'm working on a project th

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Albert-Jan Roskam
> Date: Thu, 9 Jun 2016 03:57:21 +1000 > From: st...@pearwood.info > To: tutor@python.org > Subject: Re: [Tutor] Urgent: unicode problems writing CSV file > > On Wed, Jun 08, 2016 at 01:18:11PM -0400, Alex Hall wrote: >> >> csvWriter.writerow([info.encode("utf8") if type(info)is unicode else

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Peter Otten
Alex Hall wrote: > The type of the 'info' variable can vary, as I'm pulling it from a > database with Pyodbc. I eventually found something that works, though I'm > not fully sure why or how. As Tim says, the csv.writer in Python 2 applies str() to every value. If that value is a unicode instanc

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Steven D'Aprano
On Wed, Jun 08, 2016 at 01:18:11PM -0400, Alex Hall wrote: > I never knew that specifying a question is related to a time-sensitive > project is considered impolite. My apologies. Your urgency is not our urgency. We're volunteers offerring our time and experience for free. Whether you intended it

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Michael Selik
On Wed, Jun 8, 2016 at 12:53 PM Alex Hall wrote: > All, > I'm working on a project that writes CSV files, and I have to get it done > very soon. I've done this before, but I'm suddenly hitting a problem with > unicode conversions. I'm trying to write data, but getting the standard > cannot encode

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Alex Hall
I never knew that specifying a question is related to a time-sensitive project is considered impolite. My apologies. The type of the 'info' variable can vary, as I'm pulling it from a database with Pyodbc. I eventually found something that works, though I'm not fully sure why or how. csvWriter

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Steven D'Aprano
On Wed, Jun 08, 2016 at 09:54:23AM -0400, Alex Hall wrote: > All, > I'm working on a project that writes CSV files, and I have to get it done > very soon. I've done this before, but I'm suddenly hitting a problem with > unicode conversions. I'm trying to write data, but getting the standard > canno

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Tim Golden
On 08/06/2016 14:54, Alex Hall wrote: > All, > I'm working on a project that writes CSV files, and I have to get it done > very soon. I've done this before, but I'm suddenly hitting a problem with > unicode conversions. I'm trying to write data, but getting the standard > cannot encode character: o

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Joel Goldstick
On Wed, Jun 8, 2016 at 1:08 PM, Peter Otten <__pete...@web.de> wrote: > Alex Hall wrote: > > Marking your posts is generally considered impolite and will not help you > get answers sooner than without it. > >> I'm working on a project that writes CSV files, and I have to get it done >> very soon. I

Re: [Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Peter Otten
Alex Hall wrote: Marking your posts is generally considered impolite and will not help you get answers sooner than without it. > I'm working on a project that writes CSV files, and I have to get it done > very soon. I've done this before, but I'm suddenly hitting a problem with > unicode convers

[Tutor] Urgent: unicode problems writing CSV file

2016-06-08 Thread Alex Hall
All, I'm working on a project that writes CSV files, and I have to get it done very soon. I've done this before, but I'm suddenly hitting a problem with unicode conversions. I'm trying to write data, but getting the standard cannot encode character: ordinal not in range(128) I've tried str(info).e

Re: [Tutor] Python Setup Help

2016-06-08 Thread Alan Gauld via Tutor
On 08/06/16 03:24, Vincent Trost via Tutor wrote: > Hi, > I'm looking for help on the proper installation of Python and the Text > editor, Atom. OK, Lets break those into two separate activities. Start with Python. > we downloaded Enthought Canopy and used that for some scientific Python work.

[Tutor] Python Setup Help

2016-06-08 Thread Vincent Trost via Tutor
Hi, I'm looking for help on the proper installation of Python and the Text editor, Atom. I'm a Data Science major at Penn State, and I knew I had Python 2.7.x already installed on my computer, but last semester in one of my classes we downloaded Enthought Canopy and used that for some scientific