Stack Overflow
Stack Overflow

Questions tagged [merging-data]

173 questions
1
vote
1 answer

How to merge seperate string objects into a list in Python

I have as an end product an object called 'members' and 'pcps' which are themselves actually a bunch of separate string objects. I need to vectorize them into a single list so that I can add them to a dataframe and ultimately as an excel table The…
Ben Smith
  • 360
  • 4
  • 14
1
vote
0 answers

How to merge two decoded images in ijkplayer and show it on the same surface

How can I merge the same decoded frame twice on top of one another while decoding using ijkplayer. My decoded frame is of size 4096*2048. I have created a big overlay of size 4096*4096 and want to put the same frame twice on top of one another. Here…
MSD Paul
  • 1,648
  • 3
  • 13
  • 31
1
vote
2 answers

Trouble merging new data to each data frame element of a list

I am having difficulty using a for loop for appending new data to each data frame element of a list. If I have a list of two data frames (filelist) and I wish to "dplyr::left_join" or "merge" each data frame in the list with other data from a single…
EMS_glenn
  • 29
  • 4
1
vote
0 answers

Pandas: Merge Buffer Error on Renamed Columns

Unfortunately, I can't share the actual data I'm working with for this question, so bear with me as I try to use a generalized example to help explain the error I'm seeing. I have two dataframes, which we will call df_local and df_global, which I…
Locke
  • 11
  • 3
1
vote
0 answers

How to extract/build a Domain Model from Description Logic Knowledge Base(s)

hopefully my question is not trivial or already answered elsewhere. Problem Description Let's assume we have a DL Knowledge Base KmySys = (Tsys, AmySys) representing a software architecture. The knowledge KmySys models software components (e.g.,…
aky
  • 75
  • 4
1
vote
1 answer

Data not applying separator to csv file while concatenating in Pandas

I have a set of csv files that I am trying to concat. I am having issues that the concatenated file does not apply the comma separators to the content. Given below is the code: ##Location where the csv files are located updatedfiles =…
Kevin Nash
  • 1,511
  • 3
  • 18
  • 37
1
vote
2 answers

Mysql merge multiple records with same id ignoring null fields

I'm looking to merge a number of records with the same Id into one record per Id. I have had to use pivot tables to get the data I need from multiple other tables and into an interim table that looks something like this: ID…
BobbyQ
  • 11
  • 1
1
vote
6 answers

Loop a 2d array and merge row data if encountered row key is found in previously stored subarray

I want to consolidate an associative array of indexed arrays by merging rows which have an associative key that is in another row's values. Consider this sample input: $array = [ 44259 => [50007, 50009, 46372], 50007 => [50008], 50009 =>…
Smiley
  • 38
  • 5
1
vote
2 answers

How to merge datasets by common values for variable

I want to merge 6 datasets that have an ID variable. I want to have one data set with ID values common to all datasets. I know this is an easy fix, but I haven;t come across a help topic ex. id month sbp dpb D1 3 40 40 D1 4 10 10 D1 3 …
user9459213
  • 23
  • 4
1
vote
1 answer

merge javascript object to another's root

Is there a way to merge these two object so I can get the desired output(last code snippet)? I have an object generated_calendar that has Q1-Q4 with Periods 1-12 and the weeks object within the period. var generated_calendar = { Q1 : { …
Marvine Chi
  • 177
  • 1
  • 3
  • 10
1
vote
2 answers

Merging two files by ignoring a line with AWK

I have two files: file 1: a 1 2 3 b 1 2 3 c 1 2 3 d 1 2 3 file 2: hola l m n o p q Now I want to merge them in one single file by ignoring the header of file 2 like this: a 1 2 3 l m n o p q b 1 2 3 c 1 2 3 d 1 2 3 Does anyone have an idea…
Wara
  • 304
  • 2
  • 11
1
vote
1 answer

How do I merge two datasets based on the common key in pandas?

I have two datasets that contains domain names: df1: varA domains 123 www.google.com 456 www.ebay.com 789 www.amazon.com 101 www.nbc.com .... df2: urls varB www.cnn.com …
Feyzi Bagirov
  • 1,292
  • 4
  • 28
  • 46
1
vote
0 answers

Pythonic way of doiing multiple comparisons in a function

I have a lot of data sets which I need to sort and potentially merge. The data consists of 2D (x,y)-data from different time points, and what I want to do is this: Read the different time points and see if I have several (x,y) data sets from the…
DonMP
  • 317
  • 2
  • 9
1
vote
2 answers

rxMerge for factored levels

I'm new to RRE, I'm having issue with the rxMerge function. I want to merge two xdf datasets by a factor column that have different number of level. I want an inner join to keep only the matching levels. I get the following error : ERROR: Factor…
Ouriel
  • 81
  • 8
1
vote
1 answer

How can I join 2 rows in a dataframe into 1 row in a new one?

I am filtering an external data source that is formatted as an excel file. There is nothing I can do to change how the file is generated. I need to filter out rows that are useless and combine pairs of rows into one. The process I have so far works…
Fred Mitchell
  • 2,145
  • 2
  • 21
  • 29
1 2 3
…
11 12