def METHOD_NAME(con, index):
    table = con.table("array_table")
    expr = table[table.array_int[index].name("indexed")]
    result = expr.execute()
    df = table.compile().toPandas()
    expected = pd.DataFrame(
        {
            "indexed": df.array_int.apply(
                lambda x: x[index] if -len(x) <= index < len(x) else np.nan
            )
        }
    )
    tm.assert_frame_equal(result, expected)