Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.soft-sys.math.mathematica > #16169 > unrolled thread
| Started by | nkormanik <nkormanik@gmail.com> |
|---|---|
| First post | 2013-11-05 04:15 +0000 |
| Last post | 2013-12-03 10:23 +0000 |
| Articles | 2 — 2 participants |
Back to article view | Back to comp.soft-sys.math.mathematica
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
| From | nkormanik <nkormanik@gmail.com> |
|---|---|
| Date | 2013-11-05 04:15 +0000 |
| Subject | Data 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]
| From | ariel.sepulveda@prontoanalytics.com |
|---|---|
| Date | 2013-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