Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Programming Articles
Page 184 of 2547
How to find the number of Blank and Non-Blank cells in the Excel table using Python?
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 MoreHow to find the frequency of a particular word in a cell of an excel table using Python?
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 MoreHow to find the first empty row of an excel file in Python?
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 MoreHow to Copy Odd Lines of Text File to Another File using Python
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 MoreHow to Convert CSV to Excel using Pandas in Python?
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 MoreHow to Find Line Number of a Given Word in text file using Python?
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 MoreHow to Write a List Content to a File using Python?
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 MoreHow to Remove Newline Characters from a text File?
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 MoreHow to Find the Shortest Words in a Text File using Python?
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 MoreHow to Perform Numpy Broadcasting using Python using dynamic arrays?
Broadcasting refers to how NumPy handles arrays of different dimensions during arithmetic operations. The smaller array is "broadcast" across the larger array to ensure compatible shapes for element-wise operations. This vectorizes operations in C rather than Python, making calculations faster and more memory-efficient. Broadcasting eliminates the need for data copies while enabling efficient algorithm implementations. However, it can sometimes lead to memory overhead if not used carefully. Broadcasting Rules NumPy follows specific rules when broadcasting arrays ? Arrays are aligned from the rightmost dimension Dimensions of size 1 can be stretched to match larger dimensions ...
Read More