Supply/Test code/Test code_Retrieval.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "55a7e8e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import openai\n",
    "import time\n",
    "from openai import OpenAI\n",
    "from dotenv import load_dotenv\n",
    "\n",
    "load_dotenv('untitled.env')\n",
    "\n",
    "api_key = os.getenv('OPENAI_API_KEY')\n",
    "print(api_key)  \n",
    "\n",
    "client = OpenAI()\n",
    "\n",
    "##File id, assistant id 从retrieval notebook那里获取"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "28dc98e5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing row 468/725: Is Exercise recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 468...\n",
      "Sending message for row 468...\n",
      "Creating run for row 468...\n",
      "Waiting for run to complete for row 468...\n",
      "completed\n",
      "Row 468 processing completed and saved.\n",
      "Processing row 469/725: Is Exercise education recommended for Education Treatment of  osteoarthritis.\n",
      "Creating thread for row 469...\n",
      "Sending message for row 469...\n",
      "Creating run for row 469...\n",
      "Waiting for run to complete for row 469...\n",
      "completed\n",
      "Row 469 processing completed and saved.\n",
      "Processing row 470/725: Is Exercise tailored to patient's need recommended for Exercise Treatment of  osteoarthritis.\n",
      "Creating thread for row 470...\n",
      "Sending message for row 470...\n",
      "Creating run for row 470...\n",
      "Waiting for run to complete for row 470...\n",
      "completed\n",
      "Row 470 processing completed and saved.\n",
      "Processing row 471/725: Is \"Explain to patients what osteoarthritis is\" recommended for Education Treatment of  osteoarthritis. \n",
      "Creating thread for row 471...\n",
      "Sending message for row 471...\n",
      "Creating run for row 471...\n",
      "Waiting for run to complete for row 471...\n",
      "completed\n",
      "Row 471 processing completed and saved.\n",
      "Processing row 472/725: Is Extracorporeal shockwave therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 472...\n",
      "Sending message for row 472...\n",
      "Creating run for row 472...\n",
      "Waiting for run to complete for row 472...\n",
      "completed\n",
      "Row 472 processing completed and saved.\n",
      "Processing row 473/725: Is FGF recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 473...\n",
      "Sending message for row 473...\n",
      "Creating run for row 473...\n",
      "Waiting for run to complete for row 473...\n",
      "completed\n",
      "Row 473 processing completed and saved.\n",
      "Processing row 474/725: Is Fish Oil recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 474...\n",
      "Sending message for row 474...\n",
      "Creating run for row 474...\n",
      "Waiting for run to complete for row 474...\n",
      "completed\n",
      "Row 474 processing completed and saved.\n",
      "Processing row 475/725: Is \"For those who are overweight (BMI ≥25 kg/m2) or obese (BMI ≥30 kg/m2), a minimum weight loss target of 5–7.5% of body weight\"recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 475...\n",
      "Sending message for row 475...\n",
      "Creating run for row 475...\n",
      "Waiting for run to complete for row 475...\n",
      "completed\n",
      "Row 475 processing completed and saved.\n",
      "Processing row 476/725: Is Free-floating (un-fixed) interpositional devices  recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 476...\n",
      "Sending message for row 476...\n",
      "Creating run for row 476...\n",
      "Waiting for run to complete for row 476...\n",
      "completed\n",
      "Row 476 processing completed and saved.\n",
      "Processing row 477/725: Is Gait Aids recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 477...\n",
      "Sending message for row 477...\n",
      "Creating run for row 477...\n",
      "Waiting for run to complete for row 477...\n",
      "completed\n",
      "Row 477 processing completed and saved.\n",
      "Processing row 478/725: Is gastroprotective treatment (such as a proton pump inhibitor) while taking NSAIDs recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 478...\n",
      "Sending message for row 478...\n",
      "Creating run for row 478...\n",
      "Waiting for run to complete for row 478...\n",
      "completed\n",
      "Row 478 processing completed and saved.\n",
      "Processing row 479/725: Is Ginger extract recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 479...\n",
      "Sending message for row 479...\n",
      "Creating run for row 479...\n",
      "Waiting for run to complete for row 479...\n",
      "completed\n",
      "Row 479 processing completed and saved.\n",
      "Processing row 480/725: Is Glucosamine recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 480...\n",
      "Sending message for row 480...\n",
      "Creating run for row 480...\n",
      "Waiting for run to complete for row 480...\n",
      "completed\n",
      "Row 480 processing completed and saved.\n",
      "Processing row 481/725: Is glucosamine and chondroitin in compound for recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 481...\n",
      "Sending message for row 481...\n",
      "Creating run for row 481...\n",
      "Waiting for run to complete for row 481...\n",
      "completed\n",
      "Row 481 processing completed and saved.\n",
      "Processing row 482/725: Is Hand Orthosis recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 482...\n",
      "Sending message for row 482...\n",
      "Creating run for row 482...\n",
      "Waiting for run to complete for row 482...\n",
      "completed\n",
      "Row 482 processing completed and saved.\n",
      "Processing row 483/725: Is High tibial osteotomy recommended for Surgery Treatment of  osteoarthritis.\n",
      "Creating thread for row 483...\n",
      "Sending message for row 483...\n",
      "Creating run for row 483...\n",
      "Waiting for run to complete for row 483...\n",
      "completed\n",
      "Row 483 processing completed and saved.\n",
      "Processing row 484/725: Is Hydroxychloroquine recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 484...\n",
      "Sending message for row 484...\n",
      "Creating run for row 484...\n",
      "Waiting for run to complete for row 484...\n",
      "completed\n",
      "Row 484 processing completed and saved.\n",
      "Processing row 485/725: Is IACS recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 485...\n",
      "Sending message for row 485...\n",
      "Creating run for row 485...\n",
      "Waiting for run to complete for row 485...\n",
      "completed\n",
      "Row 485 processing completed and saved.\n",
      "Processing row 486/725: Is IL-1 inhibitors recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 486...\n",
      "Sending message for row 486...\n",
      "Creating run for row 486...\n",
      "Waiting for run to complete for row 486...\n",
      "completed\n",
      "Row 486 processing completed and saved.\n",
      "Processing row 487/725: Is IL-1 Receptor Antagonists recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 487...\n",
      "Sending message for row 487...\n",
      "Creating run for row 487...\n",
      "Waiting for run to complete for row 487...\n",
      "completed\n",
      "Row 487 processing completed and saved.\n",
      "Processing row 488/725: Is Imaging recommended for Imaging Diagnosis of  osteoarthritis.\n",
      "Creating thread for row 488...\n",
      "Sending message for row 488...\n",
      "Creating run for row 488...\n",
      "Waiting for run to complete for row 488...\n",
      "completed\n",
      "Row 488 processing completed and saved.\n",
      "Processing row 489/725: Is Individualised treatment recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 489...\n",
      "Sending message for row 489...\n",
      "Creating run for row 489...\n",
      "Waiting for run to complete for row 489...\n",
      "completed\n",
      "Row 489 processing completed and saved.\n",
      "Processing row 490/725: Is Information and education recommended for Education\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 490...\n",
      "Sending message for row 490...\n",
      "Creating run for row 490...\n",
      "Waiting for run to complete for row 490...\n",
      "completed\n",
      "Row 490 processing completed and saved.\n",
      "Processing row 491/725: Is Insoles, braces, tape, splints or supports recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 491...\n",
      "Sending message for row 491...\n",
      "Creating run for row 491...\n",
      "Waiting for run to complete for row 491...\n",
      "completed\n",
      "Row 491 processing completed and saved.\n",
      "Processing row 492/725: Is interferential therapy  recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 492...\n",
      "Sending message for row 492...\n",
      "Creating run for row 492...\n",
      "Waiting for run to complete for row 492...\n",
      "completed\n",
      "Row 492 processing completed and saved.\n",
      "Processing row 493/725: Is Intra-Articular Botulinum Toxin recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 493...\n",
      "Sending message for row 493...\n",
      "Creating run for row 493...\n",
      "Waiting for run to complete for row 493...\n",
      "completed\n",
      "Row 493 processing completed and saved.\n",
      "Processing row 494/725: Is Intra-Articular Hyaluronic Acid recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 494...\n",
      "Sending message for row 494...\n",
      "Creating run for row 494...\n",
      "Waiting for run to complete for row 494...\n",
      "completed\n",
      "Row 494 processing completed and saved.\n",
      "Processing row 495/725: Is Intra-articular treatment recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 495...\n",
      "Sending message for row 495...\n",
      "Creating run for row 495...\n",
      "Waiting for run to complete for row 495...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "completed\n",
      "Row 495 processing completed and saved.\n",
      "Processing row 496/725: Is Iontophoresis recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 496...\n",
      "Sending message for row 496...\n",
      "Creating run for row 496...\n",
      "Waiting for run to complete for row 496...\n",
      "completed\n",
      "Row 496 processing completed and saved.\n",
      "Processing row 497/725: Is kinesio taping recommended for Other Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 497...\n",
      "Sending message for row 497...\n",
      "Creating run for row 497...\n",
      "Waiting for run to complete for row 497...\n",
      "completed\n",
      "Row 497 processing completed and saved.\n",
      "Processing row 498/725: Is \"Land-based exercise is recommendated to improve pain and function, regardless of their age, structural disease severity, functional status or pain levels in the treatment of osteoarthritis\"\n",
      "recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 498...\n",
      "Sending message for row 498...\n",
      "Creating run for row 498...\n",
      "Waiting for run to complete for row 498...\n",
      "completed\n",
      "Row 498 processing completed and saved.\n",
      "Processing row 499/725: Is laser therapy  recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 499...\n",
      "Sending message for row 499...\n",
      "Creating run for row 499...\n",
      "Waiting for run to complete for row 499...\n",
      "completed\n",
      "Row 499 processing completed and saved.\n",
      "Processing row 500/725: Is Lateral wedged insoles recommended for Other Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 500...\n",
      "Sending message for row 500...\n",
      "Creating run for row 500...\n",
      "Waiting for run to complete for row 500...\n",
      "completed\n",
      "Row 500 processing completed and saved.\n",
      "Processing row 501/725: Is Medial wedged insoles recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 501...\n",
      "Sending message for row 501...\n",
      "Creating run for row 501...\n",
      "Waiting for run to complete for row 501...\n",
      "completed\n",
      "Row 501 processing completed and saved.\n",
      "Processing row 502/725: Is Lifestyle changes if needed recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 502...\n",
      "Sending message for row 502...\n",
      "Creating run for row 502...\n",
      "Waiting for run to complete for row 502...\n",
      "completed\n",
      "Row 502 processing completed and saved.\n",
      "Processing row 503/725: Is local cold application (eg ice packs) recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 503...\n",
      "Sending message for row 503...\n",
      "Creating run for row 503...\n",
      "Waiting for run to complete for row 503...\n",
      "completed\n",
      "Row 503 processing completed and saved.\n",
      "Processing row 504/725: Is local heat therapy (eg hot packs) as a self-management home strategy recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 504...\n",
      "Sending message for row 504...\n",
      "Creating run for row 504...\n",
      "Waiting for run to complete for row 504...\n",
      "completed\n",
      "Row 504 processing completed and saved.\n",
      "Processing row 505/725: Is manual therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 505...\n",
      "Sending message for row 505...\n",
      "Creating run for row 505...\n",
      "Waiting for run to complete for row 505...\n",
      "completed\n",
      "Row 505 processing completed and saved.\n",
      "Processing row 506/725: Is Manual therapy in addition to an exercise program recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 506...\n",
      "Sending message for row 506...\n",
      "Creating run for row 506...\n",
      "Waiting for run to complete for row 506...\n",
      "completed\n",
      "Row 506 processing completed and saved.\n",
      "Processing row 507/725: Is massage therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 507...\n",
      "Sending message for row 507...\n",
      "Creating run for row 507...\n",
      "Waiting for run to complete for row 507...\n",
      "completed\n",
      "Row 507 processing completed and saved.\n",
      "Processing row 508/725: Is Methotrexate recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 508...\n",
      "Sending message for row 508...\n",
      "Creating run for row 508...\n",
      "Waiting for run to complete for row 508...\n",
      "completed\n",
      "Row 508 processing completed and saved.\n",
      "Processing row 509/725: Is Mind-body Exercise recommended for Exercise\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 509...\n",
      "Sending message for row 509...\n",
      "Creating run for row 509...\n",
      "Waiting for run to complete for row 509...\n",
      "completed\n",
      "Row 509 processing completed and saved.\n",
      "Processing row 510/725: Is modified shoes recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 510...\n",
      "Sending message for row 510...\n",
      "Creating run for row 510...\n",
      "Waiting for run to complete for row 510...\n",
      "completed\n",
      "Row 510 processing completed and saved.\n",
      "Processing row 511/725: Is Neuromuscular electrical stimulation (NMES) recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 511...\n",
      "Sending message for row 511...\n",
      "Creating run for row 511...\n",
      "Waiting for run to complete for row 511...\n",
      "completed\n",
      "Row 511 processing completed and saved.\n",
      "Processing row 512/725: Is Neuromuscular training in combination with traditional exercise recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 512...\n",
      "Sending message for row 512...\n",
      "Creating run for row 512...\n",
      "Waiting for run to complete for row 512...\n",
      "completed\n",
      "Row 512 processing completed and saved.\n",
      "Processing row 513/725: Is Non-selective NSAID and PPI recommended for Treatment of  osteoarthritis.\n",
      "Creating thread for row 513...\n",
      "Sending message for row 513...\n",
      "Creating run for row 513...\n",
      "Waiting for run to complete for row 513...\n",
      "completed\n",
      "Row 513 processing completed and saved.\n",
      "Processing row 514/725: Is Non-selective NSAIDs recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 514...\n",
      "Sending message for row 514...\n",
      "Creating run for row 514...\n",
      "Waiting for run to complete for row 514...\n",
      "completed\n",
      "Row 514 processing completed and saved.\n",
      "Processing row 515/725: Is Non-Tramadol Opioids recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 515...\n",
      "Sending message for row 515...\n",
      "Creating run for row 515...\n",
      "Waiting for run to complete for row 515...\n",
      "completed\n",
      "Row 515 processing completed and saved.\n",
      "Processing row 516/725: Is Electrotherapy treatments recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 516...\n",
      "Sending message for row 516...\n",
      "Creating run for row 516...\n",
      "Waiting for run to complete for row 516...\n",
      "completed\n",
      "Row 516 processing completed and saved.\n",
      "Processing row 517/725: Is omega-3 fatty acids recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 517...\n",
      "Sending message for row 517...\n",
      "Creating run for row 517...\n",
      "Waiting for run to complete for row 517...\n",
      "completed\n",
      "Row 517 processing completed and saved.\n",
      "Processing row 518/725: Is Oral acetaminophen  recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 518...\n",
      "Sending message for row 518...\n",
      "Creating run for row 518...\n",
      "Waiting for run to complete for row 518...\n",
      "completed\n",
      "Row 518 processing completed and saved.\n",
      "Processing row 519/725: Is Oral narcotics, including tramadol recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 519...\n",
      "Sending message for row 519...\n",
      "Creating run for row 519...\n",
      "Waiting for run to complete for row 519...\n",
      "completed\n",
      "Row 519 processing completed and saved.\n",
      "Processing row 520/725: Is Oral nonsteroidal antiinflammatory drugs recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 520...\n",
      "Sending message for row 520...\n",
      "Creating run for row 520...\n",
      "Waiting for run to complete for row 520...\n",
      "completed\n",
      "Row 520 processing completed and saved.\n",
      "Processing row 521/725: Is oral NSAIDs recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 521...\n",
      "Sending message for row 521...\n",
      "Creating run for row 521...\n",
      "Waiting for run to complete for row 521...\n",
      "completed\n",
      "Row 521 processing completed and saved.\n",
      "Processing row 522/725: Is Oral opioids recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 522...\n",
      "Sending message for row 522...\n",
      "Creating run for row 522...\n",
      "Waiting for run to complete for row 522...\n",
      "completed\n",
      "Row 522 processing completed and saved.\n",
      "Processing row 523/725: Is Paraffin recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 523...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sending message for row 523...\n",
      "Creating run for row 523...\n",
      "Waiting for run to complete for row 523...\n",
      "completed\n",
      "Row 523 processing completed and saved.\n",
      "Processing row 524/725: Is Patellofemoral knee braces recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 524...\n",
      "Sending message for row 524...\n",
      "Creating run for row 524...\n",
      "Waiting for run to complete for row 524...\n",
      "completed\n",
      "Row 524 processing completed and saved.\n",
      "Processing row 525/725: Is Patient education programs recommended for Education Treatment of knee osteoarthritis.\n",
      "Creating thread for row 525...\n",
      "Sending message for row 525...\n",
      "Creating run for row 525...\n",
      "Waiting for run to complete for row 525...\n",
      "completed\n",
      "Row 525 processing completed and saved.\n",
      "Processing row 526/725: Is Patient-initiated follow-up recommended for Follow-up Treatment of osteoarthritis.\n",
      "Creating thread for row 526...\n",
      "Sending message for row 526...\n",
      "Creating run for row 526...\n",
      "Waiting for run to complete for row 526...\n",
      "completed\n",
      "Row 526 processing completed and saved.\n",
      "Processing row 527/725: Is Percutaneous Electrical Nerve Stimulation recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 527...\n",
      "Sending message for row 527...\n",
      "Creating run for row 527...\n",
      "Waiting for run to complete for row 527...\n",
      "completed\n",
      "Row 527 processing completed and saved.\n",
      "Processing row 528/725: Is \"pharmacological treatments alongside non-pharmacological treatments and to support therapeutic exercise；at the lowest effective dose for the shortest possible time\" recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 528...\n",
      "Sending message for row 528...\n",
      "Creating run for row 528...\n",
      "Waiting for run to complete for row 528...\n",
      "completed\n",
      "Row 528 processing completed and saved.\n",
      "Processing row 529/725: Is Planned follow-up for people with osteoarthritis recommended for Follow-up Treatment of  osteoarthritis.\n",
      "Creating thread for row 529...\n",
      "Sending message for row 529...\n",
      "Creating run for row 529...\n",
      "Waiting for run to complete for row 529...\n",
      "completed\n",
      "Row 529 processing completed and saved.\n",
      "Processing row 530/725: Is Platelet rich plasma(PRP) recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 530...\n",
      "Sending message for row 530...\n",
      "Creating run for row 530...\n",
      "Waiting for run to complete for row 530...\n",
      "completed\n",
      "Row 530 processing completed and saved.\n",
      "Processing row 531/725: Is Prolotherapy recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 531...\n",
      "Sending message for row 531...\n",
      "Creating run for row 531...\n",
      "Waiting for run to complete for row 531...\n",
      "completed\n",
      "Row 531 processing completed and saved.\n",
      "Processing row 532/725: Is Provide accesible information tailor to their individual needs  recommended for Education Treatment of  osteoarthritis.\n",
      "Creating thread for row 532...\n",
      "Sending message for row 532...\n",
      "Creating run for row 532...\n",
      "Waiting for run to complete for row 532...\n",
      "completed\n",
      "Row 532 processing completed and saved.\n",
      "Processing row 533/725: Is Pulsed Electromagnetic Field Therapy recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 533...\n",
      "Sending message for row 533...\n",
      "Creating run for row 533...\n",
      "Waiting for run to complete for row 533...\n",
      "completed\n",
      "Row 533 processing completed and saved.\n",
      "Processing row 534/725: Is pulsed short-wave therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 534...\n",
      "Sending message for row 534...\n",
      "Creating run for row 534...\n",
      "Waiting for run to complete for row 534...\n",
      "completed\n",
      "Row 534 processing completed and saved.\n",
      "Processing row 535/725: Is pulsed vibration therapy recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 535...\n",
      "Sending message for row 535...\n",
      "Creating run for row 535...\n",
      "Waiting for run to complete for row 535...\n",
      "completed\n",
      "Row 535 processing completed and saved.\n",
      "Processing row 536/725: Is Radiofrequency ablation recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 536...\n",
      "Sending message for row 536...\n",
      "Creating run for row 536...\n",
      "Waiting for run to complete for row 536...\n",
      "completed\n",
      "Row 536 processing completed and saved.\n",
      "Processing row 537/725: Is realigning patellofemoral braces recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 537...\n",
      "Sending message for row 537...\n",
      "Creating run for row 537...\n",
      "Waiting for run to complete for row 537...\n",
      "completed\n",
      "Row 537 processing completed and saved.\n",
      "Processing row 538/725: Is Regular individualised (daily) exercise regimen recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 538...\n",
      "Sending message for row 538...\n",
      "Creating run for row 538...\n",
      "Waiting for run to complete for row 538...\n",
      "completed\n",
      "Row 538 processing completed and saved.\n",
      "Processing row 539/725: Is Routine hyaluronic acid intra-articular injection recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 539...\n",
      "Sending message for row 539...\n",
      "Creating run for row 539...\n",
      "Waiting for run to complete for row 539...\n",
      "completed\n",
      "Row 539 processing completed and saved.\n",
      "Processing row 540/725: Is Routine imaging in follow up recommended for Imaging Assessment of  osteoarthritis.\n",
      "Creating thread for row 540...\n",
      "Sending message for row 540...\n",
      "Creating run for row 540...\n",
      "Waiting for run to complete for row 540...\n",
      "completed\n",
      "Row 540 processing completed and saved.\n",
      "Processing row 541/725: Is Routine intra-articular hyaluronan injections recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 541...\n",
      "Sending message for row 541...\n",
      "Creating run for row 541...\n",
      "Waiting for run to complete for row 541...\n",
      "completed\n",
      "Row 541 processing completed and saved.\n",
      "Processing row 542/725: Is routine paracetamol recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 542...\n",
      "Sending message for row 542...\n",
      "Creating run for row 542...\n",
      "Waiting for run to complete for row 542...\n",
      "completed\n",
      "Row 542 processing completed and saved.\n",
      "Processing row 543/725: Is routine weak opioids recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 543...\n",
      "Sending message for row 543...\n",
      "Creating run for row 543...\n",
      "Waiting for run to complete for row 543...\n",
      "completed\n",
      "Row 543 processing completed and saved.\n",
      "Processing row 544/725: Is Sefl-management programs recommended for Other\n",
      "Education Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 544...\n",
      "Sending message for row 544...\n",
      "Creating run for row 544...\n",
      "Waiting for run to complete for row 544...\n",
      "completed\n",
      "Row 544 processing completed and saved.\n",
      "Processing row 545/725: Is short course of manual therapy (stretching, soft tissue and/or joint mobilisation and/or manipulation) recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 545...\n",
      "Sending message for row 545...\n",
      "Creating run for row 545...\n",
      "Waiting for run to complete for row 545...\n",
      "completed\n",
      "Row 545 processing completed and saved.\n",
      "Processing row 546/725: Is Stationary cycling and/or Hatha yoga recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 546...\n",
      "Sending message for row 546...\n",
      "Creating run for row 546...\n",
      "Waiting for run to complete for row 546...\n",
      "completed\n",
      "Row 546 processing completed and saved.\n",
      "Processing row 547/725: Is Stem Cell Injection recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 547...\n",
      "Sending message for row 547...\n",
      "Creating run for row 547...\n",
      "Waiting for run to complete for row 547...\n",
      "completed\n",
      "Row 547 processing completed and saved.\n",
      "Processing row 548/725: Is strong opioids recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 548...\n",
      "Sending message for row 548...\n",
      "Creating run for row 548...\n",
      "Waiting for run to complete for row 548...\n",
      "completed\n",
      "Row 548 processing completed and saved.\n",
      "Processing row 549/725: Is strontium ranelate recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 549...\n",
      "Sending message for row 549...\n",
      "Creating run for row 549...\n",
      "Waiting for run to complete for row 549...\n",
      "completed\n",
      "Row 549 processing completed and saved.\n",
      "Processing row 550/725: Is Structured Land-Based Exercise Programs recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 550...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sending message for row 550...\n",
      "Creating run for row 550...\n",
      "Waiting for run to complete for row 550...\n",
      "completed\n",
      "Row 550 processing completed and saved.\n",
      "Processing row 551/725: Is Supervised therapeutic exercise sessions recommended for Exercise Treatment of  osteoarthritis.\n",
      "Creating thread for row 551...\n",
      "Sending message for row 551...\n",
      "Creating run for row 551...\n",
      "Waiting for run to complete for row 551...\n",
      "completed\n",
      "Row 551 processing completed and saved.\n",
      "Processing row 552/725: Is Sustained weight loss recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 552...\n",
      "Sending message for row 552...\n",
      "Creating run for row 552...\n",
      "Waiting for run to complete for row 552...\n",
      "completed\n",
      "Row 552 processing completed and saved.\n",
      "Processing row 553/725: Is Tai chi recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 553...\n",
      "Sending message for row 553...\n",
      "Creating run for row 553...\n",
      "Waiting for run to complete for row 553...\n",
      "completed\n",
      "Row 553 processing completed and saved.\n",
      "Processing row 554/725: Is TENS that can be used at home recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 554...\n",
      "Sending message for row 554...\n",
      "Creating run for row 554...\n",
      "Waiting for run to complete for row 554...\n",
      "completed\n",
      "Row 554 processing completed and saved.\n",
      "Processing row 555/725: Is The use of appropriate and comfortable shoes recommended  for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 555...\n",
      "Sending message for row 555...\n",
      "Creating run for row 555...\n",
      "Waiting for run to complete for row 555...\n",
      "completed\n",
      "Row 555 processing completed and saved.\n",
      "Processing row 556/725: Is therapeutic ultrasound recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 556...\n",
      "Sending message for row 556...\n",
      "Creating run for row 556...\n",
      "Waiting for run to complete for row 556...\n",
      "completed\n",
      "Row 556 processing completed and saved.\n",
      "Processing row 557/725: Is Tibiofemoral knee braces recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 557...\n",
      "Sending message for row 557...\n",
      "Creating run for row 557...\n",
      "Waiting for run to complete for row 557...\n",
      "completed\n",
      "Row 557 processing completed and saved.\n",
      "Processing row 558/725: Is TNF Inhibitors recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 558...\n",
      "Sending message for row 558...\n",
      "Creating run for row 558...\n",
      "Waiting for run to complete for row 558...\n",
      "completed\n",
      "Row 558 processing completed and saved.\n",
      "Processing row 559/725: Is Topical Capsaicin recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 559...\n",
      "Sending message for row 559...\n",
      "Creating run for row 559...\n",
      "Waiting for run to complete for row 559...\n",
      "completed\n",
      "Row 559 processing completed and saved.\n",
      "Processing row 560/725: Is Topical nonsteroidal antiinflammatory drugs (Topical NSAIDs)\n",
      "recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 560...\n",
      "Sending message for row 560...\n",
      "Creating run for row 560...\n",
      "Waiting for run to complete for row 560...\n",
      "completed\n",
      "Row 560 processing completed and saved.\n",
      "Processing row 561/725: Is Tramadol recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 561...\n",
      "Sending message for row 561...\n",
      "Creating run for row 561...\n",
      "Waiting for run to complete for row 561...\n",
      "completed\n",
      "Row 561 processing completed and saved.\n",
      "Processing row 562/725: Is transcutaneous electrical nerve stimulation (TENS) \n",
      "recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 562...\n",
      "Sending message for row 562...\n",
      "Creating run for row 562...\n",
      "Waiting for run to complete for row 562...\n",
      "completed\n",
      "Row 562 processing completed and saved.\n",
      "Processing row 563/725: Is transdermal opioids recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 563...\n",
      "Sending message for row 563...\n",
      "Creating run for row 563...\n",
      "Waiting for run to complete for row 563...\n",
      "completed\n",
      "Row 563 processing completed and saved.\n",
      "Processing row 564/725: Is Turmeric recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 564...\n",
      "Sending message for row 564...\n",
      "Creating run for row 564...\n",
      "Waiting for run to complete for row 564...\n",
      "completed\n",
      "Row 564 processing completed and saved.\n",
      "Processing row 565/725: Is ultrasound therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 565...\n",
      "Sending message for row 565...\n",
      "Creating run for row 565...\n",
      "Waiting for run to complete for row 565...\n",
      "completed\n",
      "Row 565 processing completed and saved.\n",
      "Processing row 566/725: Is Ultrasound-guided intraarticular glucocorticoid injection recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 566...\n",
      "Sending message for row 566...\n",
      "Creating run for row 566...\n",
      "Waiting for run to complete for row 566...\n",
      "completed\n",
      "Row 566 processing completed and saved.\n",
      "Processing row 567/725: Is unloading shoes, minimalist footwear or rocker-sole shoes recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 567...\n",
      "Sending message for row 567...\n",
      "Creating run for row 567...\n",
      "Waiting for run to complete for row 567...\n",
      "completed\n",
      "Row 567 processing completed and saved.\n",
      "Processing row 568/725: Is valgus unloading/realignment braces recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 568...\n",
      "Sending message for row 568...\n",
      "Creating run for row 568...\n",
      "Waiting for run to complete for row 568...\n",
      "completed\n",
      "Row 568 processing completed and saved.\n",
      "Processing row 569/725: Is viscosupplementation injection recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 569...\n",
      "Sending message for row 569...\n",
      "Creating run for row 569...\n",
      "Waiting for run to complete for row 569...\n",
      "completed\n",
      "Row 569 processing completed and saved.\n",
      "Processing row 570/725: Is Vitamin D recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 570...\n",
      "Sending message for row 570...\n",
      "Creating run for row 570...\n",
      "Waiting for run to complete for row 570...\n",
      "completed\n",
      "Row 570 processing completed and saved.\n",
      "Processing row 571/725: Is Vocational rehabilitation recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 571...\n",
      "Sending message for row 571...\n",
      "Creating run for row 571...\n",
      "Waiting for run to complete for row 571...\n",
      "completed\n",
      "Row 571 processing completed and saved.\n",
      "Processing row 572/725: Is walking aids (such as walking sticks) recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 572...\n",
      "Sending message for row 572...\n",
      "Creating run for row 572...\n",
      "Waiting for run to complete for row 572...\n",
      "completed\n",
      "Row 572 processing completed and saved.\n",
      "Processing row 573/725: Is Walking aids, assistive technology and adaptations at home and/or at work recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 573...\n",
      "Sending message for row 573...\n",
      "Creating run for row 573...\n",
      "Waiting for run to complete for row 573...\n",
      "completed\n",
      "Row 573 processing completed and saved.\n",
      "Processing row 574/725: Is Walking recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 574...\n",
      "Sending message for row 574...\n",
      "Creating run for row 574...\n",
      "Waiting for run to complete for row 574...\n",
      "completed\n",
      "Row 574 processing completed and saved.\n",
      "Processing row 575/725: Is Muscle-strengthening exercise recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 575...\n",
      "Sending message for row 575...\n",
      "Creating run for row 575...\n",
      "Waiting for run to complete for row 575...\n",
      "completed\n",
      "Row 575 processing completed and saved.\n",
      "Processing row 576/725: Is Tai Chi recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 576...\n",
      "Sending message for row 576...\n",
      "Creating run for row 576...\n",
      "Waiting for run to complete for row 576...\n",
      "completed\n",
      "Row 576 processing completed and saved.\n",
      "Processing row 577/725: Is wedged insoles recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 577...\n",
      "Sending message for row 577...\n",
      "Creating run for row 577...\n",
      "Waiting for run to complete for row 577...\n",
      "completed\n",
      "Row 577 processing completed and saved.\n",
      "Processing row 578/725: Is Weight loss recommended for Other Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 578...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sending message for row 578...\n",
      "Creating run for row 578...\n",
      "Waiting for run to complete for row 578...\n",
      "completed\n",
      "Row 578 processing completed and saved.\n",
      "Processing row 579/725: Is weight management plus exercise recommended for Exercise\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 579...\n",
      "Sending message for row 579...\n",
      "Creating run for row 579...\n",
      "Waiting for run to complete for row 579...\n",
      "completed\n",
      "Row 579 processing completed and saved.\n",
      "Processing row 580/725: Is Yoga recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 580...\n",
      "Sending message for row 580...\n",
      "Creating run for row 580...\n",
      "Waiting for run to complete for row 580...\n",
      "completed\n",
      "Row 580 processing completed and saved.\n",
      "Processing row 581/725: Is  Cognitive Behavioral Therapy with Exercise recommended for Other Treatment of Knee osteoarthritis.\n",
      "Creating thread for row 581...\n",
      "Sending message for row 581...\n",
      "Creating run for row 581...\n",
      "Waiting for run to complete for row 581...\n",
      "completed\n",
      "Row 581 processing completed and saved.\n",
      "Processing row 582/725: Is Education on weight loss recommended for treatment of osteoarthritis.\n",
      "Creating thread for row 582...\n",
      "Sending message for row 582...\n",
      "Creating run for row 582...\n",
      "Waiting for run to complete for row 582...\n",
      "completed\n",
      "Row 582 processing completed and saved.\n",
      "Processing row 583/725: Is intra-articular corticosteroids (IACS) and intra-articular hyaluronan (IAHA) recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 583...\n",
      "Sending message for row 583...\n",
      "Creating run for row 583...\n",
      "Waiting for run to complete for row 583...\n",
      "completed\n",
      "Row 583 processing completed and saved.\n",
      "Processing row 584/725: Is Acetaminophen recommended for Pharmacologic treatment of osteoarthritis.\n",
      "Creating thread for row 584...\n",
      "Sending message for row 584...\n",
      "Creating run for row 584...\n",
      "Waiting for run to complete for row 584...\n",
      "completed\n",
      "Row 584 processing completed and saved.\n",
      "Processing row 585/725: Is Acupuncture (ie traditional, laser, electrical) recommended for Physical  Treatment of osteoarthritis.\n",
      "Creating thread for row 585...\n",
      "Sending message for row 585...\n",
      "Creating run for row 585...\n",
      "Waiting for run to complete for row 585...\n",
      "completed\n",
      "Row 585 processing completed and saved.\n",
      "Processing row 586/725: Is \"Advise people with osteoarthritis that joint pain may increase when they start therapeutic exercise\" recommended for Education Treatment of  osteoarthritis.\n",
      "Creating thread for row 586...\n",
      "Sending message for row 586...\n",
      "Creating run for row 586...\n",
      "Waiting for run to complete for row 586...\n",
      "completed\n",
      "Row 586 processing completed and saved.\n",
      "Processing row 587/725: Is \"Advise people with osteoarthritis where they can find further information\" recommended for Education Treatment of  osteoarthritis.\n",
      "Creating thread for row 587...\n",
      "Sending message for row 587...\n",
      "Creating run for row 587...\n",
      "Waiting for run to complete for row 587...\n",
      "completed\n",
      "Row 587 processing completed and saved.\n",
      "Processing row 588/725: Is Anti-NGF recommended for Pharmacologic Treatment\n",
      " of  osteoarthritis.\n",
      "Creating thread for row 588...\n",
      "Sending message for row 588...\n",
      "Creating run for row 588...\n",
      "Waiting for run to complete for row 588...\n",
      "completed\n",
      "Row 588 processing completed and saved.\n",
      "Processing row 589/725: Is Aquatic exercise/Hydrotherapy recommended for Exercise\n",
      "Treatment of  osteoarthritis.\n",
      "Creating thread for row 589...\n",
      "Sending message for row 589...\n",
      "Creating run for row 589...\n",
      "Waiting for run to complete for row 589...\n",
      "completed\n",
      "Row 589 processing completed and saved.\n",
      "Processing row 590/725: Is Arthritis Education recommended for OtherTreatment of osteoarthritis.\n",
      "Creating thread for row 590...\n",
      "Sending message for row 590...\n",
      "Creating run for row 590...\n",
      "Waiting for run to complete for row 590...\n",
      "completed\n",
      "Row 590 processing completed and saved.\n",
      "Processing row 591/725: Is Arthroscopic lavage or debridement,\n",
      "Arthroscopic partial meniscectomy,\n",
      "Arthroscopy with lavage and/or debridement recommended for \n",
      "Surgery Treatment of osteoarthritis.\n",
      "Creating thread for row 591...\n",
      "Sending message for row 591...\n",
      "Creating run for row 591...\n",
      "Waiting for run to complete for row 591...\n",
      "completed\n",
      "Row 591 processing completed and saved.\n",
      "Processing row 592/725: Is assistive walking device (eg cane) recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 592...\n",
      "Sending message for row 592...\n",
      "Creating run for row 592...\n",
      "Waiting for run to complete for row 592...\n",
      "completed\n",
      "Row 592 processing completed and saved.\n",
      "Processing row 593/725: Is Balance training recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 593...\n",
      "Sending message for row 593...\n",
      "Creating run for row 593...\n",
      "Waiting for run to complete for row 593...\n",
      "completed\n",
      "Row 593 processing completed and saved.\n",
      "Processing row 594/725: Is Biopsychosocial initial assessments recommended for \n",
      " Assessment of osteoarthritis.\n",
      "Creating thread for row 594...\n",
      "Sending message for row 594...\n",
      "Creating run for row 594...\n",
      "Waiting for run to complete for row 594...\n",
      "completed\n",
      "Row 594 processing completed and saved.\n",
      "Processing row 595/725: Is bisphosphonates recommended for Pharmacologic Treatment\n",
      " of  osteoarthritis.\n",
      "Creating thread for row 595...\n",
      "Sending message for row 595...\n",
      "Creating run for row 595...\n",
      "Waiting for run to complete for row 595...\n",
      "completed\n",
      "Row 595 processing completed and saved.\n",
      "Processing row 596/725: Is Brace treatment recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 596...\n",
      "Sending message for row 596...\n",
      "Creating run for row 596...\n",
      "Waiting for run to complete for row 596...\n",
      "completed\n",
      "Row 596 processing completed and saved.\n",
      "Processing row 597/725: Is calcitonin recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 597...\n",
      "Sending message for row 597...\n",
      "Creating run for row 597...\n",
      "Waiting for run to complete for row 597...\n",
      "completed\n",
      "Row 597 processing completed and saved.\n",
      "Processing row 598/725: Is Cane recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 598...\n",
      "Sending message for row 598...\n",
      "Creating run for row 598...\n",
      "Waiting for run to complete for row 598...\n",
      "completed\n",
      "Row 598 processing completed and saved.\n",
      "Processing row 599/725: Is Chondroitin recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 599...\n",
      "Sending message for row 599...\n",
      "Creating run for row 599...\n",
      "Waiting for run to complete for row 599...\n",
      "completed\n",
      "Row 599 processing completed and saved.\n",
      "Processing row 600/725: Is Cognitive behavioral therapy (CBT) recommended for Other Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 600...\n",
      "Sending message for row 600...\n",
      "Creating run for row 600...\n",
      "Waiting for run to complete for row 600...\n",
      "completed\n",
      "Row 600 processing completed and saved.\n",
      "Processing row 601/725: Is Colchicine recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 601...\n",
      "Sending message for row 601...\n",
      "Creating run for row 601...\n",
      "Waiting for run to complete for row 601...\n",
      "completed\n",
      "Row 601 processing completed and saved.\n",
      "Processing row 602/725: Is Combining therapeutic exercise with an education programme or behaviour change approaches in a structured treatment package recommended for Exercise Treatment of  osteoarthritis.\n",
      "Creating thread for row 602...\n",
      "Sending message for row 602...\n",
      "Creating run for row 602...\n",
      "Waiting for run to complete for row 602...\n",
      "completed\n",
      "Row 602 processing completed and saved.\n",
      "Processing row 603/725: Is Comprehensive management plan recommended for Other\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 603...\n",
      "Sending message for row 603...\n",
      "Creating run for row 603...\n",
      "Waiting for run to complete for row 603...\n",
      "completed\n",
      "Row 603 processing completed and saved.\n",
      "Processing row 604/725: Is \"Consider referring people with hip, knee or shoulder osteoarthritis for joint replacement if:\n",
      "• their joint symptoms (such as pain, stiffness, reduced function or progressive joint deformity) are substantially impacting their quality of life and \n",
      "• non-surgical management (for example, therapeutic exercise, weight loss, pain relief) is ineffective or unsuitable.\n",
      "Consider referring people with hip, knee or shoulder osteoarthritis for joint replacement if:\n",
      "• their joint symptoms (such as pain, stiffness, reduced function or progressive joint deformity) are substantially impacting their quality of life and \n",
      "• non-surgical management (for example, therapeutic exercise, weight loss, pain relief) is ineffective or unsuitable.\n",
      "Consider referring people with hip, knee or shoulder osteoarthritis for joint replacement if:\n",
      "• their joint symptoms (such as pain, stiffness, reduced function or progressive joint deformity) are substantially impacting their quality of life and \n",
      "• non-surgical management (for example, therapeutic exercise, weight loss, pain relief) is ineffective or unsuitable\" recommended for Surgery\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 604...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sending message for row 604...\n",
      "Creating run for row 604...\n",
      "Waiting for run to complete for row 604...\n",
      "completed\n",
      "Row 604 processing completed and saved.\n",
      "Processing row 605/725: Is COX-2 Inhibitors recommended for Pharmacologic Treatment\n",
      "of  osteoarthritis.\n",
      "Creating thread for row 605...\n",
      "Sending message for row 605...\n",
      "Creating run for row 605...\n",
      "Waiting for run to complete for row 605...\n",
      "completed\n",
      "Row 605 processing completed and saved.\n",
      "Processing row 606/725: Is Denervation therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 606...\n",
      "Sending message for row 606...\n",
      "Creating run for row 606...\n",
      "Waiting for run to complete for row 606...\n",
      "completed\n",
      "Row 606 processing completed and saved.\n",
      "Processing row 607/725: Is dextrose prolotherapy recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 607...\n",
      "Sending message for row 607...\n",
      "Creating run for row 607...\n",
      "Waiting for run to complete for row 607...\n",
      "completed\n",
      "Row 607 processing completed and saved.\n",
      "Processing row 608/725: Is diacerein recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 608...\n",
      "Sending message for row 608...\n",
      "Creating run for row 608...\n",
      "Waiting for run to complete for row 608...\n",
      "completed\n",
      "Row 608 processing completed and saved.\n",
      "Processing row 609/725: Is doxycycline recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 609...\n",
      "Sending message for row 609...\n",
      "Creating run for row 609...\n",
      "Waiting for run to complete for row 609...\n",
      "completed\n",
      "Row 609 processing completed and saved.\n",
      "Processing row 610/725: Is Dry needling recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 610...\n",
      "Sending message for row 610...\n",
      "Creating run for row 610...\n",
      "Waiting for run to complete for row 610...\n",
      "completed\n",
      "Row 610 processing completed and saved.\n",
      "Processing row 611/725: Is Duloxetine recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 611...\n",
      "Sending message for row 611...\n",
      "Creating run for row 611...\n",
      "Waiting for run to complete for row 611...\n",
      "completed\n",
      "Row 611 processing completed and saved.\n",
      "Processing row 612/725: Is electrotherapy modalities of shockwave, interferential or laser\n",
      "recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 612...\n",
      "Sending message for row 612...\n",
      "Creating run for row 612...\n",
      "Waiting for run to complete for row 612...\n",
      "completed\n",
      "Row 612 processing completed and saved.\n",
      "Processing row 613/725: Is Exercise recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 613...\n",
      "Sending message for row 613...\n",
      "Creating run for row 613...\n",
      "Waiting for run to complete for row 613...\n",
      "completed\n",
      "Row 613 processing completed and saved.\n",
      "Processing row 614/725: Is Exercise education recommended for Education Treatment of  osteoarthritis.\n",
      "Creating thread for row 614...\n",
      "Sending message for row 614...\n",
      "Creating run for row 614...\n",
      "Waiting for run to complete for row 614...\n",
      "completed\n",
      "Row 614 processing completed and saved.\n",
      "Processing row 615/725: Is Exercise tailored to patient's need recommended for Exercise Treatment of  osteoarthritis.\n",
      "Creating thread for row 615...\n",
      "Sending message for row 615...\n",
      "Creating run for row 615...\n",
      "Waiting for run to complete for row 615...\n",
      "completed\n",
      "Row 615 processing completed and saved.\n",
      "Processing row 616/725: Is \"Explain to patients what osteoarthritis is\" recommended for Education Treatment of  osteoarthritis. \n",
      "Creating thread for row 616...\n",
      "Sending message for row 616...\n",
      "Creating run for row 616...\n",
      "Waiting for run to complete for row 616...\n",
      "completed\n",
      "Row 616 processing completed and saved.\n",
      "Processing row 617/725: Is Extracorporeal shockwave therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 617...\n",
      "Sending message for row 617...\n",
      "Creating run for row 617...\n",
      "Waiting for run to complete for row 617...\n",
      "completed\n",
      "Row 617 processing completed and saved.\n",
      "Processing row 618/725: Is FGF recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 618...\n",
      "Sending message for row 618...\n",
      "Creating run for row 618...\n",
      "Waiting for run to complete for row 618...\n",
      "completed\n",
      "Row 618 processing completed and saved.\n",
      "Processing row 619/725: Is Fish Oil recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 619...\n",
      "Sending message for row 619...\n",
      "Creating run for row 619...\n",
      "Waiting for run to complete for row 619...\n",
      "completed\n",
      "Row 619 processing completed and saved.\n",
      "Processing row 620/725: Is \"For those who are overweight (BMI ≥25 kg/m2) or obese (BMI ≥30 kg/m2), a minimum weight loss target of 5–7.5% of body weight\"recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 620...\n",
      "Sending message for row 620...\n",
      "Creating run for row 620...\n",
      "Waiting for run to complete for row 620...\n",
      "completed\n",
      "Row 620 processing completed and saved.\n",
      "Processing row 621/725: Is Free-floating (un-fixed) interpositional devices  recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 621...\n",
      "Sending message for row 621...\n",
      "Creating run for row 621...\n",
      "Waiting for run to complete for row 621...\n",
      "completed\n",
      "Row 621 processing completed and saved.\n",
      "Processing row 622/725: Is Gait Aids recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 622...\n",
      "Sending message for row 622...\n",
      "Creating run for row 622...\n",
      "Waiting for run to complete for row 622...\n",
      "completed\n",
      "Row 622 processing completed and saved.\n",
      "Processing row 623/725: Is gastroprotective treatment (such as a proton pump inhibitor) while taking NSAIDs recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 623...\n",
      "Sending message for row 623...\n",
      "Creating run for row 623...\n",
      "Waiting for run to complete for row 623...\n",
      "completed\n",
      "Row 623 processing completed and saved.\n",
      "Processing row 624/725: Is Ginger extract recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 624...\n",
      "Sending message for row 624...\n",
      "Creating run for row 624...\n",
      "Waiting for run to complete for row 624...\n",
      "completed\n",
      "Row 624 processing completed and saved.\n",
      "Processing row 625/725: Is Glucosamine recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 625...\n",
      "Sending message for row 625...\n",
      "Creating run for row 625...\n",
      "Waiting for run to complete for row 625...\n",
      "completed\n",
      "Row 625 processing completed and saved.\n",
      "Processing row 626/725: Is glucosamine and chondroitin in compound for recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 626...\n",
      "Sending message for row 626...\n",
      "Creating run for row 626...\n",
      "Waiting for run to complete for row 626...\n",
      "completed\n",
      "Row 626 processing completed and saved.\n",
      "Processing row 627/725: Is Hand Orthosis recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 627...\n",
      "Sending message for row 627...\n",
      "Creating run for row 627...\n",
      "Waiting for run to complete for row 627...\n",
      "completed\n",
      "Row 627 processing completed and saved.\n",
      "Processing row 628/725: Is High tibial osteotomy recommended for Surgery Treatment of  osteoarthritis.\n",
      "Creating thread for row 628...\n",
      "Sending message for row 628...\n",
      "Creating run for row 628...\n",
      "Waiting for run to complete for row 628...\n",
      "completed\n",
      "Row 628 processing completed and saved.\n",
      "Processing row 629/725: Is Hydroxychloroquine recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 629...\n",
      "Sending message for row 629...\n",
      "Creating run for row 629...\n",
      "Waiting for run to complete for row 629...\n",
      "completed\n",
      "Row 629 processing completed and saved.\n",
      "Processing row 630/725: Is IACS recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 630...\n",
      "Sending message for row 630...\n",
      "Creating run for row 630...\n",
      "Waiting for run to complete for row 630...\n",
      "completed\n",
      "Row 630 processing completed and saved.\n",
      "Processing row 631/725: Is IL-1 inhibitors recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 631...\n",
      "Sending message for row 631...\n",
      "Creating run for row 631...\n",
      "Waiting for run to complete for row 631...\n",
      "completed\n",
      "Row 631 processing completed and saved.\n",
      "Processing row 632/725: Is IL-1 Receptor Antagonists recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 632...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sending message for row 632...\n",
      "Creating run for row 632...\n",
      "Waiting for run to complete for row 632...\n",
      "completed\n",
      "Row 632 processing completed and saved.\n",
      "Processing row 633/725: Is Imaging recommended for Imaging Diagnosis of  osteoarthritis.\n",
      "Creating thread for row 633...\n",
      "Sending message for row 633...\n",
      "Creating run for row 633...\n",
      "Waiting for run to complete for row 633...\n",
      "completed\n",
      "Row 633 processing completed and saved.\n",
      "Processing row 634/725: Is Individualised treatment recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 634...\n",
      "Sending message for row 634...\n",
      "Creating run for row 634...\n",
      "Waiting for run to complete for row 634...\n",
      "completed\n",
      "Row 634 processing completed and saved.\n",
      "Processing row 635/725: Is Information and education recommended for Education\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 635...\n",
      "Sending message for row 635...\n",
      "Creating run for row 635...\n",
      "Waiting for run to complete for row 635...\n",
      "completed\n",
      "Row 635 processing completed and saved.\n",
      "Processing row 636/725: Is Insoles, braces, tape, splints or supports recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 636...\n",
      "Sending message for row 636...\n",
      "Creating run for row 636...\n",
      "Waiting for run to complete for row 636...\n",
      "completed\n",
      "Row 636 processing completed and saved.\n",
      "Processing row 637/725: Is interferential therapy  recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 637...\n",
      "Sending message for row 637...\n",
      "Creating run for row 637...\n",
      "Waiting for run to complete for row 637...\n",
      "completed\n",
      "Row 637 processing completed and saved.\n",
      "Processing row 638/725: Is Intra-Articular Botulinum Toxin recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 638...\n",
      "Sending message for row 638...\n",
      "Creating run for row 638...\n",
      "Waiting for run to complete for row 638...\n",
      "completed\n",
      "Row 638 processing completed and saved.\n",
      "Processing row 639/725: Is Intra-Articular Hyaluronic Acid recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 639...\n",
      "Sending message for row 639...\n",
      "Creating run for row 639...\n",
      "Waiting for run to complete for row 639...\n",
      "completed\n",
      "Row 639 processing completed and saved.\n",
      "Processing row 640/725: Is Intra-articular treatment recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 640...\n",
      "Sending message for row 640...\n",
      "Creating run for row 640...\n",
      "Waiting for run to complete for row 640...\n",
      "completed\n",
      "Row 640 processing completed and saved.\n",
      "Processing row 641/725: Is Iontophoresis recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 641...\n",
      "Sending message for row 641...\n",
      "Creating run for row 641...\n",
      "Waiting for run to complete for row 641...\n",
      "completed\n",
      "Row 641 processing completed and saved.\n",
      "Processing row 642/725: Is kinesio taping recommended for Other Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 642...\n",
      "Sending message for row 642...\n",
      "Creating run for row 642...\n",
      "Waiting for run to complete for row 642...\n",
      "completed\n",
      "Row 642 processing completed and saved.\n",
      "Processing row 643/725: Is \"Land-based exercise is recommendated to improve pain and function, regardless of their age, structural disease severity, functional status or pain levels in the treatment of osteoarthritis\"\n",
      "recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 643...\n",
      "Sending message for row 643...\n",
      "Creating run for row 643...\n",
      "Waiting for run to complete for row 643...\n",
      "completed\n",
      "Row 643 processing completed and saved.\n",
      "Processing row 644/725: Is laser therapy  recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 644...\n",
      "Sending message for row 644...\n",
      "Creating run for row 644...\n",
      "Waiting for run to complete for row 644...\n",
      "completed\n",
      "Row 644 processing completed and saved.\n",
      "Processing row 645/725: Is Lateral wedged insoles recommended for Other Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 645...\n",
      "Sending message for row 645...\n",
      "Creating run for row 645...\n",
      "Waiting for run to complete for row 645...\n",
      "completed\n",
      "Row 645 processing completed and saved.\n",
      "Processing row 646/725: Is Medial wedged insoles recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 646...\n",
      "Sending message for row 646...\n",
      "Creating run for row 646...\n",
      "Waiting for run to complete for row 646...\n",
      "completed\n",
      "Row 646 processing completed and saved.\n",
      "Processing row 647/725: Is Lifestyle changes if needed recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 647...\n",
      "Sending message for row 647...\n",
      "Creating run for row 647...\n",
      "Waiting for run to complete for row 647...\n",
      "completed\n",
      "Row 647 processing completed and saved.\n",
      "Processing row 648/725: Is local cold application (eg ice packs) recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 648...\n",
      "Sending message for row 648...\n",
      "Creating run for row 648...\n",
      "Waiting for run to complete for row 648...\n",
      "completed\n",
      "Row 648 processing completed and saved.\n",
      "Processing row 649/725: Is local heat therapy (eg hot packs) as a self-management home strategy recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 649...\n",
      "Sending message for row 649...\n",
      "Creating run for row 649...\n",
      "Waiting for run to complete for row 649...\n",
      "completed\n",
      "Row 649 processing completed and saved.\n",
      "Processing row 650/725: Is manual therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 650...\n",
      "Sending message for row 650...\n",
      "Creating run for row 650...\n",
      "Waiting for run to complete for row 650...\n",
      "completed\n",
      "Row 650 processing completed and saved.\n",
      "Processing row 651/725: Is Manual therapy in addition to an exercise program recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 651...\n",
      "Sending message for row 651...\n",
      "Creating run for row 651...\n",
      "Waiting for run to complete for row 651...\n",
      "completed\n",
      "Row 651 processing completed and saved.\n",
      "Processing row 652/725: Is massage therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 652...\n",
      "Sending message for row 652...\n",
      "Creating run for row 652...\n",
      "Waiting for run to complete for row 652...\n",
      "completed\n",
      "Row 652 processing completed and saved.\n",
      "Processing row 653/725: Is Methotrexate recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 653...\n",
      "Sending message for row 653...\n",
      "Creating run for row 653...\n",
      "Waiting for run to complete for row 653...\n",
      "completed\n",
      "Row 653 processing completed and saved.\n",
      "Processing row 654/725: Is Mind-body Exercise recommended for Exercise\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 654...\n",
      "Sending message for row 654...\n",
      "Creating run for row 654...\n",
      "Waiting for run to complete for row 654...\n",
      "completed\n",
      "Row 654 processing completed and saved.\n",
      "Processing row 655/725: Is modified shoes recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 655...\n",
      "Sending message for row 655...\n",
      "Creating run for row 655...\n",
      "Waiting for run to complete for row 655...\n",
      "completed\n",
      "Row 655 processing completed and saved.\n",
      "Processing row 656/725: Is Neuromuscular electrical stimulation (NMES) recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 656...\n",
      "Sending message for row 656...\n",
      "Creating run for row 656...\n",
      "Waiting for run to complete for row 656...\n",
      "completed\n",
      "Row 656 processing completed and saved.\n",
      "Processing row 657/725: Is Neuromuscular training in combination with traditional exercise recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 657...\n",
      "Sending message for row 657...\n",
      "Creating run for row 657...\n",
      "Waiting for run to complete for row 657...\n",
      "completed\n",
      "Row 657 processing completed and saved.\n",
      "Processing row 658/725: Is Non-selective NSAID and PPI recommended for Treatment of  osteoarthritis.\n",
      "Creating thread for row 658...\n",
      "Sending message for row 658...\n",
      "Creating run for row 658...\n",
      "Waiting for run to complete for row 658...\n",
      "completed\n",
      "Row 658 processing completed and saved.\n",
      "Processing row 659/725: Is Non-selective NSAIDs recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 659...\n",
      "Sending message for row 659...\n",
      "Creating run for row 659...\n",
      "Waiting for run to complete for row 659...\n",
      "completed\n",
      "Row 659 processing completed and saved.\n",
      "Processing row 660/725: Is Non-Tramadol Opioids recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 660...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sending message for row 660...\n",
      "Creating run for row 660...\n",
      "Waiting for run to complete for row 660...\n",
      "completed\n",
      "Row 660 processing completed and saved.\n",
      "Processing row 661/725: Is Electrotherapy treatments recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 661...\n",
      "Sending message for row 661...\n",
      "Creating run for row 661...\n",
      "Waiting for run to complete for row 661...\n",
      "completed\n",
      "Row 661 processing completed and saved.\n",
      "Processing row 662/725: Is omega-3 fatty acids recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 662...\n",
      "Sending message for row 662...\n",
      "Creating run for row 662...\n",
      "Waiting for run to complete for row 662...\n",
      "completed\n",
      "Row 662 processing completed and saved.\n",
      "Processing row 663/725: Is Oral acetaminophen  recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 663...\n",
      "Sending message for row 663...\n",
      "Creating run for row 663...\n",
      "Waiting for run to complete for row 663...\n",
      "completed\n",
      "Row 663 processing completed and saved.\n",
      "Processing row 664/725: Is Oral narcotics, including tramadol recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 664...\n",
      "Sending message for row 664...\n",
      "Creating run for row 664...\n",
      "Waiting for run to complete for row 664...\n",
      "completed\n",
      "Row 664 processing completed and saved.\n",
      "Processing row 665/725: Is Oral nonsteroidal antiinflammatory drugs recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 665...\n",
      "Sending message for row 665...\n",
      "Creating run for row 665...\n",
      "Waiting for run to complete for row 665...\n",
      "completed\n",
      "Row 665 processing completed and saved.\n",
      "Processing row 666/725: Is oral NSAIDs recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 666...\n",
      "Sending message for row 666...\n",
      "Creating run for row 666...\n",
      "Waiting for run to complete for row 666...\n",
      "completed\n",
      "Row 666 processing completed and saved.\n",
      "Processing row 667/725: Is Oral opioids recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 667...\n",
      "Sending message for row 667...\n",
      "Creating run for row 667...\n",
      "Waiting for run to complete for row 667...\n",
      "completed\n",
      "Row 667 processing completed and saved.\n",
      "Processing row 668/725: Is Paraffin recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 668...\n",
      "Sending message for row 668...\n",
      "Creating run for row 668...\n",
      "Waiting for run to complete for row 668...\n",
      "completed\n",
      "Row 668 processing completed and saved.\n",
      "Processing row 669/725: Is Patellofemoral knee braces recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 669...\n",
      "Sending message for row 669...\n",
      "Creating run for row 669...\n",
      "Waiting for run to complete for row 669...\n",
      "completed\n",
      "Row 669 processing completed and saved.\n",
      "Processing row 670/725: Is Patient education programs recommended for Education Treatment of knee osteoarthritis.\n",
      "Creating thread for row 670...\n",
      "Sending message for row 670...\n",
      "Creating run for row 670...\n",
      "Waiting for run to complete for row 670...\n",
      "completed\n",
      "Row 670 processing completed and saved.\n",
      "Processing row 671/725: Is Patient-initiated follow-up recommended for Follow-up Treatment of osteoarthritis.\n",
      "Creating thread for row 671...\n",
      "Sending message for row 671...\n",
      "Creating run for row 671...\n",
      "Waiting for run to complete for row 671...\n",
      "completed\n",
      "Row 671 processing completed and saved.\n",
      "Processing row 672/725: Is Percutaneous Electrical Nerve Stimulation recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 672...\n",
      "Sending message for row 672...\n",
      "Creating run for row 672...\n",
      "Waiting for run to complete for row 672...\n",
      "completed\n",
      "Row 672 processing completed and saved.\n",
      "Processing row 673/725: Is \"pharmacological treatments alongside non-pharmacological treatments and to support therapeutic exercise；at the lowest effective dose for the shortest possible time\" recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 673...\n",
      "Sending message for row 673...\n",
      "Creating run for row 673...\n",
      "Waiting for run to complete for row 673...\n",
      "completed\n",
      "Row 673 processing completed and saved.\n",
      "Processing row 674/725: Is Planned follow-up for people with osteoarthritis recommended for Follow-up Treatment of  osteoarthritis.\n",
      "Creating thread for row 674...\n",
      "Sending message for row 674...\n",
      "Creating run for row 674...\n",
      "Waiting for run to complete for row 674...\n",
      "completed\n",
      "Row 674 processing completed and saved.\n",
      "Processing row 675/725: Is Platelet rich plasma(PRP) recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 675...\n",
      "Sending message for row 675...\n",
      "Creating run for row 675...\n",
      "Waiting for run to complete for row 675...\n",
      "completed\n",
      "Row 675 processing completed and saved.\n",
      "Processing row 676/725: Is Prolotherapy recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 676...\n",
      "Sending message for row 676...\n",
      "Creating run for row 676...\n",
      "Waiting for run to complete for row 676...\n",
      "completed\n",
      "Row 676 processing completed and saved.\n",
      "Processing row 677/725: Is Provide accesible information tailor to their individual needs  recommended for Education Treatment of  osteoarthritis.\n",
      "Creating thread for row 677...\n",
      "Sending message for row 677...\n",
      "Creating run for row 677...\n",
      "Waiting for run to complete for row 677...\n",
      "completed\n",
      "Row 677 processing completed and saved.\n",
      "Processing row 678/725: Is Pulsed Electromagnetic Field Therapy recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 678...\n",
      "Sending message for row 678...\n",
      "Creating run for row 678...\n",
      "Waiting for run to complete for row 678...\n",
      "completed\n",
      "Row 678 processing completed and saved.\n",
      "Processing row 679/725: Is pulsed short-wave therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 679...\n",
      "Sending message for row 679...\n",
      "Creating run for row 679...\n",
      "Waiting for run to complete for row 679...\n",
      "completed\n",
      "Row 679 processing completed and saved.\n",
      "Processing row 680/725: Is pulsed vibration therapy recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 680...\n",
      "Sending message for row 680...\n",
      "Creating run for row 680...\n",
      "Waiting for run to complete for row 680...\n",
      "completed\n",
      "Row 680 processing completed and saved.\n",
      "Processing row 681/725: Is Radiofrequency ablation recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 681...\n",
      "Sending message for row 681...\n",
      "Creating run for row 681...\n",
      "Waiting for run to complete for row 681...\n",
      "completed\n",
      "Row 681 processing completed and saved.\n",
      "Processing row 682/725: Is realigning patellofemoral braces recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 682...\n",
      "Sending message for row 682...\n",
      "Creating run for row 682...\n",
      "Waiting for run to complete for row 682...\n",
      "completed\n",
      "Row 682 processing completed and saved.\n",
      "Processing row 683/725: Is Regular individualised (daily) exercise regimen recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 683...\n",
      "Sending message for row 683...\n",
      "Creating run for row 683...\n",
      "Waiting for run to complete for row 683...\n",
      "completed\n",
      "Row 683 processing completed and saved.\n",
      "Processing row 684/725: Is Routine hyaluronic acid intra-articular injection recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 684...\n",
      "Sending message for row 684...\n",
      "Creating run for row 684...\n",
      "Waiting for run to complete for row 684...\n",
      "completed\n",
      "Row 684 processing completed and saved.\n",
      "Processing row 685/725: Is Routine imaging in follow up recommended for Imaging Assessment of  osteoarthritis.\n",
      "Creating thread for row 685...\n",
      "Sending message for row 685...\n",
      "Creating run for row 685...\n",
      "Waiting for run to complete for row 685...\n",
      "completed\n",
      "Row 685 processing completed and saved.\n",
      "Processing row 686/725: Is Routine intra-articular hyaluronan injections recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 686...\n",
      "Sending message for row 686...\n",
      "Creating run for row 686...\n",
      "Waiting for run to complete for row 686...\n",
      "completed\n",
      "Row 686 processing completed and saved.\n",
      "Processing row 687/725: Is routine paracetamol recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 687...\n",
      "Sending message for row 687...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Creating run for row 687...\n",
      "Waiting for run to complete for row 687...\n",
      "completed\n",
      "Row 687 processing completed and saved.\n",
      "Processing row 688/725: Is routine weak opioids recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 688...\n",
      "Sending message for row 688...\n",
      "Creating run for row 688...\n",
      "Waiting for run to complete for row 688...\n",
      "completed\n",
      "Row 688 processing completed and saved.\n",
      "Processing row 689/725: Is Sefl-management programs recommended for Other\n",
      "Education Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 689...\n",
      "Sending message for row 689...\n",
      "Creating run for row 689...\n",
      "Waiting for run to complete for row 689...\n",
      "completed\n",
      "Row 689 processing completed and saved.\n",
      "Processing row 690/725: Is short course of manual therapy (stretching, soft tissue and/or joint mobilisation and/or manipulation) recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 690...\n",
      "Sending message for row 690...\n",
      "Creating run for row 690...\n",
      "Waiting for run to complete for row 690...\n",
      "completed\n",
      "Row 690 processing completed and saved.\n",
      "Processing row 691/725: Is Stationary cycling and/or Hatha yoga recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 691...\n",
      "Sending message for row 691...\n",
      "Creating run for row 691...\n",
      "Waiting for run to complete for row 691...\n",
      "completed\n",
      "Row 691 processing completed and saved.\n",
      "Processing row 692/725: Is Stem Cell Injection recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 692...\n",
      "Sending message for row 692...\n",
      "Creating run for row 692...\n",
      "Waiting for run to complete for row 692...\n",
      "completed\n",
      "Row 692 processing completed and saved.\n",
      "Processing row 693/725: Is strong opioids recommended for Pharmacological Treatment of  osteoarthritis.\n",
      "Creating thread for row 693...\n",
      "Sending message for row 693...\n",
      "Creating run for row 693...\n",
      "Waiting for run to complete for row 693...\n",
      "completed\n",
      "Row 693 processing completed and saved.\n",
      "Processing row 694/725: Is strontium ranelate recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 694...\n",
      "Sending message for row 694...\n",
      "Creating run for row 694...\n",
      "Waiting for run to complete for row 694...\n",
      "completed\n",
      "Row 694 processing completed and saved.\n",
      "Processing row 695/725: Is Structured Land-Based Exercise Programs recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 695...\n",
      "Sending message for row 695...\n",
      "Creating run for row 695...\n",
      "Waiting for run to complete for row 695...\n",
      "completed\n",
      "Row 695 processing completed and saved.\n",
      "Processing row 696/725: Is Supervised therapeutic exercise sessions recommended for Exercise Treatment of  osteoarthritis.\n",
      "Creating thread for row 696...\n",
      "Sending message for row 696...\n",
      "Creating run for row 696...\n",
      "Waiting for run to complete for row 696...\n",
      "completed\n",
      "Row 696 processing completed and saved.\n",
      "Processing row 697/725: Is Sustained weight loss recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 697...\n",
      "Sending message for row 697...\n",
      "Creating run for row 697...\n",
      "Waiting for run to complete for row 697...\n",
      "completed\n",
      "Row 697 processing completed and saved.\n",
      "Processing row 698/725: Is Tai chi recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 698...\n",
      "Sending message for row 698...\n",
      "Creating run for row 698...\n",
      "Waiting for run to complete for row 698...\n",
      "completed\n",
      "Row 698 processing completed and saved.\n",
      "Processing row 699/725: Is TENS that can be used at home recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 699...\n",
      "Sending message for row 699...\n",
      "Creating run for row 699...\n",
      "Waiting for run to complete for row 699...\n",
      "completed\n",
      "Row 699 processing completed and saved.\n",
      "Processing row 700/725: Is The use of appropriate and comfortable shoes recommended  for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 700...\n",
      "Sending message for row 700...\n",
      "Creating run for row 700...\n",
      "Waiting for run to complete for row 700...\n",
      "completed\n",
      "Row 700 processing completed and saved.\n",
      "Processing row 701/725: Is therapeutic ultrasound recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 701...\n",
      "Sending message for row 701...\n",
      "Creating run for row 701...\n",
      "Waiting for run to complete for row 701...\n",
      "completed\n",
      "Row 701 processing completed and saved.\n",
      "Processing row 702/725: Is Tibiofemoral knee braces recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 702...\n",
      "Sending message for row 702...\n",
      "Creating run for row 702...\n",
      "Waiting for run to complete for row 702...\n",
      "completed\n",
      "Row 702 processing completed and saved.\n",
      "Processing row 703/725: Is TNF Inhibitors recommended for Pharmacologic Treatment of  osteoarthritis.\n",
      "Creating thread for row 703...\n",
      "Sending message for row 703...\n",
      "Creating run for row 703...\n",
      "Waiting for run to complete for row 703...\n",
      "completed\n",
      "Row 703 processing completed and saved.\n",
      "Processing row 704/725: Is Topical Capsaicin recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 704...\n",
      "Sending message for row 704...\n",
      "Creating run for row 704...\n",
      "Waiting for run to complete for row 704...\n",
      "completed\n",
      "Row 704 processing completed and saved.\n",
      "Processing row 705/725: Is Topical nonsteroidal antiinflammatory drugs (Topical NSAIDs)\n",
      "recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 705...\n",
      "Sending message for row 705...\n",
      "Creating run for row 705...\n",
      "Waiting for run to complete for row 705...\n",
      "completed\n",
      "Row 705 processing completed and saved.\n",
      "Processing row 706/725: Is Tramadol recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 706...\n",
      "Sending message for row 706...\n",
      "Creating run for row 706...\n",
      "Waiting for run to complete for row 706...\n",
      "completed\n",
      "Row 706 processing completed and saved.\n",
      "Processing row 707/725: Is transcutaneous electrical nerve stimulation (TENS) \n",
      "recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 707...\n",
      "Sending message for row 707...\n",
      "Creating run for row 707...\n",
      "Waiting for run to complete for row 707...\n",
      "completed\n",
      "Row 707 processing completed and saved.\n",
      "Processing row 708/725: Is transdermal opioids recommended for Pharmacologic\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 708...\n",
      "Sending message for row 708...\n",
      "Creating run for row 708...\n",
      "Waiting for run to complete for row 708...\n",
      "completed\n",
      "Row 708 processing completed and saved.\n",
      "Processing row 709/725: Is Turmeric recommended for Pharmacological Treatment of osteoarthritis.\n",
      "Creating thread for row 709...\n",
      "Sending message for row 709...\n",
      "Creating run for row 709...\n",
      "Waiting for run to complete for row 709...\n",
      "completed\n",
      "Row 709 processing completed and saved.\n",
      "Processing row 710/725: Is ultrasound therapy recommended for Physical Treatment of  osteoarthritis.\n",
      "Creating thread for row 710...\n",
      "Sending message for row 710...\n",
      "Creating run for row 710...\n",
      "Waiting for run to complete for row 710...\n",
      "completed\n",
      "Row 710 processing completed and saved.\n",
      "Processing row 711/725: Is Ultrasound-guided intraarticular glucocorticoid injection recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 711...\n",
      "Sending message for row 711...\n",
      "Creating run for row 711...\n",
      "Waiting for run to complete for row 711...\n",
      "completed\n",
      "Row 711 processing completed and saved.\n",
      "Processing row 712/725: Is unloading shoes, minimalist footwear or rocker-sole shoes recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 712...\n",
      "Sending message for row 712...\n",
      "Creating run for row 712...\n",
      "Waiting for run to complete for row 712...\n",
      "completed\n",
      "Row 712 processing completed and saved.\n",
      "Processing row 713/725: Is valgus unloading/realignment braces recommended for Other Treatment of osteoarthritis.\n",
      "Creating thread for row 713...\n",
      "Sending message for row 713...\n",
      "Creating run for row 713...\n",
      "Waiting for run to complete for row 713...\n",
      "completed\n",
      "Row 713 processing completed and saved.\n",
      "Processing row 714/725: Is viscosupplementation injection recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 714...\n",
      "Sending message for row 714...\n",
      "Creating run for row 714...\n",
      "Waiting for run to complete for row 714...\n",
      "completed\n",
      "Row 714 processing completed and saved.\n",
      "Processing row 715/725: Is Vitamin D recommended for Pharmacologic Treatment of osteoarthritis.\n",
      "Creating thread for row 715...\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sending message for row 715...\n",
      "Creating run for row 715...\n",
      "Waiting for run to complete for row 715...\n",
      "completed\n",
      "Row 715 processing completed and saved.\n",
      "Processing row 716/725: Is Vocational rehabilitation recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 716...\n",
      "Sending message for row 716...\n",
      "Creating run for row 716...\n",
      "Waiting for run to complete for row 716...\n",
      "completed\n",
      "Row 716 processing completed and saved.\n",
      "Processing row 717/725: Is walking aids (such as walking sticks) recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 717...\n",
      "Sending message for row 717...\n",
      "Creating run for row 717...\n",
      "Waiting for run to complete for row 717...\n",
      "completed\n",
      "Row 717 processing completed and saved.\n",
      "Processing row 718/725: Is Walking aids, assistive technology and adaptations at home and/or at work recommended for Physical Treatment of osteoarthritis.\n",
      "Creating thread for row 718...\n",
      "Sending message for row 718...\n",
      "Creating run for row 718...\n",
      "Waiting for run to complete for row 718...\n",
      "completed\n",
      "Row 718 processing completed and saved.\n",
      "Processing row 719/725: Is Walking recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 719...\n",
      "Sending message for row 719...\n",
      "Creating run for row 719...\n",
      "Waiting for run to complete for row 719...\n",
      "completed\n",
      "Row 719 processing completed and saved.\n",
      "Processing row 720/725: Is Muscle-strengthening exercise recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 720...\n",
      "Sending message for row 720...\n",
      "Creating run for row 720...\n",
      "Waiting for run to complete for row 720...\n",
      "completed\n",
      "Row 720 processing completed and saved.\n",
      "Processing row 721/725: Is Tai Chi recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 721...\n",
      "Sending message for row 721...\n",
      "Creating run for row 721...\n",
      "Waiting for run to complete for row 721...\n",
      "completed\n",
      "Row 721 processing completed and saved.\n",
      "Processing row 722/725: Is wedged insoles recommended for Physical\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 722...\n",
      "Sending message for row 722...\n",
      "Creating run for row 722...\n",
      "Waiting for run to complete for row 722...\n",
      "completed\n",
      "Row 722 processing completed and saved.\n",
      "Processing row 723/725: Is Weight loss recommended for Other Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 723...\n",
      "Sending message for row 723...\n",
      "Creating run for row 723...\n",
      "Waiting for run to complete for row 723...\n",
      "completed\n",
      "Row 723 processing completed and saved.\n",
      "Processing row 724/725: Is weight management plus exercise recommended for Exercise\n",
      "Treatment of osteoarthritis.\n",
      "Creating thread for row 724...\n",
      "Sending message for row 724...\n",
      "Creating run for row 724...\n",
      "Waiting for run to complete for row 724...\n",
      "completed\n",
      "Row 724 processing completed and saved.\n",
      "Processing row 725/725: Is Yoga recommended for Exercise Treatment of osteoarthritis.\n",
      "Creating thread for row 725...\n",
      "Sending message for row 725...\n",
      "Creating run for row 725...\n",
      "Waiting for run to complete for row 725...\n",
      "completed\n",
      "Row 725 processing completed and saved.\n",
      "All rows processed and saved.\n"
     ]
    }
   ],
   "source": [
    "#因为比较慢，有时会卡顿，所以没有重复五次再保存\n",
    "#Loop through each line\n",
    "import pandas as pd\n",
    "\n",
    "# Function to process queries and get responses\n",
    "def process_user_queries(client, excel_path, content_column, file_id, assistant_id, instructions):\n",
    "    # Read contents from an Excel file\n",
    "    df = pd.read_excel(excel_path)\n",
    "\n",
    "    # Prepare a column in the DataFrame to store responses if not already present\n",
    "    if 'Assistant_Responses' not in df.columns:\n",
    "        df['Assistant_Responses'] = ''\n",
    "\n",
    "    # Adjust the start row if it's beyond the range of the DataFrame\n",
    "    start_row = 467\n",
    "\n",
    "    # Iterate over each content in the DataFrame starting from the start_row\n",
    "    for index, row in df.iloc[start_row:].iterrows():\n",
    "        user_query = row[content_column]\n",
    "        print(f\"Processing row {index + 1}/{len(df)}: {user_query}\")\n",
    "\n",
    "        # Create a new thread for each query\n",
    "        print(f\"Creating thread for row {index + 1}...\")\n",
    "        thread = client.beta.threads.create()\n",
    "\n",
    "        print(f\"Sending message for row {index + 1}...\")\n",
    "        message = client.beta.threads.messages.create(\n",
    "            thread_id=thread.id,\n",
    "            role=\"user\",\n",
    "            content=user_query,\n",
    "            file_ids=[file_id]\n",
    "        )\n",
    "\n",
    "        # Create a run with specific instructions\n",
    "        print(f\"Creating run for row {index + 1}...\")\n",
    "        run = client.beta.threads.runs.create(\n",
    "            thread_id=thread.id,\n",
    "            assistant_id=assistant_id,\n",
    "            instructions=instructions\n",
    "        )\n",
    "\n",
    "        # Wait for the run to complete\n",
    "        print(f\"Waiting for run to complete for row {index + 1}...\")\n",
    "        while run.status != \"completed\":\n",
    "            time.sleep(3)  # Sleep to avoid hitting API limits\n",
    "            run = client.beta.threads.runs.retrieve(\n",
    "                thread_id=thread.id,\n",
    "                run_id=run.id\n",
    "            )\n",
    "        print(run.status)\n",
    "\n",
    "         # Retrieve and store all messages from the thread\n",
    "        messages = client.beta.threads.messages.list(\n",
    "            thread_id=thread.id\n",
    "        )\n",
    "        full_conversation = []\n",
    "        if messages.data:\n",
    "            for msg in messages.data:\n",
    "                # Extract the message text and add it to the list\n",
    "                full_conversation.append(msg.content[0].text.value)\n",
    "\n",
    "        # Join all messages into a single string\n",
    "        df.at[index, 'Assistant_Responses'] = '\\n'.join(full_conversation)\n",
    "\n",
    "\n",
    "        # Save the updated DataFrame back to the Excel file after each row is completed\n",
    "        df.to_excel(excel_path, index=False)\n",
    "        print(f\"Row {index + 1} processing completed and saved.\")\n",
    "\n",
    "    print(\"All rows processed and saved.\")\n",
    "\n",
    "# Designate file path and content to be processed\n",
    "excel_path = 'C:/Work/Articles/Chat-GPT/specializeddoc/Osteoarthritis/Part1.Base model evaluation/Retrieval/treatment_retrieval.xlsx'\n",
    "content_column = 'Treatment_specific_question'  # Replace with the name of your column\n",
    "\n",
    "\n",
    "# Replace with your actual file and assistant IDs and instructions\n",
    "file_id = 'file-GeVpnXIPlxOcodiiFHn5ya4b'\n",
    "assistant_id = 'asst_32zp9OoLhKJR8IocAS3x5Huf'\n",
    "instructions = (\"\"\"You are DocOA, read the uploaded file which contains information for you to answer the question.\n",
    "                 You should concisely state if the treatment is recommended, if any, the strength of this recommendation (if specified), and the level of certainty of the evidence supporting it (if specified). \n",
    "                 You should provide brief explanation and additional information for your answer\"\"\")\n",
    "\n",
    "\n",
    "\n",
    "# Process the queries and get responses\n",
    "process_user_queries(client, excel_path, content_column, file_id, assistant_id, instructions)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "626b8c5a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import openai\n",
    "import time\n",
    "from openai import OpenAI\n",
    "from dotenv import load_dotenv\n",
    "\n",
    "load_dotenv('untitled.env')\n",
    "\n",
    "api_key = os.getenv('OPENAI_API_KEY')\n",
    "print(api_key)  \n",
    "\n",
    "client = OpenAI()\n",
    "\n",
    "# Upload a file with an \"assistants\" purpose\n",
    "client = OpenAI()\n",
    "\n",
    "file = client.files.create(\n",
    "  file=open(\"C:/Work/Articles/Chat-GPT/Benchmark/treatment_based_QA.json\", \"rb\"),\n",
    "  purpose='assistants'\n",
    ")\n",
    "\n",
    "print(file.id)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "49adb316",
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "Assistants.create() got an unexpected keyword argument 'temperature'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[5], line 5\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[38;5;28;01mimport\u001b[39;00m \u001b[38;5;21;01mopenai\u001b[39;00m\n\u001b[0;32m      2\u001b[0m client \u001b[38;5;241m=\u001b[39m openai\u001b[38;5;241m.\u001b[39mOpenAI()\n\u001b[1;32m----> 5\u001b[0m assistant \u001b[38;5;241m=\u001b[39m client\u001b[38;5;241m.\u001b[39mbeta\u001b[38;5;241m.\u001b[39massistants\u001b[38;5;241m.\u001b[39mcreate(\n\u001b[0;32m      6\u001b[0m   name \u001b[38;5;241m=\u001b[39m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mDocOA\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m      7\u001b[0m   instructions\u001b[38;5;241m=\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mYou are DocOA, a digital osteoarthritis specialist, leveraging its professional knowledge to provide insights on osteoarthritis based on clinical guidelines. It can prescribe personalized management programs for osteoarthritis and run tests using its Python capability. DocOA\u001b[39m\u001b[38;5;124m'\u001b[39m\u001b[38;5;124ms responses are informed by specific uploaded documents, ensuring accurate and relevant information. It avoids speculation and sticks to facts in the provided materials, prioritizing knowledge from these documents over general information. If a query cannot be answered with the documents, DocOA clearly states so. It maintains a professional, informative tone, suitable for discussing medical topics.\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m      8\u001b[0m   model\u001b[38;5;241m=\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mgpt-4-1106-preview\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m      9\u001b[0m   tools\u001b[38;5;241m=\u001b[39m[{\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mtype\u001b[39m\u001b[38;5;124m\"\u001b[39m: \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mretrieval\u001b[39m\u001b[38;5;124m\"\u001b[39m}],\n\u001b[0;32m     10\u001b[0m   file_ids\u001b[38;5;241m=\u001b[39m[file\u001b[38;5;241m.\u001b[39mid],\n\u001b[0;32m     11\u001b[0m     temperature\u001b[38;5;241m=\u001b[39m\u001b[38;5;241m0\u001b[39m\n\u001b[0;32m     12\u001b[0m )\n\u001b[0;32m     13\u001b[0m \u001b[38;5;28mprint\u001b[39m(assistant\u001b[38;5;241m.\u001b[39mid)\n",
      "\u001b[1;31mTypeError\u001b[0m: Assistants.create() got an unexpected keyword argument 'temperature'"
     ]
    }
   ],
   "source": [
    "import openai\n",
    "client = openai.OpenAI()\n",
    "\n",
    "\n",
    "assistant = client.beta.assistants.create(\n",
    "  name = \"DocOA\",\n",
    "  instructions=\"You are DocOA, a digital osteoarthritis specialist, leveraging its professional knowledge to provide insights on osteoarthritis based on clinical guidelines. It can prescribe personalized management programs for osteoarthritis and run tests using its Python capability. DocOA's responses are informed by specific uploaded documents, ensuring accurate and relevant information. It avoids speculation and sticks to facts in the provided materials, prioritizing knowledge from these documents over general information. If a query cannot be answered with the documents, DocOA clearly states so. It maintains a professional, informative tone, suitable for discussing medical topics.\",\n",
    "  model=\"gpt-4-1106-preview\",\n",
    "  tools=[{\"type\": \"retrieval\"}],\n",
    "  file_ids=[file.id]\n",
    ")\n",
    "print(assistant.id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a09ddf32",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import openai\n",
    "import time\n",
    "from openai import OpenAI\n",
    "from dotenv import load_dotenv\n",
    "\n",
    "load_dotenv('untitled.env')\n",
    "\n",
    "api_key = os.getenv('OPENAI_API_KEY')\n",
    "print(api_key)  \n",
    "\n",
    "client = OpenAI()\n",
    "\n",
    "\n",
    "#Loop through each line\n",
    "import pandas as pd\n",
    "\n",
    "# Function to process queries and get responses\n",
    "def process_user_queries(client, excel_path, content_column, file_id, assistant_id, instructions):\n",
    "    # Read contents from an Excel file\n",
    "    df = pd.read_excel(excel_path)\n",
    "\n",
    "    # Prepare a column in the DataFrame to store responses if not already present\n",
    "    if 'Assistant_Responses' not in df.columns:\n",
    "        df['Assistant_Responses'] = ''\n",
    "\n",
    "    # Adjust the start row if it's beyond the range of the DataFrame\n",
    "    start_row = 467\n",
    "\n",
    "    # Iterate over each content in the DataFrame starting from the start_row\n",
    "    for index, row in df.iloc[start_row:].iterrows():\n",
    "        user_query = row[content_column]\n",
    "        print(f\"Processing row {index + 1}/{len(df)}: {user_query}\")\n",
    "\n",
    "        # Create a new thread for each query\n",
    "        print(f\"Creating thread for row {index + 1}...\")\n",
    "        thread = client.beta.threads.create()\n",
    "\n",
    "        print(f\"Sending message for row {index + 1}...\")\n",
    "        message = client.beta.threads.messages.create(\n",
    "            thread_id=thread.id,\n",
    "            role=\"user\",\n",
    "            content=user_query,\n",
    "            file_ids=[file_id]\n",
    "        )\n",
    "\n",
    "        # Create a run with specific instructions\n",
    "        print(f\"Creating run for row {index + 1}...\")\n",
    "        run = client.beta.threads.runs.create(\n",
    "            thread_id=thread.id,\n",
    "            assistant_id=assistant_id,\n",
    "            instructions=instructions\n",
    "        )\n",
    "\n",
    "        # Wait for the run to complete\n",
    "        print(f\"Waiting for run to complete for row {index + 1}...\")\n",
    "        while run.status != \"completed\":\n",
    "            time.sleep(3)  # Sleep to avoid hitting API limits\n",
    "            run = client.beta.threads.runs.retrieve(\n",
    "                thread_id=thread.id,\n",
    "                run_id=run.id\n",
    "            )\n",
    "        print(run.status)\n",
    "\n",
    "         # Retrieve and store all messages from the thread\n",
    "        messages = client.beta.threads.messages.list(\n",
    "            thread_id=thread.id\n",
    "        )\n",
    "        full_conversation = []\n",
    "        if messages.data:\n",
    "            for msg in messages.data:\n",
    "                # Extract the message text and add it to the list\n",
    "                full_conversation.append(msg.content[0].text.value)\n",
    "\n",
    "        # Join all messages into a single string\n",
    "        df.at[index, 'Assistant_Responses'] = '\\n'.join(full_conversation)\n",
    "\n",
    "\n",
    "        # Save the updated DataFrame back to the Excel file after each row is completed\n",
    "        df.to_excel(excel_path, index=False)\n",
    "        print(f\"Row {index + 1} processing completed and saved.\")\n",
    "\n",
    "    print(\"All rows processed and saved.\")\n",
    "\n",
    "# Designate file path and content to be processed\n",
    "excel_path = ''\n",
    "content_column = ''  # Replace with the name of your column\n",
    "\n",
    "\n",
    "# Replace with your actual file and assistant IDs and instructions\n",
    "file_id = ''\n",
    "assistant_id = ''\n",
    "instructions = (\"\"\" \"\"\")\n",
    "\n",
    "\n",
    "\n",
    "# Process the queries and get responses\n",
    "process_user_queries(client, excel_path, content_column, file_id, assistant_id, instructions)\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}