Welcome to the community!
If I want to remove duplicate rows from a dataframe in R, I use base::unique.
I'm not aware of a function called distinctive in base R, and a quick Google search was in vain. Can you please mention the package where does this function come from?
It'll also be very helpful if you please share a small part of the data set (say df), and different results you obtain (say df_excel and df_R) in a copy-paste friendly format.
In case you don't know how to do it, there are many options, which include:
-
If you have stored the data set in some R object, dput function is very handy.
-
In case the data set is in a spreadsheet, check out the datapasta package. Take a look at this link.