U ߁hL@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 D/home/ankuromar296_gmail_com/publish_blogs_ai/gsc/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 Cs|t|}t|d}d}d|d|}t||}td|d|krLdStd|d |}d |i}g}||||fS) NaX [ "Agriculture", "Horticulture", "Forestry", "Farming News", "Mining", "Infrastructure", "Defense/Aerospace", "Remote Sensing", "AI/ML", "AI in Agriculture", "ML for Crop Prediction", "Satellite Imaging", "SAR Imaging", "Drone Mapping", "NDVI Analysis", "Precision Agriculture", "Precision Forestry", "Soil Moisture Monitoring", "Soil Health Monitoring", "Smart Irrigation", "Irrigation Advisory", "IoT Integration", "Agricultural IoT", "Climate-Smart Agriculture", "Sustainable Agriculture", "Regenerative Agriculture", "Organic Farming", "Smart Farming", "Farm Automation", "Farm Management", "Plantation Management", "Remote Field Diagnostics", "Field Scouting", "Crop Monitoring", "Crop Health Analysis", "Pest Detection", "Weed Detection", "Plant Disease Detection", "Yield Estimation", "Harvest Forecasting", "Fertilizer Advisory", "Agri-input Optimization", "Crop Insurance & Loans", "Crop Insurance", "Agricultural Subsidies", "Carbon Footprinting", "Carbon Credits", "Carbon Sequestration", "Blockchain Traceability", "Farm-to-Fork Traceability", "Fleet Management", "Agri-Fintech", "Agronomy", "GPS Mapping", "Geospatial Analytics", "GIS Mapping", "Weather Forecasting", "Drought Monitoring", "Disaster Management", "Flood Risk Assessment", "Land Use Mapping", "Land Monitoring", "Change Detection", "Land Degradation", "Land Parcel Identification", "Land Encroachment Detection", "Illegal Mining Monitoring", "Deforestation Monitoring", "Deforestation Tracking", "Forestry Monitoring", "Agroforestry", "Biomass Estimation", "Ecosystem Services Mapping", "Terrain Analysis", "Surface Temperature Analysis", "Water Resource Management", "Watershed Management", "Groundwater Assessment", "Climate Change", "Natural Resource Management", "Digital Agriculture", "Digital Land Records", "Sustainable Land Management", "Government Agri Schemes", "Agricultural Policy", "Agricultural Extension", "Agri-tech", "Agri-market Linkage", "Agri-Education", "Rural Development", "Food Security", "Global Food Supply", "Agricultural Exports", "Commodity Markets", "Food Price Inflation", "Supply Chain Management", "Agri-Logistics", "Agro-Advisory Services", "Smart Cities", "Infrastructure Planning", "Survey & Mapping", "Environmental Monitoring", "Climate Monitoring", "Digital Farming", "Custom Alert Systems", "Insurance Claim Validation", "Farmer Outreach", "Yield Mapping", "Crop Classification", "Crop Calendar Optimization", "Agrochemical Impact Tracking", "Agricultural Data Platforms", "Agricultural Marketplaces", "Drone Imagery", "Thermal Imaging", "Multispectral Imaging", "Hyperspectral Imaging", "Military Surveillance", "Border Monitoring", "Power Grid Monitoring", "Road Condition Mapping", "Railway Safety Surveillance", "Solar Farm Monitoring", "Wind Farm Optimization", "Biodiversity Tracking", "Rural Connectivity Assessment", "Food Traceability", "ESG in Agriculture", "Honey/ Hive" ] zgpt-4.1-mini-2025-04-14zOutput YES if the provided text is related to any of the following topics (exclude dairy/ cattle farming/ crypto/ blockchain): z. Only answer YES OR NO. Text: z is relevantno)NNzI want to write an article on this topic in the context of agriculture/ farming/ forestry/ mining (not related to cyptocurrency or blockchain)/ infrastructure/ defence. Do not try to fit all contexts. Use the best context related to the topic: zh Can you cover everything about this topic in 500 words being relevant in 2025. 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