Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2008

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

Search the Archive

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


  • Prev by Date: Re: Re: External packages, Manipulate, and MathPlayer
  • Next by Date: A Package Function Tutorial
  • Previous by thread: Re: Import specific columns from a tsv-file
  • Next by thread: How to collect terms based the total power of x and y in (x + y +