ES Version: 7.10.0
Excel保存格式類似Chrome插件elasticvue的查詢展示格式艰赞,腳本如下:
需安裝兩個(gè)包 pip install elasticsearch pandas
from elasticsearch import Elasticsearch
import pandas as pd
def ExportEsData(excel_path):
# 連接es集群
es = Elasticsearch(
["192.168.2.110"],
http_auth=('elastic', 'xxxxxxx'),
port=9200)
# 指定數(shù)據(jù)查詢DSL
body = {
"query": {
"match_all": {}
},
"sort": [
{
"seq": {
"order": "desc"
}
}
],
"from":0,
"size": 200
}
# 獲取數(shù)據(jù)
query = es.search(index='wechat',
doc_type='_doc',
size=200,
body=body)
results = query['hits']['hits']
# 將 _source 對應(yīng)的value提出來保存至列表
list_dic = []
for dic in results:
dic.update(dic['_source'])
del dic['_source']
list_dic.append(dic)
# 保存至excel
EsData = pd.DataFrame(list_dic, index=[i for i in range(len(list_dic))])
EsData.to_excel(excel_path, index=False)
if __name__ == "__main__":
excel_path='/tmp/b.xlsx'
ExportEsData(excel_path)
Excel 保存格式如下:image.png