The dashboard from capallen

dashboard's Introduction

                          ___       __       __       _______ .__   __.  __     _______.               
                         /   \     |  |     |  |     |   ____||  \ |  | (_ )   /       |               
                        /  ^  \    |  |     |  |     |  |__   |   \|  |  |/   |   (----`               
                       /  /_\  \   |  |     |  |     |   __|  |  . `  |        \   \                   
                      /  _____  \  |  `----.|  `----.|  |____ |  |\   |    .----)   |                  
                     /__/     \__\ |_______||_______||_______||__| \__|    |_______/                   
                                                                                                       
 _______       ___   .___________.    ___              _______.  ______  __   _______ .__   __.   ______  _______ 
|       \     /   \  |           |   /   \            /       | /      ||  | |   ____||  \ |  |  /      ||   ____|
|  .--.  |   /  ^  \ `---|  |----`  /  ^  \          |   (----`|  ,----'|  | |  |__   |   \|  | |  ,----'|  |__   
|  |  |  |  /  /_\  \    |  |      /  /_\  \          \   \    |  |     |  | |   __|  |  . `  | |  |     |   __|  
|  '--'  | /  _____  \   |  |     /  _____  \     .----)   |   |  `----.|  | |  |____ |  |\   | |  `----.|  |____ 
|_______/ /__/     \__\  |__|    /__/     \__\    |_______/     \______||__| |_______||__| \__|  \______||_______|

Latest blog posts

>>> More blog posts

Statistics

dashboard's People

Contributors

Stargazers

Watchers

dashboard's Issues

ModuleNotFoundError

When i run the "python run.py", i got the error as fllow.

ModuleNotFoundError: No module named 'example.commons'

读取nginx_access.csv文件时报错: 不知道怎么处理.

File "D:\git_hub\Dashboard\help_funcs.py", line 503, in pre_linkage_data
data_for_line = pd.DataFrame(df_nginx.groupby(0)[2].value_counts().sort_index()).rename(columns={2:'count'}).unstack(0)

IndexError: boolean index did not match indexed array along dimension 0; dimension is 0 but corresponding boolean dimension is 1

【报错】sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file

直接运行代码后，发现，无法打开sqlite数据库，麻烦大佬有时间帮忙看看

C:\python37\python.exe D:/codePython/Dashboard-master/run.py
Engine(sqlite:///Doc/FakeDatasets.db)
Traceback (most recent call last):
  File "C:\python37\lib\site-packages\sqlalchemy\engine\base.py", line 2345, in _wrap_pool_connect
    return fn()
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 304, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 778, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 495, in checkout
    rec = pool._do_get()
  File "C:\python37\lib\site-packages\sqlalchemy\pool\impl.py", line 239, in _do_get
    return self._create_connection()
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 309, in _create_connection
    return _ConnectionRecord(self)
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 440, in __init__
    self.__connect(first_connect_check=True)
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 661, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "C:\python37\lib\site-packages\sqlalchemy\util\langhelpers.py", line 69, in __exit__
    exc_value, with_traceback=exc_tb,
  File "C:\python37\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
    raise exception
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 656, in __connect
    connection = pool._invoke_creator(self)
  File "C:\python37\lib\site-packages\sqlalchemy\engine\strategies.py", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "C:\python37\lib\site-packages\sqlalchemy\engine\default.py", line 490, in connect
    return self.dbapi.connect(*cargs, **cparams)
sqlite3.OperationalError: unable to open database file

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "D:/codePython/Dashboard-master/run.py", line 29, in <module>
    df = get_data(test=True)
  File "D:\codePython\Dashboard-master\help_funcs.py", line 27, in get_data
    df_test = pd.read_sql_table(table_name='FakeDatasets',con=engine)
  File "C:\python37\lib\site-packages\pandas\io\sql.py", line 242, in read_sql_table
    meta.reflect(only=[table_name], views=True)
  File "C:\python37\lib\site-packages\sqlalchemy\sql\schema.py", line 4356, in reflect
    with bind.connect() as conn:
  File "C:\python37\lib\site-packages\sqlalchemy\engine\base.py", line 2272, in connect
    return self._connection_cls(self, **kwargs)
  File "C:\python37\lib\site-packages\sqlalchemy\engine\base.py", line 104, in __init__
    else engine.raw_connection()
  File "C:\python37\lib\site-packages\sqlalchemy\engine\base.py", line 2379, in raw_connection
    self.pool.unique_connection, _connection
  File "C:\python37\lib\site-packages\sqlalchemy\engine\base.py", line 2349, in _wrap_pool_connect
    e, dialect, self
  File "C:\python37\lib\site-packages\sqlalchemy\engine\base.py", line 1591, in _handle_dbapi_exception_noconnection
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "C:\python37\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
    raise exception
  File "C:\python37\lib\site-packages\sqlalchemy\engine\base.py", line 2345, in _wrap_pool_connect
    return fn()
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 304, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 778, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 495, in checkout
    rec = pool._do_get()
  File "C:\python37\lib\site-packages\sqlalchemy\pool\impl.py", line 239, in _do_get
    return self._create_connection()
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 309, in _create_connection
    return _ConnectionRecord(self)
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 440, in __init__
    self.__connect(first_connect_check=True)
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 661, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "C:\python37\lib\site-packages\sqlalchemy\util\langhelpers.py", line 69, in __exit__
    exc_value, with_traceback=exc_tb,
  File "C:\python37\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
    raise exception
  File "C:\python37\lib\site-packages\sqlalchemy\pool\base.py", line 656, in __connect
    connection = pool._invoke_creator(self)
  File "C:\python37\lib\site-packages\sqlalchemy\engine\strategies.py", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "C:\python37\lib\site-packages\sqlalchemy\engine\default.py", line 490, in connect
    return self.dbapi.connect(*cargs, **cparams)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
(Background on this error at: http://sqlalche.me/e/e3q8)

Process finished with exit code 1

Recommend Projects