awk行与列互换

_寒_CU

请教行与列 互换
file1  
server_name,id,date,cpu_max,cpu_avg
linux01,26843,2016/12/26,10.8000,4.86312500
linux02,26842,2016/12/26,10.8000,4.82875000
linux03,26840,2016/12/26,12.9000,7.34791667
linux04,26839,2016/12/26,10.5000,5.00479167
linux05,26838,2016/12/26,10.4000,4.70354167
linux06,26836,2016/12/26,18.6000,5.89229167
linux07,26835,2016/12/26,23.3000,6.09437500
linux08,26834,2016/12/26,19.7000,5.88770833

file2
server_name,linux01,linux02,linux03,linux04,linux05,linux06,linux07,linux08
id,26843,26842,26840,26839,26838,26836,26835,26834
date,2016/12/26,2016/12/26,2016/12/26,2016/12/26,2016/12/26,2016/12/26,2016/12/26,2016/12/26
cpu_max,10.8000,10.8000,12.9000,10.5000,10.4000,18.6000,23.3000,19.7000
cpu_avg,4.86312500,4.82875000,7.34791667,5.00479167,4.70354167,5.89229167,6.09437500,5.88770833

想实现 file1 <——— 行与列 互换方法 ——> file2
1. file1 ----> file2
2. file2 ----> file1

haooooaaa

1. awk -F, '{for(i=1;i<=NF;i++)a[i]=a[i]?a[i]","$i:$i}END{for(i=1;i<=NR;i++)print a[i]}'

复制代码

jason680

回复 1# _寒_CU

$ awk -F, '{for(n=1;n<=NF;++n)a[n]=a[n]c$n;c=","}END{for(n=1;n<=NF;++n)print a[n]}' file1
server_name,linux01,linux02,linux03,linux04,linux05,linux06,linux07,linux08
id,26843,26842,26840,26839,26838,26836,26835,26834
date,2016/12/26,2016/12/26,2016/12/26,2016/12/26,2016/12/26,2016/12/26,2016/12/26,2016/12/26
cpu_max,10.8000,10.8000,12.9000,10.5000,10.4000,18.6000,23.3000,19.7000
cpu_avg,4.86312500,4.82875000,7.34791667,5.00479167,4.70354167,5.89229167,6.09437500,5.88770833

jcdiy0601

1. awk -F, '{for(i=1;i<=NF;i++)a[NR i]=$i}END{x=NR;y=NF;for(m=1;m<=y;m++){for(n=1;n<=x;n++)if(n!=x){printf("%s,",a[n m])}else{printf("%s\n",a[n m])}}}' file

复制代码

sauer

回复 3# jason680

awk '{for(i=0;++i<=NFa=a?a FS $ii}END{for(i=0;i++<NFprint a}'
能详细解释一下么，看不懂

jason680

回复 6# sauer

https://www.gnu.org/software/gawk/manual/gawk.html