You may want to look at this as well: http://matplotlib.sourceforge.net/api/mlab_api.html?highlight=csv#matplotlib.mlab.csv2rec
Mike On 10/07/2010 01:04 PM, João Luís Silva wrote: > 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 ------------------------------------------------------------------------------ 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
