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()))