Question: Consider I have 1000 `.CSV` files with names of my employees. So there isn't any order or numbers in file names. Is there a way to say to the computer in Python language, that read files from first to end in a special folder, whit no matter what their name is?
(It's not important for me the data is for who, I only need to grab these data for analyzing).

Answer: 
use code like:(replace current path (.) with your path:

```
import os, fnmatch
import csv
listOfFiles = os.listdir('.')  
pattern = "*.csv"  
for entry in listOfFiles:  
    if fnmatch.fnmatch(entry, pattern):
        with open(entry, newline='') as csvfile:
            spamreader = csv.reader(csvfile)
            for line in spamreader:
                print(line)

```

##########Using Danadas package

```
import os, fnmatch
import pandas as pd

listOfFiles = os.listdir('.')  
pattern = "*.csv"  
for entry in listOfFiles:  
    if fnmatch.fnmatch(entry, pattern):
        read_File_as_DF=pd.read_csv(entry)
        print(read_File_as_DF)

```
You can read all csv files in a directory like this:

My csv:

```
col1,col2,col3
a,b,c
d,e,f

```

Code:

```
import glob
import csv

PATH = "/Users/stack/"

for file in glob.glob(PATH+"*.csv"):
    with open(file) as csvfile:
        spamreader = csv.reader(csvfile, delimiter=',')
        for row in spamreader:
            print(" ".join(row))

```

Output:

```
col1 col2 col3
a b c
d e f

Process finished with exit code 0

```