使用Python向mysql导.sql、.xlsx、.csv方法

import pymysql
import pandas
from subprocess import Popen
from sqlalchemy import create_engine
import pandas as pd

# 导入sql数据
    def mysql_import(self, relative_file_path):
        # sudo ln -s /usr/local/mysql/bin/mysql  /usr/local/bin
        cmd = "mysql -h'{host}' -P'{port}' -u'{user}' -p'{passwd}' -D'stat' < '{file}'".format(host=self.host, port=self.port, user=self.user, passwd=self.passwd, file=relative_file_path)
        try:
            p = Popen(cmd, shell=True)
            p.wait()
            print("成功导入SQL文件【{}】中的数据".format(