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 ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ Matplotlib-users mailing list Matplotlib-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/matplotlib-users
