25,262
questions
0
votes
0
answers
18
views
Merging CDC Updates Into Snowflake With Varying Updated Columns
I have CDC data coming in json format from an Oracle system into S3 Bucket that looks like this for inserts:
{
"operation": "I",
"position": "...
- 15
0
votes
0
answers
6
views
Data with duplicate headers to a single table without duplicate headers
I have source data (that is loaded from an outside source) that has 193 columns. (The number of rows is dynamic.) Most of these columns have a duplicate column header. I need to compress the data to ...
-2
votes
0
answers
40
views
Combinig two dataframes by date columns [closed]
I would like to merge data2 (with 102 515 ids) to data1 (with 99 754 ids) by "id". I have also into data1 the column "trim_date" and I would like to add data2 if "trim_date&...
0
votes
0
answers
31
views
Resolve conflict with VSCode in the merging branch before merging [duplicate]
I'm using VSCode to resolve merging conflicts, but I've noticed that it uses the "standard" auto-merge option. When you have resolved all the conflicts, it creates a commit with all the ...
- 1,507
0
votes
0
answers
9
views
R: sp::merge does not merge sp-object and df as wanted
I am trying to join a sf-object and a df by a common column name, and have tried sp::merge without succeeding.
Sorry for formatting in advance.
I would like to keep all data from the sf object, ...
- 1
0
votes
2
answers
42
views
in jq, how to merge an array of object into 1 object with an array of values
Let's say I have this json:
[
{
"first": 12355,
"second": "abc"
},
{
"first": 89010,
"second": "def"
},
{
&...
- 5,524
0
votes
0
answers
14
views
merge rows based on first column and concatenate all other columns with comma delimiter [duplicate]
df0:
CC AN
0 67562 EPC9999A
1 67562 EPC9999B
2 67994 EPXFXXXA
3 67995 EPXFXXXS
Desired Result:
...
- 1
1
vote
2
answers
35
views
Merge approx. same timeseries, round time (minutes)
I have two timeseries from two different sensors. Because of internal timestamp settings they differ in a few minutes. I would like to combine them, ignoring the exact time:
#Timeseries 1
t = seq(as....
- 15
-2
votes
1
answer
73
views
What is the best way to merge two lists by markers inside them? [closed]
For example, I have two lists:
list1 = ['x', 'x', 'o', 'o', 'x', 'x']
list2 = ['o', 'x', 'o']
I'd like to merge them in a way, that they're aligned by some markers (here it is o), so I'd like to get:
...
- 276
-1
votes
1
answer
35
views
Git - how to merge a branch, but ignore one of the changes
I have two C# solutions. One is a nuget project - a library (CodeFirstWebFramework) that the other solution (AccountServer) uses.
On my main Account Server branch, the solution contains just ...
- 2,921
0
votes
0
answers
17
views
Merge two dataframes by replacing nans in r [duplicate]
I have the following two dataframes:
df_1
TE TS LULC DD RI Soil FA
TE NA 0.049 0.077 -0.119 -0.692 -0.035 -0.154
TS NA NA -0.559 -0.462 0.035 0.189 -0.196
LULC NA ...
2
votes
2
answers
66
views
Merge two dataframes and keep non-missing entries
I have two dataframes like this:
set.seed(1)
df1 <- data.frame(id= 1:4, sex= c("m", "m", NA, NA), somevar= letters[1:4], whocares_var= rnorm(4))
df2 <- data.frame(id= 1:6, ...
- 1,188
2
votes
2
answers
45
views
Create a new variable based on non-existing values on another variable in R dataframe
I know the title sounds very basic but I didn't find a solution by searching.
I have a dataframe like this where id refers to a participant:
id condition
1 0
1 0
1 1
1 2
2 0
2 0
2 1
3 ...
- 195
0
votes
1
answer
43
views
Node.js - Git - how to handle package-lock.json conflicts properly
The question
It is considered best practice to commit the package-lock.json into source repository.
My question is how to handle package-lock.json merging when there are some huge discrepencies ...
- 11
1
vote
1
answer
63
views
Multiple Unique Constraints in SQL, MERGE INTO problem
I have a table in postgresql, with primary key on col1, and unique not null constraint on col2.
Now, i have a bunch of rows that needs to be inserted. I cannot use INSERT INTO ON CONFLICT DO UPDATE ...
