#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import pandas as pd
import sys
import re

if sys.platform == 'win32':
    import io
    sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8')

df = pd.read_excel('پایگاه داده با فروش قبلی.xlsx', nrows=10)

print("Sample phone numbers from Excel:")
for idx, row in df.iterrows():
    phone = row.get('تلفن همراه مشتری')
    print(f"Row {idx}: {phone} (type: {type(phone)})")
    if pd.notna(phone):
        phone_str = str(phone)
        print(f"  As string: '{phone_str}'")
        print(f"  Starts with 0: {phone_str.startswith('0')}")

