Text
pd.read_table('data/01.txt')
pd.read_csv('data/01.txt')
pd.read_table("data/02.txt")
pd.read_table("data/03.txt")
pd.read_table("data/03.txt", sep=':', header=None)
pd.read_csv("data/03.txt", sep=':', header=None)
pd.read_table("data/03.txt", sep=':', names=['one', 'two', 'three'])
pd.read_csv("data/03.txt", sep=':', names=['one', 'two', 'three'])
CSV
pd.read_csv("data/04.csv")
Excel
pd.read_excel('data/005.xls')
html
pd.read_html('data/06.html', header=0)
MySQL
# pip install pymysql
import pymysql
conn = pymysql.connect(host='localhost', user='root', password='', db='test', charset='utf8')
sql = 'select * from stu'
data = pd.read_sql(sql, conn)
conn.close()
data
MongoDB
# pip install pymongo
import pymongo
client = pymongo.MongoClient('172.16.91.1',27017)
client
db = 'film'
table = 'film'
cursor = client[db][table].find()
data2 = pd.DataFrame(list(cursor))
data2
注:代码来自《Python全栈工程师特训班》课程