Das deutsche Python-Forum

Code: Alles auswählen

import wx
import wx.grid

data = [[65.0, 'HO13D22_R08d21', '20', '13', '36..48 HO13D22_R08d21', '...TGGTGGCTGGTCG...\n   |||||||||||||\nATGGTGGCTGGTCGTAATGG']
,[55.0, 'HW06J24', '20', '11', '52..42 HW06J24', '...GCCACCACCAA...\n   |||||||||||\nGCCACCACCAAAGTCAAATG']
,[55.0, 'HO14B24', '20', '11', '162..152 HO14B24', '...ACTCAATCCCG...\n   |||||||||||\nCATGCAGGTACTCAATCCCG']
,[55.0, 'HO10M21', '20', '11', '52..42 HO10M21', '...GCCACCACCAA...\n   |||||||||||\nGCCACCACCAAAGTCAAATG']
,[55.0, 'HO10D21_R06b22', '20', '11', '299..289 HO10D21_R06b22', '...GCCTTCAAGAT...\n   |||||||||||\nGCTCATGCCTTCAAGATCCG']
,[55.0, 'HK04J17', '20', '11', '49..59 HK04J17', '...GTTTGGGTTGG...\n   |||||||||||\nAGCCTGTTTGGGTTGGATGT']]

data.sort()

colLabels = ("% matching", "primer name", "primer length", "match length", "binding position", "sequence")


class GenericTable(wx.grid.PyGridTableBase):
            
    def __init__(self, data, colLabels=None):
        wx.grid.PyGridTableBase.__init__(self)
        self.data = data
        self.colLabels = colLabels

        self.odd=wx.grid.GridCellAttr()
        face = 'Courier'
        self.odd.SetFont(wx.Font(10, wx.DEFAULT, wx.NORMAL, wx.NORMAL, False, face))
         
    def GetNumberRows(self):
        return len(self.data)

    def GetNumberCols(self):
        return len(self.data[0])

    def GetColLabelValue(self, col):
        if self.colLabels:
            return self.colLabels[col]
              
    def IsEmptyCell(self, row, col):
        return False

    def GetValue(self, row, col):
        return self.data[row][col]

    def SetValue(self, row, col, value):
        pass

    def GetAttr(self, row, col, kind):
        attr = self.odd
        attr.IncRef()
        return attr
                  
class SimpleGrid(wx.grid.Grid):
    def __init__(self, parent):
        wx.grid.Grid.__init__(self, parent, -1)
        tableBase = GenericTable(data, colLabels)
        self.SetTable(tableBase)
        self.SetDefaultRowSize(55, True)
        self.SetColSize(1, 200)
        self.SetColSize(2, 100)
        self.SetColSize(3, 100)
        self.SetColSize(4, 250)
        self.SetColSize(5, 450)
        self.SetCellAlignment(1, 1, wx.CENTRE, wx.CENTRE)       

class TestFrame(wx.Frame):
    def __init__(self, parent):
        wx.Frame.__init__(self, parent, -1, "A Grid", 
                size=(1280, 1024))
        grid = SimpleGrid(self)

if __name__ == '__main__':
    app = wx.PySimpleApp()
    frame = TestFrame(None)
    frame.Show(True)
    app.MainLoop()

Code: Alles auswählen

data = open('liste.txt', 'r')
data = data.read()
print type(data), data

Code: Alles auswählen

In [173]: a = ["['a', 'b']", "['c', 'd']"]

In [174]: a[0]
Out[174]: "['a', 'b']"

In [175]: a[0][0]
Out[175]: '['

In [176]: a[0][1]
Out[176]: "'"

In [177]: a[0][2]
Out[177]: 'a'

Code: Alles auswählen

In [178]: b = [['a', 'b'], ['c', 'd']]

In [179]: b[0]
Out[179]: ['a', 'b']

In [180]: b[0][0]
Out[180]: 'a'

In [181]: b[0][1]
Out[181]: 'b'

Code: Alles auswählen

quellname = "quelle.txt"
f = file(quellname, "r") 
sn = csv.Sniffer() 
dialect = sn.sniff(f.readline()) 
f.seek(0)

data = [] 
for fields in csv.reader(f, dialect = dialect): 
    data.append(fields)   
f.close()

Code: Alles auswählen

$ cat test.csv
65.0;HO13D22_R08d21;20;13;36..48 HO13D22_R08d21;"...TGGTGGCTGGTCG...
   |||||||||||||
ATGGTGGCTGGTCGTAATGG"
55.0;HW06J24;20;11;52..42 HW06J24;"...GCCACCACCAA...
   |||||||||||
GCCACCACCAAAGTCAAATG"
55.0;HO14B24;20;11;162..152 HO14B24;"...ACTCAATCCCG...
   |||||||||||
CATGCAGGTACTCAATCCCG"
55.0;HO10M21;20;11;52..42 HO10M21;"...GCCACCACCAA...
   |||||||||||
GCCACCACCAAAGTCAAATG"
55.0;HO10D21_R06b22;20;11;299..289 HO10D21_R06b22;"...GCCTTCAAGAT...
   |||||||||||
GCTCATGCCTTCAAGATCCG"
55.0;HK04J17;20;11;49..59 HK04J17;"...GTTTGGGTTGG...
   |||||||||||
AGCCTGTTTGGGTTGGATGT"

Code: Alles auswählen

import csv
from itertools import izip
from pprint import pprint

def convert_row(row):
    return [f(s) for f, s in izip((float, str, int, int, str, str), row)]

csv_file = open('test.csv', 'rb')
reader = csv.reader(csv_file, delimiter=';')
data = map(convert_row, reader)
csv_file.close()

pprint(data)

Code: Alles auswählen

#... 
        # Daten in csv file schreiben
        quellname = "new.csv"                       
        f = open(quellname, "a")
        f.writelines(daten)
        f.close()

        # Grid aufrufen
        self.show_grid()
#...