def view_stats(self): company_name = [] package = [] year = [] spinvals = [] for comp in self.company.find(): company_name.append(comp['CompanyName']) package.append(comp['Package']) year.append(comp['Year']) for x in range(len(company_name)): line = '|'.join([company_name[x], package[x], year[x]]) if line not in spinvals: spinvals.append(line) self.ids.target_company.values = spinvals plt.cla() self.ids.analysis_res.clear_widgets() target_company = self.ids.target_company.text print(target_company) target = target_company.split('|') print(target) com = self.company.find_one({ 'CompanyName': target[0], 'Package': target[1], 'Year': target[2] }) if com == None: print("Data Not Found") else: com1 = self.company.count_documents({ 'CompanyName': target[0], 'Package': target[1], 'Year': target[2] }) com2 = self.company.count_documents({ 'CompanyName': target[0], 'Package': target[1], 'Year': target[2], 'Status': "Yes" }) with open('CompanyAnalysis.csv', 'w') as f: f.write('CompanyName,Package,Year,Total_stud,Selected_stud\n') line = ','.join([ str(target[0]), str(target[1]), str(target[2]), str(com1), str(com2) ]) f.write(line + '\n') df = pd.read_csv('CompanyAnalysis.csv') df.plot.bar(x='Year', y=['Total_stud', 'Selected_stud']) self.ids.analysis_res.add_widget(FCK(plt.gcf()))
def view_stats(self): plt.cla() self.ids.analysis_res.clear_widgets() target_company = self.ids.target_company.text print(target_company) target = target_company.split('|') print(target) com = self.company.find_one({ 'CompanyName': target[0], 'Package': target[1], 'Year': target[2] }) if com == None: print("Data Not Found") else: com1 = self.company.count_documents({ 'CompanyName': target[0], 'Package': target[1], 'Year': target[2] }) com2 = self.company.count_documents({ 'CompanyName': target[0], 'Package': target[1], 'Year': target[2], 'Status': "Yes" }) with open('CompanyAnalysis.csv', 'w') as f: f.write('CompanyName,Package,Year,Total_stud,Selected_stud\n') line = ','.join([ str(target[0]), str(target[1]), str(target[2]), str(com1), str(com2) ]) f.write(line + '\n') df = pd.read_csv('CompanyAnalysis.csv') df.plot.bar(x='Year', y=['Total_stud', 'Selected_stud']) self.ids.analysis_res.add_widget(FCK(plt.gcf()))
def view_stats(self): plt.cla() self.ids.analysis_res.clear_widgets() target_category = self.ids.cat.text print(target_category) conn = sqlite3.connect("expenditure.db") cur = conn.cursor() cur.execute('SELECT amount,date FROM expenses WHERE category=?', (target_category, )) rows = cur.fetchall() purchases = [] dates = [] for amt, dt in rows: purchases.append(amt) dates.append(dt) plt.bar(dates, purchases, color='#131d86', label="Expenditures") plt.ylabel('Total Purchases') plt.xlabel('day') self.ids.analysis_res.add_widget(FCK(plt.gcf()))
def view_stats(self): plt.cla() self.ids.analysis_res.clear_widgets() target_product = self.ids.target_product.text target = target_product[:target_product.find(' | ')] name = target_product[target_product.find(' | '):] df = pd.read_csv('products_purchase.csv') purchases = [] dates = [] count = 0 for x in range(len(df)): if str(df.Product_Code[x]) == target: purchases.append(df.Purchased[x]) dates.append(count) count+=1 plt.bar(dates,purchases,color='teal',label=name) plt.ylabel('Total Purchases') plt.xlabel('day') self.ids.analysis_res.add_widget(FCK(plt.gcf()))