espin086 / GPT-Jobhunter

AI-powered job analysis and resume coaching tool using GPT. Analyzes job postings and provides personalized recommendations to job seekers for improving their resumes.
MIT License
55 stars 15 forks source link

Implemented optional feature GPT based similarity #128

Closed AtharvaJadhav7 closed 8 months ago

AtharvaJadhav7 commented 8 months ago

Used OpenAI API to create GPT embeddings, saved these embeddings in database in jobs table, they are created when job entries are created in the database. creating of embeddings again and again during ETL process is avoided to save API calls cost, by calling them only if there is no entry present for that particular key, same way as jobs are skipped. Changed strcture of jobs table to accomodate embeddings column, we can avoid showing that in app by just modifying query, but kept it there now, until functionality is completely full proof. Added a way to ask users for resume from user in streamlit interface, save that resume text in database as form of text. can update those entries too, if wanted. Added a button to use selected resume to get GPT based embeddings. Separated Run and Query Database to update and view database whenever wanted. this might be more user friendly as, there are optional features, so one can just run pipeline and then query database, or opt for features and then query database.

Sharing recording of complete run and functionality Screencast from 10-28-2023 03:57:13 PM.webm

AtharvaJadhav7 commented 8 months ago

Also need to delete existing all_jobs.db file to create new tables as there are changes in structure. In ther video, the first error displayed was just to ensure the file does not exit from before

AtharvaJadhav7 commented 8 months ago

@espin086 have made changes about issues #79 and #69 check above and if there are any further improvements needed, do tell.

espin086 commented 8 months ago

Great work! Thank you!

espin086 commented 8 months ago

@AtharvaJadhav7 - can you please documention in the Quickstart.md how to add the openai key?