If Marketing files need to be send separtely, code Commented

from send_email import send_mail
import pandas as pd
import os
import re

email_detail_columns = ['filename', 'markets', 'email', 'email1', 'email2', 'email3']
email_details = pd.read_csv('emails_and_files.csv', header=None, names=email_detail_columns, index_col='filename')
report_details_columns = ['Reportname', 'rgm', 'mm', 'cm']
reportname = pd.read_csv('details.csv', names=report_details_columns, index_col='Reportname')

for detail in email_details.index:
    email_ids = []
    files = []
    if re.search(r'region', detail):
        email_ids.append(email_details.loc[detail].email)
        # print(email_details.loc[detail].email)
        markets = email_details.loc[detail].markets.split(';')
        # marketing_files = []
        for report in reportname.index:
            if reportname.loc[report].rgm == 't':
                path = os.path.join(report, 'pdf')
                for r, d, f in os.walk(path):
                    for file in f:
                        if file.replace(' report.csv', '') == detail or (file.replace(' report.csv', '') in markets):#This goes if file.replace(' report.csv', '') == detail
                            files.append(os.path.join(path, file))
                        # elif file.replace(' report.csv', '') in markets:
                        #     marketing_files.append(os.path.join(path, file))


        if files:
            send_mail("[email protected]", '{0} rgm reports'.format(detail), 'PFA', email_ids,
                      files=files)
        # if marketing_files:
        #     send_mail("[email protected]", '{0} rgm associated Marketing reports'.format(detail), 'PFA', email_ids,
        #               files=marketing_files)

    elif detail.startswith('MKT'):
        # email_ids.append(email_details.loc[detail].email)
        # email_ids.append(email_details.loc[detail].email1)
        # email_ids.append(email_details.loc[detail].email2)
        email_ids = [email_details.loc[detail].email, email_details.loc[detail].email1, email_details.loc[detail].email2]

        if type(email_details.loc[detail].email3) == str:
            email_ids.append(email_details.loc[detail].email3)
        for report in reportname.index:
            if reportname.loc[report].mm == 't':
                path = os.path.join(report, 'pdf')
                for r, d, f in os.walk(path):
                    files_without_extension = [file.replace(' report.csv', '') for file in f]
                    if detail in files_without_extension:
                        files.append(os.path.join(path, detail + ' report.csv'))
                send_mail("[email protected]", '{0} mm reports'.format(detail), 'PFA', email_ids,
                          files=files)
    elif re.match(r'^\d\d\d\d', detail):
        email_ids.append(email_details.loc[detail].email)
        for report in reportname.index:
            if reportname.loc[report].cm == 't':
                path = os.path.join(report, 'pdf')
                for r, d, f in os.walk(path):
                    files_without_extension = [file.replace(' report.csv', '') for file in f]
                    if detail in files_without_extension:
                        files.append(os.path.join(path, detail + ' report.csv'))
        send_mail("[email protected]", '{0} cm reports'.format(detail), 'PFA', email_ids, files=files)