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 ''
----- Original Message ----
From: John Hunter <>
To: sandric ionut <>
Cc: Darren Dale <>; Matplotlib <>
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 <> 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