preview image Programming

Handle Excel file using Python (Part 1)

by Anurag Srivastava , Dec 30, 2019, 11:20:08 AM

In this blog, we are going to explain how Python can be used to handle an Excel sheet. Here we will cover how to add a new sheet, delete an existing sheet, add data to the cell, read data from a sheet. Here I will be using the openpyxl module of Python, we can also use Pandas to play ...

preview image Programming

Handle Excel file using Python (Part 2)

by Anurag Srivastava , Dec 31, 2019, 1:33:53 PM

In the previous blog "Handle Excel file using Python (Part 1)", I have covered how to create the Excel file using Python, add a sheet, add data and view Excel sheet details, etc. Now we w...

preview image Programming

Create a Pie Chart in Kibana

by Anurag Srivastava , Dec 24, 2018, 5:25:28 PM

In this blog, I am going to explain how you can create a pie chart in Kibana to show Apache2 log data captured through Filebeat. So basically I will plot the pie chart to show multiple field values like response code, HTTP method and total bytes sent.We will create a s...

preview image Programming

Introduction to Elasticsearch Aggregations

by Anurag Srivastava , Aug 14, 2018, 4:47:56 PM

Aggregations provide us the option to group and extract statistics from our data. aggregations give the insight of our data and can be used for a wide range of problems like we can use Elasticsearch aggregations for creating a recommendation engine through which we can implement the recommendatio...

preview image Programming

Wildcard and Boolean Search in Elasticsearch

by Anurag Srivastava , Aug 10, 2018, 7:14:40 PM

In my last blog, I have explained basic Elasticsearch queries using which we can create basic search queries. Now in this blog, I will explain advanced search queries using which we can construct more complex queries like boolean queries, wildcard queries, etc. So let's start to create the...

preview image Programming

Bucket Aggregation in Elasticsearch

by Anurag Srivastava , Aug 29, 2018, 7:15:06 PM

Bucket aggregation is like a group by the result of the RDBMS query where we group the result with a certain field. In the case of Elasticsearch, we use to bucket data on the basis of certain criteria. In metrics aggregations, we can calculate metrics on a field while in the bucket ...

preview image Programming

Elasticsearch Rest API

by Anurag Srivastava , Jul 31, 2018, 6:16:42 PM

Elasticsearch provides extensive REST APIs to integrate, query and manage the data. In this blog, I will discuss some of the main APIs which we can use regularly from an extensive list of REST APIs.We can do many things using Elasticsearch REST APIs like:Check our cluster, ...

preview image Programming

Basics of Data Search in Elasticsearch

by Anurag Srivastava , Aug 4, 2018, 7:02:21 AM

Day by day the volume of data is increasing as we are moving towards the digital age and transforming things into the Internet of things. Take a simple example of smartwatch what it does, it measures the steps, BP, heart rate, etc and pushing to a server from where we can access our health...

preview image Programming

Metrics Aggregation in Elasticsearch

by Anurag Srivastava , Aug 18, 2018, 6:02:20 PM

In my previous blog, I have explained about basic aggregation. Now, let us pick the metrics aggregation and see how we can create these types of aggregations. Metrics aggregation are those aggregation where we apply different types of metrics on fields of Elasticsearch documents like min, ...

preview image Programming

How to delete a single file OR all files in folder OR a folder in python

by jitender yadav , Feb 2, 2018, 7:29:35 PM

First how to remove a single file in python from a directory/folder Below is the code and explanation for removing a single file in python:               import os...

Top Blogs

Configure SonarQube Scanner with Jenkins

Jun 21, 2018, 4:58:11 AM | Anurag Srivastava

Build and deploy Angular code using Python

Jun 26, 2018, 4:50:18 PM | Anurag Srivastava

Configure Jenkins for Automated Code Deployment

Jun 13, 2018, 3:44:01 PM | Anurag Srivastava

SonarQube installation on Ubuntu

May 12, 2018, 4:47:07 PM | Anurag Srivastava

Execute Commands on Remote Machines using sshpass

Jul 16, 2018, 5:00:02 PM | Anurag Srivastava

Why SonarQube is important for IT projects ?

Apr 24, 2018, 2:52:28 PM | Anurag Srivastava

Wildcard and Boolean Search in Elasticsearch

Aug 10, 2018, 7:14:40 PM | Anurag Srivastava

Elasticsearch Rest API

Jul 31, 2018, 6:16:42 PM | Anurag Srivastava

Analyze your project with SonarQube

Jun 2, 2018, 10:49:54 AM | Anurag Srivastava

Configure Logstash to send MongoDB data into Elasticsearch

Mar 9, 2019, 8:20:38 AM | Anurag Srivastava