Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2013

[Date Index] [Thread Index] [Author Index]

Search the Archive

Data format AFTER import into Mathematica from Excel.xls worksheet

  • To: mathgroup at smc.vnet.net
  • Subject: [mg131937] Data format AFTER import into Mathematica from Excel.xls worksheet
  • From: nkormanik <nkormanik at gmail.com>
  • Date: Mon, 4 Nov 2013 23:15:39 -0500 (EST)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • Delivered-to: l-mathgroup@wolfram.com
  • Delivered-to: mathgroup-outx@smc.vnet.net
  • Delivered-to: mathgroup-newsendx@smc.vnet.net

I have a large Excel worksheet (200 columns, 4,000 rows).  Every column has a unique and carefully chosen title/label.

I'm attempting to use it within Mathematica to create a large number of contour plots (1,000) -- using three columns at a time, for x, y, z.

The import, I suppose, occurs.  At least it appears to have.

Here's the question:

-- Is Mathematica using my column titles, so that I can refer to them in commands subsequent to import?

-- If not, is there any format I can put my data into to begin with so that Mathematica will readily recognize my named columns?


I certainly wanted to be getting on with the contour plots (SmoothDensityHistogram), but am having trouble getting my data into the required form.

Any help appreciated.

Nicholas Kormanik
nkormanik at gmail.com







  • Prev by Date: Re: Finding branches where general solution is possible
  • Next by Date: Use NMinimize for MonteCarloFitting???
  • Previous by thread: Re: Finding branches where general solution is possible
  • Next by thread: Re: Data format AFTER import into Mathematica from Excel.xls worksheet