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


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

Data format AFTER import into Mathematica from Excel.xls worksheet

Started bynkormanik <nkormanik@gmail.com>
First post2013-11-05 04:15 +0000
Last post2013-12-03 10:23 +0000
Articles 2 — 2 participants

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


Contents

  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

#16169 — Data format AFTER import into Mathematica from Excel.xls worksheet

Fromnkormanik <nkormanik@gmail.com>
Date2013-11-05 04:15 +0000
SubjectData format AFTER import into Mathematica from Excel.xls worksheet
Message-ID<l59rcq$rdv$1@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@gmail.com




[toc] | [next] | [standalone]


#16314

Fromariel.sepulveda@prontoanalytics.com
Date2013-12-03 10:23 +0000
Message-ID<l7kben$45t$1@smc.vnet.net>
In reply to#16169
I just saw your post, so I may be late.  In any case, it seems to me that what you would like to get from Mathematica is what I have created in MXLPlus package.  In short this package provides a set of functions that can be used to access data by using column names.  You can get it for free following this link http://www.prontoanalytics.com/fdownloads.php.

This package is part of the backbone of BEST Viewpoints (http://youtu.be/RhYoWRT2yPk) which is a general use data analysis application that you may use to simplify the process of generating all the ContourPlots you need to create.

>
> 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

[toc] | [prev] | [standalone]


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


csiph-web