Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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
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 text file into another and print them. 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 a joy Algorithm (Steps) Following are the Algorithm/steps to be followed to perform the desired task ... Read More
Python makes it simple to create new files, read existing files, append data, or replace data in existing files. With the aid of a few open-source and third-party libraries, it can manage practically all of the file types that are currently supported. We must iterate through all the necessary files, collect their data, and then add it to a new file in order to concatenate several files into a single file. This article demonstrates how to use Python to concatenate multiple files into a single file. Using Loops A list of filenames or file paths to the necessary python files ... Read More
You might wish to perform a specific action in a Python script only if a file or directory is present or not. For instance, you might wish to read from or write to a configuration file, or only create the file if it doesn't already exist There are many different ways to check if a file exists and figure out what kind of file it is in Python. Using OS Module An inbuilt Python module called Os has tools for dealing with the operating system. We can access operating system features by using os. In Python, os.path is a sub-module ... Read More
By utilising the pwd, grp, and os modules, you can modify the owner of a file or directory. To obtain the user ID from the user name, to obtain the group ID from the group name string, and to modify the owner, one uses the uid module. Following are the methods to change the owner of a directory using Python − Using os.chown() Method To change the owner and group id of the given path to the specified numeric owner id (UID) and group id(GID), use Python's os.chown() method. Syntax os.chown(filepath, uid, gid, *, dir_fd = None, follow_symlinks = True) ... Read More
The user whose actions are allowed on a file are governed by its file permissions. A file's permissions for reading, writing, and executing are modified when the file's permissions are changed. This article will cover how to change a file's permission in Python. Using os.chmod() Method To modify the permissions of a file, use the os.chmod () method. Syntax Following is the syntax for os.chmod() method − os.chmod(path, mode) Where, path represents the path of the file and mode contains different values as explained below. There is no return value obtained in this method. Os.chmod() modes Following are the ... 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. Assume we have taken an excel file with the name ExampleCsvFile.csv containing some random text. We will return a CSV File after converting the given excel file into a CSV file. ExampleCsvFile.csv Player Name Age Type Country Team Runs Wickets Virat Kohli 33 Batsman India Royal Challengers Bangalore 6300 20 Bhuvneshwar Kumar34 Batsman India Sun Risers Hyderabad 333 140 Mahendra Singh Dhoni 39 Batsman India Chennai ... Read More
Python has built-in functions for creating, reading, and writing files, among other file operations. Normal text files and binary files are the two basic file types that Python can handle. We'll look at how to write content into text files in Python in this article. Steps involved writing multiple lines in a text file using Python Following are the ways to write multiple lines in text file using Python − The open() method must be used to open the file for writing, and the function must be given a file path. The following step is to write to file. ... Read More
Directories and files can be deleted using Python's built-in modules and functions. Removing files or directories is a significant process since, after you've destroyed a directory, it's difficult to get its contents back. Therefore, users can remove the directory and its contents without much difficulty by applying a few useful Python functions. Python has the following functions for removing a directory or folder − Using os.rmdir() function Python uses the os.rmdir() function to delete empty directories. In this scenario, the required directory must be empty; else, an OSError would be raised. If the directory doesn't exist, the FileNOtFoundError is thrown. ... Read More