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>
- Reply-to: murray at math.umass.edu
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