我用这段代码将值与它们关联的字段名进行比较,然后再将其存储在csv文件中以检查正确的列,因为每次重新启动计算机时,字典中传感器的顺序都会自动更改。这就是为什么在我将值存储到csv文件之前,我必须控制dict中的值的位置,否则我将得到一个混乱的csv文件,如下面的示例,它提供的值温度是1000[°C]亮度10[lux]
import csv
from datetime import datetime
import os
import time
from collections import OrderedDict
from time import sleep
Datum = time.strftime("%Y-%m-%d")
Time = datetime.now().replace(microsecond=0).isoformat()
data = {'Stecker Energy': '2.37', 'Stromzaehler Strom L1 [A]': '0.0', '1OG Ultraviolet': '0.0','Stecker EG Energie [kWh]': '4.3'}
filename = Datum + 'SOF.csv'
if not os.path.isfile(filename):
outfile = open(filename, "w")
lineKey = ""
for x in data.keys():
lineKey+= x + ","
lineKey = 'Time '+ "," + lineKey[:-1]+"\n" # Delete last character and add new line
outfile = open(filename, "a")
outfile.write(lineKey)
outfile.close()
#check first line of fieldnames
with open(filename,'r') as myFile:
reader = csv.DictReader(myFile)
fieldnames = reader.fieldnames
myFile.close()
#Compare the values with their keys (fieldnames)
with open(filename,'a') as outfile:
lineValue = ""
for sensor, value in data.items():
if sensor in data.items()==sensor in fieldnames:
v = data[sensor]
print("v", v)
lineValue+= str(v) + ","
lineValue = Time + "," + lineValue[:-1] + "\n"
print(lineValue)
outfile.write(lineValue)
outfile.close()
问题是当我检查CSV文件时,我发现值写在错误的列中,这意味着错误的字段名,例如:
此问题在CSV文件中的示例
CSV文本示例
时间,Stromzaehler Strom L1[A],Stecker Energy,1OG紫外线,Stecker EG Energie[kWh] 2017-11-21T17:56:10,2.37,0.0,0.0,4.3 2017-11-21T17:56:26,4.3,0.0,0.0,2.37 2017-11-21T17:56:28,0,0.0,2.37,4.3 2017-11-21T17:56:30,0,2.37,0.0,4.3
^{pr2}$
我觉得这不对劲。如果您只想遍历所有字段名(而不是“Time”)并在
^{pr2}$data
中添加与这些字段对应的值,同时为data
中不存在的值加上“n/a”,那么我建议您:额外建议:手动在值之间添加逗号是一种容易出错的方法。如果可能,请使用
DictWriter
,它可以为您解决大多数格式问题。在如果您坚持不这样做,至少将这些值存储在一个列表中,最后
join
一次:额外的建议:如果这些解决方案在您不想要的行之间添加了额外的空行,您可以使用
newline=""
参数打开文件(如果使用python3):。。。或者以二进制模式打开文件(如果使用Python 2):
相关问题 更多 >
编程相关推荐