Stack Overflow
Stack Overflow

Questions tagged [intersect]

The SQL intersect operator returns rows that are common between two tables without returning duplicate records.

643 questions
1
vote
1 answer

Intersect with 2 EntityCollections via custom IEqualityComparer

Not to repeat this question too much, but I already did a search and came up empty on a result. So I have two EntityCollections of type T and I would like to find the common items in each. The catch? All fields except one must match. So for…
dangerisgo
  • 1,261
  • 3
  • 16
  • 28
1
vote
4 answers

intersect 4 lists in python with list comprehension

Is there a way to do with list comprehension the following: I have 4 lists: t1, x1(t1), t2, x2(t2). t1 and t2 have different length, and so do x1 and x2. I want to add up the values of x1 and x2 in which t1 and t2 intersect and for those values…
user3412058
  • 315
  • 1
  • 4
  • 13
1
vote
1 answer

How to Union Intersecting Geometries in Same Geopandas Dataframe

I have a dataframe with circles, some of which intersect others. I want to merge those intersecting regions to be new rows in the dataframe, adding the attributes from the intersecting regions. I only see how to use sjoin between two dataframes.
J. Doe
  • 985
  • 2
  • 10
  • 15
1
vote
1 answer

MySQL geometry intersection produces non-intersecting results

I have a MySQL table of postcodes with the geometric area of each saved as a polygon. I also have a table of regional areas that are also polygons. I'm doing a simple query to find the intersecting area for a particular postcode (ie to find which…
Matthew James Taylor
  • 4,806
  • 5
  • 29
  • 33
1
vote
4 answers

Find non-intersecting parts of a strings vector

I have a string vector. For example: vec <- c("aa.30.1","aa.40.1","aa.50.1") But it may also be: vec2 <- c("a2bsx","a2bsy","a2bsz") Or even: vec3 <-…
dan
  • 6,048
  • 10
  • 57
  • 125
1
vote
2 answers

Multiple SQL SELECT WHERE with INTERSECT, placeholder value

I'm using SQL Server and am trying to do the following: SELECT dword FROM Details WHERE dskey = '51a' INTERSECT SELECT dword FROM Details WHERE dskey = '52b' INTERSECT SELECT dword FROM Details WHERE dskey = '53i' INTERSECT SELECT dword FROM Details…
John Slate
  • 29
  • 1
  • 7
1
vote
2 answers

Delete row with shapes.. TopLeftCell Error

I am currently making an excel template for other people in company to use. I need to delete rows with a single button. I believe I've done everything correctly, but I am keep getting an error. Right below you can see the codes which gives…
Bildircin13
  • 113
  • 2
  • 16
1
vote
2 answers

Get Max Value of overlapping times in a list of Start and End Times

I am trying to get a count of the max value of times where the times intersect. The expected result that I want need from the code example below should be 4. There are a total of 8 times, there are 6 values that intersect in total, a group of 4,…
Simon Price
  • 3,011
  • 3
  • 34
  • 98
1
vote
1 answer

Increasing efficiency of table intersect

I have 2 tables.They are both in the in the form chromosome, start and end coordinates on this chromosome. The first table contains genes and the second table contains short sequences which may or may not fall in these genes. In my real dataset,…
Xizam
  • 699
  • 7
  • 21
1
vote
1 answer

Method 'Intersect' of object '_Global' failed inside a Sheet's module -- ActiveSheet not recognised

I currently use a self made spreadsheet to clock my day. Every time I insert a new activity, it should calculate the time taken me on the last activity. It works fine as is when I create a new spreadsheet everyday, however now I'm thinking to…
kitarika
  • 175
  • 1
  • 12
1
vote
1 answer

Create Vector from LookUp-Table / CSV-File in R

I have a CSV-file, where two columns contain one or more integers per cell. df <- data.frame(x=c("a","b","a","b"), y=c("datatype 1","datatype 1","datatype 2", "datatype 2"), z=c("2,3", "1,2","1,2,3,4,5", "3")) names(df) <- c("hypothesis",…
Ezra
  • 159
  • 1
  • 10
1
vote
1 answer

how to get intersect on redis's sorted sets?

I want to display leaders board for the users who are earning more points from two different games. I am storing user scores as per games using redis's sorted sets, How I can get intersect on these games sorted sets to display common leaderborad.
Suyog Kale
  • 373
  • 6
  • 17
1
vote
2 answers

INTERSECT query in MariaDB

I have a problem with this query in MariaDB language. I want to do an intersect with the same field but with two values. The problem is that i can't use the INTERSECT query. How can I do it?? I have tried with exists and inner join but it still…
Fran Ruiz
  • 13
  • 5
1
vote
2 answers

Missing parenthesis Error when building MATERIALIZED

So I'm trying to build a complex materilized view, but I somehow don't know what I'm writing wrong But for educational purposes, I'm trying to reverse the query while removing the joins and using intersection instead, even thought the query is…
napi15
  • 2,354
  • 2
  • 31
  • 55
1
vote
0 answers

R: mapply versus for loop: identical performance

I am trying to get the most optimized performance for a piece of code, but I am getting almost identical performance between mapply and for loops. Why is that? Would plyr or data.table be faster? Or is there a more efficient way to write my…
Brian A
  • 93
  • 7
1 2 3
…
42 43