How to delete a CSV file in Python?

How to delete a CSV file in Python?

Last Updated : 13 Jan, 2021

In this article, we are going to delete a CSV file in Python. CSV (Comma-separated values file) is the most commonly used file format to handle tabular data. The data values are separated by, (comma). The first line gives the names of the columns and after the next line the values of each column.

Approach :

Import module.
Check the path of the file.
If the file is existing then we will delete it with os.remove().

Syntax : os.remove('Path)

Example 1: Deleting specific csv file.

Python3

# Python program to delete a csv file 
# csv file present in same directory
import os

# first check whether file exists or not
# calling remove method to delete the csv file
# in remove method you need to pass file name and type
file = 'word.csv'
if(os.path.exists(file) and os.path.isfile(file)):
  os.remove(file)
  print("file deleted")
else:
  print("file not found")

Output:

file deleted

Example 2: Deleting all csv files in a directory

We can use the os.walk() function to walk through a directory and delete specific files. In the example below, we will delete all ‘.csv’ files in the given directory.

Python3

import os
for folder, subfolders, files in os.walk('csv/'): 
      
    for file in files: 
        
        # checking if file is 
        # of .txt type 
        if file.endswith('.csv'): 
            path = os.path.join(folder, file) 
              
            # printing the path of the file 
            # to be deleted 
            print('deleted : ', path )
            
            # deleting the csv file 
            os.remove(path)

Output:

deleted :  csv/Sample1.csv
deleted :  csv/Sample2.csv
deleted :  csv/Sample3.csv
deleted :  csv/tips.csv

How to delete a CSV file in Python?

R

rajatagrawal5

Improve

Article Tags :

Practice Tags :

python

Similar Reads

How to delete data from file in Python

When data is no longer needed, itâ€™s important to free up space for more relevant information. Python's file handling capabilities allow us to manage files easily, whether it's deleting entire files, clearing contents or removing specific data.For more on file handling, check out:File Handling in Pyt

How to delete from a pickle file in Python?

Python pickle module is used for serializing and de-serializing a Python object structure. Any object in Python can be pickled so that it can be saved on disk. What pickle does is that it â€œserializesâ€ the object first before writing it to file. Pickling is a way to convert a python object (list, dic

How to Delete a File using R

In this article, we will discuss how to delete a file in R Programming Language. Directory in use: Method 1: Using file.remove() This is the simplest approach to delete a file as in this approach the user just needs to call the file.remove() function which is a bases function of the R programming la

How to add timestamp to CSV file in Python

Prerequisite: Datetime module In this example, we will learn How to add timestamp to CSV files in Python. We can easily add timestamp to CSV files with the help of datetime module of python. Let's the stepwise implementation for adding timestamp to CSV files in Python. Creating CSV and adding timest

Delete a CSV Column in Python

The comma-separated values â€‹â€‹(CSV) file is a delimited text file that uses commas for individual values. Each line of the file is a data record in CSV. This format used for tabular data, rows, and columns, exactly like a spreadsheet. The CSV file stores data in rows and the values â€‹â€‹in each row are