Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.soft-sys.math.mathematica > #16169

Data format AFTER import into Mathematica from Excel.xls worksheet

From nkormanik <nkormanik@gmail.com>
Newsgroups comp.soft-sys.math.mathematica
Subject Data format AFTER import into Mathematica from Excel.xls worksheet
Date 2013-11-05 04:15 +0000
Message-ID <l59rcq$rdv$1@smc.vnet.net> (permalink)
Organization Time-Warner Telecom

Show all headers | View raw


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@gmail.com




Back to comp.soft-sys.math.mathematica | Previous | Next — Next in thread | Find similar | Unroll thread


Thread

Data format AFTER import into Mathematica from Excel.xls worksheet nkormanik <nkormanik@gmail.com> - 2013-11-05 04:15 +0000
  Re: Data format AFTER import into Mathematica from Excel.xls worksheet ariel.sepulveda@prontoanalytics.com - 2013-12-03 10:23 +0000

csiph-web