Usually I navigate to the folder I am extracting data from and copy the file name directly:
If I have multiple files and want to do the same for all the files, how do I specify the folder to open and get all the files inside?
I want to run the above code without specifying the file's full path
You want listdir from the os module.
import os path = "C:\\Users\\X\\Desktop\\Y\\Z\\" files = os.listdir(path) print(files) dataframe_list =  for filename in files: dataframe_list.append(pd.read_csv(os.path.join(path,filename)))
You should open the desired directory and loop through all the files then do something to them.
# import required module import os # assign directory directory = 'files' # iterate over files in def goThroughDirectory(directory): for filename in os.listdir(directory): f = os.path.join(directory, filename) # checking if it is a file if os.path.isfile(f): # do something
If you also want to loop through all the files in a directory you should add a check for
if os.path.isdir(f) like this
... def goThroughDirectory(directory): for filename in os.listdir(directory): f = os.path.join(directory, filename) # checking if it is a file if os.path.isfile(f): # do something elif os.path.isdir(f): # its not a file but a directory then loop through that directory aswell goThroughDirectory(directory + "\" + f)
for more information you should check geeksforgeeks