CoTan/Me_learn.py

import tkinter
from tkinter.filedialog import askopenfilename,asksaveasfilename
import tkinter.messagebox
import Learn
import webbrowser
import os
from tkinter.scrolledtext import ScrolledText
import chardet

#数据清洗
Clean_Text='''#输入你的数据清洗执行代码

Done_Row=[] #输入操作的行号
Done_Column=[] #输入操作的列号
axis=True #True-操作行，False-操作列
name='' #方法代号

def check(data,row,column,get,R,C): #检查方法
    return True

def done(data,row,column,get,R,C): #应用修正方法
    return DEL
'''

Clean_Help='''
使用Python代码进行数据清洗
1)代码结构
    Done_Row=[] 代码用来检测的数据的列号
    Done_Column=[] 代码用来检测的数据的行号
        不在以上指定范围内的数据将不会被检测，若为空则整个表格检测
    axis 执行删除方法时删除行或者列
    name 方法代号
    
    check 检查方法
        输入:当前的值(输入的是一个值而不是一行(列)或整个列表)
        输入:row和column当前值来自的行号(row)和列号(column)
        输入:get当前检查的所有数据:类型是表格
        输入:R和C当前值所来自的行和列的所有数据:类型是一维表格
        
        输出:输出布尔为True代表该值可以使用，输出布尔为假表示该值不可使用
        
    done 不可使用的数值改造方法
        输入:内容同上
        输出:改造值或者DEL
            DEL:代表删除改值所在的行(axis = True)或列(axis = False)
2)扩展
    默认:pd-pandas，re-re[正则表达式]，Sheet-包含所有表格，用Sheet['name']访问名字为name的表格(注意引号别漏了)
    支持:可以使用import导入语句，支持python语法
'''

Args_Help='''
输入python变量赋值代码:渲染设置
title #设置标题:str
vice_title #设置副标题:str

show_Legend #是否显示图例:bool

show_Visual_mapping #是否使用视觉映射:bool
is_color_Visual_mapping #是否为颜色视觉映射:bool[否则为大小视觉映射]
min_Visual_mapping #映射的最小值
max_Visual_mapping #映射的最大值

......(我太懒了,设置太多不想写了)
'''

def DTYPE():
    global Dtype_Column, Dtype_Input, Dtype_Wrong, Dtype_Func,ML
    type_ = bool(Dtype_Func.get())
    name = get_Name()
    column_list = Dtype_Column.get().split(',')
    if column_list == ['']:column_list = []
    dtype = Dtype_Input.get()
    wrong = Dtype_Wrong.get()
    if wrong != 'ignore':wrong = 'coerce'
    if type_:#软转换
        ML.Reasonable_Type(name,column_list,dtype,wrong)
    else:
        ML.as_Type(name,column_list,dtype,wrong)
    Updat_BOX()

def Import_c():#导入绘制方法
    global Done_Func
    Dic = askopenfilename(title='打开Python脚本',filetypes=[("Python", ".py"),("TXT", ".txt")])
    with open(Dic) as f:
        get = f.read()
        Render_ToHTML(ML.Import_c(get), '自定义图')

def get_ARGS():#获取画图的args
    global Args_Input
    return Args_Input.get('0.0',tkinter.END)

def Draw():
    global R_Dic,R_BOX
    Dic = asksaveasfilename(title='选择渲染保存地址',filetypes=[("HTML", ".html")]) + '.html'
    if Dic == '.html':return False
    webbrowser.open(ML.Draw_Page(get_ARGS(),Dic))
    Update_R_BOX()

def Draw_One():
    global R_Dic, R_BOX
    Dic = asksaveasfilename(title='选择渲染保存地址', filetypes=[("HTML", ".html")]) + '.html'
    if Dic == '.html': return False
    list(R_Dic.values())[R_BOX.curselection()[0]].render(Dic)
    webbrowser.open(Dic)
    Update_R_BOX()

def Del_R_BOX():
    global R_Dic,R_BOX,ML
    key = list(R_Dic.keys())[R_BOX.curselection()[0]]
    ML.Delete_RDic(key)
    Update_R_BOX()

def Update_R_BOX():
    global R_Dic,R_BOX,ML
    R_Dic = ML.retunr_RDic()
    R_BOX.delete(0, tkinter.END)
    R_BOX.insert(tkinter.END, *R_Dic.keys())

def Render_ToHTML(c,name):
    global R_Dic,Draw_asWell
    if bool(Draw_asWell.get()):
        c.render(f'{PATH}\\{name}.html')
    Update_R_BOX()

def to_Gauge():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Gauge(name,get_ARGS()),'仪表图')

def to_Liquid():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Liquid(name,get_ARGS()),'水球图')

def to_Line3D():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Line3D(name,get_ARGS()),'3D折线图')

def to_Scatter3D():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Scatter3D(name,get_ARGS()),'3D散点图')

def to_Bar3d():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Bar3d(name,get_ARGS()),'3D柱状图')

def to_WordCloud():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_WordCloud(name,get_ARGS()),'词云图')

def to_Radar():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Radar(name,get_ARGS()),'雷达图')

def to_Polar():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Polar(name,get_ARGS()),'极坐标图')

def to_Pie():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Pie(name,get_ARGS()),'饼图')

def to_Parallel():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Parallel(name,get_ARGS()),'多轴图')

def to_Graph():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Graph(name,get_ARGS()),'关系图')

def to_Funnel():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Funnel(name,get_ARGS()),'漏斗图')

def to_HeatMap():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_HeatMap(name,get_ARGS()),'热力图')

def to_Boxpolt():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Boxpolt(name,get_ARGS()),'箱形图')

def to_Pictorialbar():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Pictorialbar(name,get_ARGS()),'象形柱状图')

def to_Scatter():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Scatter(name,get_ARGS()),'散点图')

def to_Line():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Line(name,get_ARGS()),'折线图')

def to_Bar():
    global ML
    name = get_Name()
    Render_ToHTML(ML.to_Bar(name,get_ARGS()),'柱状图')

def Show_Help():
    tkinter.messagebox.showinfo('帮助字典',Clean_Help)

def Open_Python():
    global Done_Func
    Dic = askopenfilename(title='打开Python脚本',filetypes=[("Python", ".py"),("TXT", ".txt")])
    with open(Dic) as f:
        get = f.read()
        Done_Func.delete('0.0', tkinter.END)
        Done_Func.insert('0.0', get)

def get_InsertClean_Text():
    global Done_Func,Clean_Text
    Done_Func.delete('0.0',tkinter.END)
    Done_Func.insert('0.0',Clean_Text)

def get_CleanEXP():
    global ML,Clean_List,Done_CleanBox,Done_Func
    name = Clean_List[Done_CleanBox.curselection()[0]]
    get = ML.Return_CleanExp(name)
    Done_Func.delete('0.0',tkinter.END)
    Done_Func.insert('0.0',get)

def Tra_Clean():
    global ML
    ML.Tra_Clean()
    Updat_BOX()

def Done_Clean():
    global ML
    name = get_Name()
    Data = ML.Done_CleanFunc(name)
    title = f'CoTan机器学习 表格:{name}.数据清洗'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def Del_Clean():
    global ML,Clean_List,Done_CleanBox
    name = Clean_List[Done_CleanBox.curselection()[0]]
    ML.Delete_CleanFunc(name)
    Update_Clean()

def Update_Clean():
    global ML,Done_CleanBox,Clean_List
    Clean_List = ML.Return_CleanFunc()
    Done_CleanBox.delete(0, tkinter.END)
    Done_CleanBox.insert(tkinter.END, *Clean_List)

def Add_Clean():
    global ML,Done_CleanBox,Done_Func
    Exp = Done_Func.get('0.0',tkinter.END)
    print(Exp)
    ML.Add_CleanFunc(Exp)
    Update_Clean()

def Done_NaN():
    global Drop_Column
    name = get_Name()
    Data = ML.Dropna(name,True)
    title = f'CoTan机器学习 表格:{name}.NaN'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def is_Na():
    global Bool_E
    name = get_Name()
    Data = ML.is_Na(name)
    title = f'CoTan机器学习 表格:{name}.NaN'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def Make_BoolSheet():
    global Bool_E
    Bool_Exp = Bool_E.get()
    name = get_Name()
    Data = ML.Done_Bool(name,Bool_Exp,True)
    print(Data)
    title = f'CoTan机器学习 表格:{name} 布尔化'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def Del_Data():
    global Slice_new, Column_clist, Row_clist
    Column = Column_clist[0].get().replace(' ','').split(',')
    Row = Row_clist[0].get().replace(' ', '').split(',')
    new = bool(Slice_new.get())
    name = get_Name()
    try:
        Data = ML.Delete(name,Column,Row,new)
    except:
        Data = 'None 你的操作不被允许'
    title = f'CoTan机器学习 表格:{name}'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def __get_clist(n,t=str):
    a = []
    for i in n:
        b = i.get().replace(' ','')
        if b == '':a.append(None)
        else:
            try:a.append(t(b))
            except:a.append(None)
    if a[0] != None and a[1] == None:
        a[1] = a[0]+1
        a[2] = None
    return a

def Slice_Data():
    global Slice_new, Column_Type, Row_Type, Column_clist, Row_clist
    CT = Column_Type.get()
    U = True
    if CT == 0:#输入的列号
        Column = slice(*__get_clist(Column_clist,int))
    elif CT == 1:
        U = False
        Column = slice(*__get_clist(Column_clist, str))
    else:
        get = Column_clist[0].get().replace(' ','').split(',')
        Column = []
        for i in get:
            try:Column.append(int(i))
            except:pass

    RT = Row_Type.get()
    if RT == 0:  # 输入的列号
        Row = slice(*__get_clist(Row_clist, int))
    elif RT == 1:
        Row = slice(*__get_clist(Row_clist, str))
    else:
        get = Row_clist[0].get().replace(' ', '').split(',')
        Row = []
        for i in get:
            try:
                Row.append(int(i))
            except:
                pass
    new = bool(Slice_new.get())
    name = get_Name()
    try:
        Data = ML.get_Clice(name,Column,Row,U,new)
    except:
        Data = 'None 你的操作不被允许'
    title = f'CoTan机器学习 表格:{name}'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def Stored_Value():
    global ML,Stored_List
    name = get_Name()
    new = bool(Ascending_New.get())
    Data = ML.Stored_Valuse(name, Stored_List,new)
    title = f'CoTan机器学习 表格:{name}.Stored'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def Tra_Stored_Value():
    global Stored_List, Stored_BOX
    Stored_List = []
    Update_Stored()

def Delete_Stored_Value():
    global Stored_List,Stored_BOX,Ascending_Type
    del Stored_List[Stored_BOX.curselection()[0]]
    Update_Stored()

def add_Stored_Value():#按基准列排行
    global ML,Stored_List,Sort_By,Ascending_Type
    try:
        a = not bool(Ascending_Type.get())
        value = int(Sort_By.get())
        Stored_List.append((value,a))
    except:pass
    Update_Stored()

def Update_Stored():
    global Stored_List,Stored_BOX
    re = []
    d = {True:'正序',False:'倒叙'}
    for i in Stored_List:
        re.append(f"列号:{i[0]},排序方式{d[i[1]]}")
    Stored_BOX.delete(0,tkinter.END)
    Stored_BOX.insert(tkinter.END,*re)

def Stored_Column():#行
    global ML
    name = get_Name()
    a = not bool(Ascending_Type.get())
    new = bool(Ascending_New.get())
    Data = ML.Sorted(name,False,new,a)
    title = f'CoTan机器学习 表格:{name}.Stored by Column'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def Stored_Row():#行
    global ML
    name = get_Name()
    new = bool(Ascending_New.get())
    a = not bool(Ascending_Type.get())
    Data = ML.Sorted(name,True,new,a)
    title = f'CoTan机器学习 表格:{name}.Stored by Row'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def T():
    global ML
    name = get_Name()
    new = bool(Ascending_New.get())
    Data = ML.T(name,new)
    title = f'CoTan机器学习 表格:{name}.T'
    Creat_TextSheet(Data, title)
    Updat_BOX()

def Show_Des():
    global PATH,top
    if not tkinter.messagebox.askokcancel('提示', f'是否统计数据，大量的数据需要耗费一定的时间(确定后，系统会在后台统计)'):return False
    Dic = f'{PATH}/$Show_Des_Sheet.html'
    try:
        name = get_Name()
        if name == None:raise Exception
        ML.to_Report(name,Dic)
        webbrowser.open(Dic)
    except:
        pass

def Show_describe():
    global ML,Des_Bool
    Des = bool(Des_Bool.get())
    name = get_Name()
    title = f'CoTan机器学习 表格:{name}_describe'
    Data = str(ML.Describe(name,Des))
    Creat_TextSheet(Data, title)
    Updat_BOX()

def Write_Sheet():
    global ML,top
    name = get_Name()
    title = f'CoTan机器学习 表格:{name}'
    Data = str(ML.get_Sheet(name))
    Creat_TextSheet(Data,title)

def Creat_TextSheet(data,name):
    global bg,ft1
    new_top = tkinter.Toplevel(bg=bg)
    new_top.title(name)
    new_top.geometry('+10+10')#设置所在位置
    text = ScrolledText(new_top,font=ft1,height=50)
    text.pack(fill=tkinter.BOTH)
    text.insert('0.0',data)
    text.config(state=tkinter.DISABLED)
    new_top.resizable(width=False, height=False)

def get_Column():#列名(横行竖列，列名是上面的)
    global ML
    name = get_Name()
    Updat_IndexBOX(ML.get_Column(name))

def get_Index():#行名(横行竖列，行名左)
    global ML
    name = get_Name()
    Updat_IndexBOX(ML.get_Index(name))

def Updat_IndexBOX(get_Index):
    global top,Index_BOX
    Index_BOX.delete(0,tkinter.END)
    Index_BOX.insert(tkinter.END, *get_Index)

def Show():
    global PATH,to_HTML_Type
    Dic = f'{PATH}/$Show_Sheet.html'
    try:
        name = get_Name()
        if name == None:raise Exception
        ML.to_Html(name,Dic,to_HTML_Type.get())
        webbrowser.open(Dic)
    except:
        raise

def Add_CSV():
    global top,Seq_Input,Code_Input,str_must,Index_must
    Dic = askopenfilename(title='选择载入的CSV',filetypes=[("CSV", ".csv")])
    Seq = Seq_Input.get()
    Codeing = Code_Input.get()
    str_ = bool(str_must.get())
    Index = bool(Index_must.get())
    if Codeing == '':
        with open(Dic, 'rb') as f:
            Codeing = chardet.detect(f.read())['encoding']
            print(Codeing)
    if Seq == '':Seq = ','
    ML.Add_CSV(Dic,'',Seq,Codeing,str_,Index)
    Updat_BOX()

def Add_Python():
    global top,Seq_Input,Code_Input,str_must,Index_must
    Dic = askopenfilename(title='选择载入的py',filetypes=[("Python", ".py"),("Txt", ".txt")])
    with open(Dic,'r') as f:
        ML.Add_Python(f.read(),'')
    Updat_BOX()

def Add_Html():
    global top,Seq_Input,Code_Input,str_must,Index_must
    Dic = askopenfilename(title='选择载入的Html',filetypes=[("CSV", ".csv")])
    Codeing = Code_Input.get()
    str_ = bool(str_must.get())
    Index = bool(Index_must.get())
    if Codeing == '':
        with open(Dic, 'rb') as f:
            Codeing = chardet.detect(f.read())['encoding']
            print(Codeing)
    ML.Add_Html(Dic,'',Codeing,str_,Index)
    Updat_BOX()

def get_Name():#获得名字统一接口
    global Form_List
    try:
        return Form_List[Form_BOX.curselection()[0]]
    except:
        try:
            return Form_List[0]
        except:
            return None

def Updat_BOX():
    global top,Form_BOX,Form_List
    Form_List = ML.get_FormList()
    Form_BOX.delete(0,tkinter.END)
    Form_BOX.insert(tkinter.END, *Form_List)

def Machine_learning():
    global top,ML,Form_List,PATH,bg,ft1,Stored_List,Clean_List,R_Dic
    R_Dic = {}#保存了画图的List
    PATH = os.getcwd()
    Form_List = []
    ML = Learn.Form()
    top = tkinter.Tk()
    bg = '#FFFAFA'#主颜色
    bbg = '#FFFAFA'#按钮颜色
    fg = '#000000'#文字颜色
    top["bg"] = bg
    FONT = ('黑体', 11)#设置字体
    ft1 = ('黑体',13)
    top.title('CoTan机器学习')
    top.resizable(width=False, height=False)
    top.geometry('+10+10')#设置所在位置
    width_B = 13#标准宽度
    height_B=2
    a_y = 0
    a_x = 0
    Stored_List = []
    Clean_List = []

    tkinter.Button(top, bg=bbg, fg=fg, text='导入CSV',command=Add_CSV, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='导入Py',command=Add_Python, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='导入HTML',command=Add_Html, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='删除表格', font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='查看表格',command=Show, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='清空表格', font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    global Form_BOX,Index_BOX,Column_BOX,to_HTML_Type,Seq_Input,Code_Input,str_must,Index_must
    a_y += 1
    to_HTML_Type = tkinter.IntVar()#正，负，0
    lable = ['选项卡型','可移动型','自适应型']#复选框
    for i in range(3):
        tkinter.Radiobutton(top,bg = bg,fg = fg,activebackground=bg,activeforeground=fg,selectcolor=bg,text=lable[i], variable=to_HTML_Type,
                            value=i).grid(column=a_x+i, row=a_y, sticky=tkinter.W)

    str_must = tkinter.IntVar()
    Index_must = tkinter.IntVar()
    a_y += 1
    tkinter.Label(top, text='编码方式:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    Code_Input = tkinter.Entry(top, width=width_B)
    Code_Input.grid(column=a_x + 1, row=a_y, sticky=tkinter.E + tkinter.W)
    buttom = tkinter.Checkbutton(top, bg=bg, fg=fg, activebackground=bg, activeforeground=fg, selectcolor=bg, text='字符串类型',
                        variable=str_must)
    buttom.select()
    buttom.grid(column=a_x + 2, row=a_y, sticky=tkinter.W)

    a_y += 1
    tkinter.Label(top, text='CSV分隔符:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    Seq_Input = tkinter.Entry(top, width=width_B)
    Seq_Input.grid(column=a_x + 1, row=a_y, sticky=tkinter.E + tkinter.W)
    tkinter.Checkbutton(top, bg=bg, fg=fg, activebackground=bg, activeforeground=fg, selectcolor=bg, text='重置列名',
                        variable=Index_must).grid(column=a_x + 2, row=a_y, sticky=tkinter.W)

    a_y += 1
    Form_BOX = tkinter.Listbox(top, width=width_B * 3,height = height_B*5)  # 显示符号
    Form_BOX.grid(column=a_x, row=a_y, columnspan=3, rowspan=5,sticky=tkinter.E + tkinter.W + tkinter.S + tkinter.N)

    a_y += 5
    tkinter.Button(top, bg=bbg, fg=fg, text='查看行名',command=get_Index, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='查看列名',command=get_Column, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='显示表格',command=Write_Sheet, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    global Max_Row,Max_Column
    a_y += 1
    tkinter.Label(top, text='最大显示行数:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    Max_Row = tkinter.Entry(top, width=width_B * 2)
    Max_Row.grid(column=a_x + 1, row=a_y, columnspan=2, sticky=tkinter.E + tkinter.W)

    a_y += 1
    tkinter.Label(top, text='最大显示列数:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    Max_Column = tkinter.Entry(top, width=width_B * 2)
    Max_Column.grid(column=a_x + 1, row=a_y, columnspan=2, sticky=tkinter.E + tkinter.W)

    #Row与Column Row是横行，tkinter布局中Row变大，表示所在行数变大，向下移动如：
    # 1，2，3，4，5，6
    # 7，8，9，a，b，c
    # 其中数字1-6是第一行，1-c是第二行，第二行在第一行下面，row变大向下移动（Row是横向行而不是横向移动） to 搞不清楚横行竖列的人

    a_y += 1
    Index_BOX = tkinter.Listbox(top, width=width_B * 3,height = height_B*3)  # 显示符号
    Index_BOX.grid(column=a_x, row=a_y, columnspan=3, rowspan=3,sticky=tkinter.E + tkinter.W + tkinter.S + tkinter.N)

    global Des_Bool
    a_y += 3
    tkinter.Button(top, bg=bbg, fg=fg, text='查看数据分析',command=Show_Des, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='简单数据统计',command=Show_describe, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    Des_Bool = tkinter.IntVar()#是否启用
    tkinter.Checkbutton(top, bg=bg, fg=fg, activebackground=bg, activeforeground=fg, selectcolor=bg, text='生成统计表格',
                        variable=Des_Bool).grid(column=a_x + 2, row=a_y, sticky=tkinter.W)

    a_y += 1
    tkinter.Label(top, text='【排序操作】', bg=bg, fg=fg, font=FONT, width=width_B*3, height=height_B).grid(column=a_x,
                                                                                               columnspan=3,row=a_y)  # 设置说明

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='表格转置', command=T, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='按行名排序', command=Stored_Row, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='按列名排序', command=Stored_Column, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    global Sort_By,Ascending_Type,Ascending_New,Stored_BOX
    a_y += 1
    tkinter.Label(top, text='基准列(列号):', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    Sort_By = tkinter.Entry(top, width=width_B+2)
    Sort_By.grid(column=a_x + 1, row=a_y, sticky=tkinter.W)
    tkinter.Button(top, bg=bbg, fg=fg, text='按数据排序', command=Stored_Value, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    Ascending_Type = tkinter.IntVar()
    Ascending_New = tkinter.IntVar()
    lable = ['正序排列','倒序排列']#复选框
    for i in range(2):
        tkinter.Radiobutton(top,bg = bg,fg = fg,activebackground=bg,activeforeground=fg,selectcolor=bg,text=lable[i], variable=Ascending_Type, value=i).\
            grid(column=a_x+i, row=a_y, sticky=tkinter.W)
    tkinter.Checkbutton(top, bg=bg, fg=fg, activebackground=bg, activeforeground=fg, selectcolor=bg, text='生成新表格',
                        variable=Ascending_New).grid(column=a_x + 2, row=a_y, sticky=tkinter.W)

    a_y += 1
    Stored_BOX = tkinter.Listbox(top, width=width_B * 3,height = height_B*3)  # 显示符号
    Stored_BOX.grid(column=a_x, row=a_y, columnspan=3, rowspan=3,sticky=tkinter.E + tkinter.W + tkinter.S + tkinter.N)

    a_y += 3
    tkinter.Button(top, bg=bbg, fg=fg, text='添加基准', command=add_Stored_Value, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='删除基准', command=Delete_Stored_Value, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='清空基准', command=Tra_Stored_Value, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_x += 3
    tkinter.Label(top, text='', bg=bg, fg=fg, font=FONT, width=1).grid(column=a_x,row=a_y)  # 设置说明
    a_x += 1
    a_y = 0

    tkinter.Label(top, text='【数据清洗】', bg=bg, fg=fg, font=FONT, width=width_B*3, height=height_B).grid(column=a_x,
                                                                                               columnspan=3,row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)  # 设置说明

    global Slice_new,Column_Type,Row_Type,Column_clist,Row_clist
    Column_clist = []
    Row_clist = []
    label = ['启始(列号):','终止(列):','间隔(列):']
    for i in range(3):
        a_y += 1
        tkinter.Label(top, text=label[i], bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
        Column_clist.append(tkinter.Entry(top, width=width_B * 2))
        Column_clist[-1].grid(column=a_x + 1, row=a_y,columnspan=2, sticky=tkinter.W+tkinter.E)

    label = ['启始(行号):', '终止(行):', '间隔(行):']
    for i in range(3):
        a_y += 1
        tkinter.Label(top, text=label[i], bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
        Row_clist.append(tkinter.Entry(top, width=width_B * 2))
        Row_clist[-1].grid(column=a_x + 1, row=a_y,columnspan=2, sticky=tkinter.W+tkinter.E)

    a_y += 1
    Column_Type = tkinter.IntVar()
    lable = ['根据列号','根据列名','输入列号']#复选框
    for i in range(3):
        tkinter.Radiobutton(top,bg = bg,fg = fg,activebackground=bg,activeforeground=fg,selectcolor=bg,text=lable[i], variable=Column_Type, value=i).\
            grid(column=a_x+i, row=a_y, sticky=tkinter.W)

    a_y += 1
    Row_Type = tkinter.IntVar()
    lable = ['根据行号','根据行名','输入行号']#复选框
    for i in range(3):
        tkinter.Radiobutton(top,bg = bg,fg = fg,activebackground=bg,activeforeground=fg,selectcolor=bg,text=lable[i], variable=Row_Type, value=i).\
            grid(column=a_x+i, row=a_y, sticky=tkinter.W)

    a_y += 1
    Slice_new = tkinter.IntVar()
    tkinter.Button(top, bg=bbg, fg=fg, text='切片选定', command=Slice_Data, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='删除选定', command=Del_Data, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Checkbutton(top, bg=bg, fg=fg, activebackground=bg, activeforeground=fg, selectcolor=bg, text='生成新表格',
                        variable=Slice_new).grid(column=a_x + 2, row=a_y, sticky=tkinter.W)

    global Bool_E,Drop_Column
    a_y += 1
    tkinter.Label(top, text='布尔逻辑:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,
                                                                                                      row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)  # 设置说明
    Bool_E = tkinter.Entry(top, width=width_B*2)
    Bool_E.grid(column=a_x + 1, row=a_y,columnspan=2, sticky=tkinter.W+tkinter.E)

    a_y += 1
    tkinter.Label(top, text='操作的列号:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,
                                                                                                      row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)  # 设置说明
    Drop_Column = tkinter.Entry(top, width=width_B*2)
    Drop_Column.grid(column=a_x + 1, row=a_y,columnspan=2, sticky=tkinter.W+tkinter.E)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='生成布尔表格', command=Make_BoolSheet, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='查看空值', command=is_Na, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='清洗空值(按行)', command=Done_NaN, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='添加执行方法', command=Add_Clean, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='删除执行方法', command=Del_Clean, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='执行数据清洗', command=Done_Clean, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    global Done_CleanBox,Done_Func
    a_y += 1
    Done_CleanBox = tkinter.Listbox(top, width=width_B * 3, height=height_B * 2)
    Done_CleanBox.grid(column=a_x, row=a_y, columnspan=3, rowspan=2, sticky=tkinter.E + tkinter.W + tkinter.S + tkinter.N)

    a_y += 2
    tkinter.Button(top, bg=bbg, fg=fg, text='查看词典', command=Show_Help, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='恢复显示', command=get_InsertClean_Text, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='执行数据清洗', command=Done_Clean, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    Done_Func = tkinter.Text(top,width=width_B*3,height=height_B*7)
    Done_Func.grid(column=a_x, row=a_y,columnspan=3,rowspan=7, sticky=tkinter.E + tkinter.W + tkinter.N + tkinter.S)
    Done_Func.insert('0.0',Clean_Text)

    a_y += 7
    tkinter.Button(top, bg=bbg, fg=fg, text='清空执行方法', command=Tra_Clean, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='查看执行方法', command=get_CleanEXP, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='导入执行方法', command=Open_Python, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_x += 3
    tkinter.Label(top, text='', bg=bg, fg=fg, font=FONT, width=1).grid(column=a_x,row=a_y)  # 设置说明
    a_x += 1
    a_y = 0

    tkinter.Label(top, text='【数据画图】', bg=bg, fg=fg, font=FONT, width=width_B*3, height=height_B).grid(column=a_x,
                                                                                               columnspan=3,row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)  # 设置说明

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='生成柱状图', command=to_Bar, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成3D柱状图', command=to_Bar3d, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成折线图', command=to_Line, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='生成3D折线图', command=to_Line3D, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成象形柱状图', command=to_Pictorialbar, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y,columnspan=2, sticky=tkinter.E + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='生成散点图', command=to_Scatter, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成3D散点图', command=to_Scatter3D, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成箱形图', command=to_Boxpolt, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='生成漏斗图', command=to_Funnel, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成关系图', command=to_Graph, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成饼图', command=to_Pie, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='生成多轴图', command=to_Parallel, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成极坐标图', command=to_Polar, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成雷达图', command=to_Radar, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='生成词云', command=to_WordCloud, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y,columnspan=2, sticky=tkinter.E + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成热力图', command=to_HeatMap, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='生成水球图', command=to_Liquid, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y,columnspan=2, sticky=tkinter.E + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='生成仪表图', command=to_Gauge, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x + 2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='渲染HTML', command=Draw, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='单独渲染HTML', command=Draw_One, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='删除渲染', command=Del_R_BOX, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    a_y += 1
    global R_BOX,Args_Input
    R_BOX = tkinter.Listbox(top, width=width_B * 3, height=height_B * 3)
    R_BOX.grid(column=a_x, row=a_y, columnspan=3, rowspan=3, sticky=tkinter.E + tkinter.W + tkinter.S + tkinter.N)

    a_y += 3
    global Draw_asWell
    Draw_asWell = tkinter.IntVar()
    tkinter.Button(top, bg=bbg, fg=fg, text='清空渲染', command=Draw, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='导入渲染', command=Draw, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Checkbutton(top, bg=bg, fg=fg, activebackground=bg, activeforeground=fg, selectcolor=bg, text='马上渲染',
                        variable=Draw_asWell).grid(column=a_x + 2, row=a_y, sticky=tkinter.W)
    a_y += 1
    Args_Input = tkinter.Text(top,width=width_B*3,height=height_B*4)
    Args_Input.grid(column=a_x, row=a_y,columnspan=3,rowspan=6, sticky=tkinter.E + tkinter.W + tkinter.N + tkinter.S)

    a_y += 6
    tkinter.Button(top, bg=bbg, fg=fg, text='查看词典', font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    tkinter.Button(top, bg=bbg, fg=fg, text='恢复显示', font=FONT, width=width_B,
                   height=height_B).grid(column=a_x+1, row=a_y,columnspan = 2, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)

    global Dtype_Column,Dtype_Input,Dtype_Wrong,Dtype_Func
    a_y += 1
    tkinter.Label(top, text='【数据类型管理】', bg=bg, fg=fg, font=FONT, width=width_B*3, height=height_B).grid(column=a_x,
                                                                                               columnspan=3,row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)  # 设置说明

    a_y += 1
    tkinter.Label(top, text='修改(列号):', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    Dtype_Column = tkinter.Entry(top, width=width_B * 2)
    Dtype_Column.grid(column=a_x + 1, row=a_y, columnspan=2, sticky=tkinter.E + tkinter.W)

    a_y += 1
    tkinter.Label(top, text='数据类型:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    Dtype_Input = tkinter.Entry(top, width=width_B * 2)
    Dtype_Input.grid(column=a_x + 1, row=a_y, columnspan=2, sticky=tkinter.E + tkinter.W)

    a_y += 1
    tkinter.Label(top, text='错误值:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    Dtype_Wrong = tkinter.Entry(top, width=width_B * 2)
    Dtype_Wrong.grid(column=a_x + 1, row=a_y, columnspan=2, sticky=tkinter.E + tkinter.W)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='执行转换',command=DTYPE, font=FONT, width=width_B,
                   height=height_B).grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)
    Dtype_Func = tkinter.IntVar()#正，负，0
    lable = ['硬转换','软转换']#复选框
    for i in range(2):
        tkinter.Radiobutton(top,bg = bg,fg = fg,activebackground=bg,activeforeground=fg,selectcolor=bg,text=lable[i],
                            variable=Dtype_Func, value=i).grid(column=a_x+1+i, row=a_y, sticky=tkinter.W)

    a_x += 3
    tkinter.Label(top, text='', bg=bg, fg=fg, font=FONT, width=1).grid(column=a_x,row=a_y)  # 设置说明
    a_x += 1
    a_y = 0

    tkinter.Label(top, text='【行名与列名】', bg=bg, fg=fg, font=FONT, width=width_B*3, height=height_B).grid(column=a_x,
                                                                                               columnspan=3,row=a_y, sticky=tkinter.E + tkinter.W + tkinter.W+tkinter.S + tkinter.N)  # 设置说明

    global replace_Dic,Repalce_RC,replace_iloc,Date_Input,RC_Type
    a_y += 1
    Repalce_RC = tkinter.IntVar()
    lable = ['(列数据)调整行名','(行数据)调整列名']#复选框
    for i in range(2):
        tkinter.Radiobutton(top,bg = bg,fg = fg,activebackground=bg,activeforeground=fg,selectcolor=bg,text=lable[i],
                            variable=Repalce_RC, value=i).grid(column=a_x+i, row=a_y, sticky=tkinter.W)
    tkinter.Button(top, bg=bbg, fg=fg, text='植入行(列)号',command=num_withName, font=FONT, width=width_B,height=height_B).\
        grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W)

    a_y += 1
    RC_Type = []
    lable = ['保留原值','保留新值']#复选框
    for i in range(2):
        RC_Type.append(tkinter.IntVar())
        tkinter.Checkbutton(top,bg = bg,fg = fg,activebackground=bg,activeforeground=fg,selectcolor=bg, text=lable[i],
                            variable=RC_Type[-1]).grid(column=a_x+i, row=a_y, sticky=tkinter.W)
    tkinter.Button(top, bg=bbg, fg=fg, text='统一行号',command=num_toName, font=FONT, width=width_B,height=height_B).\
        grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W)

    a_y += 1
    tkinter.Label(top, text='替换字典:', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    replace_Dic = tkinter.Entry(top, width=width_B * 2)
    replace_Dic.grid(column=a_x + 1, row=a_y, columnspan=2, sticky=tkinter.E + tkinter.W)

    a_y += 1
    tkinter.Label(top, text='替换列(行):', bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
    replace_iloc = tkinter.Entry(top, width=width_B * 2)
    replace_iloc.grid(column=a_x + 1, row=a_y, columnspan=2, sticky=tkinter.E + tkinter.W)

    a_y += 1
    tkinter.Button(top, bg=bbg, fg=fg, text='执行替换已有列(行)操作',command=Change_Index, font=FONT, width=width_B*2, height=height_B). \
        grid(column=a_x,columnspan=2, row=a_y, sticky=tkinter.E + tkinter.W)
    tkinter.Button(top, bg=bbg, fg=fg, text='执行替换操作',command=Replace_Index, font=FONT, width=width_B,height=height_B).\
        grid(column=a_x+2, row=a_y, sticky=tkinter.E + tkinter.W)

    label = ['起点','终点','间隔']
    Date_Input = []
    for i in range(3):
        a_y += 1
        tkinter.Label(top, text='时间序列'+label[i], bg=bg, fg=fg, font=FONT, width=width_B, height=height_B).grid(column=a_x,row=a_y)  # 设置说明
        Date_Input.append(tkinter.Entry(top, width=width_B * 2))
        Date_Input[-1].grid(column=a_x + 1, row=a_y, columnspan=2, sticky=tkinter.E + tkinter.W)

    global Date_Type
    a_y += 1
    Date_Type = tkinter.IntVar()
    tkinter.Button(top, bg=bbg, fg=fg, text='刷入Date序列',command=Date_Index, font=FONT, width=width_B,height=height_B).\
        grid(column=a_x, row=a_y, sticky=tkinter.E + tkinter.W)
    tkinter.Button(top, bg=bbg, fg=fg, text='刷入Time序列',command=Time_index, font=FONT, width=width_B, height=height_B). \
        grid(column=a_x+1, row=a_y, sticky=tkinter.E + tkinter.W)
    tkinter.Checkbutton(top, bg=bg, fg=fg, activebackground=bg, activeforeground=fg, selectcolor=bg, text='使用间隔',
                        variable=Date_Type).grid(column=a_x + 2, row=a_y, sticky=tkinter.W)

    top.mainloop()

#出现在此下面的函数应转移到上方方便管理！......

def Replace_Index():
    global replace_Dic, Repalce_RC,ML
    name = get_Name()
    Dic = eval(replace_Dic.get())
    is_Column = bool(Repalce_RC.get()) #操作行-False，操作列-True
    save = bool(RC_Type[0].get())

    ML.Replace_Index(name,is_Column,Dic,save)
    Updat_BOX()

def Change_Index():
    global Repalce_RC, replace_iloc, RC_Type,ML
    name = get_Name()  # 名字
    is_Column = bool(Repalce_RC.get())  # 操作行名-False，操作列名-True
    iloc = int(replace_iloc.get()) # 替换的列号(行号)
    save = bool(RC_Type[0].get())
    drop = not bool(RC_Type[1].get())

    ML.Change_Index(name,is_Column,iloc,save,drop)
    Updat_BOX()

def num_toName():
    global Repalce_RC, replace_iloc, RC_Type,ML
    name = get_Name()  # 名字
    is_Column = bool(Repalce_RC.get())  # 操作行名-False，操作列名-True
    save = bool(RC_Type[0].get())

    ML.num_toName(name,is_Column,save)
    Updat_BOX()

def num_withName():
    global Repalce_RC,RC_Type,ML
    name = get_Name()  # 名字
    is_Column = bool(Repalce_RC.get())  # 操作行名-False，操作列名-True
    save = bool(RC_Type[0].get())

    ML.num_withName(name,is_Column,save)
    Updat_BOX()

def DateTime_Index(is_Date=True):
    global Repalce_RC, RC_Type,ML,Date_Input,Date_Type
    name = get_Name()  # 名字
    is_Column = bool(Repalce_RC.get())  # 操作行名-False，操作列名-True
    save = bool(RC_Type[0].get())

    k = ['start','end','freq']
    Init = {}
    for i in range(len(Date_Input)):
        Input = Date_Input[i].get()
        if Input == '':continue
        Init[k[i]] = Input
    if len(Init) == 3:
        if bool(Date_Type.get()):#使用间隔
            del Init['end']
        else:
            del Init['freq']
    if is_Date:
        ML.Date_Index(name,is_Column,save,**Init)
    else:
        ML.Time_Index(name, is_Column, save, **Init)
    Updat_BOX()

def Date_Index():
    DateTime_Index(True)

def Time_index():
    DateTime_Index(False)

if __name__ == '__main__':
    Machine_learning()