/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 vote383 views2 answers
Django forms error customize
Python Django
9 votes344 views5 answers
Join to dataframes pandas
Python
1 vote309 views1 answer
Numpy random float array between 0 and 1
Python
0 vote329 views1 answer
Rotate image pyqt5
Python
6 votes377 views4 answers
Pandas read csv without header
Python
9 votes345 views1 answer
Flask tutorials
Python
0 vote281 views1 answer
Convert pandas.core.indexes.numeric.int64index to list
Python
4 votes362 views2 answers
Loginrequiredmixin django
Python Django
0 vote331 views2 answers
Numpy array into tuple
Python
0 vote311 views2 answers
I want to check my python code online
Python