Re: Plot Lists of values from excel to mathematica

• To: mathgroup at smc.vnet.net
• Subject: [mg95344] Re: [mg95310] Plot Lists of values from excel to mathematica
• From: Murray Eisenberg <murray at math.umass.edu>
• Date: Fri, 16 Jan 2009 06:08:22 -0500 (EST)
• Organization: Mathematics & Statistics, Univ. of Mass./Amherst
• References: <200901151110.GAA18969@smc.vnet.net>

```I presume your data comes from Excel in the form of a list of lists,
with each constituent list being a row of your table, i.e.:

xy = {{1,5,2,4},{2,6,1,2},{3,2,2,1},{4,1,7,2}};

Define an auxiliary function to associate the first entry in each row
with each of the remaining entries in its row:

f[lis_] := Flatten[Outer[List, {First[lis]}, Rest[lis]], 1]

Now Apply that function to each row (but do it all at once) and do a
ListPlot of the result:

ListPlot[f/@xy,PlotStyle->{PointSize[Large]}]

I don't know whether this is the "simplest" way, but it's a reasonably
straightforward way.

dinodeblasio at gmail.com wrote:
> Hello everybody I'd like to plot in mathematica one four columns data
> that i have in excel, how i can do that in mathematica? For example I
> have:
> 1 5 2 4
> 2 6 1 2
> 3 2 2 1
> 4 1 7 2
>
> I'd like to have a plot wher on the x axis I have 1,2,3,4 and for the
> x=1 the point are at: 5,2,4; at x=2 the points are at 6,1,2 and so on.
> What is the simplest way to do that in mathematica?
> Thanks very much.
> Dino
>

--
Murray Eisenberg                     murray at math.umass.edu
Mathematics & Statistics Dept.
Lederle Graduate Research Tower      phone 413 549-1020 (H)
University of Massachusetts                413 545-2859 (W)
710 North Pleasant Street            fax   413 545-1801
Amherst, MA 01003-9305

```

• Prev by Date: Mathematica Player Pro 7 now available
• Next by Date: Re: Problem in generating a DO cycle (mathematica 6.0)
• Previous by thread: Re: Plot Lists of values from excel to mathematica
• Next by thread: Which editor do you use for math articles