Das deutsche Python-Forum

Code: Alles auswählen

with open('Dip_Cor_Moxa_raman_8_05_1520160131000534.csv','r') as temp_file:    
        
        text = temp_file.read() 
        
        trace = text.split('[Trace.*')
         
        sec=re.findall(r'Time.Second.*',trace)
        minu=re.findall(r'Time.Minute.*',trace)
        hour=re.findall(r'Time.Hour.*',trace)
        day=re.findall(r'Date.Day.*',trace)
        month=re.findall(r'Date.Month.*'trace)
        year=re.findall(r'Date.Year.*',trace)

Code: Alles auswählen

with open('Dip_Cor_Moxa_raman_8_05_1520160131000534.csv','r') as temp_file:    
        
        text = temp_file.read() 
        
        #trace = text.split('[Trace.*')
         
        sec=re.findall(r'Time.Second.*',text,re.MULTILINE)
        minu=re.findall(r'Time.Minute.*',text,re.MULTILINE)
        hour=re.findall(r'Time.Hour.*',text,re.MULTILINE)
        day=re.findall(r'Date.Day.*',text,re.MULTILINE)
        month=re.findall(r'Date.Month.*',text,re.MULTILINE)
        year=re.findall(r'Date.Year.*',text,re.MULTILINE)

Code: Alles auswählen

for line in file:
    if line < 112: continue    #ersten 112 Zeilen werden weg gelassen
    if line == "":
      break #bei leerer zeile aufhören    

Code: Alles auswählen

from itertools import islice

for line in islice(file, 112, None):
    # process

Code: Alles auswählen

import numpy as np


input = 'Dip_Cor_Moxa_raman_8_05_1520160122122520.csv'

output = 'Dip_Cor_Moxa_raman_8_05_1520160122122520_korr.csv' 


with open (input, 'r') as in_file,open (output, 'w'):
    
    
    
    
    points = [str(i) for i in range(0,273,1)]
    #points = ["{:02d}".format(x) for x in points]
    
    
    
   # new = np.zeros()
    new_line =np.zeros((1,279))    
    for lines in in_file:
        line = lines.rstrip('\n').split(';')

        if line[]        
        
        if any(s in line for s in ['Trace']):                                  #für Traces
            Trace_nr = line.split('.')[1].split(']')[0]
            new_line[0][0]=Trace_nr
            
        if any(line[0] in s for s in points):                                  #für Daten
            data = line[2]
            new_line[0][int(line[0])]=data
            
        if any(s in line for s in ['Date.Year']):                              #Date
            year = line[1] 
            new_line[0][-1]=year
        
        if any(s in line for s in ['Date.Month']):
            month = line[1]     
            new_line[0][-2]=month
            
        if any(s in line for s in ['Date.Day']):
            day = line[1] 
            new_line[0][-3]=day
            
        if any(s in line for s in ['Time.Minute']):
            minute = line[1] 
            new_line[0][-5]=minute
            
        if any(s in line for s in ['Time.Second']):
            sec = line[1]
            new_line[0][-6]=sec
            
        if any(s in line for s in ['Time.Hour']):
            hor = line[1]
            new_line[0][-4]=hor

Code: Alles auswählen

#!/usr/bin/env python
# coding: utf8
from __future__ import absolute_import, division, print_function
import csv
import re
from itertools import groupby, imap, islice
from operator import itemgetter

TRACE_RE = re.compile(r'\[Trace\.(\d+)\]')

get_first = itemgetter(0)
get_second = itemgetter(1)


def load_rows(filename):
    with open(filename, 'rb') as lines:
        for row in csv.reader(lines, delimiter=';'):
            yield row


def iter_sections(rows):
    def stamp_rows():
        section_id = None
        for row in rows:
            if row:
                match = TRACE_RE.match(row[0])
                if match:
                    section_id = match.group(1)
            yield (section_id, row)

    for section_id, group in groupby(stamp_rows(), get_first):
        yield (section_id, imap(get_second, group))


def process_section(section_id, rows):
    rows = iter(rows)
    header = next(rows)
    assert header and header[0].startswith('[Trace.'), header
    result = [section_id]
    values = [row[2] for row in islice(rows, 4)]
    year, month, day, hour, minute, second = (row[1] for row in islice(rows, 6))
    result.append(
        '{0}-{1:>02}-{2:>02}T{3:>02}:{4:>02}:{5:>02}'.format(
            year, month, day, hour, minute, second
        )
    )
    result.extend(values)
    return result


def save_rows(filename, rows):
    with open(filename, 'wb') as out_file:
        csv.writer(out_file, delimiter=';').writerows(rows)


def main():
    rows = load_rows('test.csv')
    processed_sections = (
        process_section(section_id, row)
        for section_id, row in iter_sections(rows)
    )
    save_rows('test2.csv', processed_sections)


if __name__ == '__main__':
    main()