【openpyxl】python中对Excel进⾏写⼊操作，写⼊⼀列或者⼀⾏（从excel。。
。
前⾔
最近在做expansion of datt，所以需要把扩展的datat写⼊到excel中
我已经矩阵运算全部搞定，最终输出的是两个输出 labels 和 features
⾃⼰整理为以下格式
label =[[0],
[1],
[2],
[3]
]
feature =[
[0.1,0.2,0.3,0.4,0.5],
[0.11,0.21,0.31,0.41,0.51],
[0.6,0.7,0.8,0.9,1.00],
[1.1,1.2,1.3,1.4,1.5],
]
解决⽅案
先是准备⽤python带的xlrd xlrd 等包来操作感觉真的不太⾏高考之后
换思路，⽤第三⽅包openpyxl来操作
pip install openpyxl
官⽅⽂档在这⾥
安徒生童话图片
代码
废话不多说，show you my code
典型事例范文
# coding=utf-8
from openpyxl import Workbook
import numpy as np
wb = Workbook()
ws = wb.create_sheet("che")
label =[[0],
[1],产品经理年终总结
[2],
[3]
]
feature =[
[0.1,0.2,0.3,0.4,0.5],
[0.11,0.21,0.31,0.41,0.51],
[0.6,0.7,0.8,0.9,1.00],
[1.1,1.2,1.3,1.4,1.5],
]
#这个地⽅之所以变成numpy格式是因为在很多时候我们都是在numpy格式下计算的，模拟⼀下预处理label = np.array(label)
feature = np.array(feature)
label_input =[]
for l in range(len(label)):
label_input.append(label[l][0])
ws.append(label_input)
for f in range(len(feature[0])):
ws.append(feature[:, f].tolist())
wb.save("chehongshu.xlsx")
结果⽣成⼀个excel，最后结果如下图：
总结
openpyxl包⽤起来是真的⽅便，对于写⼊，只需要建⽴⼀个LIST进⾏append就好了，如果excel为空的那append就从第⼀⾏开始递增操作，你也可以理解为⼀个ws.append()操作就相当于写⼊⼀⾏，如果excel为有数据的时候，那写⼊操作从没有数据的那⼀⾏开始写⼊；这⾥也说⼀下本来想⽤Inrt来着但是忽略了⼀个条件，就是inrt有个前提条件就是For example to inrt a row at 7 (before the existing row 7):，意思为插⼊之前你的数据的⼤⼩⼀定是⽐要插⼊的⾏数或者列数⼤的，也就是说插⼊只能插到⾥⾯，不能在边缘插。
插⼊核⼼参考代码长干
for col in range(len(label)):
print col
ws.inrt_cols(col+1)
for index, row in ws):
头像漫画男
#print row
if index ==0:
#row[col+1].value = label[col][0]
print"label"
print label[col]
el:
print"feature"
print feature[col][index-1]
#row[col+1].value = feature[col][index-1]
读取代码
def create_data_expansion(path, sheet):
data_init = pd.read_excel(path, sheet)
# print data_init
data_df = pd.DataFrame(data_init)
print data_df
氛围的英文data_df_transpon = data_df.T
label_expansion = np.array(data_df_transpon.index)
省份的英文label_expansion_l =[]
for l in range(len(label_expansion)):
label_expansion_l.append([l])
feature_expansion = np.array(data_df_transpon)
label_expansion = np.array(label_expansion_l)
return label_expansion, feature_expansion
if __name__ =="__main__":
path_name ="excel_demo.xlsx"
sheet_name ="11"
label, feature = create_data_expansion(path_name, sheet_name)
print label
print feature
结果：
