/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

11 votes268 views3 answers
Python set windows environment variable
Python
0 vote277 views1 answer
Python string remove accent
Python
16 votes250 views6 answers
Map in python
Python
1 vote255 views1 answer
Fill na with mode and mean python
Python
3 votes264 views2 answers
AttributeError: module 'tensorflow' has no attribute 'placeholder'
Python
4 votes229 views2 answers
Check installed django version
Python Django
0 vote262 views1 answer
Make blinking text python
Python
1 vote254 views1 answer
How to remove python3 on mac
Python
2 votes261 views1 answer
Fromkeys in python
Python
0 vote264 views1 answer
Django project files
Python