In this article, we will show you how to print all the lines that contain a given specific string in a given text file using python. Assume we have taken a text file with the name ExampleTextFile.txt consisting of some random text. We will return the lines from a text ... Read More

In this article, we will show you how to find the most repeated word in a given text file using python. Assume we have taken a text file with the name ExampleTextFile.txt consisting of some random text. We will return the most repeated word in a given text file ExampleTextFile.txt ... Read More

In this article, we will show you how to print all the longest words from a given text file using python. The longest words are the words which are having the same length as the longest word (maximum length) in a text file. Assume we have taken a text file ... Read More

In this article, we will show you how to split the list and insert those into an excel file using python. Assume we have taken a static list and split that list and insert those list items into an excel file, by returning an excel file say outputExcelFile.xlsx containing the ... Read More

In this article, we will show you how to get all the sheet names found in an excel file using python openpyxl library. Assume we have taken an excel file with the name sampleTutorialsPoint.xlsx containing multiple sheets with some random data. We will return all the sheet names found in ... Read More

In this article, we will show you how to get all the row values of a particular column in an excel file using the python openpyxl library. Assume we have taken an excel file with the name sampleTutorialsPoint.xlsx containing some random data. We will return all the row values of ... Read More

In this article, we will show you how to find the count of a number of blank and non-blank (filled) cells in an excel worksheet using python. Assume we have taken an excel file with the name demoTutorialsPoint.xlsx containing some random data with some blank cells. We will return the ... Read More

In this article, we will show you how to find the frequency (number of times the word occurs) of a specific word in a cell of a given excel file using python. Assume we have taken an excel file with the name TutorialsPoint.xlsx containing some random data. We will return ... Read More

In this article, we will show you how to find the index of a first empty row of a given excel file using python. Assume we have taken an excel file with the name demoTutorialsPoint.xlsx containing some random data with some empty rows. We will return the index of the ... Read More

In this article, we will show you how to copy only odd lines of a text file to another text file using python. Assume we have taken a text file with the name TextFile.txt consisting of some random text. We need to copy just all the odd lines of a ... Read More