import pandas as pd

data = pd.read_excel('testT.xlsx')
print('源數(shù)據(jù): ',data)
print('==========================')
data = data.T
print('轉(zhuǎn)置之后: ', data)

data.to_excel('轉(zhuǎn)置完成后.xlsx',header=False)

import pandas as pd

data = pd.read_excel('testT.xlsx')
# 確定最后所需要的列名
new_columns = ['year', 'month', 'month_en', 'Type', 'Amount']
# 獲取固定列的值并轉(zhuǎn)換為values
fixed_values = data.iloc[0:,0:3].values.tolist()
# 獲取轉(zhuǎn)置的列名
need_T_columns = data.columns.tolist()[3:]
# 獲取需要轉(zhuǎn)置的值
need_T_values = data.iloc[0:,3:].values.tolist()

list1 = []
listAll = []
for i in range(len(fixed_values)):
	a = fixed_values[i]
	for j in range(len(need_T_columns)):
		list1 += a
		list1.append(need_T_columns[j])
		list1.append(need_T_values[i][j])
		listAll.append(list1)
		list1 = []

data = pd.DataFrame(listAll, columns=new_columns)
print(data)