Skip to content

Latest commit

 

History

History
77 lines (62 loc) · 3.59 KB

README.md

File metadata and controls

77 lines (62 loc) · 3.59 KB

Student Enrollment Analysis System (SEAS)

A web-based application written in Python (Django) to analyze the enrollment data of university students, particularly students from Independent University, Bangladesh.

Screenshot 1 Screenshot 2

  • Create a virtual environment using the following command pip install virtualenv myenv
  • Select that environment's python.exe as the interpreter,'path: myenv/Scripts/python.exe'

Dependencies

  • Install all the list of dependencies with the specified version: pip install mysqlclient==2.1.0
  • Django==3.2.9
  • mysqlclient==2.1.0
  • numpy==1.21.4
  • openpyxl==3.0.9
  • pandas==1.3.4
  • python-decouple==3.5

Run the project

  • Try this command in the terminal [VScode] to run the project python manage.py runserver

  • The default address [ http://127.0.0.1:8000/ ] will let you login to the web application

Login Credentials anyone of below:

username: topurayhan007 password: 12345
username: zannatchowdhury password: 3451
username: admin password: 12345

Alternate Database

  • Note that SQLite is used as the default database in this project
  • If you choose to use a different database configure it in the Django Settings DATABASE section
  • Then migrate to create the tables in the SQL database using the following command python manage.py makemigrations followed by python manage.py migrate
  • Create a user by the following command python manage.py createsuperuser
  • To populate the database with data run the following script in python shell populationScript.py filepath scripts/populationScript.py
    • To run the populationScript.py on windows [make sure you have GitBash terminal in VScode]: Use the following command ./manage.py shell < scripts/populationScript.py
    • To run the populationScript.py on Mac: Use the following command python manage.py shell < scripts/populationScript.py NOTE: The population Script will take a very long time to populate data if you are using SQLite Database (60 minutes +)
      • It was lot faster in MySQL like around 4/5 minutes
      • These doesn't apply to Mac users, not sure about Linux users
  • You should see that your database has successfully populated

Thanks for reading. Have a nice day & keep on coding! :)

Screenshot 3 Screenshot 4 Screenshot 5 Screenshot 6 Screenshot 7 Screenshot 8 Screenshot 9 Screenshot 10 Screenshot 11 Screenshot 12 Screenshot 13 Screenshot 14 Screenshot 15 Screenshot 16 Screenshot 17 Screenshot 18 Screenshot 19 Screenshot 20 Screenshot 21 Screenshot 22 Screenshot 23 Screenshot 24 Screenshot 25 Screenshot 26 Screenshot 27 Screenshot 28