Python操作Excel实战：Excel行转列

# 1、原始数据准备

样例数据准备

#2、python脚本编写，新建app.py文件，内容如下：

import pandas as pd
import numpy as np# 读取原始 Excel 文件
df = pd.read_excel('shanghaiTrailerFee.xlsx')print(df.head())# 选择第二行开始的数据，并每行复制 5 次
df_copy = pd.DataFrame(np.repeat(df.iloc[0:, :].values, 5, axis=0), columns=df.columns)print('************************')# print(df_copy.shape[0])# print(df_copy.head())totalRow = df_copy.shape[0]
print("总计行数为",totalRow)
for i in range(totalRow):if i % 5 == 0 :df_copy.values[i][6] = df_copy.values[i][0]df_copy.values[i][7] = df_copy.values[i][1]df_copy.values[i][8] = 'CBM'df_copy.values[i][9] = 0df_copy.values[i][10] = 1if i % 5 == 1 :df_copy.values[i][6] = df_copy.values[i][0]df_copy.values[i][7] = df_copy.values[i][2]df_copy.values[i][8] = 'CBM'df_copy.values[i][9] = 2df_copy.values[i][10] = 5if i % 5 == 2 :df_copy.values[i][6] = df_copy.values[i][0]df_copy.values[i][7] = df_copy.values[i][3]df_copy.values[i][8] = 'CBM'df_copy.values[i][9] = 6df_copy.values[i][10] = 10if i % 5 == 3 :df_copy.values[i][6] = df_copy.values[i][0]df_copy.values[i][7] = df_copy.values[i][4]df_copy.values[i][8] = 'CBM'df_copy.values[i][9] = 11df_copy.values[i][10] = 20if i % 5 == 4 :df_copy.values[i][6] = df_copy.values[i][0]df_copy.values[i][7] = df_copy.values[i][5]df_copy.values[i][8] = 'CBM'df_copy.values[i][9] = 21df_copy.values[i][10] = 40df_copy.drop(df_copy.columns[[0,1,2,3,4,5]], axis=1, inplace=True)   # 将处理后的数据保存到新的Excel文件中
df_copy.to_excel('new_shanghaiTrailerFee.xlsx', index=False)

# 3、执行python app.py

# 4、效果展示