crop care.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "ec145636",
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.webdriver.common.action_chains import ActionChains\n",
    "from selenium.webdriver.chrome.options import Options\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import requests as rq\n",
    "import numpy as np\n",
    "import time as tm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "322d5d75",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "5\n"
     ]
    }
   ],
   "source": [
    "driver = webdriver.Chrome()\n",
    "url= \"https://www.biostadt.com/products/adjuvants.aspx\"\n",
    "driver.get(url)\n",
    "\n",
    "\n",
    "wait = WebDriverWait(driver, 10) # wait for up to 10 seconds for the page to load\n",
    "wait.until(EC.presence_of_element_located((By.TAG_NAME, \"body\")))\n",
    "\n",
    "\n",
    "content = driver.page_source.encode('utf-8').strip()\n",
    "soup = BeautifulSoup(content,\"html.parser\")\n",
    "\n",
    "div = soup.find(\"ul\",{\"class\":\"prod-list\"})\n",
    "# ul = div.find(\"ul\")\n",
    "links = div.find_all(\"li\")\n",
    "\n",
    "\n",
    "# imglist = []\n",
    "productlinks = []\n",
    "for i in links:\n",
    "    a = i.find(\"a\")\n",
    "    link = a.get(\"href\")\n",
    "    productlinks.append(link)  \n",
    "#     img = i.find(\"img\").get(\"src\")\n",
    "#     imglist.append(img)\n",
    "\n",
    "print(len(productlinks))\n",
    "\n",
    "\n",
    "driver.quit()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "a8915fed",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "../crop-protection/4-in-1.aspx\n",
      "../crop-protection/latino.aspx\n",
      "../crop-protection/nanologicals-mixin.aspx\n",
      "../crop-protection/neostick.aspx\n",
      "../crop-protection/wetwell.aspx\n"
     ]
    }
   ],
   "source": [
    "for i in  productlinks:\n",
    "    print(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "c4415ea4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "benefits:\n",
      "_________end_______________\n",
      "_________end_______________\n",
      "_________end_______________\n",
      "_________end_______________\n",
      "benefits:\n",
      "_________end_______________\n"
     ]
    }
   ],
   "source": [
    "datas = []\n",
    "for x in range(0, len(productlinks)):\n",
    "\n",
    "\n",
    "#     if x == 3:\n",
    "#         break\n",
    "        \n",
    "    # Set Chrome options to run in headless mode\n",
    "    chrome_options = Options()\n",
    "    chrome_options.add_argument(\"--headless\")\n",
    "        \n",
    "    url = \"https://www.biostadt.com\" + str(productlinks[x]).lstrip(\"..\")\n",
    "    \n",
    "    driver = webdriver.Chrome()\n",
    "    driver.get(url)\n",
    "\n",
    "    content = driver.page_source.encode('utf-8').strip()\n",
    "    soup = BeautifulSoup(content,\"html.parser\")\n",
    "    \n",
    "    name,category,tname,para,mode,crop,tar,dose,pack,dilu,beni,fea,img = None,None,None,None,None,None,None,None,None,None,None,None,None\n",
    "    cropl,tarl,dosel,packl, dilul = [],[],[],[],[]\n",
    "    \n",
    "    \n",
    "    try:\n",
    "        div = soup.find(\"div\",{\"class\":\"tab_content\"})\n",
    "        name = div.find(\"h2\").text.strip()\n",
    "#         print(name)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        div = soup.find(\"div\",{\"class\":\"tab_content\"})\n",
    "        table = div.find(\"table\")\n",
    "        tr = table.find_all(\"tr\")\n",
    "        for i in range(len(tr)):\n",
    "            td = tr[i].find_all(\"td\")\n",
    "            if \"common\" in td[0].text.strip().lower():\n",
    "                tname = td[1].text.strip()\n",
    "#         print(tname)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        ul = soup.find(\"ul\",{\"class\":\"product-pic\"})\n",
    "        imgl = ul.find(\"img\").get(\"src\")\n",
    "        img = \"https://www.biostadt.com\" + imgl.lstrip(\"..\")\n",
    "#         print(img)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    \n",
    "    try:\n",
    "        ul = soup.find(\"ul\",{\"class\":\"product-pic\"})\n",
    "        table1 = ul.find_next_sibling(\"table\")\n",
    "        tr1 = table1.find_all(\"tr\")\n",
    "        table2 = tr1[1].find(\"table\")\n",
    "        tr2 = table2.find(\"tr\")\n",
    "        table3 = tr2.find(\"table\")\n",
    "        tr = table3.find_all(\"tr\")\n",
    "        prodtr = tr\n",
    "        \n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"introduction\" in tx:\n",
    "                para = tr[i+1].text.strip()\n",
    "#         print(para)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "#         print(tr)\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"mode of action:\" in tx:\n",
    "#                 print(tx)\n",
    "                mode = tr[i+1].text.strip()\n",
    "#         print(mode)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"benefits:\" in tx:\n",
    "                print(tx)\n",
    "                beni = tr[i+1].text.strip()\n",
    "#         print(beni)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"features:\" in tx:\n",
    "                fea = tr[i+1].text.strip()\n",
    "#         print(fea)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"active ingredient:\" in tx:\n",
    "                tname = tr[i+1].text.strip()\n",
    "#         print(tname)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"method of application:\" in tx:\n",
    "                pack = tr[i+1].text.strip()\n",
    "#         print(pack)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"packing available:\" in tx or \"packaging:\" in tx:\n",
    "                pack = tr[i+1].text.strip()\n",
    "#         print(pack)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"dosage & dilution:\" in tx:\n",
    "                \n",
    "                tbody = tr[i+1].find(\"tbody\")\n",
    "                trs = tbody.find_all(\"tr\")\n",
    "                for i in range(len(trs)):\n",
    "                    if i == 0:\n",
    "                        continue\n",
    "                    td = trs[i].find_all(\"td\")\n",
    "                    cropl.append(td[0].text.strip())\n",
    "                    tarl.append(td[1].text.strip())\n",
    "                    dosel.append(td[2].text.strip())\n",
    "                    \n",
    "        crop = \" | \".join(cropl)\n",
    "        tar = \" | \".join(tarl)\n",
    "        dose =  \" | \".join(dosel)\n",
    "#         print(crop)\n",
    "#         print(tar)\n",
    "#         print(dose)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"spectrum of action and suggested uses:\" in tx:\n",
    "                \n",
    "                tbody = tr[i+1].find(\"tbody\")\n",
    "                trs = tbody.find_all(\"tr\")\n",
    "                for i in range(len(trs)):\n",
    "                    if i == 0:\n",
    "                        continue\n",
    "                    td = trs[i].find_all(\"td\")\n",
    "                    cropl.append(td[0].text.strip())\n",
    "                    tarl.append(td[1].text.strip())\n",
    "                    dosel.append(td[2].text.strip())\n",
    "                    \n",
    "        crop = \" | \".join(cropl)\n",
    "        tar = \" | \".join(tarl)\n",
    "        dose =  \" | \".join(dosel)\n",
    "#         print(crop)\n",
    "#         print(tar)\n",
    "#         print(dose)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    try:\n",
    "        tr = prodtr\n",
    "        for i in range(len(tr)):\n",
    "            tx = tr[i].text.strip().lower()\n",
    "            if \"recommendation:\" in tx:\n",
    "                tbody = tr[i+1].find(\"tbody\")\n",
    "                trs = tbody.find_all(\"tr\")\n",
    "                for i in range(len(trs)):\n",
    "                    if i == 0 or i == 1:\n",
    "                        continue\n",
    "                    td = trs[i].find_all(\"td\")\n",
    "                    cropl.append(td[0].text.strip())\n",
    "                    tarl.append(td[1].text.strip())\n",
    "                    dosel.append(td[2].text.strip())\n",
    "                    dilul.append(td[3].text.strip())\n",
    "                    \n",
    "                    \n",
    "        crop = \" | \".join(cropl)\n",
    "        tar = \" | \".join(tarl)\n",
    "        dose =  \" | \".join(dosel)\n",
    "        dilu = \" | \".join(dilul)\n",
    "#         print(crop)\n",
    "#         print(tar)\n",
    "#         print(dose)\n",
    "    except:\n",
    "        pass\n",
    "    \n",
    "    \n",
    "\n",
    "        \n",
    "\n",
    "\n",
    "        \n",
    " \n",
    "        \n",
    "        \n",
    "    \n",
    "    \n",
    "    print(\"_________end_______________\" )\n",
    "\n",
    "        \n",
    "    product = {\"Name\":name, \"Brand Name\":\"NACL\", \"Technical Name\":tname,\"Category\":\"Adjuvants\",\"Product Brief\":para, \"Mode\":mode,\"Crop\":crop,\"Target\":tar,\"Dosage\":dose,\"Pack Sizes\":pack,\"Dilution\":dilu, \"Features\":fea, \"Benefits\":beni,\"Image Link\":img, \"Product Link\": url}\n",
    "\n",
    "    datas.append(product)\n",
    "\n",
    "    driver.quit()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "592dc0c8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Brand Name</th>\n",
       "      <th>Technical Name</th>\n",
       "      <th>Category</th>\n",
       "      <th>Product Brief</th>\n",
       "      <th>Mode</th>\n",
       "      <th>Crop</th>\n",
       "      <th>Target</th>\n",
       "      <th>Dosage</th>\n",
       "      <th>Pack Sizes</th>\n",
       "      <th>Dilution</th>\n",
       "      <th>Features</th>\n",
       "      <th>Benefits</th>\n",
       "      <th>Image Link</th>\n",
       "      <th>Product Link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4-in-1</td>\n",
       "      <td>NACL</td>\n",
       "      <td>Sticker-Spreader-Rainfastner-Activator</td>\n",
       "      <td>Adjuvants</td>\n",
       "      <td>None</td>\n",
       "      <td>Once applied on Leaf Surface, it quickly stick...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Biostadt'd 4-in-1 can be applied with Insectic...</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/4-in-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Latino</td>\n",
       "      <td>NACL</td>\n",
       "      <td>Silicon Based Adjuvant</td>\n",
       "      <td>Adjuvants</td>\n",
       "      <td>LATINO is a new type novel adjuvant which is h...</td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Apply LATINO with any herbicides, insecticides...</td>\n",
       "      <td></td>\n",
       "      <td>New Type Novel Adjuvant – Double Function Perf...</td>\n",
       "      <td>None</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/latin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mixin</td>\n",
       "      <td>NACL</td>\n",
       "      <td>None</td>\n",
       "      <td>Adjuvants</td>\n",
       "      <td>Mixin is a specialty performance chemical inno...</td>\n",
       "      <td>Sticker: Wetting agent present in Mixin helps ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/nanol...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Neostick</td>\n",
       "      <td>NACL</td>\n",
       "      <td>None</td>\n",
       "      <td>Adjuvants</td>\n",
       "      <td>Mixin is a specialty performance chemical inno...</td>\n",
       "      <td>Sticker: Wetting agent present in Mixin helps ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/neost...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Wetwell</td>\n",
       "      <td>NACL</td>\n",
       "      <td>Sticker-Spreader-Rainfastner-Activator        ...</td>\n",
       "      <td>Adjuvants</td>\n",
       "      <td>Wetwell is a new generation Silicone (Trisilox...</td>\n",
       "      <td>When water is placed on a water repellent surf...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td></td>\n",
       "      <td>None</td>\n",
       "      <td>Maximum spray usage and distribution across le...</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/wetwe...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Name Brand Name                                     Technical Name  \\\n",
       "0    4-in-1       NACL             Sticker-Spreader-Rainfastner-Activator   \n",
       "1    Latino       NACL                             Silicon Based Adjuvant   \n",
       "2     Mixin       NACL                                               None   \n",
       "3  Neostick       NACL                                               None   \n",
       "4   Wetwell       NACL  Sticker-Spreader-Rainfastner-Activator        ...   \n",
       "\n",
       "    Category                                      Product Brief  \\\n",
       "0  Adjuvants                                               None   \n",
       "1  Adjuvants  LATINO is a new type novel adjuvant which is h...   \n",
       "2  Adjuvants  Mixin is a specialty performance chemical inno...   \n",
       "3  Adjuvants  Mixin is a specialty performance chemical inno...   \n",
       "4  Adjuvants  Wetwell is a new generation Silicone (Trisilox...   \n",
       "\n",
       "                                                Mode Crop Target Dosage  \\\n",
       "0  Once applied on Leaf Surface, it quickly stick...                      \n",
       "1                                               None                      \n",
       "2  Sticker: Wetting agent present in Mixin helps ...                      \n",
       "3  Sticker: Wetting agent present in Mixin helps ...                      \n",
       "4  When water is placed on a water repellent surf...                      \n",
       "\n",
       "                                          Pack Sizes Dilution  \\\n",
       "0                                               None            \n",
       "1  Apply LATINO with any herbicides, insecticides...            \n",
       "2                                               None            \n",
       "3                                               None            \n",
       "4                                               None            \n",
       "\n",
       "                                            Features  \\\n",
       "0                                               None   \n",
       "1  New Type Novel Adjuvant – Double Function Perf...   \n",
       "2                                               None   \n",
       "3                                               None   \n",
       "4                                               None   \n",
       "\n",
       "                                            Benefits  \\\n",
       "0  Biostadt'd 4-in-1 can be applied with Insectic...   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3                                               None   \n",
       "4  Maximum spray usage and distribution across le...   \n",
       "\n",
       "                                          Image Link  \\\n",
       "0  https://www.biostadt.com/uploads/products/prod...   \n",
       "1  https://www.biostadt.com/uploads/products/prod...   \n",
       "2  https://www.biostadt.com/uploads/products/prod...   \n",
       "3  https://www.biostadt.com/uploads/products/prod...   \n",
       "4  https://www.biostadt.com/uploads/products/prod...   \n",
       "\n",
       "                                        Product Link  \n",
       "0  https://www.biostadt.com/crop-protection/4-in-...  \n",
       "1  https://www.biostadt.com/crop-protection/latin...  \n",
       "2  https://www.biostadt.com/crop-protection/nanol...  \n",
       "3  https://www.biostadt.com/crop-protection/neost...  \n",
       "4  https://www.biostadt.com/crop-protection/wetwe...  "
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_data = pd.DataFrame.from_dict(datas)\n",
    "pd.set_option('display.max_rows', None)\n",
    "new_data.head(110)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "48328160",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Name</th>\n",
       "      <th>Brand Name</th>\n",
       "      <th>Technical Name</th>\n",
       "      <th>Category</th>\n",
       "      <th>Product Brief</th>\n",
       "      <th>Mode</th>\n",
       "      <th>Crop</th>\n",
       "      <th>Target</th>\n",
       "      <th>Dosage</th>\n",
       "      <th>Pack Sizes</th>\n",
       "      <th>Dilution</th>\n",
       "      <th>Features</th>\n",
       "      <th>Benefits</th>\n",
       "      <th>Image Link</th>\n",
       "      <th>Product Link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Accuracy+</td>\n",
       "      <td>NACL</td>\n",
       "      <td>Hexaconazole 5 SC</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>Accuracy+ is an improved formulation of Hexaco...</td>\n",
       "      <td>Accuracy+ is a unique systemic triazole fungic...</td>\n",
       "      <td>Mango | Paddy/Rice | Grapes</td>\n",
       "      <td>Powdery mildew | Sheath blight | Powdery mildew</td>\n",
       "      <td>0.2% or (200 ml/100 lt. water) | 0.2% or (200 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Accuracy+ is a broad-spectrum fungicide, contr...</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/accur...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Alliance</td>\n",
       "      <td>NACL</td>\n",
       "      <td>Azoxystrobin 11% + Tebuconazole 18.3% SC</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Systemic: Translaminar and Strong systemic mod...</td>\n",
       "      <td>Chilli | Rice</td>\n",
       "      <td>Fruit rot, Powdery mildew, Die back | Sheath B...</td>\n",
       "      <td>Spray | Spray</td>\n",
       "      <td>Foliar Spray: Spray @ 625 to 750 ml per ha. (1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alliance is Broad spectrum Systemic fungicide....</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/allia...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Bavistin 50 DF</td>\n",
       "      <td>NACL</td>\n",
       "      <td>Carbendazim 50% DF</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>It has a unique dry Flowable formulation which...</td>\n",
       "      <td>This renowned systemic fungicide can be used a...</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/bavis...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Bellkute 40 WP</td>\n",
       "      <td>NACL</td>\n",
       "      <td>Iminoctadine Tris(albesilate) 40%</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This new generation, broad spectrum contact fu...</td>\n",
       "      <td>A new generation fungicide with unique chemica...</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/bellk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Bendaco</td>\n",
       "      <td>NACL</td>\n",
       "      <td>Carbendazin 12% + Mancozeb 63% WP</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Groundnut | Paddy</td>\n",
       "      <td>Rust &amp; Leaf Spot | Blast</td>\n",
       "      <td>500 | 750</td>\n",
       "      <td>Available in 50 gm, 100 gm, 250 gm, 500 gm and...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/benda...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0            Name Brand Name  \\\n",
       "0           0       Accuracy+       NACL   \n",
       "1           1        Alliance       NACL   \n",
       "2           2  Bavistin 50 DF       NACL   \n",
       "3           3  Bellkute 40 WP       NACL   \n",
       "4           4         Bendaco       NACL   \n",
       "\n",
       "                             Technical Name    Category  \\\n",
       "0                         Hexaconazole 5 SC  Fungicides   \n",
       "1  Azoxystrobin 11% + Tebuconazole 18.3% SC  Fungicides   \n",
       "2                        Carbendazim 50% DF  Fungicides   \n",
       "3         Iminoctadine Tris(albesilate) 40%  Fungicides   \n",
       "4         Carbendazin 12% + Mancozeb 63% WP  Fungicides   \n",
       "\n",
       "                                       Product Brief  \\\n",
       "0  Accuracy+ is an improved formulation of Hexaco...   \n",
       "1                                                NaN   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                                NaN   \n",
       "\n",
       "                                                Mode  \\\n",
       "0  Accuracy+ is a unique systemic triazole fungic...   \n",
       "1  Systemic: Translaminar and Strong systemic mod...   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                                NaN   \n",
       "\n",
       "                          Crop  \\\n",
       "0  Mango | Paddy/Rice | Grapes   \n",
       "1                Chilli | Rice   \n",
       "2                          NaN   \n",
       "3                          NaN   \n",
       "4            Groundnut | Paddy   \n",
       "\n",
       "                                              Target  \\\n",
       "0    Powdery mildew | Sheath blight | Powdery mildew   \n",
       "1  Fruit rot, Powdery mildew, Die back | Sheath B...   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                           Rust & Leaf Spot | Blast   \n",
       "\n",
       "                                              Dosage  \\\n",
       "0  0.2% or (200 ml/100 lt. water) | 0.2% or (200 ...   \n",
       "1                                      Spray | Spray   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                          500 | 750   \n",
       "\n",
       "                                          Pack Sizes Dilution  \\\n",
       "0                                                NaN      NaN   \n",
       "1  Foliar Spray: Spray @ 625 to 750 ml per ha. (1...      NaN   \n",
       "2                                                NaN      NaN   \n",
       "3                                                NaN      NaN   \n",
       "4  Available in 50 gm, 100 gm, 250 gm, 500 gm and...      NaN   \n",
       "\n",
       "                                            Features  \\\n",
       "0                                                NaN   \n",
       "1                                                NaN   \n",
       "2  It has a unique dry Flowable formulation which...   \n",
       "3  This new generation, broad spectrum contact fu...   \n",
       "4                                                NaN   \n",
       "\n",
       "                                            Benefits  \\\n",
       "0  Accuracy+ is a broad-spectrum fungicide, contr...   \n",
       "1  Alliance is Broad spectrum Systemic fungicide....   \n",
       "2  This renowned systemic fungicide can be used a...   \n",
       "3  A new generation fungicide with unique chemica...   \n",
       "4                                                NaN   \n",
       "\n",
       "                                          Image Link  \\\n",
       "0  https://www.biostadt.com/uploads/products/prod...   \n",
       "1  https://www.biostadt.com/uploads/products/prod...   \n",
       "2  https://www.biostadt.com/uploads/products/prod...   \n",
       "3  https://www.biostadt.com/uploads/products/prod...   \n",
       "4  https://www.biostadt.com/uploads/products/prod...   \n",
       "\n",
       "                                        Product Link  \n",
       "0  https://www.biostadt.com/crop-protection/accur...  \n",
       "1  https://www.biostadt.com/crop-protection/allia...  \n",
       "2  https://www.biostadt.com/crop-protection/bavis...  \n",
       "3  https://www.biostadt.com/crop-protection/bellk...  \n",
       "4  https://www.biostadt.com/crop-protection/benda...  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_data = pd.read_csv(\"herbicides.csv\")\n",
    "new_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "8608ed04",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Name</th>\n",
       "      <th>Brand Name</th>\n",
       "      <th>Technical Name</th>\n",
       "      <th>Category</th>\n",
       "      <th>Product Brief</th>\n",
       "      <th>Mode</th>\n",
       "      <th>Crop</th>\n",
       "      <th>Target</th>\n",
       "      <th>Dosage</th>\n",
       "      <th>Pack Sizes</th>\n",
       "      <th>Dilution</th>\n",
       "      <th>Features</th>\n",
       "      <th>Benefits</th>\n",
       "      <th>Image Link</th>\n",
       "      <th>Product Link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Accuracy+</td>\n",
       "      <td>BIOSTADT</td>\n",
       "      <td>Hexaconazole 5 SC</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>Accuracy+ is an improved formulation of Hexaco...</td>\n",
       "      <td>Accuracy+ is a unique systemic triazole fungic...</td>\n",
       "      <td>Mango | Paddy/Rice | Grapes</td>\n",
       "      <td>Powdery mildew | Sheath blight | Powdery mildew</td>\n",
       "      <td>0.2% or (200 ml/100 lt. water) | 0.2% or (200 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Accuracy+ is a broad-spectrum fungicide, contr...</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/accur...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Alliance</td>\n",
       "      <td>BIOSTADT</td>\n",
       "      <td>Azoxystrobin 11% + Tebuconazole 18.3% SC</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Systemic: Translaminar and Strong systemic mod...</td>\n",
       "      <td>Chilli | Rice</td>\n",
       "      <td>Fruit rot, Powdery mildew, Die back | Sheath B...</td>\n",
       "      <td>Spray | Spray</td>\n",
       "      <td>Foliar Spray: Spray @ 625 to 750 ml per ha. (1...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Alliance is Broad spectrum Systemic fungicide....</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/allia...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Bavistin 50 DF</td>\n",
       "      <td>BIOSTADT</td>\n",
       "      <td>Carbendazim 50% DF</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>It has a unique dry Flowable formulation which...</td>\n",
       "      <td>This renowned systemic fungicide can be used a...</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/bavis...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Bellkute 40 WP</td>\n",
       "      <td>BIOSTADT</td>\n",
       "      <td>Iminoctadine Tris(albesilate) 40%</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>This new generation, broad spectrum contact fu...</td>\n",
       "      <td>A new generation fungicide with unique chemica...</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/bellk...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Bendaco</td>\n",
       "      <td>BIOSTADT</td>\n",
       "      <td>Carbendazin 12% + Mancozeb 63% WP</td>\n",
       "      <td>Fungicides</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Groundnut | Paddy</td>\n",
       "      <td>Rust &amp; Leaf Spot | Blast</td>\n",
       "      <td>500 | 750</td>\n",
       "      <td>Available in 50 gm, 100 gm, 250 gm, 500 gm and...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://www.biostadt.com/uploads/products/prod...</td>\n",
       "      <td>https://www.biostadt.com/crop-protection/benda...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0            Name Brand Name  \\\n",
       "0           0       Accuracy+   BIOSTADT   \n",
       "1           1        Alliance   BIOSTADT   \n",
       "2           2  Bavistin 50 DF   BIOSTADT   \n",
       "3           3  Bellkute 40 WP   BIOSTADT   \n",
       "4           4         Bendaco   BIOSTADT   \n",
       "\n",
       "                             Technical Name    Category  \\\n",
       "0                         Hexaconazole 5 SC  Fungicides   \n",
       "1  Azoxystrobin 11% + Tebuconazole 18.3% SC  Fungicides   \n",
       "2                        Carbendazim 50% DF  Fungicides   \n",
       "3         Iminoctadine Tris(albesilate) 40%  Fungicides   \n",
       "4         Carbendazin 12% + Mancozeb 63% WP  Fungicides   \n",
       "\n",
       "                                       Product Brief  \\\n",
       "0  Accuracy+ is an improved formulation of Hexaco...   \n",
       "1                                                NaN   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                                NaN   \n",
       "\n",
       "                                                Mode  \\\n",
       "0  Accuracy+ is a unique systemic triazole fungic...   \n",
       "1  Systemic: Translaminar and Strong systemic mod...   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                                NaN   \n",
       "\n",
       "                          Crop  \\\n",
       "0  Mango | Paddy/Rice | Grapes   \n",
       "1                Chilli | Rice   \n",
       "2                          NaN   \n",
       "3                          NaN   \n",
       "4            Groundnut | Paddy   \n",
       "\n",
       "                                              Target  \\\n",
       "0    Powdery mildew | Sheath blight | Powdery mildew   \n",
       "1  Fruit rot, Powdery mildew, Die back | Sheath B...   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                           Rust & Leaf Spot | Blast   \n",
       "\n",
       "                                              Dosage  \\\n",
       "0  0.2% or (200 ml/100 lt. water) | 0.2% or (200 ...   \n",
       "1                                      Spray | Spray   \n",
       "2                                                NaN   \n",
       "3                                                NaN   \n",
       "4                                          500 | 750   \n",
       "\n",
       "                                          Pack Sizes Dilution  \\\n",
       "0                                                NaN      NaN   \n",
       "1  Foliar Spray: Spray @ 625 to 750 ml per ha. (1...      NaN   \n",
       "2                                                NaN      NaN   \n",
       "3                                                NaN      NaN   \n",
       "4  Available in 50 gm, 100 gm, 250 gm, 500 gm and...      NaN   \n",
       "\n",
       "                                            Features  \\\n",
       "0                                                NaN   \n",
       "1                                                NaN   \n",
       "2  It has a unique dry Flowable formulation which...   \n",
       "3  This new generation, broad spectrum contact fu...   \n",
       "4                                                NaN   \n",
       "\n",
       "                                            Benefits  \\\n",
       "0  Accuracy+ is a broad-spectrum fungicide, contr...   \n",
       "1  Alliance is Broad spectrum Systemic fungicide....   \n",
       "2  This renowned systemic fungicide can be used a...   \n",
       "3  A new generation fungicide with unique chemica...   \n",
       "4                                                NaN   \n",
       "\n",
       "                                          Image Link  \\\n",
       "0  https://www.biostadt.com/uploads/products/prod...   \n",
       "1  https://www.biostadt.com/uploads/products/prod...   \n",
       "2  https://www.biostadt.com/uploads/products/prod...   \n",
       "3  https://www.biostadt.com/uploads/products/prod...   \n",
       "4  https://www.biostadt.com/uploads/products/prod...   \n",
       "\n",
       "                                        Product Link  \n",
       "0  https://www.biostadt.com/crop-protection/accur...  \n",
       "1  https://www.biostadt.com/crop-protection/allia...  \n",
       "2  https://www.biostadt.com/crop-protection/bavis...  \n",
       "3  https://www.biostadt.com/crop-protection/bellk...  \n",
       "4  https://www.biostadt.com/crop-protection/benda...  "
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_data['Brand Name'] = new_data['Brand Name'].replace(\"NACL\", \"BIOSTADT\")\n",
    "# new_data['Category'] = new_data['Category'].replace(\"Plant Growth Nutrients\", \"RALLIS\")\n",
    "new_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "de67d25c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "bb6b722b",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_data.to_csv(\"fungicides.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "56b0137b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}