use a dict cursor.

gistfile1.py

import pymysql
from contextlib import contextmanager
#from contextlib import contextmanager


@contextmanager
def create_dict_cursor():
    with pymysql.connect(user='root', passwd='goodboy', host='127.0.0.1', cursorclass=pymysql.cursors.DictCursor) as cursor:
        yield cursor


with create_dict_cursor() as cursor:
    cursor.execute('show slave status')
    for i in cursor: print i