1,690 questions
0
votes
2
answers
69
views
Outer join numpy arrays, fill with 0
In Python, I have two arrays:
import numpy as np
a = np.array([
[1, 0.2],
[2, 0.5],
[3, 0.8]])
b = np.array([
[2, 0.4],
[3, 0.7],
[4, 1.3],
[5, 2]])
I need to do an "outer join&...
- 179
0
votes
1
answer
169
views
Why is LEFT INNER JOIN deprecated? [closed]
Why is LEFT INNER JOIN deprecated, removed or no longer recommended?
The join syntax specifies the driving table first (using LEFT or RIGHT), followed by the join method (INNER or OUTER).
- 19
1
vote
2
answers
176
views
Full outer join but matching only first occurrence
I have table A:
ID Date Amount TimeRef
---------------------------
xx 29/Jan 10 123
xx 29/Jan 10 345
And table B:
ID Date Amount UIQ
---------------------------
xx ...
- 133
0
votes
4
answers
136
views
Query outer join fixed values
I would like to query some IDs (fixed values) into a table, like a "outer join" with the mandatory fields should be the fixed values. I have to do the same for SQL Server and MySQL, but with ...
- 1,144
3
votes
1
answer
451
views
Is it possible to join two SwiftData models into a single list?
I have three models SwiftData - a parent Event related to two others. I am trying to write a query that joins the two sub-models and filters to only show the results that match the selected event.
...
- 33
0
votes
0
answers
140
views
outer join in pyspark between a huge DF and a very small DF
I'm trying to make an outer join of DF A (with 433 Million rows) and DF B (with 14 rows) in PySpark and I have directly a OOM error. Does Spark is not good for this kind of join ?
result = DF1.join(...
- 45
2
votes
1
answer
189
views
How to Populate Null Values in Columns After Outer Join in Python Pandas
My goal is to join two dataframes from different sources in Python using Pandas and then fill null values in columns with corresponding values in the same column.
The dataframes have similar columns, ...
- 401
-1
votes
1
answer
41
views
doing outer for really large data frame hitting memory usage in R
So i have three data frame having this information
> dim(result)
[1] 652265 10
> dim(rat)
[1] 107190 2
> dim(mouse)
[1] 219016 2
> names(result)
[1] "ensembl_gene_id&...
- 1,016
0
votes
2
answers
115
views
Using Join in python [closed]
I am converting an SQL code, that has a join function, to Python.
This is the SQL code:
INSERT INTO tropical_fruits
SELECT DISTINCT A.*
FROM fruits A LEFT OUTER JOIN tropical_fruits B
ON A.[fruit1] =...
- 11
-1
votes
2
answers
44
views
Select only a row if one of the joined columns meets both conditions in Postgresql
Please suppose these two tables:
users table:
id
account_id
1
1
2
1
3
1
4
1
user_labels table:
id
user_id
title
1
2
label1
2
2
label2
3
1
label1
4
1
label2
now I want to select users who have both ...
- 307
0
votes
1
answer
63
views
Join 2 tables where the first table has the time stamp and the second table has the applications opened during that time
I need to join 2 tables in SQL Server. First data set has the total time spent by an agent on a particular activity during the day and the second data set is a breakup of that time spent per ...
1
vote
1
answer
49
views
Pandas merge dataframe with the same columns and one one varying
Probably already asked before, buy I cannot find it even after 30 mins of searching.
I have two pandas dataframes with the same columns. The values match except for one column and I want to perform a ...
- 340
0
votes
0
answers
64
views
Outer Join and then calculating the counts in Laravel
I'm trying to calculate counts of relationship based on where conditions with help of CASE statement in my Laravel application.
I've a Project Model which has ManyToMany relationship with Professional ...
- 157
0
votes
2
answers
335
views
joining two tables with multiple keys in excel? [closed]
Table A:
From_Node
To_Node
Avg_Time_real
1975
3752
4.06
1975
4874
28
1975
4900
23.4
1975
5016
27.4
3752
5949
4
3752
6204
32
3752
6228
16
7100
1004
9
7100
1006
10
4874
1975
29
4874
3752
28
Table B:
...
- 13
0
votes
1
answer
1k
views
SQL Join types and possible minimum and maximum number of rows [closed]
enter image description here
I have 2 tables, both contain a column user_id; table 1 has 50 rows and table 2 has 100 rows. If I perform an inner join, left join, right join and full outer join from ...
- 11
0
votes
1
answer
68
views
SQL joining 2 tables to fill blank fields
I have 2 tables and want to join them.
Table1:
Period
Sale
Q1
30$
Q2
40$
Table2:
Period
Sale
Q1
10$
Q2
as you can see, Table2 has no Sale-Value in Q2. Now I want to fill this field with the field of ...
- 11
-1
votes
1
answer
80
views
How to delete duplicates if all the their linked values in another table (foreign key linked rows) are also the same
I have three tables:
x (column1,..., x_id)
y (column1, column2, colum3, ..., x_id, y_id)
z (column1, column2, colum3,..., x_id, y_id, z_id)
My final goal: delete duplicates in y table if all of ...
- 168
-1
votes
1
answer
51
views
Outer merge two dataframe in python where the left dataframe is larger than the first
I am trying to perform an outer join (union) of two time series in python.
The left time series is larger than the first.
An example:
Right time series - df_1
Time
Series 1
3
1
4
2
5
3
Left time ...
- 11
2
votes
1
answer
55
views
How to get data from three joined tables, and always show data from 1st, and nulls or existsing records from 3rd?
I have three tables, Roles, Users, and connecting table.
I want to show all roles, and existence of it for particular user.
Basically a table with roles, which check box "in role" on the ...
- 674
2
votes
1
answer
101
views
SciPy equivalent of np.minimum.outer
I need to do the outer product of two (large) sparse vectors, taking a minimum of the values instead of multiplication. I need an efficient way to perform this.
The build-in point-wise multiplication ...
- 123
-1
votes
1
answer
25
views
Combine more than 3 data.frames while keeping the extra-rows from the master file that didn't match
I have the following data.frame "A" in R:
ID
1
456
200
550
110
and the following data.frame "B" defined in R
ID
Interaction
Student
Date
1
email_sent
Isabel Gauss
10/20/2021
200
...
- 15
-1
votes
1
answer
51
views
Full outer join not working, got a multi-part identifier could not be bound error [closed]
I am doing a full outer join of two tables, but received the multi-part identifier could not be bound error. I couldn't figure out why as I have checked everything else.
SELECT A.INTEGRATION_ID,
...
- 17
0
votes
3
answers
1k
views
Update one Pandas dataframe from another and append rows if needed
I have the following dataframes in Pandas:
df1:
index column
1 A1
2 A2
df2:
index column
2 A2_new
3 A3
I want to get the result:
index column
1 A1
2 ...
- 147
2
votes
4
answers
60
views
Side-by-side comparison of df's with duplicates_dropped
I have the following very basic df's:
df1:
A B
0 1 4
1 2 5
2 3 6
df2:
A B
0 1 4
1 2 7
2 3 6
I would like to have a comparison of them where the result is showing ...
- 203
-3
votes
1
answer
212
views
How can I combine two virtual tables from one table, assigning half the data to a new column, without losing data
I have a table formatted as such
age
height
name
15
180
george
16
192
phil
20
148
lily
17
187
george
19
196
phil
24
147
lily
19
190
george
20
199
phil
22
148
lily
21
190
george
27
197
phil
60
138
lily
...
- 517