# encoding: utf-8

def dealLianXuJuFenLei(dataset):
    import pandas as pd;

    data = pd.read_excel(dataset)
    for i in range(len(data)):
        str = data.iloc[i:i+1,8:9].values[0][0]
        index = str.find('(')
        if(index!=-1):
            if index == 0:
                str = str[3:]
            else:
                str = str[0:index]
            data.iloc[i:i + 1, 8:9] = str

    data.to_excel( './dataset/dealTvTableAll.xlsx')


dataset = './dataset/tv.xls';
dealLianXuJuFenLei(dataset=dataset)