/
trimmingdata.py
83 lines (81 loc) · 1.71 KB
/
trimmingdata.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
import csv
f = open('train.csv','rb')
f1 = open('trimeedtraining.csv','w+')
fc = csv.reader(f,delimiter=',')
fw = csv.writer(f1,delimiter=',')
f2 = open('train.csv','rb')
fc1 = csv.reader(f2,delimiter=',')
Dics={}
Dics1={}
Dics2={}
dics=[]
count=0
for row in fc1:
if (row[4] not in Dics1):
Dics1[row[4]] = 1
else:
Dics1[row[4]]=Dics1[row[4]]+1
f2.close();
for key in Dics1:
if(Dics1[key] >= 1000):
Dics[key] = (Dics1[key]/1000)
Dics2[key] = 1
else:
Dics[key] = 1000/Dics1[key]
Dics2[key] = 0
Dics["Device"]=0
#for index in Dics:
# print index+' '+str(Dics[index])+' '+str(Dics1[index])
count1=0
count2=0
xm=0
ym=0
zm=0
prev=""
for row in fc:
#if (row[4] not in Dics):
# Dics[row[4]] = 1
#dics = [row[1],row[2],row[3],row[4]]+dics
#print row[1]+","+row[2]+","+row[3]+","+row[4]+"\r\n"
# fw.writerow(row)
#else:
# if (Dics[row[4]]<100):
# #Dics[row[4]]=Dics[row[4]]+1
# dics = [row[1],row[2],row[3],row[4]]+dics
# fw.writerow(row)
#print row[1]+","+row[2]+","+row[3]+","+row[4]+"\r\n"
# Dics[row[4]]=Dics[row[4]]+1
if(prev != row[4]):
count2=0
xm=0
ym=0
zm=0
prev=row[4]
if(int(Dics2[row[4]]) == 1):
#if(count1 < Dics1[row[4]]):
if(count2 < Dics[row[4]]):
xm=xm+float(row[1])
ym=ym+float(row[2])
zm=zm+float(row[3])
count2=count2+1
elif (count2 == Dics[row[4]]):
xm=xm+float(row[1])
ym=ym+float(row[2])
zm=zm+float(row[3])
fw.writerow([row[0],xm/1000,ym/1000,zm/1000,row[4]])
xm=0
ym=0
zm=0
count2=0
#count1=count+1
#elif(count1==Dics[row[4]]):
#xm=float(row[1])
#ym=float(row[2])
#zm=float(row[3])
#count1=1
#count2=1
elif(int(Dics2[row[4]])==0):
for i in range(1,int(Dics[row[4]])):
fw.writerow(row)
f.close();
f2.close();