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:
Save data in CSV file and use csv.dictreader to create a dictionary. I actually couldn’t figure this one out.
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!
University of North Carolina at Chapel Hill, 2010
Cell: (516) 480-4825