Re: [R] extracting columns from a list
Hi Mohamed Try: lapply (NameOfYourList, function (dat, NumCol) dat[,NumCol], c(12,13)) But there must be a shorter way to write this. Nael On Fri, May 23, 2008 at 3:37 PM, mohamed nur anisah [EMAIL PROTECTED] wrote: Dear all, i have 2 lists of data with each of the list contain 14 columns. How am i going to extract column 12 and 13 from each of the list ?? and can i combine my extracted columns to form a single list. Attach with are my data. Your coorperation is highly appreciated. Many thanks Regards, Anisah [[1]] CS(O) id no.anchor ref loc.start loc.end CS(O).size CS(O)ref.density tested loc.start loc.end breakp.start breakp.end den of anchor 1 CS 2.0 3 mmu19 6465196 6978022 512826 6 cfa18 55567952 55782336 6978022699273428 2 CS 3.057 mmu19 6992734 102499663257232 17 cfa18 55792632 57688808 10249966 1027743025 3 CS 4.021 mmu19 10277430 10955201 61 31 cfa18 57721864 58419812 10955201 1100852636 4 CS 5.0 2 mmu19 11008526 11045352 36826 54 cfa18 58462088 58518608 11045352 1131686532 5 CS 6.0 7 mmu19 11316865 11814604 497739 14 cfa21 53902028 53514536 11814604 1193722837 6 CS 7.014 mmu19 11937228 138476331910405 7 cfa18 40111560 41204940 13847633 1451509117 7 CS 8.0 3 mmu19 14515091 160227701507679 2 cfa1 82195232 83511824 16022770 16199850 5 8 CS 9.025 mmu19 16199850 236258567426006 3 cfa1 83903856 90638880 23625856 2375455414 9 CS 10.033 mmu19 23754554 296761925921638 6 cfa1 90773872 96913624 29676192 2976391816 10CS 11.0 6 mmu19 29763918 30164446 400528 15 cfa11 29919668 30510776 30164446 30611872 8 11CS 12.019 mmu19 30611872 345583123946440 5 cfa26 38767664 41958808 34558312 3473440415 12 CSO 13.173 mmu19 34734404 440096169275212 8 cfa28 7343952 15872122 44009616 4408825621 13 CSO 13.271 mmu19 44088256 535826329494376 7 cfa28 15923283 24830712 53582632 5365479614 [[2]] CS(O) id no.anchor ref loc.start loc.end CS(O).size CS(O)ref.density tested loc.start loc.end breakp.start breakp.end den of anchor 1CSO 2.1 4 mmuX 7311438 7428353 116915 34 cfaX 41732964 41660008 7428353835693216 2CSO 2.241 mmuX 8356932 20225456 11868524 3 cfaX 32299338 41540632 20225456 2064158413 3CSO 2.3 8 mmuX 20641584 33046200 12404616 1 cfaX 91770240 94412912 33046200 3317518815 4CSO 3.173 mmuX 33175188 57970280 24795092 3 cfaX 94538728 114133200 57970280 64939220 3 5CSO 3.229 mmuX 64939220 700112805072060 6 cfaX 119319152 124625688 70011280 7003978432 6 CS 4.021 mmuX 70039784 70677328 637544 33 cfaX 124652504 125280776 70677328 7124127229 7CSO 5.1 2 mmuX 71241272 71362456 121184 17 cfaX 125764816 125872960 71362456 7142557614 8CSO 6.1 4 mmuX 71425576 71824776 399200 10 cfaX 125917392 126261784 71824776 73894168 6 9CSO 6.2 2 mmuX 73894168 74014744 120576 17 cfaX 6363930 1898656 74014744 7470540811 10 CSO 6.317 mmuX 74705408 90487648 15782240 1 cfaX 32034930 19573208 90487648 9122816010 11 CSO 6.449 mmuX 91228160 1010581929830032 5 cfaX 51733740 61930260101058192 101967264 9 12CS 7.0 3 mmuX 101967264 102176888 209624 14 cfaX 62797768 63194052102176888 10223004011 13 CSO 8.1 2 mmuX 102230040 102409592 179552 11 cfaX 63307688 63460248102409592 103123352 9 14 CSO 8.216 mmuX 103123352 1105914647468112 2 cfaX 63896752 71000280110591464 116044144 2 15CS 9.0 2 mmuX 116044144 116407200 363056 6 cfaX 71543016 71752808116407200 118512328 1 16CS 10.024 mmuX 118512328 131185424 12673096 2 cfaX 72291072 79468544131185424 13161668820 17CS 11.0 8 mmuX 131616688 132395992 779304 10 cfaX 79821128 80586408132395992 13246176017 18CS 12.021 mmuX 132461760 1375643685102608 4 cfaX 80674704 85936464137564368 13792777612 19 CSO 13.114 mmuX 137927776 1427167524788976 3 cfaX 86288848 90933784142716752 145888160 5 20 CSO 13.2
Re: [R] extracting columns from a list
I forgot to answer to the last part of your question. I think what you call a list is actually an element of a list, right? If so, the command you want depends on the way you want to combine these elements. For example, the following lines will extract columns 12 and 13 of any array-like element of your list and bind them into columns of a same array (if all your elements have the same number of rows). List2 - lapply (NameOfYourList, function (dat, NumCol) dat[,NumCol], c(12,13)) Array2 - do.call (cbind, List2) If you meant something else by 'combine, please be more explicit. Nael On Fri, May 23, 2008 at 3:54 PM, N. Lapidus [EMAIL PROTECTED] wrote: Hi Mohamed Try: lapply (NameOfYourList, function (dat, NumCol) dat[,NumCol], c(12,13)) But there must be a shorter way to write this. Nael On Fri, May 23, 2008 at 3:37 PM, mohamed nur anisah [EMAIL PROTECTED] wrote: Dear all, i have 2 lists of data with each of the list contain 14 columns. How am i going to extract column 12 and 13 from each of the list ?? and can i combine my extracted columns to form a single list. Attach with are my data. Your coorperation is highly appreciated. Many thanks Regards, Anisah [[1]] CS(O) id no.anchor ref loc.start loc.end CS(O).size CS(O)ref.density tested loc.start loc.end breakp.start breakp.end den of anchor 1 CS 2.0 3 mmu19 6465196 6978022 512826 6 cfa18 55567952 55782336 6978022699273428 2 CS 3.057 mmu19 6992734 102499663257232 17 cfa18 55792632 57688808 10249966 1027743025 3 CS 4.021 mmu19 10277430 10955201 61 31 cfa18 57721864 58419812 10955201 1100852636 4 CS 5.0 2 mmu19 11008526 11045352 36826 54 cfa18 58462088 58518608 11045352 1131686532 5 CS 6.0 7 mmu19 11316865 11814604 497739 14 cfa21 53902028 53514536 11814604 1193722837 6 CS 7.014 mmu19 11937228 138476331910405 7 cfa18 40111560 41204940 13847633 1451509117 7 CS 8.0 3 mmu19 14515091 160227701507679 2 cfa1 82195232 83511824 16022770 16199850 5 8 CS 9.025 mmu19 16199850 236258567426006 3 cfa1 83903856 90638880 23625856 2375455414 9 CS 10.033 mmu19 23754554 296761925921638 6 cfa1 90773872 96913624 29676192 2976391816 10CS 11.0 6 mmu19 29763918 30164446 400528 15 cfa11 29919668 30510776 30164446 30611872 8 11CS 12.019 mmu19 30611872 345583123946440 5 cfa26 38767664 41958808 34558312 3473440415 12 CSO 13.173 mmu19 34734404 440096169275212 8 cfa28 7343952 15872122 44009616 4408825621 13 CSO 13.271 mmu19 44088256 535826329494376 7 cfa28 15923283 24830712 53582632 5365479614 [[2]] CS(O) id no.anchor ref loc.start loc.end CS(O).size CS(O)ref.density tested loc.start loc.end breakp.start breakp.end den of anchor 1CSO 2.1 4 mmuX 7311438 7428353 116915 34 cfaX 41732964 41660008 7428353835693216 2CSO 2.241 mmuX 8356932 20225456 11868524 3 cfaX 32299338 41540632 20225456 2064158413 3CSO 2.3 8 mmuX 20641584 33046200 12404616 1 cfaX 91770240 94412912 33046200 3317518815 4CSO 3.173 mmuX 33175188 57970280 24795092 3 cfaX 94538728 114133200 57970280 64939220 3 5CSO 3.229 mmuX 64939220 700112805072060 6 cfaX 119319152 124625688 70011280 7003978432 6 CS 4.021 mmuX 70039784 70677328 637544 33 cfaX 124652504 125280776 70677328 7124127229 7CSO 5.1 2 mmuX 71241272 71362456 121184 17 cfaX 125764816 125872960 71362456 7142557614 8CSO 6.1 4 mmuX 71425576 71824776 399200 10 cfaX 125917392 126261784 71824776 73894168 6 9CSO 6.2 2 mmuX 73894168 74014744 120576 17 cfaX 6363930 1898656 74014744 7470540811 10 CSO 6.317 mmuX 74705408 90487648 15782240 1 cfaX 32034930 19573208 90487648 9122816010 11 CSO 6.449 mmuX 91228160 1010581929830032 5 cfaX 51733740 61930260101058192 101967264 9 12CS 7.0 3 mmuX 101967264 102176888 209624 14 cfaX 62797768 63194052102176888 10223004011 13 CSO 8.1 2 mmuX 102230040 102409592 179552 11 cfaX 63307688 63460248102409592 103123352 9 14 CSO 8.216 mmuX 103123352 1105914647468112 2 cfaX 63896752 71000280110591464 116044144
Re: [R] extracting columns from a list
Le ven. 23 mai à 09:37, mohamed nur anisah a écrit : Dear all, i have 2 lists of data with each of the list contain 14 columns. No, you have one list with two elements; each is a 14-column data frame. How am i going to extract column 12 and 13 from each of the list ?? Let's call your list 'x'. Then lapply(x, [, c(12, 13)) or, better yet, lapply(x, [, c(breakp.start, breakp.end)) if I counted your columns correctly. and can i combine my extracted columns to form a single list. You mean a single data frame? Given that the number of rows is not the same in both elements, no. If they were, using sapply() instead of lapply() would do the trick. HTH Vincent Attach with are my data. Your coorperation is highly appreciated. Many thanks Regards, Anisah [[1]] CS(O) id no.anchor ref loc.start loc.end CS(O).size CS(O)ref.density tested loc.start loc.end breakp.start breakp.end den of anchor 1 CS 2.0 3 mmu19 6465196 6978022 5128266 cfa18 55567952 55782336 6978022 699273428 2 CS 3.057 mmu19 6992734 10249966 3257232 17 cfa18 55792632 57688808 10249966 1027743025 3 CS 4.021 mmu19 10277430 10955201 61 31 cfa18 57721864 58419812 10955201 1100852636 4 CS 5.0 2 mmu19 11008526 11045352 36826 54 cfa18 58462088 58518608 11045352 1131686532 5 CS 6.0 7 mmu19 11316865 11814604 497739 14 cfa21 53902028 53514536 11814604 1193722837 6 CS 7.014 mmu19 11937228 13847633 19104057 cfa18 40111560 41204940 13847633 1451509117 7 CS 8.0 3 mmu19 14515091 16022770 15076792 cfa1 82195232 83511824 16022770 16199850 5 8 CS 9.025 mmu19 16199850 23625856 74260063 cfa1 83903856 90638880 23625856 2375455414 9 CS 10.033 mmu19 23754554 29676192 59216386 cfa1 90773872 96913624 29676192 2976391816 10CS 11.0 6 mmu19 29763918 30164446 400528 15 cfa11 29919668 30510776 30164446 30611872 8 11CS 12.019 mmu19 30611872 34558312 39464405 cfa26 38767664 41958808 34558312 3473440415 12 CSO 13.173 mmu19 34734404 44009616 92752128 cfa28 7343952 15872122 44009616 4408825621 13 CSO 13.271 mmu19 44088256 53582632 94943767 cfa28 15923283 24830712 53582632 5365479614 [[2]] CS(O) id no.anchor ref loc.start loc.end CS(O).size CS(O)ref.density tested loc.start loc.end breakp.start breakp.end den of anchor 1CSO 2.1 4 mmuX 7311438 7428353 116915 34 cfaX 41732964 41660008 7428353 835693216 2CSO 2.241 mmuX 8356932 20225456 118685243 cfaX 32299338 41540632 20225456 2064158413 3CSO 2.3 8 mmuX 20641584 33046200 124046161 cfaX 91770240 94412912 33046200 3317518815 4CSO 3.173 mmuX 33175188 57970280 247950923 cfaX 94538728 114133200 57970280 64939220 3 5CSO 3.229 mmuX 64939220 70011280 50720606 cfaX 119319152 124625688 70011280 7003978432 6 CS 4.021 mmuX 70039784 70677328 637544 33 cfaX 124652504 125280776 70677328 7124127229 7CSO 5.1 2 mmuX 71241272 71362456 121184 17 cfaX 125764816 125872960 71362456 7142557614 8CSO 6.1 4 mmuX 71425576 71824776 399200 10 cfaX 125917392 126261784 71824776 73894168 6 9CSO 6.2 2 mmuX 73894168 74014744 120576 17 cfaX 6363930 1898656 74014744 7470540811 10 CSO 6.317 mmuX 74705408 90487648 157822401 cfaX 32034930 19573208 90487648 9122816010 11 CSO 6.449 mmuX 91228160 101058192 98300325 cfaX 51733740 61930260101058192 101967264 9 12CS 7.0 3 mmuX 101967264 102176888 209624 14 cfaX 62797768 63194052102176888 10223004011 13 CSO 8.1 2 mmuX 102230040 102409592 179552 11 cfaX 63307688 63460248102409592 103123352 9 14 CSO 8.216 mmuX 103123352 110591464 74681122 cfaX 63896752 71000280110591464