how to import a file into mathematica and reference a column by header name

Posted by Tom on Stack Overflow See other posts from Stack Overflow or by Tom
Published on 2010-03-11T04:43:13Z Indexed on 2010/03/12 1:47 UTC
Read the original article Hit count: 412

Filed under:

mathematica

Hi, I have a tsv file with many columns like so; genename X1 X100 X103 X105 X115 X117 X120 X122 X123
Gene20728 0.415049 0.517868 0.820183 0.578081 0.30997 0.395181

I would like to import it into mathematica, and then extract and sort a column.

ie I want to extract column ["X117"] and sort it, and output the sorted list.

Thanks, Tom

Related posts about mathematica

Debugging a working program on Mathematica 5 with Mathematica 7

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everybody, I'm currently reading the Mathematica Guidebooks for Programming and I was trying to work out one of the very first program of the book. Basically, when I run the following program: Plot3D[{Re[Exp[1/(x + I y)]]}, {x, -0.02, 0.022}, {y, -0.04, 0.042}, PlotRange -> {-1, 8}, PlotPoints… >>> More
Mathematica 8 crashes Ubuntu 13.10

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have Mathematica 8 installed on my Ubuntu laptop since 2011. I updated Ubuntu several times, and experienced no problems with Mathematica. It also worked smoothly after I updated Ubuntu to 13.10 (it worked for sure for a week after update). When I tried to start Mathematica today by executing… >>> More
What is in your Mathematica tool bag?

as seen on Stack Overflow - Search for 'Stack Overflow'
We all know that Mathematica is great, but it also often lacks critical functionality. What kind of external packages / tools / resources do you use with Mathematica? I'll edit (and invite anyone else to do so too) this main post to include resources which are focused on general applicability in… >>> More
Running Mathematica-5 remotely

as seen on Server Fault - Search for 'Server Fault'
I have Mathematica 5 - a powerful CAS. I have a cheap netbook (running Windows XP), wich not only is too slow to run mathmatica on, I doubt it has the harddrive space. I do however have remote access to a number of very powerful computers, (most of wich run variose Linuxes, but one of which is Windows… >>> More
How to extract a Date from an SQLDateTime object in Mathematica

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to do a plot of a time series with DateListPlot. I want to feed it a time series I obtain from an SQL database. When I retrieve the time series the list is composed of SQLDateTime entries that DateListPlot doesn't understand. In[24]:= t=SQLExecute[conn, "select timestamp,value from… >>> More

Developer IT

how to import a file into mathematica and reference a column by header name - Developer IT

how to import a file into mathematica and reference a column by header name

mathematica

Related posts about mathematica

Debugging a working program on Mathematica 5 with Mathematica 7

Mathematica 8 crashes Ubuntu 13.10

What is in your Mathematica tool bag?

Running Mathematica-5 remotely

How to extract a Date from an SQLDateTime object in Mathematica

Categories cloud