Generate bugs to verify from bugzilla CSV by state

bug_status_by_state.py

import os
import pandas as pd
import pysiv.toolbook as tb

_STATES = ("RESOLVED", "ASSIGNED", "FIXED")

def make_bug_summary(csv_file_name, output_image, state="RESOLVED"):
    if state not in _STATES:
        raise ValueError("Unsupported state {s}".format(s=state))
    
    df = pd.DataFrame.from_csv(csv_file_name)
    sdf = df[df.bug_status == state]
    
    fig, ax = tb.get_fig_axes(dims=(8, 6))
    
    assigned_to = sdf.assigned_to.values
    user_name = [x.split('@')[0] for x in assigned_to]
    sdf['user_name'] = user_name
    sdf.groupby('user_name').user_name.count().plot(kind="barh", ax=ax, color="red", alpha=0.75)
    ax.set_ylabel("User name")
    ax.set_xlabel("Number of bugs to Verify")
    fig.savefig(output_image, dpi=240)
    return fig, ax