/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 vote294 views1 answer
Rewrite the equation shown in Figure 2.4 as a Python expression and get the result of the equation: Pay special attention to the order of operations.
Python
3 votes251 views1 answer
Pandas remove char from column
Python
0 vote278 views1 answer
1d random walk in python stack exchange
Python
0 vote260 views1 answer
Pandas swapaxes example
Python
6 votes295 views4 answers
Get number in string python
Python
6 votes268 views3 answers
Pandas.core.series.series to dataframe
Python
2 votes258 views1 answer
How to save query data into dataframe pscopg2
Python
168 votes362 views6 answers
How to upgrade pip in python
Python
0 vote269 views1 answer
Python attributes from string
Python
1 vote270 views1 answer
How to fix turtle has no member
Python