25,243 questions
5
votes
2
answers
143
views
Drop duplicate values when merging dataframe
I have a DataFrame that I want to merge and drop only duplicates values based on column name and row. For example, key_x and key_y has the
same values in the same row in row 0,3,10,12,15.
My DataFrame
...
- 57
0
votes
2
answers
171
views
Error due to single-level dataframe merge with multi-level indexed dataframe
# Read lookup file which only contains 5 columns.
df_lookup = pd.read_excel(
os.path.join(path, 'lookup.xlsx'),
index_col=[0, 1, 2, 3, 4])
# sample df_lookup
# |A |B |C |D |E |
# |--|--|--|--|...
- 27
2
votes
1
answer
44
views
How to join a pivoted table with other tables
I’m working with the DolphinDB Python API to analyze financial data, but I can’t join a table transformed by pivotby() with another table directly. The error says TablePivotBy has no merge attribute. ...
- 31
3
votes
3
answers
80
views
Looking for a clean way to reword a few commits from before multiple merges were done without having to re-resolve conflicts
Note: I have already looked at the following answers and they don't seem to apply or work in the way I expect them to work:
Reword one commit prior to merge
Squashing old git commits that were before ...
- 1,803
-1
votes
1
answer
119
views
How can I merge two lists in Python while removing duplicates but preserving the original order? [duplicate]
I have two lists in Python:
list1 = [1, 2, 3, 4]
list2 = [3, 4, 5, 6]
I want to merge them into a single list such that:
No duplicates remain
The original order of elements is preserved
For the ...
0
votes
0
answers
40
views
join not merging data from both tables rapidminer
I am trying to join two outlier tests, by attribute id, the outliers discovered from LOF_Outliers and the outliers discovered from Distance_Outliers.
But only one of these two outliers is showing:
...
- 145
2
votes
1
answer
82
views
Why is `git merge-base` non-deterministic?
This is a follow-up question to my attempt at debugging a merge conflict. Instead of the complex case there, consider the following script that re-creates the "same" repo every time:
#!/bin/...
- 10.6k
1
vote
0
answers
133
views
In a merge conflict, why would `git log --merge` only show a single commit?
I'm trying to merge the branch feature1 into the branch main, but I'm getting merge conflicts:
$ git status
On branch main
Your branch is up to date with 'origin/main'.
nothing to commit, working ...
- 10.6k
1
vote
2
answers
92
views
How to find columns not matching in Pandas Merge?
I'm performing data validation in Python using the Pandas module. I have two datasets to compare source and target data for expected values. I've successfully merged two dataframes using pd.merge and ...
0
votes
1
answer
174
views
Diagnosing duplicate inserts after merge/upsert with deltalake (Python)
I’d really appreciate your help with a duplication issue I’m hitting when using deltalake merges (Python).
Context
Backend: Azure Blob Storage
Libraries: deltalake 1.1.4 (Python), Polars 1.31.0 (...
- 456
0
votes
2
answers
117
views
Pandas merge one-to-many [duplicate]
I'm trying to merge two pandas DataFrames on multiple columns. It is a many-to-one relationship. There are many of the same values in df1 but only value in df2.
These are the example DataFrames :
df1 =...
- 283
0
votes
0
answers
67
views
GitHub updating old PR branch
I have about a year old branch with submitted PR.
About 6 month later I tried to pull the latest master in but for some reason didn't finish.
Now I'll try to complete the PR and submit it for ...
- 6,455
2
votes
3
answers
133
views
How to left join two datasets in r based on several conditions? [closed]
I have two datasets (Each dataset around 1.8M rows), one contains per second data, and the other one sometimes have per second, every two second, or three second. I wanted to join these two datasets, ...
- 321
1
vote
3
answers
90
views
Merge data between 2 tables using the same primary key but different record count
I have 2 tables - Car1:
And Car2:
S_No
Brand
Type
Cost
Tax
Discount
Launch Month
4
Maruti
Baleno
2000000
10
6
June
5
Maruti
Baleno
2500000
11
8
June
Primary key is S.No. column. However, the ...
- 33
0
votes
2
answers
124
views
How to merge only some commits from master to version branch?
We have a challenge with how things have been merged into two different branches in our (public) Git repository.
We have two branches:
master (commits: a, b, c, d, e)
maintenance-8.x.x (commits: a, x, ...
- 463