整合小文档：dataframe直接或间接读取mysql形式

1、直接

import pymysql
import pandas as pd
from sqlalchemy import create_engine

def GetQueryByDF(sql):
    
    connect_info = 'mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8'\
        .format("user", "passwd", "hostname", "port","dbname")
    engine = create_engine(connect_info)
    result = pd.read_sql(sql, engine)
    return result

GetQueryByDF("select a.movie_num,a.title,a.language,a.area,a.director,a.type,a.tv_describe,(case a.vtype_sub when '0' then '电视剧' when '1' then '纪录片' end) as type,group_concat(b.crew_name SEPARATOR ',') as crew from hx_online_tv a join hx_crew_images_formal b on a.movie_num = b.movie_num GROUP BY b.movie_num;")

2、间接

import pymysql

import pandas as pd


conn = pymysql.connect(host='p', user='w', password='c', port=3306,
                    db&#