Questions tagged [merging-data]
173 questions
0
votes
3 answers
What is the best way to concat/merge below two array without disturbing sort order?
example array are as below:
var aa = [{date: "sep", data:[1,2,3]}, {date: "oct", data:[4,5,6]}];
var bb = [{date: "oct", data:[1,2,3]}, {date: "nov", data:[40,50,60]}, {date: "dec", data:[41,51,61]}];
after merging result should look like:
…
love-for-coding
- 229
- 2
- 8
0
votes
3 answers
How merge a dict and a list and adding more value to it?
we have this dict and this list
mydict={a:1,b:1}
mylist=[a,b,a,c]
I want to merge that list into the dict like this:
mydict={a:3,b:2,c:1}
Kori
- 15
- 3
0
votes
2 answers
Merge flash site into one executable
I need somehow to merge flash site into one executable.
Site consists of:
index.html
images
sounds
pdfs
etc.
After clicking on a merged file, index.html is needed to be opened.
Is this possible?
=====================================
Adobe AIR might…
xZ6a33YaYEfmv
- 1,816
- 4
- 24
- 43
0
votes
1 answer
Multiple data sources: data storage and retrieval approaches
I am building a website (probably in Wordpress) which takes data from a number of different sources for display on various pages.
The sources:
A Twitter feed
A Flickr feed
A database on a remote server
A local database
From each source I will…
dianovich
- 2,288
- 21
- 34
0
votes
2 answers
How to merge two data frames based on unique ID's and changing/updating a column
I have just been given 2 sales data frames; the main data frame houses all the information while the second has the latest sales for the month.
I need to merge the information from one data frame into the other based on a client's unique ID.…
mcl76
- 1
- 3
0
votes
1 answer
SQL Eliminate Duplicates whilst merging additional table
i have two tables, ADDRESSES and an additional table CONTACTS. CONTACTS have a SUPERID which is the ID of the ADDRESS they belong to.
I want to identify duplicates (same Name, Firstname and Birthday) in the ADDRESSES Table and merge the contacts of…
HBecks
- 11
- 3
0
votes
0 answers
weighting methodology. 0 sample cell merging
Input DataFrame looks like
enter image description here
In the above case, i need to write a code saying If we have cell with sample 0, then merge it with immediate above cell, and divide the universe and allot the weight accordingly.
Final Weights…
Srikanth Ayithy
- 99
- 9
0
votes
0 answers
Merging Multiple xlsx Files into one sheet
Currently I am trying to merge multiple excel files into one Using python. What I have so far is as follows:
sharedDocs = "C:\\SPSharedDocuments\\*.xlsx"
invoices = "C:\\SPInvoices\\*.xlsx"
formsCerts = "C:\\SPForms&Certificates\\*.xlsx"
mgmt =…
RChicas23
- 3
- 3
0
votes
1 answer
How do I match a column entry from one df to a different df; and if they're the same, append another column's entry from the first df to the 2nd df?
CONTEXT:
I have two dataframes that have the following set up:
df1 looks like this...and goes on for about 3500 rows:
| id1 | id2 |
|:----|------:|
| a | name1 |
| b | name2 |
| c | name3 |
| d | name4 |
| e | name5 |
| f |…
cross12tamu
- 13
- 4
0
votes
0 answers
Python two tables merge returns empty dataframe
I am fairly new to both Python and Stackoverflow, so please accept my apologies if I've overlooked anything.
I am simply trying to merge two tables.
Table1: incomeStates
Int64Index: 48 entries, 0 to 47
Data…
Johnny Petr
- 31
- 3
0
votes
1 answer
tolower function and merging two dataframes
I have 3 dataframes called respectively: barometre2013, barometre2016, barometre2018.
I've already merge barometre2018 and barometre2016 like this:
baro1618 <- merge(barometre2016, barometre2018, all = TRUE)
All was good, I have all rows of the…
Marine Leroi
- 23
- 1
- 6
0
votes
1 answer
Merging two associative arrays where the second array has more keys php?
I have been reading this question here as I have a similar challenge:
Merging two multidimensional associative arrays
I have a very similar problem where I am trying to merge 2 associative arrays together but they act in a 'parent/child' model where…
AshBash
- 27
- 6
0
votes
2 answers
How to combine data points in a data frame in R?
The data frame x has a column in which the values are periodic. For each unique value in that column, I want to calculate summation of the second column. If x is something like this:
x <- data.frame(a=c(1:2,1:2,1:2),b=c(1,4,5,2,3,4))
a b
1 1 1
2 2…
wthimdh
- 476
- 1
- 5
- 19
0
votes
0 answers
Merging similar columns in different tables SQL
Right now I have two separate tables created as such
SELECT *
FROM PROD_EDW.ADMIN.FACT_DAILY_DEPOSIT_ACCOUNT_SNAPSHOT ac
left join PROD_EDW.ADMIN.DIM_ACCOUNT_TYPE actyp on (
actyp.ACCOUNT_TYPE_KEY = ac.ACCOUNT_TYPE_KEY
)
LIMIT…
ColtonMSU
- 41
- 6
0
votes
2 answers
Combining data from multiple records into multiple columns of a single record in SQL
Please find below my table structure and test data.
CREATE TABLE TX(
TX_ID VARCHAR2(10),
DESCRIPTION VARCHAR2(100),
CONSTRAINT "PK_TX" PRIMARY KEY ("TX_ID")
);
CREATE TABLE PARTNER(
TX_ID VARCHAR2(10),
PTNR_ID VARCHAR2(10),
…
Keerthi Sagar
- 29
- 5