U JXLh@sZddlZddlmZdZdZeedZddlZddlZddZdd Zd d Zd d Z dS)N)OpenAIZ%hf_RwrpebXRyHAHIwBflkGrsqeAeFgoGcPYCuzsk-proj-O44Tus5LHWDwreXOqQOMjJqqKIVMrIYHNBoJSitbCH4OLdT5bDUp3Ey9n7qtt1zTsbwrUtHX6gT3BlbkFJLbzL1SHbiJDfiSin8Kyf--R9BfRQp4WTCa7kxGxQlZB-ALIqFlror4MCBBAcT5mc6k4a0T3PkA)api_keyc st|dddd"}tt|}dd|DW5QRXrFd|r~tdd |Dfd dtdtD}ng}t|d ddd}t|}| |W5QRXd S) z Deletes the first element (top-left cell) of a CSV file and adjusts the rest of the content so there are no blank cells left. Args: csv_file_path (str): Path to the CSV file. Returns: None rutf-8modenewlineencodingcSsg|]}|D]}|q qSr ).0rowcellr r E/home/ankuromar296_gmail_com/publish_blogs_ai/news/get_article_obj.py sz(delete_first_element..rcss|]}t|VqdS)N)len)r r r r r %sz'delete_first_element..csg|]}||qSr r )r i flat_datanum_colsr rr&swN) openlistcsvreaderpopmaxrangerwriter writerows) csv_file_pathfilernew_rowsrr rrdelete_first_elements  " r$cCs(tjjj|d|dgd}|jdjjS)Nuser)rolecontent)modelmessagesr)clientchat completionscreatechoicesmessager')promptr( completionr r r call_genai/s r2c CsZt|dddd@}t|}|D] }|r |dW5QRSq W5QRdSQRXdS)z Reads the first element (top-left cell) of a CSV file. Args: csv_file_path (str): Path to the CSV file. Returns: str: The first element of the CSV file, or None if file is empty. rrrrrN)rrr)r!r"rr r r rread_first_element?s  r3c Cst|}t|d}d}d|d|}t||}td|d|krLdSd}td |d |}d |i}g}||||fS) Naagriculture/forestry/farming news, precision agriculture, remote sensing, NDVI, satellite imagery, crop monitoring, yield estimation, soil moisture, irrigation advisory, farm management, agri-tech, climate-smart agriculture, sustainable agriculture, agri-input optimization, agricultural IoT, GPS mapping, weather forecasting, drought monitoring, land use mapping, pest detection, crop health, forestry monitoring, carbon sequestration, agroforestry, biomass estimation, drone mapping, smart farming, geospatial analytics, carbon credits, deforestation tracking, land degradation, crop insurance, agricultural subsidies, regenerative agriculture, organic farming, climate change, water resource management, AI in agriculture, ML for crop prediction, agricultural policy, smart irrigation, field scouting, weed detection, fertilizer advisory, farm automation, agronomy, agri-fintech, farm-to-fork traceability, agricultural extension, rural development, ESG in agriculture, remote field diagnostics, plant disease detection, agricultural marketplaces, agricultural data platforms, precision forestry, sustainable land management, government agri schemes, digital agriculture, food security, global food supply, agricultural exports, food price inflation, commodity markets, land monitoring, harvest forecastingzgpt-4.1-mini-2025-04-14zKOutput YES if the provided text is related to any of the following topics: z. Only answer YES OR NO. Text: z is relevantno)NNz%gpt-4o-mini-search-preview-2025-03-11z[I want to write an article on this topic in the context of agriculture/ farming/ forestry: zR Can you cover everything about this topic in 1000 words. Output only the content.body)r3printr2lowerappend) file_path main_keywordZrelevant_keywordsr(r0Z is_relevantr'Z content_objZ all_contentsr r rget_article_objPs"    r;) ropenairZhf2 model_keyr*r$r2r3r;r r r rs