12-08-2013, 11:53 PM
Dear all,
I have code as below. Which read data from serial port . I am trying to write these data into CSV file. please help me complete this code. I tried on py scripter it worked but code not working
code syntax
output file:
I have code as below. Which read data from serial port . I am trying to write these data into CSV file. please help me complete this code. I tried on py scripter it worked but code not working
code syntax
Code:
import serial
import csv
import string
import os
import time
import sys
def main():
pass
if __name__ == '__main__':
main()
count=0
f=open("test.csv","w+");
result = csv.writer(f,delimiter=',', dialect='excel-tab')
result_statememt=("date","time","Zenith","Azimuth","Elevation","conv_elevation");
result.writerow(result_statememt)
f.close()
while(count<5):
#time.sleep(60)
ser=serial.Serial()
ser.port=2
ser.baudrate=9600
ser.open()
str=ser.read(109)
print str
val=str.split(":")
print val
print "\n"
lines=str.split("\r\n")
print lines
#k=lines.split('')
#print k
l#ine=lines.split
wst=[]
#print line
wst=[]
for line in lines[:]:
line=lines.split(":") [b]/*getting error saying list object has no attribute called split*/[/b]
print line
f=open("test.csv","a+")
result=csv.writer(f,delimiter=',')
count=count+1
#lines=str.split("\r\n")
#print count
#f=open("test.txt","a+")
#result=csv.writer(f,delimiter=',')
#result.writerow()
f.close()
f.close()
ser.close()output file:
Code:
date is:7/12/16
time is:24-0-0
Zenith:104.85
Azimuth:110.40
Elevation:-14.85
Converted Elevation:15.79
['date is', '7/12/16\r\ntime is', '24-0-0\r\nZenith', '104.85\r\nAzimuth', '110.40\r\nElevation', '-14.85\r\nConverted Elevation', '15.79\r\n']
['date is:7/12/16', 'time is:24-0-0', 'Zenith:104.85', 'Azimuth:110.40', 'Elevation:-14.85', 'Converted Elevation:15.79', '']
Traceback (most recent call last):
File "C:\Documents and Settings\Administrator\My Documents\python code\code1\module1.py", line 40, in <module>
line=lines.split
AttributeError: 'list' object has no attribute 'split'