/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 vote192 views1 answer
Asyncio
Python
0 vote297 views1 answer
Sneon dr pepper
Python
2 votes197 views1 answer
Python pi value
Python
-1 vote201 views1 answer
Python "in magic method"
Python
2 votes212 views1 answer
Boto signed url
Python
1 vote227 views2 answers
How to remove the very last character of a text file in python
Python
3 votes192 views2 answers
Multiple Regression in Python
Python
0 vote199 views1 answer
Python random real
Python
6 votes255 views1 answer
Selectfield flask wtf
Python Flask
5 votes195 views2 answers
How to get the local time in python
Python