Removing duplicates with multiple constraints

[Juliavv]

Hi all,

I'm trying to remove duplicates in my dataset, but it's not working. I'm using the following function:

CapitalIQ <-
CapitalIQ %>%
group_by(companyname, interestratehighvalue, fyear) %>%

Eliminate firm years with duplicate

filter(n() == 1)

So what I want is that for each fyear and gvkey, I want to remove the duplicates based on the variable interestratehighvalue.

But if I run this code it removes a lot more than what I wanted.

Could anyone help me or give some tweaks to my code?

[jrkrideau]

I think we need to see some sample data.

A handy way to supply some sample data is the dput() function. In the case of a large dataset something like dput(head(mydata, 100)) should supply the data we need. Just do dput(mydata) where mydata is your data. Copy the output and paste it here.

[Juliavv]

Hi,

Thanks for helping, but i figured it out. thanks!