Re: [Matplotlib-users] Best way to use Excel Data

[João L. S. <js...@fc...>]

On 10/07/2010 05:11 PM, Jahan Mohiuddin wrote:
> Hi,
>
> I am an novice-intermediate user of python (I took a 1 semester course
> in scientific programming with python). I wanted to know what the best
> way is to manipulate, analyze, and plot Microsoft Excel data. The
> methods I've looked into:
>
> 1. Save data in CSV file and use csv.dictreader to create a dictionary.
> I actually couldn't figure this one out.
>
> 2. Read the CSV and extract the numerical data into an array of floats
> so I can manipulate the data. This is alright but then I lose the text
> for the header row.
>
>
> I have a fairly large biological data set, but I also really just want
> to practice with a good method. Any advice is much appreciated. Thanks!
>
>
> -Jahan
>

You could use the python package xlrd, available at
http://www.lexicon.net/sjmachin/xlrd.htm

 From what I remember the documentation wasn't all that great, but you 
should be able to access your data without too much trouble.

Regards,
João Silva