/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 vote315 views1 answer
KeyError: 'PROJ_LIB'
Python
0 vote289 views1 answer
How to get one csv column in python
Python
10 votes338 views3 answers
Convert a dictionary into dataframe python
Python
1 vote296 views2 answers
List all virtualenv in python
Python
0 vote327 views1 answer
Python datetime add one week
Python
0 vote261 views1 answer
Pyqt5 qpush button pressed
Python
0 vote296 views1 answer
Get unique words from pandas dataframe
Python
2 votes278 views3 answers
Roll dice python
Python
4 votes299 views1 answer
How to calculate rmse in linear regression python
Python
1 vote382 views1 answer
How to use one with as statement to open two files python
Python