Excell to Elasticsearch with Python

Hi everyone; With this article we will convert excell file to csv file using python. After convert operation We will transfer data from csv to elasticsearch using python. By the way, Elasticsearch has security configuration. That is why we have to get “http_ca.crt” file from server elasticsearch is allready installed.

Just install this prerequest packages using pip.

pip install elasticsearch
pip install pandas

Here is the Python code.

--

--

I am writing about Sql Server, Elasticsearch and Python. İ am an Database Administrator on SQL Server and Elasticsearch more than 5+ years.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
HKN MZ

I am writing about Sql Server, Elasticsearch and Python. İ am an Database Administrator on SQL Server and Elasticsearch more than 5+ years.