/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

0 vote219 views1 answer
Python generate html
Python
5 votes216 views2 answers
How to get first element of array in python
Python
11 votes197 views3 answers
How to do pandas profiling
Python
0 vote230 views1 answer
Changes in settings.py for media storage without db
Python
0 vote211 views1 answer
The entire bee movie script but backwards
Python
130 votes221 views6 answers
Rename columns in dataframe
Python
1 vote219 views1 answer
How to move a column to the beginning in dataframe
Python
1 vote217 views1 answer
Dict to array of string python
Python
0 vote175 views1 answer
Python how to hash string into pbkdf2
Python
3 votes228 views1 answer
Python set return type
Python