select rows with unidentical column values

Posted by Bazon on Stack Overflow See other posts from Stack Overflow or by Bazon
Published on 2010-05-20T01:08:00Z Indexed on 2010/05/20 1:10 UTC
Read the original article Hit count: 365

Filed under:

select

|

rows

Hi Guys, I need to create a new data frame that excludes dams that appear in "dam1" and "dam2" columns on the same fosdate (fostering date). I tried df <- df[df$dam1!=dam2,] but did not work. Dam1 and dam2 are factors which are the ids's of mothers.

my df: fosdate dam1 dam2 8/09/2009 2Z523 2Z523 30/10/2009 1W509 5C080 30/10/2009 1W509 5C640 30/10/2009 1W509 1W509 1/10/2009 1W311 63927

The new data frame that I need to get is: dfnew: fosdate dam1 dam2 30/10/2009 1W509 5C080 30/10/2009 1W509 5C640 1/10/2009 1W311 63927

Would appreciate any help!

Bazon

© Stack Overflow or respective owner

Related posts about select

HTML muliple select should look like HTML select

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to use a HTML select box with 'multiple' select options and size to 1 as below ` <SELECT NAME="toppings" MULTIPLE SIZE=5> <OPTION VALUE="mushrooms">mushrooms <OPTION VALUE="greenpeppers">green peppers </SELECT> When the size is set to 1 small scrollbar appears… >>> More
MySQL Query Select using sub-select takes too long

as seen on Stack Overflow - Search for 'Stack Overflow'
I noticed something strange while executing a select from 2 tables: SELECT * FROM table_1 WHERE id IN ( SELECT id_element FROM table_2 WHERE column_2=3103); This query took approximatively 242 seconds. But when I executed the subquery SELECT id_element FROM table_2 WHERE column_2=3103 it… >>> More
SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

as seen on SQL Authority - Search for 'SQL Authority'
Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click here to… >>> More
Nesting Linq-to-Objects query within Linq-to-Entities query –what is happening under the covers?

as seen on Programmers - Search for 'Programmers'
var numbers = new int[] { 1, 2, 3, 4, 5 }; var contacts = from c in context.Contacts where c.ContactID == numbers.Max() | c.ContactID == numbers.FirstOrDefault() select c; foreach (var item in contacts) Console.WriteLine(item.ContactID); Linq-to-Entities… >>> More
Play Framework: Error getting sequence nextval using H2 in-memory database

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory. I set up a basic unit test: public class ModelTest { @Test public void checkThatIndustriesExist() { running(fakeApplication(inMemoryDatabase()), new Runnable() { public… >>> More

Related posts about rows

in MSSQL Server 2005 Dev Edition, I faced index corruption

as seen on Server Fault - Search for 'Server Fault'
Hi all, When running stored procedures in MSSQL Server, I found it failed and the DBMS (MSSQL Server 2005 Dev Edition) notified that some indexes are corrupted. Please advice me, here below is DBCC logs: DBCC results for 'itopup_dev'. Service Broker Msg 9675, State 1: Message Types analyzed: 14… >>> More
Mulitple full joins in Postgres is slow

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a program to use the IMDB database and am having very slow performance on my query. It appears that it doesn't use my where condition until after it materializes everything. I looked around for hints to use but nothing seems to work. Here is my query: SELECT * FROM name as n1 FULL JOIN… >>> More
Strange: Planner takes decision with lower cost, but (very) query long runtime

as seen on Stack Overflow - Search for 'Stack Overflow'
Facts: PGSQL 8.4.2, Linux I make use of table inheritance Each Table contains 3 million rows Indexes on joining columns are set Table statistics (analyze, vacuum analyze) are up-to-date Only used table is "node" with varios partitioned sub-tables Recursive query (pg = 8.4) Now here is the explained… >>> More
Random Page Cost and Planning

as seen on Stack Overflow - Search for 'Stack Overflow'
A query (see below) that extracts climate data from weather stations within a given radius of a city using the dates for which those weather stations actually have data. The query uses the table's only index, rather effectively: CREATE UNIQUE INDEX measurement_001_stc_idx ON climate.measurement_001 … >>> More
Update multiple rows with known keys without inserting new rows if nonexistent keys are found

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, Let's imagine that we have table items... table: items item_id INT PRIMARY AUTO_INCREMENT title VARCHAR(255) views INT Let's imagine that it is filled with something like (1, item-1, 10), (2, item-2, 10), (3, item-3, 15) I want to make multi update view for this items from data taken… >>> More