def export_data():

         infos = [
                 'Conta Corrente Itau',
                 'Cartao Itau Master',
                 'Cartao Itau VISA',
                 'Carteira'
                 ]

        chart_of_accounts = list(infos)

        for account in chart_of_accounts:
            cnx = mariadb.connect(user='root', password='', database='base_completa')
            cursor = cnx.cursor()
            params = (account, account)
            query = """
                    SELECT Y, M,(@total := @total + Fluxo) AS ValorTotal
                    FROM (
                    SELECT year(data) AS Y, month(data) AS M,
                            (
                                SUM(IF(Credito="%s", valor, 0))-
                                SUM(IF(Debito="%s", valor, 0))
                            ) AS Fluxo
                        FROM ledger
                        GROUP BY YEAR(DATA), MONTH(DATA)
                        ) AS T,
                    (SELECT @total:=0) AS n;
                    """ % (params)

            cursor.execute(query)
            rows = cursor.fetchall()
            desc = cursor.description

            lista = [dict(itertools.izip([col[0] for col in desc], row))
                for row in rows]

            cnx.commit()

            print account
            print json.dumps(lista)

        return lista

    results = export_data()

cursor.execute(query, (chart_of_accounts[account] for account in chart_of_accounts))

SUM(IF(Credito=""Conta Corrente Itau"", valor, 0))

SUM(IF(Credito="%s", valor, 0))

params = (account, account)

with open(file_location+'\' + 'file_name' +'.sql','r') as inserts:
        sqlScript = inserts.read()
        for statement in sqlScript.split(';'):
            with cnx.cursor() as cur:
                cur.execute(statement)

    query="Select * from output_table"

df=pd.read_sql_query(query, cnx)

Select * from output_table

params = (account, account)