PYTHON csv文件导入数据库遇到的问题

UnicodeDecodeError: 'gbk' codec can't decode byte 0xa4 in position 124: illegal multibyte sequence

with codecs.open(file_path, 'rU', encoding='utf-8',errors='ignore') as f：

pymysql.err.DataError: (1366, "Incorrect string value: '\xF0\x9F\x91\x88 d...' for column 'key' at row 22")

还没找到合适的解决方案

import re
def f_emoji(emoji_text):
    try:
        co = re.compile(u'[U00010000-U0010ffff]')
    except re.error:
        co = re.compile(u'[uD800-uDBFF][uDC00-uDFFF]')
    return co.sub('', emoji_text)

finger=emoji.demojize('')
print(finger)
print(emoji.emojize(finger))

#':thumbs_up:'
#