pandas数据导入：
1 import pymysql
2 import pandas as pd
3
4 #导入csv文件
5 data = pd.read_csv('file_name')
6
7 #导入excel文件
8 data = pd.read_excel('file_name')
9
10 #从mysql导入数据
11 conn = pymysql.connect(
12 host = '127.0.0.1',
13 user = 'user_name',
14 password = 'password'
15 db = 'db_name')
16 sql = 'SELECT * FROM tb_name'
17 data = pd.read_sql(sql, conn)
18
19 #转为DataFrame类型
20 df = pd.DataFrame(data)
