/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

3 votes145 views2 answers
Isalnum python
Python
45 votes165 views2 answers
String to datetime convert
Python
2 votes229 views2 answers
Super in django manager
Python Django
0 vote146 views1 answer
Find the median of input number in a list and print
Python
0 vote125 views1 answer
Change colour of control maya python
Python
3 votes132 views2 answers
Python generators
Python
0 vote141 views2 answers
Detect Word Then Send Message (discord.py)
Python
1 vote171 views1 answer
Python tts
Python
4 votes177 views1 answer
How To Exit Console On Python
Python
0 vote172 views1 answer
How to keep old content when using write in python
Python