Breaking News: Grepper is joining You.com. Read the official announcement!

EmptyDataError: No columns to parse from file

Uptight Unicorn answered on November 16, 2022 Popularity 9/10 Helpfulness 5/10

answer EmptyDataError: No columns to parse from file

related EmptyDataError: No columns to parse from file site:stackoverflow.com

EmptyDataError: No columns to parse from file

Comment

import os
import pandas as pd
from pandas.errors import EmptyDataError


#### get a list of files in data directory
data_dir = "/path/to/dir/"
files_list = os.listdir(data_dir)


#### result containers
good_files = []
bad_files = []


#### iterate files in directory
for one_file in files_list:
    print(f"Parsing: {one_file}")
    try:
        #### read csv file to pandas data frame
        df = pd.read_csv(one_file, low_memory=False)
        #### append the file name to a list of good files
        good_files.append(one_file)
        # ...
    except EmptyDataError:
        print(f"No columns to parse from file {one_file}")
        bad_files.append(one_file)
print('Done parsing.')

Popularity 9/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: file python

Link to this answer
Share Copy Link

Contributed on Nov 16 2022

Uptight Unicorn

0 Answers Avg Quality 2/10

Closely Related Answers

EmptyDataError: No columns to parse from file site:stackoverflow.com

Comment

import pandas as pd

# Replace 'filename.csv' with the actual file path
try:
    df = pd.read_csv('filename.csv')
    # Perform further operations on the DataFrame if necessary
    print(df)
except pd.errors.EmptyDataError:
    print("No columns to parse. The file is empty.")
except FileNotFoundError:
    print("File not found.")
except Exception as e:
    print(f"Error occurred: {str(e)}")

Popularity 6/10 Helpfulness 1/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

EmptyDataError: No columns to parse from file

Contents

More Related Answers

EmptyDataError: No columns to parse from file

Closely Related Answers

EmptyDataError: No columns to parse from file site:stackoverflow.com

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.