get elastic data into pandas dataframe

This 2 lines of code will conncet to Elastic instance hosted in Amazon cloud and download the data from a given index. It will save the data as pandas data frame and also flatten the JSON data to look like an excel spreadsheet.

import eland as ed

df = ed.DataFrame(“https://xxx.us-east-1.es.amazonaws.com:443″, es_index_pattern=”cwl-2020.12.13”)

Powered by WPeMatico