一个简单的列排序,可是我不会,哪位大侠教教我?
时间:2010-11-09
来源:互联网
一个txt文件,里面有大量的数据:
Probeset Leaf-GSM154957 Leaf-GSM154958 Root-GSM159177 Root-GSM159178 Root-GSM159179
AFFX-BioB-3_at 147.438394 120.287116 158.262351 135.838130 148.615466 156.167483
AFFX-BioB-5_at 152.820703 132.522439 190.963500 165.799346 172.740874 172.205294
AFFX-BioB-M_at 111.647941 92.591200 125.143278 129.887014 125.521894 141.97432
AFFX-BioC-3_at 291.797267 248.405128 387.504701 355.767594 373.751574 401.470090
AFFX-BioC-5_at 263.062712 233.914970 364.908139 340.023593 341.710079 366.611716
AFFX-BioDn-3_at 1935.857984 1803.055973 1862.832016 1841.855969 1806.653863 1803.870173
AFFX-BioDn-5_at 906.065702 771.286346 897.558482 796.056270 916.960411 879.400853
AFFX-CreX-3_at 5465.609768 5026.454881 5998.697248 5963.822669 5822.091691 5578.085588
AFFX-CreX-5_at 4294.531845 3819.625102 4699.464561 4314.708828 4539.797359 4499.291776
AFFX-DapX-3_at 9.475168 9.612640 888.827223 709.757881 1027.118192 848.078968 1054
AFFX-DapX-5_at 6.636439 10.240921 118.498994 111.046386 81.403957 73.346384 98.24549
AFFX-DapX-M_at 6.528740 7.918818 397.519492 349.737549 356.111067 292.336840 337.
AFFX-LysX-3_at 13.270087 13.211207 161.454350 108.960922 189.208902 185.695619 228.
AFFX-LysX-5_at 6.182626 6.780416 30.283933 23.272321 35.669376 28.236014 31.103583 46
AFFX-LysX-M_at 14.389267 13.315424 54.565536 50.228937 66.496554 54.898420 75.55743
AFFX-Mgr-actin-3_at 16.980639 20.805341 23.890124 33.022251 25.637180 23.997352 30.41214
AFFX-Mgr-actin-5_at 19.695688 17.403888 31.446622 32.488098 28.237225 28.264318 21.14122
AFFX-Mgr-actin-M_at 27.151841 28.192460 41.836546 29.270830 37.623071 29.749619 41.55317
AFFX-Mgr-ef1a-3_at 25. 27.416384 41.993659 41.014066 44.880428 29.742959 26.18314
AFFX-Mgr-ef1a-3_x_at 21.199517 20.139905 29.164184 32.520566 32.687945 18.221015 24.321
AFFX-Mgr-ef1a-5_at 24.847554 31.506806 34.151328 29.352739 38.064581 31.358932 32.18036
AFFX-Mgr-ef1a-M_at 21.750084 23.487391 35.890356 34.807054 32.879076 25.998143 23.67290
AFFX-Mgr-gapdh-3_at 32.045674 27.175590 40.891912 35.593480 38.833121 49.867232 30.30044
AFFX-Mgr-gapdh-5_at 8.674494 10.817328 13.489433 12.492219 12.007793 12.753129 9.998126
AFFX-Mgr-gapdh-M_at 9.042819 8.894872 11.357769 10.377864 9.469603 9.819513 10.65713
AFFX-OS-18SrRNA_s_at 129.880244 82.402870 1521.329724 1751.357076 183.744073 336.2633
AFFX-OS-25SrRNA_s_at 137.606837 129.258257 900.262090 1143.702422 99.655421 126.3561
这只是其中的一小部分,我想把每列按照从 a 到z 的顺序排列,怎么样才能使其列下的数据一同移动呢?
Probeset Leaf-GSM154957 Leaf-GSM154958 Root-GSM159177 Root-GSM159178 Root-GSM159179
AFFX-BioB-3_at 147.438394 120.287116 158.262351 135.838130 148.615466 156.167483
AFFX-BioB-5_at 152.820703 132.522439 190.963500 165.799346 172.740874 172.205294
AFFX-BioB-M_at 111.647941 92.591200 125.143278 129.887014 125.521894 141.97432
AFFX-BioC-3_at 291.797267 248.405128 387.504701 355.767594 373.751574 401.470090
AFFX-BioC-5_at 263.062712 233.914970 364.908139 340.023593 341.710079 366.611716
AFFX-BioDn-3_at 1935.857984 1803.055973 1862.832016 1841.855969 1806.653863 1803.870173
AFFX-BioDn-5_at 906.065702 771.286346 897.558482 796.056270 916.960411 879.400853
AFFX-CreX-3_at 5465.609768 5026.454881 5998.697248 5963.822669 5822.091691 5578.085588
AFFX-CreX-5_at 4294.531845 3819.625102 4699.464561 4314.708828 4539.797359 4499.291776
AFFX-DapX-3_at 9.475168 9.612640 888.827223 709.757881 1027.118192 848.078968 1054
AFFX-DapX-5_at 6.636439 10.240921 118.498994 111.046386 81.403957 73.346384 98.24549
AFFX-DapX-M_at 6.528740 7.918818 397.519492 349.737549 356.111067 292.336840 337.
AFFX-LysX-3_at 13.270087 13.211207 161.454350 108.960922 189.208902 185.695619 228.
AFFX-LysX-5_at 6.182626 6.780416 30.283933 23.272321 35.669376 28.236014 31.103583 46
AFFX-LysX-M_at 14.389267 13.315424 54.565536 50.228937 66.496554 54.898420 75.55743
AFFX-Mgr-actin-3_at 16.980639 20.805341 23.890124 33.022251 25.637180 23.997352 30.41214
AFFX-Mgr-actin-5_at 19.695688 17.403888 31.446622 32.488098 28.237225 28.264318 21.14122
AFFX-Mgr-actin-M_at 27.151841 28.192460 41.836546 29.270830 37.623071 29.749619 41.55317
AFFX-Mgr-ef1a-3_at 25. 27.416384 41.993659 41.014066 44.880428 29.742959 26.18314
AFFX-Mgr-ef1a-3_x_at 21.199517 20.139905 29.164184 32.520566 32.687945 18.221015 24.321
AFFX-Mgr-ef1a-5_at 24.847554 31.506806 34.151328 29.352739 38.064581 31.358932 32.18036
AFFX-Mgr-ef1a-M_at 21.750084 23.487391 35.890356 34.807054 32.879076 25.998143 23.67290
AFFX-Mgr-gapdh-3_at 32.045674 27.175590 40.891912 35.593480 38.833121 49.867232 30.30044
AFFX-Mgr-gapdh-5_at 8.674494 10.817328 13.489433 12.492219 12.007793 12.753129 9.998126
AFFX-Mgr-gapdh-M_at 9.042819 8.894872 11.357769 10.377864 9.469603 9.819513 10.65713
AFFX-OS-18SrRNA_s_at 129.880244 82.402870 1521.329724 1751.357076 183.744073 336.2633
AFFX-OS-25SrRNA_s_at 137.606837 129.258257 900.262090 1143.702422 99.655421 126.3561
这只是其中的一小部分,我想把每列按照从 a 到z 的顺序排列,怎么样才能使其列下的数据一同移动呢?
作者: xingzhou823 发布时间: 2010-11-09
这个excel排序就能做啊
作者: mingxw 发布时间: 2010-11-09
回复 mingxw
是啊,excel能做,而且很简单。
但是,由于列数太多,有300多列,而且文件大小为187M,根本就没法用excel打开的。
没办法,只好求教perl了
是啊,excel能做,而且很简单。
但是,由于列数太多,有300多列,而且文件大小为187M,根本就没法用excel打开的。
没办法,只好求教perl了
作者: xingzhou823 发布时间: 2010-11-09
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28