code_wise/db.py at master · winter-code/code_wise · GitHub

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

import sys
import pandas as pd
import numpy as np
import csv
from PyQt5 import QtWidgets


class Window(QtWidgets.QWidget):
    df = pd.read_csv('Book1.csv')


    def __init__(self):
        df = pd.read_csv('Book1.csv')
        super().__init__()

        self.init_ui()

    def init_ui(self):
        df = pd.read_csv('Book1.csv')
        self.le = QtWidgets.QLineEdit()
        self.b1 = QtWidgets.QPushButton('Clear')
        self.b2 = QtWidgets.QPushButton('Search')
        self.l1 = QtWidgets.QLabel('In progress')


        v_box = QtWidgets.QVBoxLayout()

        v_box.addWidget(self.le)
        v_box.addWidget(self.b1)
        v_box.addWidget(self.b2)
        v_box.addWidget(self.l1)

        self.setLayout(v_box)
        self.setWindowTitle('Code_Wise')


        self.b1.clicked.connect(self.btn_clk)
        self.b2.clicked.connect(self.btn_clk)

        self.show()

    def btn_clk(self):
        df = pd.read_csv('Book1.csv')
        #print(self.le.text() == df['Item Name'])
        sender = self.sender()
        if sender.text() == 'Search':
            if self.le.text() == '':
                self.l1.setText("Enter something!")
            elif (df['Item Name'] == self.le.text()).any :
                v = df.loc[df['Item Name'] == self.le.text()]
                print(v)
            else:
                self.l1.setText('Not FOUND!')

        else:
            self.le.clear()


app = QtWidgets.QApplication(sys.argv)
a_window = Window()
sys.exit(app.exec_())