Re: [R] comparing 2 dataframes

2006-11-07 Thread Priya Kanhai
Hi The problem is I'm first connecting to the Access database with odbcConnectAccess and then select with a sqlQuery the dataframe. In your solution you are typing it. But mine databases consist of approximately 6 records. Maybe you have another solution? Thanks in advance. Regards, Priya

[R] comparing 2 dataframes

2006-11-06 Thread Priya Kanhai
Hi, I''ve a question about comparing 2 dataframes: RRC_db1 and RRC_db2 of different length. For example: RRC_db1: CUSTOMER_ID CUSTOMER_RR 1 1000786BR 5+ 2 1002047BR4 3 10127BR 5+ 4 1004166834BR2 5

Re: [R] comparing 2 dataframes

2006-11-06 Thread Christoph Buser
Hi Maybe this example can help you to find your solution: dat1 - data.frame(CUSTOMER_ID = c(1000786BR, 1002047BR, 10127BR, 1004166834BR, 1004310897BR, 1006180BR, 10064798BR, 1007311BR, 1007621BR, 1008195BR, 10126BR, 95323994BR),