|Jul24-12, 10:26 PM||#1|
Excel Headers --> Mathematica
I have a large Excel .xls file. Miniature version shown below:
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?
|Similar Threads for: Excel Headers --> Mathematica|
|Data format AFTER import into Mathematica from Excel.xls worksheet||Math & Science Software||1|
|Long tube headers vs. short tube headers.||Mechanical Engineering||8|
|Excel/Mathematica Extracting Data with a twist!||Math & Science Software||2|
|Headers on titlepage using LaTeX||Math & Science Software||5|
|Mathematica/Excel Users||Math & Science Software||6|