导入数据
读取CSV
pd.read_csv('file.csv', name=['列名','列名2'])
pd.read_csv('c:/mydata/jit.csv',encoding='gb18030')
sql 读取
pd.read_sql(query, connection_object)
import pymysql
conn=pymysql.connect(host='127.0.0.1', user='root', passwd='root', db=' employee')
sql='select * from employee'
pd.read_sql(sql, conn)
从限定分隔符的文本文件导入数据
pd.read_table(filename, header=0)
Excel 导入
pd.read_excel('file.xlsx', sheet_name=' 表1', header=0)
JSON 导入
pd.read_json(json_string)
URL
pd.read_html(url)
粘贴板
pd.read_clipboard()
字典对象导入
pd.DataFrame(dict)
导入字符串
from io import StringIO
pd.read_csv(StringIO(web_data.text))