import pandas as pd
path = r'D:\Evolução categorias\temp_bd2.xlsx'
df = pd.read_excel(path, sheet_name='Planilha1', header=None)
raw_dates = df.iloc[0, 1:].tolist()

print("Meses de Abril encontrados:")
for i, d in enumerate(raw_dates):
    try:
        ts = pd.Timestamp(d)
        if pd.notna(ts) and ts.month == 4:
            col = i + 1
            lbl = ts.strftime('%b/%Y')
            vals = [df.iloc[r, col] for r in range(2, 6)]
            print(f"  {lbl} (col {col}): {vals}")
    except:
        pass

print()
print("Todos os meses no dataset:")
labels = []
for i, d in enumerate(raw_dates):
    try:
        ts = pd.Timestamp(d)
        if pd.notna(ts):
            labels.append(ts.strftime('%b/%Y'))
    except:
        pass
print(labels)