Re: Extract columns based on their the title in header
- To: mathgroup at smc.vnet.net
- Subject: [mg131690] Re: Extract columns based on their the title in header
- From: Joug Raw <jougraw at gmail.com>
- Date: Sat, 21 Sep 2013 04:36:50 -0400 (EDT)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
- Delivered-to: l-mathgroup@wolfram.com
- Delivered-to: mathgroup-outx@smc.vnet.net
- Delivered-to: mathgroup-newsendx@smc.vnet.net
- References: <20130920110717.97AEE6A3D@smc.vnet.net>
>>datalist[[All,{1,3}]]
>>--
>>Itai Seggev
>>Mathematica Algorithms R&D
What I want is not to use the number, but the string of the column name.
Because, in reality my table would be super long with thousands of columns.
It is hard for me to know which information stored in which columns, but
the names of the columns have kind of order that allows me to guess. That
is why I need to start from the name string.
On Fri, Sep 20, 2013 at 5:26 PM, Itai Seggev <itais at wolfram.com> wrote:
> On Fri, Sep 20, 2013 at 07:07:17AM -0400, Joug Raw wrote:
> >
> > I import a CSV file like this:
> >
> > Name, Sex, Age, ... , ...
> > Tom, M, 12, ... ,...
> > Bob, M, 13,
> > Lily, F, 11,
> > Jack, M, 14,
> > Micheal, M, 10,
> > ..
> >
> > It become a list and I call it datalist. Then I want only extract the
> Name
> > and Age for each child in the list. I did some thing like:
> >
> > ColumPos =
> > Map[#[[2]] &,
> > Map[Position[datalist, #] &, {"Name",
> > "Age"}], {2}]
> > Map[Extract[#, ColumPos] &, datalist]
> >
> > Yes, it works. But the code are bit complicated. Any one has any idea to
> > get it done in a more efficient way?
>
>
> datalist[[All,{1,3}]]
>
> --
> Itai Seggev
> Mathematica Algorithms R&D
> 217-398-0700
>
- References:
- Extract columns based on their the title in header
- From: Joug Raw <jougraw@gmail.com>
- Extract columns based on their the title in header