def update_connection(n): if n > 0: collect.get_data() test2.sale_col = test2.get_col(test2.sale_col) print('data have been updated') return ''
def update_connection(n): global df global df_1 global df_final global df_ko global df_neuf if n>0: df = pd.read_csv('data/inventory.csv') df['cost_price'] = df['cost_price'].round(2) df = df[df['country'] == 'Mali'] df.fillna(0, inplace=True) df_1 = df.groupby(['product_type', 'etat', 'cost_price', 'stock_type'], as_index=False).sum({'quantite': 'sum'}) df_final = df_1.copy() df_final = df_final[(df_final['etat'] == 'Endommagé') | (df_final['etat'] == 'Neuf')] df_final['Cout Total'] = (df_final['quantite'] * df_final['cost_price']).round(2) # df_final.rename(columns={'serial':'Quantite'},inplace=True) df_ko = df_final[df_final['etat'] == 'Endommagé'] df_neuf = df_final[df_final['etat'] == 'Neuf'] collect.get_data() job2() print('data have been updated') return ''
def update_connection(n): global sale_col if n > 0: collect.get_data() sale_col = get_col(sale_col) print('data have been updated') return ''
def update_connection(n): global data if n > 0: data = pd.read_csv('data/inventory.csv') collect.get_data() print('data have been updated') return ''
def prep(path): data, features = get_data(path) features.sort() label = [] new_data = [] for l in data: new_row = [] if l[0] in affected_syscalls: label.append(1) else: label.append(0) memfreq = l[1] for f in features: if f not in memfreq.keys(): new_row.append(0) else: new_row.append(memfreq[f]) new_data.append(new_row) return new_data, label
import dash_bootstrap_components as dbc import dash_html_components as html import dash_core_components as dcc from dash.dependencies import Input, Output import dash_table as dt import psycopg2 from psycopg2 import Error from sqlalchemy import text from datetime import date from datetime import timedelta import collect import atexit from apscheduler.schedulers.background import BackgroundScheduler collect.get_data() scheduler = BackgroundScheduler(daemon=True) scheduler.add_job(func=collect.get_data, trigger="interval", minutes=60) scheduler.start() df_ag_sup = pd.read_csv('Data/ag_sup.csv') df_stock = pd.read_csv('Data/stock.csv') df_vente = pd.read_csv('Data/vente.csv') df_sup = pd.read_csv('Data/superviseur.csv') df_ticket = pd.read_csv('Data/ticket.csv') df_backlog = pd.read_csv('Data/backlog.csv') table_header_style = { # "backgroundColor": "#E5E2E2", "color": "balck",
from collect import get_data from graph import mkgraph from subprocess import call mkgraph(list(get_data()), 'graph.png') call(['xloadimage', '-onroot', 'graph.png'])