[R] Subseting

[Jessica Streicher]

data[!(data$Name %in% names), ]

then, and "names" having the 9 names you want to dismiss.

Also please reply to the list as well if you answer, otherwise others won't know of the progress made.

On 02.08.2012, at 11:48, Akhil dua wrote:

> This is the only issue actually
> I dotn want to take the pain of writing names of 40 companies 
> rather than this i want to remove the date for 9 companies which i dont need 
> 
> On Thu, Aug 2, 2012 at 3:00 PM, Jessica Streicher <j.streicher at micromata.de> wrote:
> data[data$Name %in% names, ]
> 
> should work then. You do know which 40 of your 49 banks you want, right?
> put their names in the "names" variable above.
> 
> If you want random 40 banks you can do something like this:
> 
> allNames<-unique(data$Name)
> names<-sample(allNames,40)
> 
> Does that help? You really aren't explaining your problem well^^
> 
> On 02.08.2012, at 11:18, Akhil dua wrote:
> 
> > sry its not firms
> > its banks
> >
> > On Thu, Aug 2, 2012 at 2:42 PM, Jessica Streicher <j.streicher at micromata.de> wrote:
> >
> > On 02.08.2012, at 10:44, Akhil dua wrote:
> >
> > > Hi everyone
> > >
> > > I have banking data set in long format with 4 columns.One of these columns
> > > is bank name which consist of 49 banks and I want the data for only 40
> > > banks out of these 49
> > > so can anyone help me on how to get this 40 banks data
> > >
> > > My data looks like
> > >
> > > Year  Name totalliabilties assets
> > > 1990  a              90            10
> > > 1991  a              89            48
> > > 1992  a              87            34
> > > 1993  a              56            05
> > > 1990  b              90            11
> > > 1991  b              69            43
> > > 1992  b              37            34
> > > 1993  b              46            17
> > > 1990  c              55            10
> > > 1991  c              67            18
> > > 1992  c              34            24
> > > 1993  c              53            35
> > >
> > > please keep in mind that I have 49 firms so I cant do
> > > object<-data[,c("names of the banks I need the data")]
> >
> > That would actually rather be
> > data[data$Name %in% names, ]
> >
> > wouldn't it? You want to extract the rows that belong to a bank you want to retain?
> >
> > what are firms? what have the firms to do with the banks and their names?
> >
> > > and then extract the data for these banks out of the whole sample
> > >
> > >       [[alternative HTML version deleted]]
> > >
> > > ______________________________________________
> > > R-help at r-project.org mailing list
> > > https://stat.ethz.ch/mailman/listinfo/r-help
> > > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> > > and provide commented, minimal, self-contained, reproducible code.
> >
> >
> 
>