Displaying 4 results from an estimated 4 matches for "mergeddata".
Did you mean:
merged_data
2008 Sep 04
1
how to match or merge data.frames in this case...
Hi,
I'm trying to match two data frames in order to replace the boundary values
in a dataframe.1 with values in dataframe.2 ONLY where the pair id1 id2
matches between the two data frames.
Eg.
> dataframe.1
... id1 id2 boundary
3307 1095 1108 438.691
3308 1095 1109 438.691
3309 1095 1121 438.691
3310 1096 1109 438.691
...
3345 1108 1120 438.691
3346 1108 1121 438.691
3347 1108
2012 Sep 19
2
write.table: strange output has been produced
...$id)
>ML = match(subset, statdata$id)
>extra[ML,1] = as.character(annot[MR,2])
>extra[ML,2] = as.character(annot[MR,3])
>extra[ML,3] = as.character(annot[MR,4])
# strangely, if I do
# extra[ML,] = as.character(annot[MR,2:4])
# it produces digits (???) instead of a string value
>mergedData = data.frame(statdata, extra)
>write.table(mergedData, 'filename.csv', sep=',')
--------------------------------8<--------------------------------------------
Any ideas why this is happening?
Many thanks
-Igor
2010 Jan 27
2
Merge: sort=F not preserving order?
...12395
9 ?012689
10 009302
11 002845
12 006669
13 008823
14 009302
15 025340
16 012689
and data2 in this format (index2 are chars):
?? ? ? index2 ? ? ?tic
1 ? ? 001003 ? ? ANTQ
2 ? ? 001004 ? ? AIR
3 ? ? 001009 ? ? ABSI
4 ? ? 001011 ? ? ACSE
etc
I am attempting to merge them using the following:
mergeddata <- merge(data1,data2, by.x="index", by.y="index2", sort=FALSE)
I want to preserve the order of data1 by setting sort=FALSE, however
the output I get is:
?? index ? tic
1 ?008823 PHM
2 ?008823 PHM
3 ?012689 KBH
4 ?012689 KBH
5 ?012689 KBH
6 ?012689 KBH
7 ?012689 KBH
8 ?00...
2008 Oct 08
1
How to join the two tables based on one overlapped column
Dear list,
I need some clues on this. I have two excel files and I basically want
to map one to the other one. Can you give me some hints how to do
it?
The first excel file, named as "Susan_probe.xls", there are two columns,
"PROBE_ID1" and "SEARCH_KEY1"
PROBE_ID1 SEARCH_KEY1 ILMN_30212 ILMN_30212 ILMN_1285 ILMN_1285
ILMN_137964 ILMN_137964 ILMN_138109