How to check csv file is empty in python?

Question

I have so many CSV files in a particular folder. So i just want to check which CSV file is empty and if any csv file is empty print that file name also. And Some files may be contain only header part. So this type file will also be empty file. I need to print that file also.

     try:
        path = '/nsmnt/NS_Exec_DSHBD/output/*.csv'
        files = glob.glob(path)
        for name in files:
            with open(name, 'r') as csvfile:
                csvreader = csv.reader(csvfile)
                for row in csvreader:
                    #print(row)
                    if row[0] == 'NULL':
                        print("file is empty!")
                        print(name)

    except Exception as ex:
        print(ex)

Possible duplicate of How to check whether a file is empty or not? — Ajay Singh
– Ajay Singh, Commented Apr 3, 2019 at 12:22
Not a duplicate after the update: header-only file is also considered empty in this case. — bereal
– bereal, Commented Apr 3, 2019 at 12:32

bereal · Accepted Answer · 2019-04-03 12:53:32Z

3

The question boils down to how to find out if a file has at most one row (which is a header).

def is_empty_csv(path):
    with open(name) as csvfile:
        reader = csv.reader(csvfile)
        for i, _ in enumerate(reader):
            if i:  # found the second row
                return False
    return True

answered Apr 3, 2019 at 12:53

bereal

34.7k8 gold badges65 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to check csv file is empty in python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related