import requests

# Fetch the public IP address
response = requests.get("https://api.ipify.org?format=json")

# Print the IP address
if response.status_code == 200:
    print("Colab's Public IP Address:", response.json()["ip"])
else:
    print("Failed to retrieve IP address")

# Define the API URL and API key
GOOGLE_API_KEY = 'YOUR-GOOGLE-API'  # Replace with your actual API key
lat, lon = 14.84238, 101.11501  # Replace with your test coordinates

# Construct the API URL
url = f"https://maps.googleapis.com/maps/api/geocode/json?latlng={lat},{lon}&key={GOOGLE_API_KEY}"

# Send the GET request to the API
response = requests.get(url)

# Check if the API request was successful (status code 200)
if response.status_code == 200:
    print("API request successful!")

    # Parse the JSON response
    data = response.json()

    # Check if 'status' is 'OK'
    if data.get('status') == 'OK':
        print("Geocoding successful. Data received:")
        print(data)  # Print the raw response data
    else:
        print(f"API request successful, but status: {data.get('status')}")
else:
    print(f"API request failed with status code: {response.status_code}")
    print(f"Error message: {response.text}")

import pandas as pd
import requests
import logging
from time import sleep

# Enable logging
logging.basicConfig(level=logging.INFO)

# Mockup data
mockup_data = customer_Lat_long.copy()[['Latitude','Longitude']]
mockup_df = pd.DataFrame(mockup_data)

# Google Geocoding API Key
GOOGLE_API_KEY = 'YOUR-GOOGLE-API'  # Replace with your actual API key

# API rate limit settings
MAX_REQUESTS_PER_MINUTE = 3000
REQUEST_DELAY = 60 / MAX_REQUESTS_PER_MINUTE  # Delay per request

# Function to reverse geocode
def reverse_geocode(lat, lon):
    """
    Convert latitude and longitude into Sub-District (ตำบล), District (อำเภอ), and Province (จังหวัด).
    """
    try:
        # Make API request with language parameter set to Thai
        url = f"https://maps.googleapis.com/maps/api/geocode/json?latlng={lat},{lon}&language=th&key={GOOGLE_API_KEY}"
        response = requests.get(url)
        data = response.json()

        if data['status'] == 'OK':
            sub_district, district, province = 'Unknown', 'Unknown', 'Unknown'

            # Extract address components
            for component in data['results'][0].get('address_components', []):
                if 'locality' in component['types']:  # ตำบล
                    sub_district = component['long_name']
                elif 'administrative_area_level_2' in component['types']:  # อำเภอ
                    district = component['long_name']
                elif 'administrative_area_level_1' in component['types']:  # จังหวัด
                    province = component['long_name']

            return {"Sub-District": sub_district, "District": district, "Province": province}
        else:
            logging.warning(f"No results for coordinates ({lat}, {lon}): {data['status']}")
            return {"Sub-District": "Unknown", "District": "Unknown", "Province": "Unknown"}

    except Exception as e:
        logging.error(f"Error during geocoding for ({lat}, {lon}): {e}")
        return {"Sub-District": "Unknown", "District": "Unknown", "Province": "Unknown"}

# Perform geocoding
results = []
for _, row in mockup_df.iterrows():
    lat, lon = row['Latitude'], row['Longitude']
    result = reverse_geocode(lat, lon)
    results.append(result)
    sleep(REQUEST_DELAY)  # Respect API rate limit

# Combine results with original data
result_df = pd.concat([mockup_df, pd.DataFrame(results)], axis=1)

# Display the result
result_df