notebook.community

Edit and run 





In [1]:



    


myrowdata = [['cell#','mv','peak'],
            ['fk1',1,2],
            ['fk2',2,25],
            ['fk3',43,-45]]



    











In [ ]:



    






    











In [2]:



    


mycoldata={}

all_col_header = myrowdata[0]

all_col_header



    


















    
Out[2]:








['cell#', 'mv', 'peak']

















In [3]:



    


col_hdr = all_col_header[0]
col_hdr



    


















    
Out[3]:








'cell#'

















In [4]:



    


mycoldata[col_hdr] = []

mycoldata



    


















    
Out[4]:








{'cell#': []}

















In [5]:



    


value_list  = myrowdata[1]
mycoldata[col_hdr].append(value_list[0])
mycoldata



    


















    
Out[5]:








{'cell#': ['fk1']}

















In [6]:



    


value_list = myrowdata[2]
mycoldata[col_hdr].append(value_list[0])
mycoldata



    


















    
Out[6]:








{'cell#': ['fk1', 'fk2']}

















In [7]:



    


value_list = myrowdata[3]
mycoldata[col_hdr].append(value_list[0])
mycoldata



    


















    
Out[7]:








{'cell#': ['fk1', 'fk2', 'fk3']}

















In [ ]:



    






    











In [ ]:



    






    











In [ ]:



    






    











In [8]:



    


col_hdr = all_col_header[1] 
col_hdr



    


















    
Out[8]:








'mv'

















In [9]:



    


mycoldata[col_hdr] = [] 
mycoldata



    


















    
Out[9]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': []}

















In [10]:



    


value_list = myrowdata[1] 
mycoldata[col_hdr].append(value_list[1])
mycoldata



    


















    
Out[10]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': [1]}

















In [11]:



    


value_list = myrowdata[2]
mycoldata[col_hdr].append(value_list[1])
mycoldata



    


















    
Out[11]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': [1, 2]}

















In [12]:



    


value_list = myrowdata[3]
mycoldata[col_hdr].append(value_list[1])
mycoldata



    


















    
Out[12]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': [1, 2, 43]}

















In [ ]:



    






    











In [ ]:



    






    











In [ ]:



    






    











In [13]:



    


col_hdr = all_col_header[2]
col_hdr



    


















    
Out[13]:








'peak'

















In [14]:



    


mycoldata[col_hdr] = []
mycoldata



    


















    
Out[14]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': [1, 2, 43], 'peak': []}

















In [15]:



    


value_list = myrowdata[1]
mycoldata[col_hdr].append(value_list[2])
mycoldata



    


















    
Out[15]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': [1, 2, 43], 'peak': [2]}

















In [16]:



    


value_list = myrowdata[2]
mycoldata[col_hdr].append(value_list[2])
mycoldata



    


















    
Out[16]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': [1, 2, 43], 'peak': [2, 25]}

















In [17]:



    


value_list = myrowdata[3]
mycoldata[col_hdr].append(value_list[2])
mycoldata



    


















    
Out[17]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': [1, 2, 43], 'peak': [2, 25, -45]}

Now we are adding a loop to append the row values to each key of dictionary





In [18]:



    


mycoldata = {}



    











In [19]:



    


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[19]:








{'peak': [2, 25, -45]}

















In [20]:



    


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[20]:








{'mv': [1, 2, 43], 'peak': [2, 25, -45]}

















In [22]:



    


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[22]:








{'cell#': ['fk1', 'fk2', 'fk3'], 'mv': [1, 2, 43], 'peak': [2, 25, -45]}

















In [21]:



    


for i in range(1,4):
    print(i)



    


















    






1
2
3

















In [34]:



    


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



    


















    
Out[34]:








{'cell#': ['fk1', 'fk2', 'fk3', 'fk4'],
 'col4': [8, 7, 8, 8],
 'mv': [1, 2, 43, 33],
 'peak': [2, 25, -45, -4]}

















In [29]:



    


len(myrowdata)



    


















    
Out[29]:








4

















In [32]:



    


len(all_col_header)



    


















    
Out[32]:








3

















In [ ]:



    






    











In [1]:



    


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[1]:








{'DESCR': 'Iris Plants Database\n\nNotes\n-----\nData Set Characteristics:\n    :Number of Instances: 150 (50 in each of three classes)\n    :Number of Attributes: 4 numeric, predictive attributes and the class\n    :Attribute Information:\n        - sepal length in cm\n        - sepal width in cm\n        - petal length in cm\n        - petal width in cm\n        - class:\n                - Iris-Setosa\n                - Iris-Versicolour\n                - Iris-Virginica\n    :Summary Statistics:\n\n    ============== ==== ==== ======= ===== ====================\n                    Min  Max   Mean    SD   Class Correlation\n    ============== ==== ==== ======= ===== ====================\n    sepal length:   4.3  7.9   5.84   0.83    0.7826\n    sepal width:    2.0  4.4   3.05   0.43   -0.4194\n    petal length:   1.0  6.9   3.76   1.76    0.9490  (high!)\n    petal width:    0.1  2.5   1.20  0.76     0.9565  (high!)\n    ============== ==== ==== ======= ===== ====================\n\n    :Missing Attribute Values: None\n    :Class Distribution: 33.3% for each of 3 classes.\n    :Creator: R.A. Fisher\n    :Donor: Michael Marshall (MARSHALL%PLU@io.arc.nasa.gov)\n    :Date: July, 1988\n\nThis is a copy of UCI ML iris datasets.\nhttp://archive.ics.uci.edu/ml/datasets/Iris\n\nThe famous Iris database, first used by Sir R.A Fisher\n\nThis is perhaps the best known database to be found in the\npattern recognition literature.  Fisher\'s paper is a classic in the field and\nis referenced frequently to this day.  (See Duda & Hart, for example.)  The\ndata set contains 3 classes of 50 instances each, where each class refers to a\ntype of iris plant.  One class is linearly separable from the other 2; the\nlatter are NOT linearly separable from each other.\n\nReferences\n----------\n   - Fisher,R.A. "The use of multiple measurements in taxonomic problems"\n     Annual Eugenics, 7, Part II, 179-188 (1936); also in "Contributions to\n     Mathematical Statistics" (John Wiley, NY, 1950).\n   - Duda,R.O., & Hart,P.E. (1973) Pattern Classification and Scene Analysis.\n     (Q327.D83) John Wiley & Sons.  ISBN 0-471-22361-1.  See page 218.\n   - Dasarathy, B.V. (1980) "Nosing Around the Neighborhood: A New System\n     Structure and Classification Rule for Recognition in Partially Exposed\n     Environments".  IEEE Transactions on Pattern Analysis and Machine\n     Intelligence, Vol. PAMI-2, No. 1, 67-71.\n   - Gates, G.W. (1972) "The Reduced Nearest Neighbor Rule".  IEEE Transactions\n     on Information Theory, May 1972, 431-433.\n   - See also: 1988 MLC Proceedings, 54-64.  Cheeseman et al"s AUTOCLASS II\n     conceptual clustering system finds 3 classes in the data.\n   - Many, many more ...\n',
 'data': array([[ 5.1,  3.5,  1.4,  0.2],
        [ 4.9,  3. ,  1.4,  0.2],
        [ 4.7,  3.2,  1.3,  0.2],
        [ 4.6,  3.1,  1.5,  0.2],
        [ 5. ,  3.6,  1.4,  0.2],
        [ 5.4,  3.9,  1.7,  0.4],
        [ 4.6,  3.4,  1.4,  0.3],
        [ 5. ,  3.4,  1.5,  0.2],
        [ 4.4,  2.9,  1.4,  0.2],
        [ 4.9,  3.1,  1.5,  0.1],
        [ 5.4,  3.7,  1.5,  0.2],
        [ 4.8,  3.4,  1.6,  0.2],
        [ 4.8,  3. ,  1.4,  0.1],
        [ 4.3,  3. ,  1.1,  0.1],
        [ 5.8,  4. ,  1.2,  0.2],
        [ 5.7,  4.4,  1.5,  0.4],
        [ 5.4,  3.9,  1.3,  0.4],
        [ 5.1,  3.5,  1.4,  0.3],
        [ 5.7,  3.8,  1.7,  0.3],
        [ 5.1,  3.8,  1.5,  0.3],
        [ 5.4,  3.4,  1.7,  0.2],
        [ 5.1,  3.7,  1.5,  0.4],
        [ 4.6,  3.6,  1. ,  0.2],
        [ 5.1,  3.3,  1.7,  0.5],
        [ 4.8,  3.4,  1.9,  0.2],
        [ 5. ,  3. ,  1.6,  0.2],
        [ 5. ,  3.4,  1.6,  0.4],
        [ 5.2,  3.5,  1.5,  0.2],
        [ 5.2,  3.4,  1.4,  0.2],
        [ 4.7,  3.2,  1.6,  0.2],
        [ 4.8,  3.1,  1.6,  0.2],
        [ 5.4,  3.4,  1.5,  0.4],
        [ 5.2,  4.1,  1.5,  0.1],
        [ 5.5,  4.2,  1.4,  0.2],
        [ 4.9,  3.1,  1.5,  0.1],
        [ 5. ,  3.2,  1.2,  0.2],
        [ 5.5,  3.5,  1.3,  0.2],
        [ 4.9,  3.1,  1.5,  0.1],
        [ 4.4,  3. ,  1.3,  0.2],
        [ 5.1,  3.4,  1.5,  0.2],
        [ 5. ,  3.5,  1.3,  0.3],
        [ 4.5,  2.3,  1.3,  0.3],
        [ 4.4,  3.2,  1.3,  0.2],
        [ 5. ,  3.5,  1.6,  0.6],
        [ 5.1,  3.8,  1.9,  0.4],
        [ 4.8,  3. ,  1.4,  0.3],
        [ 5.1,  3.8,  1.6,  0.2],
        [ 4.6,  3.2,  1.4,  0.2],
        [ 5.3,  3.7,  1.5,  0.2],
        [ 5. ,  3.3,  1.4,  0.2],
        [ 7. ,  3.2,  4.7,  1.4],
        [ 6.4,  3.2,  4.5,  1.5],
        [ 6.9,  3.1,  4.9,  1.5],
        [ 5.5,  2.3,  4. ,  1.3],
        [ 6.5,  2.8,  4.6,  1.5],
        [ 5.7,  2.8,  4.5,  1.3],
        [ 6.3,  3.3,  4.7,  1.6],
        [ 4.9,  2.4,  3.3,  1. ],
        [ 6.6,  2.9,  4.6,  1.3],
        [ 5.2,  2.7,  3.9,  1.4],
        [ 5. ,  2. ,  3.5,  1. ],
        [ 5.9,  3. ,  4.2,  1.5],
        [ 6. ,  2.2,  4. ,  1. ],
        [ 6.1,  2.9,  4.7,  1.4],
        [ 5.6,  2.9,  3.6,  1.3],
        [ 6.7,  3.1,  4.4,  1.4],
        [ 5.6,  3. ,  4.5,  1.5],
        [ 5.8,  2.7,  4.1,  1. ],
        [ 6.2,  2.2,  4.5,  1.5],
        [ 5.6,  2.5,  3.9,  1.1],
        [ 5.9,  3.2,  4.8,  1.8],
        [ 6.1,  2.8,  4. ,  1.3],
        [ 6.3,  2.5,  4.9,  1.5],
        [ 6.1,  2.8,  4.7,  1.2],
        [ 6.4,  2.9,  4.3,  1.3],
        [ 6.6,  3. ,  4.4,  1.4],
        [ 6.8,  2.8,  4.8,  1.4],
        [ 6.7,  3. ,  5. ,  1.7],
        [ 6. ,  2.9,  4.5,  1.5],
        [ 5.7,  2.6,  3.5,  1. ],
        [ 5.5,  2.4,  3.8,  1.1],
        [ 5.5,  2.4,  3.7,  1. ],
        [ 5.8,  2.7,  3.9,  1.2],
        [ 6. ,  2.7,  5.1,  1.6],
        [ 5.4,  3. ,  4.5,  1.5],
        [ 6. ,  3.4,  4.5,  1.6],
        [ 6.7,  3.1,  4.7,  1.5],
        [ 6.3,  2.3,  4.4,  1.3],
        [ 5.6,  3. ,  4.1,  1.3],
        [ 5.5,  2.5,  4. ,  1.3],
        [ 5.5,  2.6,  4.4,  1.2],
        [ 6.1,  3. ,  4.6,  1.4],
        [ 5.8,  2.6,  4. ,  1.2],
        [ 5. ,  2.3,  3.3,  1. ],
        [ 5.6,  2.7,  4.2,  1.3],
        [ 5.7,  3. ,  4.2,  1.2],
        [ 5.7,  2.9,  4.2,  1.3],
        [ 6.2,  2.9,  4.3,  1.3],
        [ 5.1,  2.5,  3. ,  1.1],
        [ 5.7,  2.8,  4.1,  1.3],
        [ 6.3,  3.3,  6. ,  2.5],
        [ 5.8,  2.7,  5.1,  1.9],
        [ 7.1,  3. ,  5.9,  2.1],
        [ 6.3,  2.9,  5.6,  1.8],
        [ 6.5,  3. ,  5.8,  2.2],
        [ 7.6,  3. ,  6.6,  2.1],
        [ 4.9,  2.5,  4.5,  1.7],
        [ 7.3,  2.9,  6.3,  1.8],
        [ 6.7,  2.5,  5.8,  1.8],
        [ 7.2,  3.6,  6.1,  2.5],
        [ 6.5,  3.2,  5.1,  2. ],
        [ 6.4,  2.7,  5.3,  1.9],
        [ 6.8,  3. ,  5.5,  2.1],
        [ 5.7,  2.5,  5. ,  2. ],
        [ 5.8,  2.8,  5.1,  2.4],
        [ 6.4,  3.2,  5.3,  2.3],
        [ 6.5,  3. ,  5.5,  1.8],
        [ 7.7,  3.8,  6.7,  2.2],
        [ 7.7,  2.6,  6.9,  2.3],
        [ 6. ,  2.2,  5. ,  1.5],
        [ 6.9,  3.2,  5.7,  2.3],
        [ 5.6,  2.8,  4.9,  2. ],
        [ 7.7,  2.8,  6.7,  2. ],
        [ 6.3,  2.7,  4.9,  1.8],
        [ 6.7,  3.3,  5.7,  2.1],
        [ 7.2,  3.2,  6. ,  1.8],
        [ 6.2,  2.8,  4.8,  1.8],
        [ 6.1,  3. ,  4.9,  1.8],
        [ 6.4,  2.8,  5.6,  2.1],
        [ 7.2,  3. ,  5.8,  1.6],
        [ 7.4,  2.8,  6.1,  1.9],
        [ 7.9,  3.8,  6.4,  2. ],
        [ 6.4,  2.8,  5.6,  2.2],
        [ 6.3,  2.8,  5.1,  1.5],
        [ 6.1,  2.6,  5.6,  1.4],
        [ 7.7,  3. ,  6.1,  2.3],
        [ 6.3,  3.4,  5.6,  2.4],
        [ 6.4,  3.1,  5.5,  1.8],
        [ 6. ,  3. ,  4.8,  1.8],
        [ 6.9,  3.1,  5.4,  2.1],
        [ 6.7,  3.1,  5.6,  2.4],
        [ 6.9,  3.1,  5.1,  2.3],
        [ 5.8,  2.7,  5.1,  1.9],
        [ 6.8,  3.2,  5.9,  2.3],
        [ 6.7,  3.3,  5.7,  2.5],
        [ 6.7,  3. ,  5.2,  2.3],
        [ 6.3,  2.5,  5. ,  1.9],
        [ 6.5,  3. ,  5.2,  2. ],
        [ 6.2,  3.4,  5.4,  2.3],
        [ 5.9,  3. ,  5.1,  1.8]]),
 'feature_names': ['sepal length (cm)',
  'sepal width (cm)',
  'petal length (cm)',
  'petal width (cm)'],
 'target': array([0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
        0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
        1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
        1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
        2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
        2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2]),
 'target_names': array(['setosa', 'versicolor', 'virginica'], 
       dtype='<U10')}

















In [ ]:



    






    











In [ ]:

Content source: Adamthe1st/Adamthe1st-green-cortex

Similar notebooks:

notebook.community | gallery | about