reading multiple csv file from a different directory in python

Question

import csv
import pandas

df_list = []
path = "C:/Users/bubai/Desktop/try/scrapy/output"
#all csv file
for file in os.listdir(path):
    #print(file)
    df_list.append(file)  # all csv file in this
#print(df_list) 
for i in df_list:
    df = pandas.read_csv(i)  # open one by one 
    print(df)

I have some error:-FileNotFoundError: [Errno 2] File b'poem1.csv' does not exist: b'poem1.csv' file name are saved like poem1.csv poem10.csv poem11.csv poem12.csv poem13.csv poem14.csv poem15.csv poem16.csv poem17.csv poem18.csv poem19.csv poem2.csv poem20.csv

This solution may be what you are looking for: <stackoverflow.com/a/21232849/12762476> — Walter Chanava
– Walter Chanava, Commented Jun 15, 2020 at 18:51

JoKing · Accepted Answer · 2020-06-15 18:53:28Z

2

You need to append the filename to the path.

import csv
import pandas
import os

df_list = []
path = "C:/Users/bubai/Desktop/try/scrapy/output"
#all csv file
for file in os.listdir(path):
    df_list.append(os.path.join(path,file))  # all csv file in this
#print(df_list) 
for i in df_list:
    df = pandas.read_csv(i)  # open one by one 
    print(df)

answered Jun 15, 2020 at 18:53

JoKing

4703 silver badges11 bronze badges

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

Comments

Barmar · Accepted Answer · 2020-06-15 18:49:35Z

2

You need to concatenate the directory name with the filename in order to refer to the file.

import os

df = pandas.read_csv(os.path.join(path, i)

answered Jun 15, 2020 at 18:49

Barmar

789k57 gold badges554 silver badges669 bronze badges

Collectives™ on Stack Overflow

reading multiple csv file from a different directory in python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related