Questions tagged [merging-data]
173 questions
1
vote
2 answers
Combining factor levels in data frame column
I have a data frame data with a column, named "Project License", which represents a categorical variable, and, thus, in R terminology, is a factor. I'm trying to create a new column, where open source software licenses are combined into larger…
Aleksandr Blekh
- 2,462
- 4
- 32
- 64
1
vote
1 answer
Merging two data frames with different sizes and missing values
I'm having a problem merging two data frames in R.
The first one consists of 103731 obs of 6 variables. The variable that I have to use to merge has 77111 unique values and the rest are NAs with a value of 0. The second one contains the frequency of…
user3388256
- 11
- 1
1
vote
3 answers
SAS to R conversion of merge
I am currently working on converting a SAS macro into a R code. I have worked a lot on R but I am relatively new to SAS. I am having trouble understanding the SAS code for a merge command -
data dates;
merge A(keep=date…
RHelp
- 815
- 2
- 8
- 23
1
vote
2 answers
Merging Tagged PDF without ruining the tags
I am trying to merge two Tagged PDF's with the iTextPDF 5.4.4 version jar. After doing all the operations while closing the document on the line: document.close();): . It throws the below error
java.lang.NullPointerException
PDF Creation Failed…
Comm
- 11
- 1
- 3
1
vote
2 answers
MySQL merge tables with different structure
I have two databases with different structure.
Table 1:
ch_code ch_def ch_weight
Table 2:
address ch_code
I need to merge this two tables, so the structure would look like:
ch_code ch_def ch_weight address
The number or rows in…
Anthony
- 681
- 3
- 9
- 20
1
vote
1 answer
Looking to merge two Excel files by ID into one Excel file using Python 2.7
I am new to the Python family and have been trying to solve merge two Excel files for days. I have researched merging endlessly and tried to adapt my code to fit my needs, but it hasn't been working. I was wondering if I could get any help of why…
user2584342
- 31
- 3
- 4
1
vote
1 answer
Trying to merge contents of several text files as a cell each in a spreadsheet
Essentially:
I have several (400) text files each with a numerical file name (ie 12345.txt).
Each text file contains some text(Long description style, plain text paragraphs, etc). I am trying to figure out if I could import all of these text files…
Remog
- 163
- 1
- 8
1
vote
3 answers
SQL issue when merging two databases with foreign keys
I have a database at a workspace A and workspace B.
Online there is a copy of this database which is always updated from both workspaces.
Also both workspaces can need to update their databases whenever the other workspace makes any changes.…
Haz
- 849
- 1
- 9
- 18
0
votes
1 answer
Merging 3 lists (or more)
I have 2 lists/arrays of strings
a list of currencies:
String [] currencies = {EUR, USD, CAD, etc};
a list of time periods:
String [] periods = {"T","O","SN", "1M","1Y","1W", "2M","3M","4M","5M","6M","7M","8M","9M","10M","11M", ...};
a list of…
Adrian
- 5,603
- 8
- 53
- 85
0
votes
0 answers
Appending the data from 1 File to another File
I am trying to append the data from one file (OLD) to another file (NEW) in folder for the multiple files for the matching same filename. Its working fine when only number files are matching, when there is missing file in the NEW folder it will stop…
Yogs
- 13
- 2
0
votes
0 answers
Undoing garbage collection
Recently i was working on a project with two other guys, now i encountered an error when i was trying to pull making commits to my local work, after checking stackoverflow i was advised to to do git gc,( garbage collection), i was able to pull after…
Jonas
- 1
- 1
0
votes
0 answers
Combining many timestamped audio files into long clips
I have a radio archival tool (trunk-recorder) that records and saves radio transmissions as individual unix-timestamped wav files. Each of these files is relatively short (~5-10s) and contains the channel that was recorded and the unix time stamp of…
Patrick
- 355
- 2
- 11
0
votes
1 answer
Merging Data with Power Query and 2 Columns and Dates
I really need some help on merging data in Power Query. I am importing data from a file (from a network drive) and also pulling data from a static table. However I am trying to obtain a match with headers 1) Container Number 2) ETA
Unfortunately the…
JDogg
- 1
- 1
0
votes
0 answers
intersecting time-series polygon and raster -- unable to save the output
I have sf data frame with refugee camps / populations across sub-Saharan Africa from 2009-2018. I created 50KM buffers around each camp for analysis, and am using that file for analysis buffer_shp
data <- data.frame(country = rep(c("Angola", "DRC",…
Victoria Puglia
- 1
- 1
0
votes
0 answers
Merging dataframe in R with unequal columns and sample sizes and overlapping observations
I'm trying to merge two dataframes (dataframe1 and dataframe2) into dataframe3. Dataframe1 has 74 observations and dataframe2 has 78 observations, 74 of which overlap.
variables in dataframe1: name gender height weight
variables in dataframe2: name…
