word导入数据出现数据全是一个

为什么会出现一个数据和名称重复,有什么方法能解决吗,我想保留两位小数要怎么弄

img

import numpy as np
import docx


file = 's.energy.txt'
f = open(file)
lines = f.readlines()
list1 = []
list2 = []

line_data = []
for line in lines:
    a = line.split()
    line_data.append(a)
data = np.array(line_data)
need_data = data[0:14,1]
need_name = data[0:14,0]
f.close()
for j in need_name:
    list1.append(j)
for i in need_data:
    list2.append(i)
# print(list1)
# print(list2)
file_name = 'ca.docx'
doc = docx.Document(file_name)
table = doc.add_table(rows=len(need_name)*3, cols=4)


for x in list1:
    for y in list2:
        for row in range(len(need_name)*3):

            for col in range(0,4):
                if (row+1)%3 == 0:
                    table.rows[row].cells[col].text = x
                    table.rows[row-1].cells[col].text = y #有什么方法可以保留两位小数

doc.save('1'+file_name)
print('完成')

import numpy as np
import docx
file = 's.energy.txt'
f = open(file)
lines = f.readlines()
list1 = []
list2 = []
line_data = []
for line in lines:
    a = line.split()
    line_data.append(a)
data = np.array(line_data)
need_data = data[0:14,1]
need_name = data[0:14,0]
f.close()
file_name = 'ca.docx'
doc = docx.Document(file_name)
table = doc.add_table(rows=len(need_name)*3, cols=4)


row=0
col=0#注
for i in range(len(need_name)):
    if i>0:
        if  i%4==0:#换行
            row+=3
            col=0#列变量从0开始
        else:
            col+=1
    y=need_data[i]
    table.rows[row].cells[col].text = '{:.2f}'.format(float(y))
    table.rows[row+1].cells[col].text = need_name[i]
 
doc.save('1'+file_name)
print('完成')

您好,我是有问必答小助手,您的问题已经有小伙伴帮您解答,感谢您对有问必答的支持与关注!
PS:问答VIP年卡 【限时加赠:IT技术图书免费领】,了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632