R语言数据合并求助

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

我需要挑选出两个文件中probenames这一列中相同的数据形成新的文件。应该在R中怎样实现。

CSV1:

ProbeName	log Fold Change	Fold Change	Regulation	C8.gProcessedSignal.raw.	T8.gProcessedSignal.raw.
RNA53135|H-InvDB_397_647	1.000403	2.000558	up	80.80627	75.62845
RNA62616|RNAz_3334_237	1.000685	2.00095	up	64.44429	60.32672
RNA59641|RNAz_352_371	1.001416	2.001964	up	119.8466	112.246
RNA64109|RNAz_4829_210	1.001602	2.002222	up	375.001	351.2641
RNA161210|XLOC_013360	1.001998	2.002772	up	103.7206	97.18194
RNA63055|RNAz_3773_233	1.00258	2.00358	up	60.68222	56.87967
RNA44948|UCSC_3026_2595	1.003004	2.004169	up	358.3311	335.9757
RNA177222|ENST00000552378	1.003014	2.004182	up	140.7494	131.9692
RNA164485|XLOC_005482	1.003122	2.004333	up	66.87047	62.70372
RNA50058|UCSC_9262_991	1.00316	2.004385	up	78.87569	73.96279
RNA177335|ENST00000485162	1.003195	2.004434	up	67.82449	63.60145

CSV2:

ProbeName	Log Fold change	Fold Change	Regulation	C2.gProcessedSignal.raw.	T2.gProcessedSignal.raw.
RNA55591|H-InvDB_2974_210	-7.5948	-193.314	down	29386.56	223.1399
RNA51970|UCSC_11583_309	-7.52576	-184.281	down	31791.03	253.2305
RNA55628|H-InvDB_3014_207	-7.43715	-173.303	down	32110.03	271.9731
RNA53728|H-InvDB_1005_436	-7.05381	-132.865	down	2679.197	29.59963
RNA60377|RNAz_1089_304	-6.74278	-107.097	down	1568.821	21.50233
RNA43423|UCSC_1157_3864	-6.2042	-73.7312	down	13821.38	275.1638
RNA44109|UCSC_1985_3194	-6.17505	-72.2561	down	1350.413	27.43362

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：数据合并 R语言 Regulation Processed Process 语言

1. csv_new<-csv1[which(csv1$probename %in% csv2$probname)]

复制代码

水天一色DIY 发表于 2013-5-22 11:01

谢谢！