excel_example_for_danke

py

import pandas as pd
import numpy as np
import xlrd as xl
from pandas import ExcelWriter


class execel_reader:

    def __init__(self, file):
        self.file_trnd = file
        self.firstNumber = None


    ## deal with data frame line.
    def _deal_line(self, line):
        copy = line.copy()
        copy[1] = self.deal_number(copy[1])
        return copy

    def deal_file(self):
        data = pd.DataFrame()
        for i, row in self.file_trnd.iterrows():
            result = self._deal_line(row)
            data = data.append(result)
        return data

    def file_export():
       pass

    def deal_number(self, number):
        if number == 0:
            if self.firstNumber != None:
                return self.firstNumber
            else:
                return number
        else:
            self.firstNumber = number
            return number

    def output_to_excel(self, file_name):
        pass

file = pd.read_excel("./TRND.xlsx", "Sheet1");
dFile = execel_reader(file)
result = dFile.deal_file()
#print result
writer = ExcelWriter('result.xlsx')
result.to_excel(writer,'Sheet1',index=False)
writer.save()