In [42]:
myrowdata = [['cell#','mv','peak'],
['fk1',1,2],
['fk2',2,25],
['fk3',43,-45]]
In [ ]:
In [43]:
mycoldata={}
all_col_header = myrowdata[0]
all_col_header
Out[43]:
In [44]:
col_hdr = all_col_header[0]
col_hdr
Out[44]:
In [45]:
mycoldata[col_hdr] = []
mycoldata
Out[45]:
In [46]:
value_list = myrowdata[1]
mycoldata[col_hdr].append(value_list[0])
mycoldata
Out[46]:
In [47]:
value_list = myrowdata[2]
mycoldata[col_hdr].append(value_list[0])
mycoldata
Out[47]:
In [48]:
value_list = myrowdata[3]
mycoldata[col_hdr].append(value_list[0])
mycoldata
Out[48]:
In [ ]:
In [ ]:
In [ ]:
In [49]:
col_hdr = all_col_header[1]
col_hdr
Out[49]:
In [50]:
mycoldata[col_hdr] = []
mycoldata
Out[50]:
In [51]:
value_list = myrowdata[1]
mycoldata[col_hdr].append(value_list[1])
mycoldata
Out[51]:
In [52]:
value_list = myrowdata[2]
mycoldata[col_hdr].append(value_list[1])
mycoldata
Out[52]:
In [53]:
value_list = myrowdata[3]
mycoldata[col_hdr].append(value_list[1])
mycoldata
Out[53]:
In [ ]:
In [ ]:
In [ ]:
In [54]:
col_hdr = all_col_header[2]
col_hdr
Out[54]:
In [55]:
mycoldata[col_hdr] = []
mycoldata
Out[55]:
In [56]:
value_list = myrowdata[1]
mycoldata[col_hdr].append(value_list[2])
mycoldata
Out[56]:
In [57]:
value_list = myrowdata[2]
mycoldata[col_hdr].append(value_list[2])
mycoldata
Out[57]:
In [58]:
value_list = myrowdata[3]
mycoldata[col_hdr].append(value_list[2])
mycoldata
Out[58]:
Now we are adding a loop to append the row values to each key of dictionary
In [59]:
mycoldata = {}
In [60]:
col_hdr = all_col_header[2] #peak
mycoldata[col_hdr] = []
for row_index in range(1,4):
value_list = myrowdata[row_index]
mycoldata[col_hdr].append(value_list[2])
mycoldata
Out[60]:
In [61]:
col_hdr = all_col_header[1] #mv
mycoldata[col_hdr] = []
for row_index in range(1,4):
value_list = myrowdata[row_index]
mycoldata[col_hdr].append(value_list[1])
mycoldata
Out[61]:
In [62]:
col_hdr = all_col_header[0] # Cell#
mycoldata[col_hdr] = []
for row_index in range(1,4):
value_list = myrowdata[row_index]
mycoldata[col_hdr].append(value_list[0])
mycoldata
Out[62]:
In [63]:
for i in range(1,4):
print(i)
In [64]:
myrowdata = [['cell#','mv','peak','col4'],
['fk1',1,2,8],
['fk2',2,25,7],
['fk3',43,-45,8],
['fk4',33,-4,8]]
def transform_row_to_col(myrowdata):
all_col_header = myrowdata[0] # first row has to be col header (this is a must requirment)
mycoldata = {}
for col_index in range(0, len(all_col_header)):
col_hdr = all_col_header[col_index]
mycoldata[col_hdr] = []
for row_index in range(1, len(myrowdata)):
value_list = myrowdata[row_index]
mycoldata[col_hdr].append(value_list[col_index])
return mycoldata
In [65]:
len(myrowdata)
Out[65]:
In [66]:
len(all_col_header)
Out[66]:
In [ ]:
In [67]:
from sklearn.datasets import load_iris
from sklearn import tree
import numpy as np
from sklearn.externals.six import StringIO
#import pydot
iris = load_iris();
iris
Out[67]:
In [68]:
myrowdata
Out[68]:
In [69]:
myetd =[]
myerow = []
mycurrentrow = myrowdata[1]
myerow.append(mycurrentrow[1])
myerow.append(mycurrentrow[2])
myerow.append(mycurrentrow[3])
myetd.append(myerow)
myetd
Out[69]:
In [70]:
myerow = []
mycurrentrow = myrowdata[2]
myerow.append(mycurrentrow[1])
myerow.append(mycurrentrow[2])
myerow.append(mycurrentrow[3])
myetd.append(myerow)
myetd
Out[70]:
In [71]:
myerow = []
mycurrentrow = myrowdata[3]
myerow.append(mycurrentrow[1])
myerow.append(mycurrentrow[2])
myerow.append(mycurrentrow[3])
myetd.append(myerow)
myetd
Out[71]:
In [72]:
myetd =[]
myerow = []
mycurrentrow = myrowdata[1]
for col_index in range(1,len(mycurrentrow)):
myerow.append(mycurrentrow[col_index])
myetd.append(myerow)
myetd
Out[72]:
In [73]:
myerow = []
mycurrentrow = myrowdata[2]
for col_index in range(1,len(mycurrentrow)):
myerow.append(mycurrentrow[col_index])
myetd.append(myerow)
myetd
Out[73]:
In [74]:
myerow = []
mycurrentrow = myrowdata[3]
for col_index in range(1,len(mycurrentrow)):
myerow.append(mycurrentrow[col_index])
myetd.append(myerow)
myetd
Out[74]:
In [75]:
myetd = []
for row_index in range(1,len(myrowdata)):
myerow = []
mycurrentrow = myrowdata[row_index]
for col_index in range(1,len(mycurrentrow)):
myerow.append(mycurrentrow[col_index])
myetd.append(myerow)
myetd
Out[75]:
In [76]:
start_col = 2
myetd = []
for row_index in range(1,len(myrowdata)):
myerow = []
mycurrentrow = myrowdata[row_index]
for col_index in range(start_col,len(mycurrentrow)):
myerow.append(mycurrentrow[col_index])
myetd.append(myerow)
myetd
Out[76]:
In [77]:
col_filter_list = [1,2,3]
myetd = []
for row_index in range(1,len(myrowdata)):
myerow = []
mycurrentrow = myrowdata[row_index]
for col_index in col_filter_list:
myerow.append(mycurrentrow[col_index])
myetd.append(myerow)
myetd
Out[77]:
In [81]:
myrowdata
row_filter_list = range(1,len(myrowdata))
col_filter_list = [1,2,3]
myetd = []
for row_index in row_filter_list:
myerow = []
mycurrentrow = myrowdata[row_index]
for col_index in col_filter_list:
myerow.append(mycurrentrow[col_index])
myetd.append(myerow)
myetd
Out[81]:
In [83]:
myrowdata
Out[83]:
In [14]:
list(range(1,10)) + list(range(15,20)) + list(range(25,29))
Out[14]: