1 利用python读取MySQL数据库中的表格
from sqlalchemy import create_engine
import pandas as pd
connect = create_engine('mysql+pymysql://root:123@localhost:3306/')
train_data = pd.read_sql_table('train',connect,schema='titanic')
test_data = pd.read_sql_table('test',connect,schema='titanic')
gender_submission_data = pd.read_sql_table('gender_submission',connect,schema='titanic')
输出结果如下:
2 虚拟环境
查看虚拟环境:conda info --envs
创建虚拟环境: conda create -n automl python==3.9
激活/切换虚拟环境: conda activate automl
删除虚拟环境: conda env remove --name automl