Re: Import specific columns from a tsv-file

*To*: mathgroup at smc.vnet.net*Subject*: [mg92202] Re: Import specific columns from a tsv-file*From*: Jean-Marc Gulliet <jeanmarc.gulliet at gmail.com>*Date*: Tue, 23 Sep 2008 07:30:04 -0400 (EDT)*Organization*: The Open University, Milton Keynes, UK*References*: <gb7ocu$nhp$1@smc.vnet.net>

suladna wrote: > I want to import data from a tsv-file to a Table in Mathematica, without the first column of the tsv-file. What should I write to do this? > > Alternatively I can import the whole tsv-file and then drop the first column from my Mathematica-Table.. but I don't know how to do the "drop column" part. In[1]:= imp = Import["file.tsv.txt", "TSV"] Out[1]= {{"line one", "1,1", "1,2", "1,3"}, {"line two", 2.1, 2.2, 2.3}, {"line three", 3.1, 3.2, 3.3}} In[2]:= data = Rest[Transpose@imp] Out[2]= {{"1,1", 2.1, 3.1}, {"1,2", 2.2, 3.2}, {"1,3", 2.3, 3.3}} In[3]:= data = imp[[All, 2 ;;]] Out[3]= {{"1,1", "1,2", "1,3"}, {2.1, 2.2, 2.3}, {3.1, 3.2, 3.3}} (* among many other ways... *) Regards, -- Jean-Marc