/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

33 votes149 views6 answers
Bs4 python
Python
4 votes128 views2 answers
Sum of array using recursion in python
Python
0 vote139 views1 answer
Switch case dictionary python
Python
4 votes186 views2 answers
Python read array line by line
Python
4 votes167 views1 answer
Replace multi spaces with single space
Python
1 vote152 views1 answer
Python filter list of int and strings
Python
2 votes136 views1 answer
How to add captcha in django forms
Python
0 vote139 views1 answer
How to get image object from array in python
Python
0 vote182 views1 answer
Exception Type: AssertionError Exception Value: Expected a `Response`, `HttpResponse` or `HttpStreamingResponse` to be returned from the view, but received a `<class 'django.db.models.query.QuerySet'>`
Python Django
4 votes132 views1 answer
Python int binary
Python