def join_experiments_file_table(exp_table, file_table):
    """
    Joins the experiments and files table to make a merged table, which has
    information about each experiment and the files associated with it.
    """
    file_table["Experiment"] = \
        file_table["Dataset"].str.split("/").apply(lambda l: l[2])
    merged = exp_table.merge(
        file_table, left_on="Accession", right_on="Experiment",
        suffixes=("_exp", "_file")
    )
    return merged