In this article, we will show you how to read and print the first N lines of a text file for the given N value using python. Assume we have taken a text file with the name ExampleTextFile.txt consisting of some random text. We will return the first N lines of a text file for the given N value. ExampleTextFile.txt Good Morning Tutorials Point This is Tutorials Point sample File Consisting of Specific abbreviated source codes in Python Seaborn Scala Imagination Summary and Explanation Welcome user Learn with a joy Algorithm (Steps) Following are the Algorithm/steps to be followed ... Read More

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 file containing a given particular string from a text file. ExampleTextFile.txt Good morning to TutorialsPoint This is TutorialsPoint sample File Consisting of Specific source codes in Python, Seaborn, Scala Summary and Explanation Welcome to TutorialsPoint Learn with a joy Good morning to TutorialsPoint Algorithm (Steps) Following are the Algorithm/steps ... 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 Good Morning TutorialsPoint This is TutorialsPoint sample File Consisting of Specific source codes in Python, Seaborn, Scala Summary and Explanation Welcome TutorialsPoint Learn with a joy Algorithm (Steps) Following are the Algorithm/steps to be followed to perform the desired task − Import the Counter function (The Counter class ... 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 with the name ExampleTextFile.txt consisting of some random text. We will return all the longest words from a given text file. ExampleTextFile.txt Good Morning Tutorials Point This is Tutorials Point sample File Consisting of Specific abbreviated source codes in Python Seaborn Scala Imagination Summary and Explanation Welcome user Learn with ... 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 below output. outputExcelFile.xlsx Player Name Country Virat Kohli India Bhuvaneshwar Kumar India Mahendra Singh Dhoni India Rashid Khan Afghanistan Hardik Pandya India David Warner Australia West Indies Kieron Pollard India Rohit Sharma ... 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 a given particular column in an excel file. sampleTutorialsPoint.xlsx Player Name Age Type Country Team Runs Wickets Virat Kohli 33 Batsman India Royal Challengers Bangalore 6300 20 Bhuvaneshwar Kumar 34 Batsman India Sun Risers Hyderabad 333 140 Mahendra Singh Dhoni 39 Batsman ... 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 a given excel file using the sheetnames attribute. sampleTutorialsPoint.xlsx firstSheet Player Name Age Type Country Team Runs Wickets Virat Kohli 33 Batsman India Royal Challengers Bangalore 6300 20 Bhuvaneshwar Kumar 34 Batsman India Sun Risers Hyderabad 333 140 Mahendra Singh Dhoni 39 ... 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 count of a number of blank and non-blank (filled) cells in an excel worksheet. sampleTutorialsPoint.xlsx Player Name Age Type Country Team Runs Wickets Virat Kohli Batsman India Royal Challengers Bangalore 20 34 Batsman India Sun Risers Hyderabad 333 140 ... 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 the frequency of a given word in a cell of a given excel file. sampleTutorialsPoint.xlsx Player Name Age Type Country Team Runs Wickets Virat Kohli Batsman India Royal Challengers Bangalore 20 34 Batsman India Sun Risers Hyderabad 333 140 ... 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 first empty row in an excel worksheet. sampleTutorialsPoint.xlsx Player Name Age Type Country Team Runs Wickets Virat Kohli 33 Batsman India Royal Challengers Bangalore 6300 20 Bhuvaneshwar Kumar 34 Batsman India Sun Risers Hyderabad 333 140 Mahendra Singh Dhoni 39 Batsman India ... Read More