pandas 操作mongdb excel

# -*- encoding: utf-8 -*-
import pymongo
import pandas as pd

# 链接mongdb
client = pymongo.MongoClient('localhost', 27017)

# 数据库名字
db = client['research']

# 表名
pk10 = db['highway_name']

# 从excel中读数据到Pandas
# excel名称
#excelFile = r''
#df = pd.DataFrame(pd.read_excel(excelFile))

# 加载数据到Pandas中
data = pd.DataFrame(list(pk10.find()))

# 删除mongdb中_id字段
del data['_id']

# 选择需要显示的字段
#data = data[['date', 'num1', 'num10']]
print data

# 写入excel
df = data.to_excel('/home/highway_name.xlsx')