import numpy as np
import pandas as pd
data = pd.read_excel(r'/Users/doubleq/Desktop/excelScript.xlsx', header=None).values
[n, m] = data.shape
data = data.tolist()
data_new = [['' for j in range(4)] for i in range(n // 4)]
now = 0
for i in range(n // 4):
for j in range(4):
data_new[i][j] = data[now][0]
now += 1
# print(data_new)
pd.DataFrame(np.array(data_new)).to_excel(r'/Users/doubleq/Desktop/excelScript_1.xlsx', header=None, index=False)
用Python将Excel中的一列数据排成四列
于 2022-09-14 19:44:16 首次发布