import pandas as pd
import json



# Load the Excel file
df = pd.read_excel("GL Detail Dataset.xlsx")  # Replace with your actual file name

# Load Excel

# Select only relevant columns
gl_df = df[['GL Number', 'Account Name']]

# Drop duplicates to get unique GL Number + Account Name pairs
unique_gls = gl_df.drop_duplicates().sort_values(by='GL Number')

# Print the results
print("✅ Unique GL Number and Account Name pairs:")
print(unique_gls)