【Python】pandas加载数据（部分代码未完成测试）

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全栈工程师特训班》课程