duplicates Questions
2
Solved
I am using Snowflake database and ran this query to find total count, number of distinct records and difference:
select
(select count(*) from mytable) as total_count,
(select count(*) from (se...
Lipscomb asked 21/5, 2019 at 22:37
3
Solved
I'm currently creating a program that can compute near-dupliate score within a corpus of text documents (+5000 docs).
I'm using Simhash to generate a uniq footprint of a document (thanks to this gi...
Seismic asked 13/4, 2018 at 15:14
3
Solved
I am trying to use the pandas.cumsum() function, but in a way that ignores rows with a value in the ID column that is duplicated and specifically only adds the last value to the cumulative sum, ign...
Georgiageorgian asked 20/6, 2024 at 0:4
3
Solved
There is a similar question for PHP, but I'm working with R and am unable to translate the solution to my problem.
I have this data frame with 10 rows and 50 columns, where some of the rows are ab...
Klehm asked 7/12, 2012 at 12:35
20
Solved
I have an int array, and am looking for duplicates.
int[] zipcodelist = // ...
duplicates = false;
for(j = 0; j < zipcodeList.length; j++){
for(k = 0; k < zipcodeList.length; k++){
if (zip...
Pessa asked 17/10, 2010 at 1:15
4
http://jsfiddle.net/tXFbk/2/
HTML:
<div class="control-group">
<label for="some_id" class="control-label">Some ID</label>
<div class="controls">
<input type="text" i...
Impetuous asked 20/2, 2013 at 9:15
3
Solved
I have a normalized database and I'm trying to return data from multiple tables using JOINs and GROUP_CONCAT.
Problem: Rows are being duplicated with GROUP_CONCAT. I can't use DISTINCT because so...
Pilferage asked 3/5, 2014 at 23:46
8
Solved
I have a data frame in R which looks like:
| RIC | Date | Open |
|--------|---------------------|--------|
| S1A.PA | 2011-06-30 20:00:00 | 23.7 |
| ABC.PA | 2011-07-03 20:00:00 | 24.31 |
| EFG.PA...
Voiced asked 8/8, 2011 at 18:19
7
Solved
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 the best way?
Stonemason asked 5/5, 2015 at 12:50
4
I have two arrays containing repeating values:
$test1 = [
"blah1",
"blah1",
"blah1",
"blah1",
"blah2"
];
$test2 = [
"blah1",
&quo...
Rebirth asked 9/2, 2016 at 2:21
27
Solved
I need to take a C++ vector with potentially a lot of elements, erase duplicates, and sort it.
I currently have the below code, but it doesn't work.
vec.erase(
std::unique(vec.begin(), vec.end()...
Mirepoix asked 25/6, 2009 at 0:28
2
Solved
I'm trying to duplicate a Redshift table including modifiers.
I've tried using a CTAS statement and for some reason that fails to copy modifiers like not null
create table public.my_table as (sel...
Hornbook asked 1/6, 2017 at 23:4
18
Solved
I'm sure this is an extremely obvious question, and that there's a function that does exactly this, but I can't seem to find it. In PHP, I'd like to know if my array has duplicates in it, as effici...
Juanajuanita asked 29/6, 2010 at 23:52
13
Solved
Possible Duplicate:
Easiest way to find duplicate values in a javascript array
How do I check if an array has duplicate values?
If some elements in the array are the same, then return true...
Clearly asked 11/9, 2011 at 6:4
11
I am supposed to read in a file containing many different email addresses and print them out using an array. The problem is I need to eliminate duplicate emails.
I was able to get my try / catch ...
Wafd asked 7/4, 2012 at 17:35
6
Solved
I have two lists List that I need to combine in third list and remove duplicate values from that lists
A bit hard to explain, so let me show an example of what the code looks like and what I want ...
Ruzich asked 27/10, 2010 at 8:35
18
Solved
Grouping elements in array by multiple properties is the closest match to my question as it indeed groups objects by multiple keys in an array. Problem is this solution doesn't sum up the propertie...
Hagerty asked 17/10, 2017 at 15:51
6
there is a function to delete data from a Delta Table:
deltaTable = DeltaTable.forPath(spark, "/data/events/")
deltaTable.delete(col("date") < "2017-01-01")
But is there also a way to drop du...
Cytochrome asked 8/5, 2020 at 7:48
4
Solved
I've written this code to find duplicates and it works fine:
SELECT *
FROM StyleTable
GROUP BY Color
HAVING count(*) > 1
The problem is, it's returning just one of the duplicate rows. Is it...
Landscapist asked 5/3, 2012 at 22:12
6
Solved
Please look at the following query:
tbl_Contents
Content_Id Content_Title Content_Text
10002 New case Study New case Study
10003 New case Study New case Study
10004 New case Study New case Study
...
Vendetta asked 31/3, 2014 at 18:43
5
I am using the java and Spring. As a test, I query an object by id, then try to save the same object without updating anything. I get a duplicate key exception when I do this. According to what I'v...
Fabien asked 3/5, 2016 at 0:0
15
Solved
I have a text file that contains a long list of entries (one on each line). Some of these are duplicates, and I would like to know if it is possible (and if so, how) to remove any duplicates. I am ...
Smoothtongued asked 8/12, 2008 at 22:24
34
Solved
It's easy to find duplicates with one field:
SELECT email, COUNT(email)
FROM users
GROUP BY email
HAVING COUNT(email) > 1
So if we have a table
ID NAME EMAIL
1 John [email protected]
2 Sa...
Urinate asked 7/4, 2010 at 18:17
4
Solved
Here is an example data frame to show my problem and what I want to achieve.
Here I have two columns, x and y, that I want to remove duplicates from. I also have column z that contains the a sorted...
Claw asked 18/12, 2023 at 15:40
20
Solved
I am using MySQL 5.1.56, MyISAM. My table looks like this:
CREATE TABLE IF NOT EXISTS `my_table` (
`number` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`money` int(11) NOT NULL,
PRIMARY KEY...
Hebraic asked 30/10, 2012 at 4:13
1 Next >
© 2022 - 2025 — McMap. All rights reserved.