Following are the required pre-requisites:

The following libraries can also be found in requirements.txt by running the following command:
pip install -r requirements.txt

gspread - pip install gspread
dotenv - pip install python-dotenv
discord.py - pip install discord.py
discord.py-pagination - pip install discord.py-pagination
pretty-help - pip install discord-pretty-help

---

Summary

Code Breakdown:

mainBot.py

1. This script is the main file for the bot.
2. It has the commands that help in reloading cogs def reload() as well as shut the bot def shut().

cutoff.py

1. This script is an command extension file containing the commands relating to DASA.

• cutoff - This command retrieves the cutoffs for a given college taken from a given year, round, branch and category. If branch is not given, cutoffs for all the branches from the given college will be displayed.
• analyze - This command returns the colleges whose closing rank cutoffs are closest to the rank inputed by the user. If branch is not givem, cutoffs for all the branches from all the colleges within a close range(i.e. 10000 higher than the given rank) of the given rank is returned.

connectRankDB.py

1. The script imports the necessary libraries, gspread for interacting with Google Sheets, as well as os and pathlib for getting filepaths etc.
2. The script establishes a data connection to Google Sheets using the service_account method from gspread. It loads the service account credentials from a JSON file named "DASABot/db_key.json".
3. It then opens a specific google sheet using its key, and then gets all the worksheets present and adds it to an object variable called worksheets
4. The script retrieves all the values from the worksheet using the get_all_values method and stores them in the worksheet_data variable in the form of a nested list. Since the data is static, the program operates based on list indexes.

Upon this, there are multiple methods to execute specific functions:

• get_sheet searches the worksheet containing the cutoffs of a specific year and round
• request_college_list returns a list of colleges participating in DASA counselling in a specific year and round
• nick_to_college converts any college nickname to its full name and returns it
• request_branch_list returns a list of valid branches under a college depending on whether the student qualifies for ciwg or not
• get_statistics returns a list of the cutoff ranks for a specific branch under a college
• get_statistics_for_all returns a list of cutoff ranks for all branches under a specified college (using get_statistics)
• reverse_engine returns a list of colleges which has a closing rank cutoff closest to the rank given by the user
• analysis returns three lists each containing the names of colleges filtered out by the difference between the user's CRL and college's Round 3 JEE Closing cutoff

NOTE: The code assumes the presence of the gspread library and a valid service account JSON file with the appropriate access to the Google Sheet.

Contributors:

• Haz3jolt: Worked and assisted in front-end service using discord.py
• Koshy: Front-end Manager. Structured and designed front-end interface and coded discord slash commands to pull data from database
• Cookie: Back-end Manager. Established and converted DASA cutoffs to usable data in XLS format. Coded algorithms to sift through data to return requested information.
• Amol: Full-Stack Developer. Assisted in mapping of DASA ranks with JEE ranks within database and laid foundation for connectrankdb