/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 vote111 views1 answer
Python delete dict key if exists
Python
1 vote144 views1 answer
Django add to cart
Python Django
13 votes128 views2 answers
Pip version command
Python
22 votes117 views5 answers
How to check if a word is a palindrome in python
Python
0 vote109 views1 answer
X y coordinates in python
Python
11 votes95 views6 answers
Venv activate windows
Python
0 vote114 views1 answer
Remove inner list from outer list python
Python
0 vote176 views1 answer
|safe django
Python Django
0 vote130 views1 answer
Python euler
Python
0 vote107 views1 answer
If settings.debug
Python