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


Groups > comp.soft-sys.math.mathematica > #11059 > unrolled thread

Excel Headers --> Mathematica

Started byNicholas Kormanik <nkormanik@gmail.com>
First post2012-07-25 06:33 +0000
Last post2012-07-25 06:33 +0000
Articles 1 — 1 participant

Back to article view | Back to comp.soft-sys.math.mathematica


Contents

  Excel Headers --> Mathematica Nicholas Kormanik <nkormanik@gmail.com> - 2012-07-25 06:33 +0000

#11059 — Excel Headers --> Mathematica

FromNicholas Kormanik <nkormanik@gmail.com>
Date2012-07-25 06:33 +0000
SubjectExcel Headers --> Mathematica
Message-ID<juo403$173$1@smc.vnet.net>
I have a large Excel .xls file.  Miniature version shown below:

Test1   Test2
75        64
58        85
81        55
64        63
70        94
88        90
78        96
96        98
54        97
75        61

I would like to do some statistical analysis on the file in Mathematica 8.0.4.

Additionally I am using Mathematica Link for Excel 3.5.

The issue I'm now attempting to address concerns the "headers," or "column labels."

I need to tell Mathematica to disregard the headers.  I want to use each respective header, however, as the name for the "variable stream"  (Mathematica-speak for each column of data.)

What might be the best ways of dealing with such headers?

Thanks.

Nicholas Kormanik
nkormanik@gmail.com

[toc] | [standalone]


Back to top | Article view | comp.soft-sys.math.mathematica


csiph-web