Stack Overflow
Stack Overflow

Questions tagged [merging-data]

173 questions
0
votes
0 answers

Google App Scripts Merging Data from multiple Sheets

Not very familiar with Google App Scripts but trying to merge content from multiple tabs into one master sheet. In addition, there are some tabs I want to ignore in the file. I know that by using logger, that the row referencing filteredSheets is…
Berryblue
  • 17
  • 5
0
votes
1 answer

How can I avoid getting extra non matching values after merging dataframes?

I have a DataFrame with multiple columns: #list list = [('Bass', "Albert", 15), ('Bass', "Daniel", 12), ('Bass', "Paul", 31), ('Bass', "Tony", 11), ('Palmer', "Albert", 12), ('Palmer', "Daniel", 22), ('Palmer', "Paul", 30), ('Palmer', "Tony", 50),…
Fauz
  • 1
  • 1
0
votes
0 answers

Created a procedure for merging two tables branch_mstr and new_branches (having only two fields and same primary key)

delimiter $$ create procedure mergeData() begin declare counter, rowws int default 0; set rowws = (select count(*) from new_branches); begin while counter < rowws do if new_branches.branch_no != branch_mstr.branch_no…
Ravi Parmar
  • 1
  • 1
0
votes
1 answer

Does H2O Driverless AI have inbuilt support for merging multiple dataset and using the merged dataset for training?

Suppose we have three datasets containing data from a company. employee.csv : This dataset contains the details of the employees working in the company, like employee ID, employee name, dept id of the dept he works in, country code of the country…
Firenze
  • 365
  • 2
  • 11
0
votes
1 answer

Differential file saving algorithm or tool

I'm looking for any information or algorithms that allows differential file saving and merging. To be more clear, I would like when modifying the content of a file the original file should stay the same and every modification made must be saved in a…
Yassine El Khanboubi
  • 185
  • 3
  • 19
0
votes
1 answer

Merging text files to csv under the same header in R

I have a folder with over 1000 text files showing pollutant levels from particular air quality stations. I'm looking to combine all these text files into one csv in R, so i can analyse the data temporally in one space. Each text file is organised as…
Adam_Eire_2020
  • 22
  • 2
0
votes
1 answer

How do I de-duplicate while merging this data in R?

Goal: Merge two excel files that will have significant overlap, but overwrite ONLY the phone numbers and record ID of one data set. What I have been doing: Just brute force de-dup in excel where I copy over the sheet with phone numbers, sort the ID…
Walker
  • 63
  • 7
0
votes
1 answer

Is there a fast way to re-format and compile odd data in Excel using VBA or R?

I have over 200 sheets in an Excel workbook that are each formatted in a really odd way and I need to figure out how to compile all the data that I need into a single master sheet. I only need the values from certain cells and ranges (shown in the…
alliecat966
  • 15
  • 1
  • 5
0
votes
1 answer

How to merge 2 objects together where you want to update a single parameter within the sub-object

UPDATE Since posting this question and also the link that someone provided in the comments below, the $.extend method only goes one level deep which explains the issue i was having. Using the solution mentioned in the link below will resolve the…
Gadgetfreak
  • 1
  • 1
0
votes
0 answers

Merged two data sets by IDs, and now there are more observations

R community. So I merged a csv "clin" with a csv "cpath" to create my dataframe "mint." clin is 265 obs. of 62 variable. cpath is 169 of 64 variables. mint is 270 of 2 variables I merged the csv files by the "kitid" variable (7 digit number); thus,…
Brian
  • 31
  • 3
0
votes
3 answers

Merge emails in text format into one csv file for machine learning

I am using the Enron dataset for a machine learning problem. I want to merge all the spam files into a single csv file and all the ham files into another single csv for further analysis. I'm using the dataset listed here:…
py_noob
  • 433
  • 2
  • 8
  • 17
0
votes
0 answers

How do I merge/join lon and lat in my data by matching the country names?

I am trying to draw a map. I need to merge/join lon and lat data from the ggmap to my data. My data sets looks like this dataworld <- read.dta(file ="arrival.dta") My data sets looks like this: Name Country Date XXX India 29/01/2016 XXX Brazil…
Rezoan
  • 19
  • 4
0
votes
0 answers

Pandas Data Merge

I am new to pandas. Is there any way i can merge this 2 dataframes into following result DataFrame1:- |-------------|---------|----------------------|-------| |Test Case | SubTest | App | Count | | geekebench5 | OpenCL |…
anjali rai
  • 185
  • 1
  • 1
  • 14
0
votes
1 answer

Want to implement logic in datastage other than Aggregator stage

I want to implement this logic other than aggregator stage, basically through transformer stage to merge these records based on the ID column, and there is no possibility to get multiple values for same field in my case for same ID column. I have…
Pr. N
  • 17
  • 3
0
votes
1 answer

Assigning the filename and sheet name to (multiple) observations in R

I have written a function that, after giving the direction of the folder, takes all the excel files inside it and merges them into a data frame with some modest modifications. Yet I have two small things I would like to add but struggle with: Each…
Bartek Arendarski
  • 1
  • 2
1 2 3
…
11 12