pandas处理excel功能实现

part I
功能：将表格T1转化为T2的形式，根据x,y填充z

T1	a	b	c
1	1a	1b	1c
2	2a	2b	2c
3	3a	3b	3c

T2	1b	2b	3b
1a	1c
2a		2c
3a			3c

T2 = pd.DataFrame(index = T1[a].drop_duplicates(), columns = T1[b].drop_duplicates())
for i in range(4):
	a = T1.at[i,'a']
    b = T1.at[i,'b']
    c = T1.at[i,'c']
    T2.at[a,b] = c