Posts by Sadhu Meghana
Author Biographical Info: Interested in Python, Machine Learning, and Web development.
Merge two excel files using openpyxl in Python
In this tutorial, we will learn how to merge two excel files into one file using openpyxl in Python. To achieve this we are using ExcelWriter() method of pandas. It has a parameter.... Read More
Select a specific range of cells in openpyxl Python
In this tutorial, we will learn how to get a range of cells from an excel sheet using openpyxl module of Python. We are going to use worksheet.cell() method to achieve this. We can.... Read More
Create and use a global variable in a function in Python
In this tutorial, we will learn about global variables and their usage. Python uses variables to hold data. Variables created outside the function or in the global scope are called.... Read More
Change sheet name using openpyxl in Python
In this tutorial, we will learn how to change sheet names using openpyxl in Python. We already know that each workbook can have multiple sheets. Let’s consider a workbook wit.... Read More
How does numpy.histogram2d works in Python
In this tutorial, we will understand what numpy.histogram2d is and how it works in Python. The Numpy library contains many functions which perform mathematical operations with arra.... Read More
Creating a line chart using Openpyxl in Python
In this tutorial, we will learn how to draw line charts using openpyxl in Python. Python provides openpyxl library using which we can perform operations like reading, writing, and .... Read More
Iterate through columns using iter_cols of openpyxl
In this tutorial, we will learn how to iterate through columns in an excel sheet in Python. To achieve this, we use the iter_cols() method of openpyxl module. Python provides the o.... Read More
Transform Pandas columns using map and apply
In this tutorial, we will use map() and apply() methods to transform Pandas columns. While working with datasets, there will be many situations where you need to transform and mani.... Read More