/Python/Make pandas dataframe from elasticsearch

Make pandas dataframe from elasticsearch

Get data from elasticsearch to jupyter

from datetime import datetime
from elasticsearch import Elasticsearch
from pandas import DataFrame, Series
import pandas as pd
import matplotlib.pyplot as plt
es = Elasticsearch(host="192.168.121.252")
res = es.search(index="_all", doc_type='logs', body={"query": {"match_all": {}}}, size=2, fields=('path','@timestamp'))

Source: stackoverflow.com

Make pandas dataframe from elasticsearch

# Create a basic ES client
client = Elasticsearch(['url'])

# Search
search = Search(using=client)

results = search.execute()

search_dict = results.hits.hits

results_df = pd.DataFrame(search_dict)

Source: github.com

Similar codes

2 votes209 views4 answers
How to add column to np array
Python
0 vote197 views1 answer
Python currency format locale
Python
0 vote188 views1 answer
The dropping of sediment by water wind and ice or gravity is known as
Python
1 vote181 views1 answer
For i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):for i in range(0,4):
Python
0 vote211 views1 answer
Readlines replace \n
Python
1 vote208 views1 answer
How to move a column to the beginning in dataframe
Python
0 vote180 views1 answer
Close all tables python
Python
0 vote206 views1 answer
Pyqt5 qtextedit change color of a specific line
Python
-1 vote213 views1 answer
How to use visualize_runtimes
Python
34 votes204 views6 answers
Python to exe converter online
Python