Questions tagged [merging-data]
173 questions
0
votes
3 answers
Merging objects based on their values
I have an array of objects and I’m trying to combine them together into a single object, based on their values.
For example, if I have this array:
const arr = [
{mo: true, tu: true, we: {...another object}, th: true, fr: true, sa:…
Cal Courtney
- 1,279
- 2
- 10
- 22
0
votes
0 answers
I'm getting an error "PIL.UnidentifiedImageError: cannot identify image file <_io.BytesIO object at 0x000001FFA78D10E0>" when converting bytes to img
I am attempting to merge 2-byte arrays together and convert the bytes all together back into an image. However, I keep getting the issue "open raise UnidentifiedImageError( PIL.UnidentifiedImageError: cannot identify image file <_io.BytesIO object…
Humza
- 1
0
votes
1 answer
How can I coalesce two columns with alternating missing values (Yes/No survey data)?
I am trying to merge two columns in my dataset based on binary survey responses (Yes/No).
The dataset looks like this:
Treatment1: "No", N/A, N/A, "Yes", "No", N/A, "No" ...
Treatment2: N/A, "Yes", "No", N/A, N/A, "No", N/A ...
The scores are thus…
0
votes
0 answers
Using Power BI for Merging 4 Different Tables With Different Initial Starting Dates Into Additional Single Table : Feasible?, if yes, how
I have been directed to ascertain the feasibility of using Power BI for merging four different tables with different initial starting dates into an additional single table : Each of these four tables involves an ongoing project of monitoring and…
Richard Argento
- 1
- 2
0
votes
5 answers
Extracting a common Object from two Javascript objects with same keys
I have two Javascript objects with the same keys but the keys with some value in obj1 are empty in obj2 and vice versa. There can also be keys that are empty in both objects.
obj1 = {
a: 1,
b: 2,
c: ' ',
d: ' ',
e: ' '
}
obj2 = {
a: ' ',
b:…
Muhammad Ushay
- 93
- 7
0
votes
2 answers
XSLT - Merge 2 elements and add some other elements instead of one of them
Good morning,
What I want to do:
I have the following xml (it's a part of the xml, not the complete)
Alex Mutschl
- 27
- 1
- 7
0
votes
1 answer
Merging data and filling in missing data
I have two sets of data:
Unique ID
1
2
3
Date
2020
2021
2022
Is there a way to merge this so the data looks like below?
Unique…
EpiCat27
- 47
- 3
0
votes
2 answers
Merging columns from different DFs in to one DF-but w missing values. [R]
I have many datasets with two variables-essentially the Year and the value. The dataset goes from 1960-2019, however some variables skip a year or two, or are only from 1990-2019, etc. This is an example:
---LND.KM--- …
user15770147
0
votes
1 answer
Matching up responses of two different data sets and adding parts of one to the other
I have two unrelated datasets in R.
Dataset A contains hundreds of words given as responses in an experiment. Some of the words come up several times, there are 25 responses per participant, with 112 participants. It is formatted like this:
ID …
user13343754
- 91
- 5
0
votes
1 answer
How to merge datastes using pandas merge function while having non-unique merging keys
I have huge data that in two files I want to merge them but the merging key 'ChannelPartnerID' does not have unique values in every row in one of the data set. I want it to merge it with the first matching row in the second data set and give NaN…
Khalid Mohamed
- 5
- 2
0
votes
1 answer
How do i merge these two collections in the same database to look like a single document
I am working on an inventory management app. I have to collections in my database. One contains the product information uploaded along with the username like this
{
"_id" : ObjectId("60c6f5d5a9304624908d2b9f"),
"username" : "valorant",
"id" :…
K.V.Praneeth Reddy
- 38
- 5
0
votes
3 answers
How to merge multiple raw input CSV's with pandas containing similar columns with slightly different names?
I wrote some code to combine multiple CSV's that are interpretered with Pandas and appended to one combined CSV.
The issue I have is that the CSV files are delivered by multiple parties (monthly) and often contain differences with regard to column…
Stijn
- 121
- 9
0
votes
1 answer
Efficiently joining two data.tables in R (or SQL tables) on date ranges?
I'm using hospital admissions data, and trying to tie together a table of observations:
dt_taken
patient_id
observation
value
2020-04-13 00:00:00
patient01
"Heart rate"
69
...
... with a table of…
Nickopotamus
- 51
- 6
0
votes
1 answer
Merging two dataframes in R by date when some dates are NA
I have two dataframes;
df.tweets <- data.frame(Date = c(as.Date("2020-12-26"), as.Date="2020-12-15", as.Date="2021-01-12"), Tweet = c("abs", "ksk", "sks"), Ticker = c("NFLX", "GOOGL", "FB"))
Date Tweet Ticker
1 2020-12-26 abs NFLX
2…
Josephine
- 23
- 4
0
votes
0 answers
Merge a dataframe with an rda file in r
I'm building a process where I need to import 4 large txt data sets on a recurring basis, the files include multiple variables with codes values that need to be converted into a tangible values, I.e. title_code 01 = Manager. I've created 12 rda…
Ricky
- 123
- 9