/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

1 vote171 views1 answer
Read a function of excel in python
Python
0 vote168 views1 answer
Install sorting
Python
8 votes174 views1 answer
Show more columns / rows of a Pandas DataFrame
Python
9 votes149 views1 answer
Load csv file using pandas
Python
0 vote165 views1 answer
Mechanize python #4
Python
0 vote186 views1 answer
How to work with django ornm __in
Python Django
3 votes147 views1 answer
Python list of random float numbers
Python
0 vote227 views1 answer
Transform jpg image into array for conv2d
Python
-1 vote173 views1 answer
Python port forwarding
Python
6 votes152 views2 answers
Dump json in file python
Python