app.py

from smolagents import CodeAgent,DuckDuckGoSearchTool, HfApiModel,load_tool,tool
import datetime
import requests
import pytz
import yaml
import pandas as pd
from tools.final_answer import FinalAnswerTool
from tools.visit_webpage import VisitWebpageTool

from Gradio_UI import GradioUI

 
@tool
def GetElectricityCutInfo(locationName: str) -> str:
    """A tool that searches for electricity cut information by City or District from an Excel file.
    Args:
        locationName: The name of the City or District to search for (e.g., 'Beşiktaş' or 'İzmir').
    """
    try:
        # Excel dosyasını oku (Dosya adının 'kesintiler.xlsx' olduğunu varsayıyorum)
        df = pd.read_excel("kesintiler.xlsx")
        
        # Karşılaştırma kolaylığı için tüm tabloyu ve aranan kelimeyi küçük harfe çevirelim
        search_term = locationName.lower().strip()
        
        # Hem 'İl' hem de 'İlçe' sütununda arama yapalım
        # Not: Sütun isimlerinin Excel'de 'İl', 'İlçe', 'Kesinti', 'Açıklama' olduğundan emin ol.
        result = df[
            (df['İl'].astype(str).str.lower() == search_term) | 
            (df['İlçe'].astype(str).str.lower() == search_term)
        ]
        
        if not result.empty:
            responses = []
            for _, row in result.iterrows():
                info = f"📍 {row['İl']} - {row['İlçe']}: Kesinti {row['Kesinti']}. Bilgi: {row['Açıklama']}"
                responses.append(info)
            return "\n".join(responses)
        else:
            return f"'{locationName}' için sistemde bir kesinti kaydı bulunamadı."
            
    except Exception as e:
        return f"Veri okunurken hata oluştu: {str(e)}"

@tool
def get_current_time_in_timezone(timezone: str) -> str:
    """A tool that fetches the current local time in a specified timezone.
    Args:
        timezone: A string representing a valid timezone (e.g., 'America/New_York').
    """
    try:
        # Create timezone object
        tz = pytz.timezone(timezone)
        # Get current time in that timezone
        local_time = datetime.datetime.now(tz).strftime("%Y-%m-%d %H:%M:%S")
        return f"The current local time in {timezone} is: {local_time}"
    except Exception as e:
        return f"Error fetching time for timezone '{timezone}': {str(e)}"


final_answer = FinalAnswerTool()
visit_webpage = VisitWebpageTool()

# If the agent does not answer, the model is overloaded, please use another model or the following Hugging Face Endpoint that also contains qwen2.5 coder:
# model_id='https://pflgm2locj2t89co.us-east-1.aws.endpoints.huggingface.cloud' 

model = HfApiModel(
max_tokens=2096,
temperature=0.5,
model_id='Qwen/Qwen2.5-Coder-32B-Instruct',# it is possible that this model may be overloaded
custom_role_conversions=None,
)


# Import tool from Hub
image_generation_tool = load_tool("agents-course/text-to-image", trust_remote_code=True)

with open("prompts.yaml", 'r') as stream:
    prompt_templates = yaml.safe_load(stream)
    
agent = CodeAgent(
    model=model,
    tools=[
        final_answer,
        GetElectricityCutInfo
    ],        
    max_steps=6,
    verbosity_level=1,
    grammar=None,
    planning_interval=None,
    name=None,
    description=None,
    prompt_templates=prompt_templates
)


GradioUI(agent).launch()