plot xy data with missing values

Thank you John:

I have exported the excel file in csv format and imported as you showed me. When I try to create a plot with the command: plot(a[isfinite(b)],b[isfinite(b)]), I get an error message: index should be int. When I look at the second column from the csv file I see that the values are imported like ‘23.5’ and not like 23.5 and this causes that error. How can I imported the values from all columns without ‘’

Ionut

···

----- Original Message ----
From: John Hunter <jdh2358@…287…>
To: sandric ionut <sandricionut@…9…>
Cc: Darren Dale <dsdale24@…287…>; Matplotlib matplotlib-users@lists.sourceforge.net
Sent: Saturday, June 28, 2008 5:19:42 PM
Subject: Re: [Matplotlib-users] plot xy data with missing values

On Sat, Jun 28, 2008 at 9:16 AM, sandric ionut <sandricionut@…9…> wrote:

Thank you Darren:

The second example is what I need. I have made some test and it looks OK
I have my data in excel. How can I read from excel files? Is it a special
tool?

If you save as csv, you can use matplotlib.mlab.csv2rec to get your
data back as a record array. See

http://matplotlib.sourceforge.net/examples/pylab_examples/loadrec.py

JDH