Data Analysis

This is a project for read and update one spreadsheet the Google

Technologies   |    About project   |    Documentation   |    Licence

🚀 Technologies

This project was developed with the following technologies

• Python 3.11.7
  • gspread 6.0.0
  • pandas 2.1.0
  • numpy 1.25.2
  • math (the library is already in python)
  • platform (the library is already in python)
  • os (the library is already in python)
• Git and Github
• Visual Studio Code

💻 About project

The application is used to read a Google Sheets spreadsheet, search for information, calculate and read the result in the spreadsheet.

Rules

Avarage	Situation
avg < 50	Failed due to grades
50 < avg <= 70	Exam failed
avg > 70	Approved

Calculation Naf

If the student is in the “Final Exam” situation, their passing grade must be calculated using the following formula.

5 <= (avg + naf) / 2

Click here to view Google Sheets spreadsheet.

📖 Documentation

To be able to complete this project, you will need to follow a step-by-step guide.
app.py is file central and framewok.py file is the functions.

FIRST STEP ✔

• Log in or register on Google Console;
• Click in 'APIs and Services';
• In the APIs library, search for 'Google Sheets API' and activate;
• In the credentials, create 'service accounts'. Choose your name and write about your description;
• Click on the created email and copy. Go to the spreadsheet, click share, enter this copied email and send the share. (it is a bot to manipulate the spreadsheet).
• Finally, go back to the Google Console in the created service, create and download the json key from the service account, change the name to key.json, and add the file to the project folder.

OBS:For security reasons, I recommend that everyone have their own Google Sheets API to use the application, which is why I added mine to gitignore.

SECOND STEP ✔

• Download this repository;

• Install the imported libraries;

  • pip install pandas;
  • pip install gspread;
  • pip install numpy;
  • pip install math
  • pip install lib-platform
  • pip install os

• Confirm that the key.json file is in the folder;

• If everything is correct, you can run the app.py file using F5 (in Visual Studio Code) or writing python app.py in the console.

THIRD STEP ✔

• In the console is possible to view the results from the program (logs);
• After the console shows 'Application terminated', you can view the result in the Google Sheets spreadsheet.

Licence

This project is under the MIT license.