Category "duplicates"

Pandas - Duplicate Rows and Slice String

I'm trying to create duplicate rows during a dataframe on conditions. For example, I have this Dataframe. students = [ ("a", "Ursula"), ("b", "Hayfa, Ma

Python Duplicated attributes in XML file

I am new programming Python, and I cant figured out to solve my issue :(. I would like to know it there is a way to list all the duplicated information on an XM

Excel VBA code error type mismatch using worksheetfunction to find duplicates

I get a Type Mismatch Error "13" with the below code. Can anyone assist with where I'm going wrong with my VBA syntax and use of variables. If Applicat

How to find and delete all duplicates from SQL Server database

I'm new to SQL in general and I need to delete all duplicates in a given database. For the moment, I use this DB to experiment some things. The table currentl

How to get the NA rate by column in Tableau Desktop?

I try to get a simple thing with Tableau, the % of null value by column of my dataset. But each time I put my dimensions on my columns it displays all of possib

Remove duplicate combinations in R [duplicate]

I am using R and I would like to remove combinations in a data.frame. Unique function does not seem to do the job. a b c 1 1 4 A 2 2 3 B 3

Fastest way to remove duplicates in a list without importing libraries and using sets

I was trying to remove duplicates from a list using the following code: a = [1,2,3,4,2,6,1,1,5,2] res = [] [res.append(i) for i in a if i not in res] But I wou

sqlite mark duplicates with true or false

I need to create a new column in my dataset (duplicate_name) that contains TRUE if there are more than one record for someone or FALSE otherwise. I found this c

remove duplicates from 2d lists regardless of order [duplicate]

I have a 2d list a = [[1, 2], [1, 3], [2, 1], [2, 3], [3, 1], [3, 2]] How can I get the result: result = [[1,2],[1,3],[2,3]] Where dupli

Mergesorting and Removing Duplicates in C (Any language will work)

This is my first question so I apologize in advance if I leave anything out or am ambiguous on an item. Anyway, this is code I got form GeeksForGeeks.org (arr

JS Find indices of duplicate values in array if there are more than two duplicates

I'm creating coordinate plane Three in a row game so I have to find out if there are three numbers of the same value in the array BUT WITHOUT sorting array beca

How do I get a list of all the duplicate items using pandas in python?

I have a list of items that likely has some export issues. I would like to get a list of the duplicate items so I can manually compare them. When I try to use

How to check if exists any duplicate in Java 8 Streams?

In java 8, what's the best way to check if a List contains any duplicate? My idea was something like: list.size() != list.stream().distinct().count() Is it

Remove pair duplicates from array of values

The problem In lua I have an array of values (specifically - x and y position values) from which I would like to remove duplicate pairs. The array looks as fol

Javascript - Remove duplicate ID from array of objects

Take the following two arrays: const array1 = [ { props: { type : 'text', id : 'item1', name : 'item1', value : '@item1@', },