I got the dataset after merge two old one .The id of the column isn?t just the number of the column.So when I identify some obs,I got the figure 28000(though my obs is only 6000).So it causes the trouble to remove these obs in the dataset.I wander how to make the id of the merged dataset in a right order.Or what could I do when I did identify the id of the outliner(but not the number of the column it belongs to ) when I need to remove those obs. Thanks for your time.
Perhaps I do not understand you correctly but why not create a variable for the id before you merge? On 09/06/2016 09:00, ? ?? wrote:> I got the dataset after merge two old one .The id of the column isn?t just the number of the column.So when I identify some obs,I got the figure 28000(though my obs is only 6000).So it causes the trouble to remove these obs in the dataset.I wander how to make the id of the merged dataset in a right order.Or what could I do when I did identify the id of the outliner(but not the number of the column it belongs to ) when I need to remove those obs. > Thanks for your time. > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. >-- Michael http://www.dewey.myzen.co.uk/home.html
How do you merge the two data.frames? Could it be that you make an outer join? HTH Ulrik On Thu, 9 Jun 2016 at 19:45 Michael Dewey <lists at dewey.myzen.co.uk> wrote:> Perhaps I do not understand you correctly but why not create a variable > for the id before you merge? > > On 09/06/2016 09:00, ? ?? wrote: > > I got the dataset after merge two old one .The id of the column isn?t > just the number of the column.So when I identify some obs,I got the figure > 28000(though my obs is only 6000).So it causes the trouble to remove these > obs in the dataset.I wander how to make the id of the merged dataset in a > right order.Or what could I do when I did identify the id of the > outliner(but not the number of the column it belongs to ) when I need to > remove those obs. > > Thanks for your time. > > ______________________________________________ > > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > > 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. > > > > -- > Michael > http://www.dewey.myzen.co.uk/home.html > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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.[[alternative HTML version deleted]]
We really need a reproducible example. Otherwise, we can only guess what the starting point was, how the merge was done, what the expected result was, and how the obtained result differed from the expected result. Dan Daniel Nordlund, PhD Research and Data Analysis Division Services & Enterprise Support Administration Washington State Department of Social and Health Services> -----Original Message----- > On 09/06/2016 09:00, ? ?? wrote: > > I got the dataset after merge two old one .The id of the column isn?t just > the number of the column.So when I identify some obs,I got the figure > 28000(though my obs is only 6000).So it causes the trouble to remove these > obs in the dataset.I wander how to make the id of the merged dataset in a > right order.Or what could I do when I did identify the id of the outliner(but > not the number of the column it belongs to ) when I need to remove those > obs. > > Thanks for your time.