/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 vote168 views1 answer
Select rainfall events and calculate rainfall event total from time-series data
Python
0 vote157 views1 answer
Discord.py get client avatar
Python
12 votes166 views1 answer
How to create an env to use in vs code using anaconda
Python
0 vote176 views1 answer
Tb to pb with python calculator
Python
0 vote167 views1 answer
Time in regression expression python
Python
71 votes194 views6 answers
Python ide online
Python
0 vote160 views1 answer
500 dollars to naira
Python
2 votes176 views1 answer
Google calendar Request had insufficient authentication scopes.
Python
28 votes164 views1 answer
'utf-8' codec can't decode byte 0x85 in position 715: invalid start byte
Python
6 votes163 views2 answers
Read data from yaml file in python
Python