Data format AFTER import into Mathematica from Excel.xls worksheet
- To: mathgroup at smc.vnet.net
- Subject: [mg131937] Data format AFTER import into Mathematica from Excel.xls worksheet
- From: nkormanik <nkormanik at gmail.com>
- Date: Mon, 4 Nov 2013 23:15:39 -0500 (EST)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
- Delivered-to: l-mathgroup@wolfram.com
- Delivered-to: mathgroup-outx@smc.vnet.net
- Delivered-to: mathgroup-newsendx@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 at gmail.com