MathGroup Archive 2011

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Please add me to this group

  • To: mathgroup at
  • Subject: [mg117115] Re: Please add me to this group
  • From: "Kevin J. McCann" <Kevin.McCann at>
  • Date: Thu, 10 Mar 2011 06:08:37 -0500 (EST)
  • References: <il7qbb$duc$>

A bit more transparent is

column1 = allData[[All,1]];
column2 = allData[[All,2]];



On 3/9/2011 7:03 AM, Michael Stern wrote:
> You will probably get a lot of answers to this. In the simplest case,
> save your mathematica notebook into the same directory where your excel
> spreadsheet lives.
> You can then use something like the following to load the entire workbook:
> allData = Import[NotebookDirectory[]<>  "data.xlsx", "Data"]
> And can extract each column with something like
> column1 = Transpose[allData[[1]]][[1]]
> column2 = Transpose[allData[[1]]][[2]]
> Cheers,
> Michael
> On 3/8/2011 5:32 AM, Len Horton wrote:
>> As a new user of Mathematica and as a purchaser of the Home Edition,
>> which does not include any support, I am trying to figure out how to
>> take data from an Excel spreadsheet into Mathematica to analyze and
>> graph.
>> I have taken a couple of free seminars on line, but I have not been able
>> to figure out how to do just a few basic statistical things.  Each
>> column in my spreadsheet is a variable.  In order to produce a histogram
>> of one of those variables, I had to open the spreadsheet in Excel, copy
>> the column, then paste it into the curly braces inside the Histogram
>> function, then eliminate the carriage returns manually while inserting
>> commas manually in order to produce the Histogram.  Surely there must be
>> a faster way.
>> In the first place, I cannot tell where to place the Excel file so that
>> Mathematica knows where it is.  Anything you could do to get me started
>> would be much appreciated.
>> Sincerely,
>> Len Horton
>> Atlanta

  • Prev by Date: Re: Gotcha?
  • Next by Date: Re: How to kill slave kernel securely?
  • Previous by thread: Re: Please add me to this group
  • Next by thread: two figures on same axes with different scales