# Get elevation data

if 'lat' in data.columns and 'long' in data.columns:
    # Fetch elevation for each row
    def fetch_elevation(row):
        url = f"https://api.open-elevation.com/api/v1/lookup?locations={row['lat']},{row['long']}"
        response = requests.get(url)
        if response.status_code == 200:
            return response.json()['results'][0]['elevation']
        return None

    data['elevation'] = data.apply(fetch_elevation, axis=1)
else:
    print("Latitude and/or Longitude columns are missing in the dataset.")

data.head()

# Function to generate summary for a location's reviews
def summarize_reviews(reviews, location_name):
    prompt = f"""
    You are an expert summarizer. Below are reviews for a location named '{location_name}':

    {reviews}

    Provide a 3 sentence summary capturing the key insights from these reviews, focusing on common themes, strengths, or weaknesses.
    Don't need to include things like 'Here's a 3 sentence summary capturing the key insights from these reviews:' or 'Here's a summary' in your response.  Provide the summary directly.

    Write the summary in a friendly and engaging tone, as if you are recommending this location to a friend. Extract general sentence summary based on what reviewers are saying.  Don't mention names and don't plagiarize directly from the review.  Use unique words and keep it casual.  The goal is to give a neutral description of the campsite. Avoid using the word 'review' in the summary.  Only include things that are mentioned in the reviews.  Don't make up things that are not mentioned in the reivews.
    Make sure to include the {location_name} in the first sentence of the summary.
    
    """
    try:
        response = ollama.generate(model='llama3.2:3b', prompt=prompt)
        return response['response'].strip()
    except Exception as e:
        logging.error(f"Summary failed for {location_name}: {e}")
        return "Summary unavailable due to processing error."