tharun323/aggrid-plotly-django

Optimal display of Plotly Charts using Django API , Data is displayed in tabular form with search , sort and filter functionality using Aggrid

SurvaiderWebapp

system requirements:

-Python 3

-Django 2.0

-Mysql 5.3

-DjangoRestFramework

Features Present:

-Created a database in Mysql in local and uploaded the Employees details dataset

-Created RESTful API for the model which will be used to power the Plotly Charts

-Created Charts in Plotly using JavaScript and using the RestAPI to power the charts

-Cache is implemented using the Djanco cache mechanism and the database is optimised using indexing method.

-Created Aggrid in Javascript and added filters and sorting features to the dataset columns

-Used the REST api to power the Dataset

Steps to run the web application:

-Clone the files to the local system using https://github.com/tharun323/SurvaiderWebapp.git

-In the folder root , create the virtual environment

-Activate the virtual environment and install the requirements.txt file , run the migrations

-Run the application using python manage.py runserver

pointers:

Please use the local Sqlite database to store the data , since the API is not globally exposed. ( I do not have an AWS account )

Import the dataset csv file into Mysql using the Mysql Workbench

API should be deployed using Zappa + AWS lambda

Employee dataset in Aggrid using javascript and Django API

Various types of filters and sorting features are added in the columns

Plotly charts for Relationship distribution and Male and Female distribution using DjangoAPI

aggrid-plotly-django's Issues

simple