Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Data format AFTER import into Mathematica from Excel.xls worksheet

  1. Jul 17, 2012 #1
    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

  2. jcsd
  3. Jul 17, 2012 #2
    Mathematica is very likely not using your Excel column titles, but we cannot see your code so we cannot be absolutely certain.

    If you would be willing to generate a small sample Excel sheet (and save it in an old .XLS format rather than any of the newer formats that some of us don't have a version of Excel new enough to read) with the same number of columns and titles and perhaps half a dozen or a dozen rows

    AND create a small simple version of your Mathematica notebook that shows how you are currently importing your Excel sheet and how you would like to refer to your Excel column names when using the data in a contour plot and describes as clearly as possible what you want to see. If you want to generate thousands of contour plots then this should probably include just enough information so that someone can understand how the notebook needs to be able to do that. These last parts don't necessarily need to work, but they need to communicate clearly enough that someone with Mathematica experience can understand what they need to write for you.

    THEN someone might be able to take a few minutes and see if they can find a way to fiddle the notebook contents to make it do what you want.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook