Top "Duplicates" questions

The "duplicates" tag concerns detecting and/or dealing with multiple instances of items in collections.

MySQL remove duplicates from big database quick

I've got big (>Mil rows) MySQL database messed up by duplicates. I think it could be from 1/4 to 1/2 of …

sql mysql duplicates
Filter to show only duplicate entries in Excel 2010

I have two files: Old and New. I need to remove any entry that Old contains from New. So I've …

excel filter duplicates formula
spark dataframe drop duplicates and keep first

Question: in pandas when dropping duplicates you can specify which columns to keep. Is there an equivalent in Spark Dataframes? …

dataframe apache-spark pyspark apache-spark-sql duplicates
Put entire column (each value in column) in an array?

So i'm making a macro to do a bunch of things. one thing is find duplicates of cells in sheet1 …

vba excel duplicates excel-2010
counting duplicates in a sorted sequence using command line tools

I have a command (cmd1) that greps through a log file to filter out a set of numbers. The numbers …

bash command-line sorting count duplicates
Check and return duplicates array php

I would like to check if my array has any duplicates and return the duplicated values in an array. I …

php arrays duplicates
How to delete duplicate rows without unique identifier

I have duplicate rows in my table and I want to delete duplicates in the most efficient way since the …

sql database postgresql duplicates netezza
Error Code: 1062. Duplicate entry 'PRIMARY'

So, my professor gave me tables to insert it in a database but when I execute his code, MySQL is …

mysql duplicates primary-key mysql-error-1062
How to remove repeated elements in a vector, similar to 'set' in Python

I have a vector with repeated elements, and would like to remove them so that each element appears only once. …

python r duplicates
How to find a duplicate element in an array of shuffled consecutive integers?

I recently came across a question somewhere: Suppose you have an array of 1001 integers. The integers are in random order, …

arrays algorithm duplicates