Django excel data analysis

• You can import excel sheet data to mysql using Django and Angular js.

Examples

Features

• This project makes it easy to:
  • Sort data by clicking their headings.
  • Filter data by using filter provided
  • Upload excel file to server and import it to mysql

Installation

• Install virtualenv with the following command:

  $ pip install virtualenv

• Set up your development structure:

  $ mkdir YourProjectName
  $ cd YourProjectName
  $ virtualenv YourProjectEnv
  $ git clone [email protected]:ijajmulani/risktask.git
  $ source YourProjectEnv/bin/activate
  $ cd risktask

• Let’s get Django installed:

  $ pip install django

• Install MySQL-python, which is a database connector for Python:

  $ sudo apt-get install libmysqlclient-dev
  $ pip install mysqlclient

• Install xlrd, The xlrd module reads a spreadsheet into a hierarchical data structure:

  $ pip install xlrd

• Install dateutil module for date conversion:

  $ pip install python-dateutil

• Edit your settings.py file within your directory to add the following information about your database:

  DATABASES = {
    'default': {
      'ENGINE': 'django.db.backends.mysql',
      'NAME': 'django_db',
      'USER': 'root',
      'PASSWORD': 'your_password',
    }
  }
  

• Create your database tables:

  $ python manage.py migrate
  

• Launch the development server:

  $ python manage.py runserver