glob.glob returns an empty list while reading multiple csv files

Question

I am trying to concatenate multiple csv files( all placed in one folder) in a pandas dataframe. When I use glob, I get an empty list. I am am not understanding why.

Here is my code

    import pandas as pd

    import glob

    path=r'C:\Users\ABC\Desktop'

    files=glob.glob(path+'/*.csv') **## the code returns files as an empty list.**

   print(files)

yes.Its empty because "files=glob.glob(path+'/*.csv')" returns an empty list — learning_python, Sep 25 '18 at 05:09
So why have you included all of the code after that? It has no meaning to your question. Please see this: http://stackoverflow.com/help/mcve — Stephen Rauch, Sep 25 '18 at 05:11
Possible duplicate of [Find all files in a directory with extension .txt in Python](https://stackoverflow.com/questions/3964681/find-all-files-in-a-directory-with-extension-txt-in-python) — stovfl, Sep 25 '18 at 07:05
Read about [os.path.join](https://docs.python.org/3/library/os.path.html#os.path.join) — stovfl, Sep 25 '18 at 07:10

score 1 · Accepted Answer · answered Sep 25 '18 at 07:55

1

Can you try with

path = 'C:\\Users\\ABC\\Desktop\\'
files = glob.glob(path+'*.csv')

answered Sep 25 '18 at 07:55

Ankit Paliwal

156
4

glob.glob returns an empty list while reading multiple csv files

1 Answers1