-
Notifications
You must be signed in to change notification settings - Fork 0
/
read_data_set.py
141 lines (115 loc) · 6.11 KB
/
read_data_set.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
from tkinter import *
import os
import csv
import sample_data
from tkinter import *
import tkinter.ttk as ttk
import csv
########################################################### function
def read_data_set():
TableMargin = Frame(read_data_main, width=500)
TableMargin.place(x=50, y=110,width=655, height=255)
scrollbarx = Scrollbar(TableMargin, orient=HORIZONTAL)
scrollbary = Scrollbar(TableMargin, orient=VERTICAL)
tree = ttk.Treeview(TableMargin, columns=("customerID","gender","SeniorCitizen","Partner","Dependents","tenure","PhoneService","MultipleLines"
, "InternetService", "OnlineSecurity","OnlineBackup","DeviceProtection","TechSupport","StreamingTV"
,"StreamingMovies","Contract","PaperlessBilling","PaymentMethod","MonthlyCharges"
,"TotalCharges","Churn"), height=400, selectmode="extended", yscrollcommand=scrollbary.set, xscrollcommand=scrollbarx.set)
scrollbary.config(command=tree.yview)
scrollbary.pack(side=RIGHT, fill=Y)
scrollbarx.config(command=tree.xview)
scrollbarx.pack(side=BOTTOM, fill=X)
tree.heading('customerID', text="customerID", anchor=W)
tree.heading('gender', text="gender", anchor=W)
tree.heading('SeniorCitizen', text="SeniorCitizen", anchor=W)
tree.heading('Partner', text="Partner", anchor=W)
tree.heading('Dependents', text="Dependents", anchor=W)
tree.heading('tenure', text="tenure", anchor=W)
tree.heading('PhoneService', text="PhoneService", anchor=W)
tree.heading('MultipleLines', text="MultipleLines", anchor=W)
tree.heading('InternetService', text="InternetService", anchor=W)
tree.heading('OnlineSecurity', text="OnlineSecurity", anchor=W)
tree.heading('OnlineBackup', text="OnlineBackup", anchor=W)
tree.heading('DeviceProtection', text="DeviceProtection", anchor=W)
tree.heading('TechSupport', text="TechSupport", anchor=W)
tree.heading('StreamingTV', text="StreamingTV", anchor=W)
tree.heading('StreamingMovies', text="StreamingMovies", anchor=W)
tree.heading('Contract', text="Contract", anchor=W)
tree.heading('PaperlessBilling', text="PaperlessBilling", anchor=W)
tree.heading('PaymentMethod', text="PaymentMethod", anchor=W)
tree.heading('MonthlyCharges', text="MonthlyCharges", anchor=W)
tree.heading('TotalCharges', text="TotalCharges", anchor=W)
tree.heading('Churn', text="Churn", anchor=W)
tree.column('#0', stretch=NO, minwidth=0, width=0)
tree.column('#1', stretch=NO, minwidth=0, width=200)
tree.column('#2', stretch=NO, minwidth=0, width=200)
tree.column('#3', stretch=NO, minwidth=0, width=100)
tree.column('#4', stretch=NO, minwidth=0, width=100)
tree.column('#5', stretch=NO, minwidth=0, width=100)
tree.column('#6', stretch=NO, minwidth=0, width=100)
tree.column('#7', stretch=NO, minwidth=0, width=100)
tree.column('#8', stretch=NO, minwidth=0, width=100)
tree.column('#9', stretch=NO, minwidth=0, width=100)
tree.column('#10', stretch=NO, minwidth=0, width=100)
tree.column('#11', stretch=NO, minwidth=0, width=100)
tree.column('#12', stretch=NO, minwidth=0, width=100)
tree.column('#13', stretch=NO, minwidth=0, width=100)
tree.column('#14', stretch=NO, minwidth=0, width=100)
tree.column('#15', stretch=NO, minwidth=0, width=100)
tree.column('#16', stretch=NO, minwidth=0, width=100)
tree.column('#17', stretch=NO, minwidth=0, width=100)
tree.column('#18', stretch=NO, minwidth=0, width=100)
tree.column('#19', stretch=NO, minwidth=0, width=100)
tree.column('#20', stretch=NO, minwidth=0, width=100)
tree.column('#21', stretch=NO, minwidth=0, width=100)
tree.pack()
ob=sample_data
file=ob.f_filepath
with open(file) as f :
reader = csv.DictReader(f, delimiter=',')
for row in reader:
t1 = row['customerID']
t2 = row['gender']
t3 = row['SeniorCitizen']
t4 = row['Partner']
t5 = row['Dependents']
t6 = row['tenure']
t7 = row['PhoneService']
t8 = row['MultipleLines']
t9 = row['InternetService']
t10 = row['OnlineSecurity']
t11 = row['OnlineBackup']
t12 = row['DeviceProtection']
t13 = row['TechSupport']
t14 = row['StreamingTV']
t15 = row['StreamingMovies']
t16 = row['Contract']
t17 = row['PaperlessBilling']
t18 = row['PaymentMethod']
t19 = row['MonthlyCharges']
t20 = row['TotalCharges']
t21 = row['Churn']
tree.insert("", 0, values=(t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,t20,t21))
def next_page1():
read_data_main.destroy()
import missing_values
############################################################
read_data_main = Tk()
w=750
h=550
ws = read_data_main.winfo_screenwidth()
hs = read_data_main.winfo_screenheight()
x = (ws/2) - (w/2)
y = (hs/2) - (h/2)
read_data_main.geometry('%dx%d+%d+%d' % (w, h, x, y))
read_data_main.title(sample_data.student.title)
read_data_main.resizable(False, False)
read_data_main.configure(background=sample_data.student.background)
########################################################### Element design
message = Label(read_data_main, text=sample_data.student.titlec,bg=sample_data.student.background,fg="#FFF", width=35,height=3, font=('times', 30, 'italic bold '))
message.place(x=00, y=10)
compare_dataset = Button(read_data_main, text="Read Data",width=15,command=read_data_set ,height=1,fg="#FFF",bg="#004080", activebackground = "#ff8000",activeforeground="white" ,font=('times', 15, ' bold '))
compare_dataset.place(x=150, y=400)
resust_dataset = Button(read_data_main, text="Next",command=next_page1,width=15 ,height=1,fg="#FFF",bg="#004080", activebackground = "#ff8000",activeforeground="white" ,font=('times', 15, ' bold '))
resust_dataset.place(x=450, y=400)
read_data_main.mainloop()