/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 vote133 views1 answer
All python commands list and what they do
Python
0 vote131 views2 answers
Xgbboostclassifier model
Python
0 vote122 views1 answer
Sklearn pipeline with interactions python
Python
2 votes124 views2 answers
Python django query
Python
1 vote140 views1 answer
Flatten a 2d array python
Python
1 vote162 views1 answer
Initialize array of natural numbers python
Python
1 vote178 views1 answer
Django return only part of string
Python
2 votes123 views3 answers
Python datetime no milliseconds
Python
0 vote112 views1 answer
Python invalid syntax for no reason
Python
4 votes165 views2 answers
Django reset database
Python Django