Python tool to extract data from excel worksheets and create separate worksheets depending on common cell data
Statistical data related to Turkish examination for specialty in medicine (TUS - Tıpta Uzmanlık Sınavı 2022.1) results are announced by the OSYM with a pdf file. Mentioned results can be seen and obtained from here.
With this tool, I aimed to obtain separate worksheets according to common specialization area names of medical studies. After converting this result pdf to an excel file, with the help of this tool this aim is achieved.
clone the repo, then install requirements. (openpyxl for excel files and inflection for string formatting)