Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
In this article, we will show you how to get all the sheet names found in an excel file using Python's 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. Sample Excel File Structure Our example file sampleTutorialsPoint.xlsx contains three sheets: firstSheet Player Name Age ... Read More
Excel files often contain blank cells, and counting these cells is a common requirement for data validation and analysis. Python's xlrd module provides an efficient way to read Excel files and count blank and non-blank cells. Assume we have an Excel file named sampleTutorialsPoint.xlsx containing cricket player data with some blank cells. We will count both empty and filled cells in the worksheet. Sample Data Here's our sample Excel file structure ? Player Name Age Type Country Team Runs Wickets Virat Kohli Batsman India Royal Challengers Bangalore 20 ... Read More
Finding the frequency of a specific word in Excel cells is useful for data analysis and text processing. Python's pandas library provides an efficient way to read Excel files and count word occurrences. We'll demonstrate using a sample Excel file sampleTutorialsPoint.xlsx containing cricket player data. Sample Excel Data Player Name Age Type Country Team Runs Wickets Virat Kohli 33 Batsman India Royal Challengers Bangalore 6500 20 Mahendra Singh Dhoni 39 Batsman India Chennai Super Kings 4600 0 Rashid Khan 24 Bowler Afghanistan Gujarat Titans 500 130 Hardik ... Read More
In this article, we will show you how to find the index of the first empty row in an Excel file using Python. This is useful for data processing tasks where you need to identify gaps in your data or find where to insert new records. We'll work with a sample Excel file called sampleTutorialsPoint.xlsx containing cricket player data with some empty rows ? 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 ... 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. This is useful when you need to extract every alternate line starting from the second line. Assume we have a text file named TextFile.txt with some sample content. We need to copy all the odd-numbered lines (2nd, 4th, 6th, etc.) to another file. Sample Input File TextFile.txt Good Morning This is the Tutorials Point sample File Consisting of Specific source codes in Python, Seaborn, Scala Summary and Explanation Welcome everyone Learn with ... Read More
In this article, we will show you how to convert a CSV file (Comma Separated Values) to an Excel file using the pandas module in Python. This is useful when you need to transform data into Excel format for reporting or sharing purposes. We'll use a sample CSV file called ExampleCsvFile.csv containing cricket player data to demonstrate the conversion process. Sample Data Our example CSV file contains the following player statistics ? Player Name Age Type Country Team Runs Wickets Virat Kohli 33 Batsman India Royal Challengers Bangalore 6300 20 ... Read More
In this article, we will show you how to find the line number where a specific word appears in a text file using Python. This is useful for searching keywords in documents, logs, or code files. Let's assume we have a text file named TextFile.txt with the following content ? 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 Following are the steps to find line numbers containing a specific word ? Open the ... Read More
In this article, we will show you how to write list data to a text file using Python. There are several methods to accomplish this task, each with different formatting options. Writing List Elements Line by Line The most common approach is to write each list element on a separate line using a loop ? # Input list input_list = ['This', 'is', 'a', 'TutorialsPoint', 'sample', 'file'] # Write list elements to file (one per line) with open("ListDataFile.txt", 'w') as filedata: for item in input_list: ... Read More
When working with text files in Python, you often encounter newline characters () at the end of each line. This article demonstrates how to remove these newline characters using Python's built-in methods. Let's assume we have a text file called TextFile.txt with the following content: 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 Approach 1: Using rstrip() with List Comprehension The most common approach combines readlines() with rstrip() and list comprehension ? # Create a ... Read More
In this article, we will show you how to find and print all the shortest words from a given text file using Python. The shortest words are those having the same length as the minimum length word in the file. We'll work with a sample text file containing various words of different lengths and extract all words that match the shortest length. Sample Text File Let's assume we have a text file called TextFile.txt with the following content ? Good Morning Tutorials Point This is the Tutorials Point sample File Consisting of Specific abbreviated source ... Read More