Read multiple csv files in a folder

Question

I have multiple .csv files that represents a serious of measurements maiden.

I need to plot them in order to compare proceeding alterations.

I basically want to create a function with it I can read the file into a list and replay several of the "data cleaning in each .csv file" Then plot them all together in a happy graph

this is a task I need to do to analyze some results. I intend to make this in python/pandas as I might need to integrate into a bigger picture in the future but for now, this is it.

I basically want to create a function with it I can read the file into a big picture comparing it Graph.

I also have one file that represents background noise. I want to remove these values from the others .csv as well

import matplotlib.pyplot as plt
from matplotlib.ticker import FormatStrFormatter
PATH = r'C:\Users\UserName\Documents\FSC\Folder_name'
FileNames = [os.listdir(PATH)]
for files in FileNames:
    df = pd.read_csv(PATH + file, index_col = 0)

I expected to read every file and store into this List but I got this code:

FileNotFoundError: [Errno 2] File b'C:\Users\UserName\Documents\FSC\FolderNameFileName.csv' does not exist: b'C:\Users\UserName\Documents\FSC\FolderNameFileName.csv'

Try adding a \ to the end of your PATH value, e.g. 'C:\Users\UserName\Documents\FSC\Folder_name\' — quaabaam
– quaabaam, Commented Nov 7, 2019 at 16:06

Umar.H · Accepted Answer · 2021-05-17 15:58:24Z

10

Have you used pathlib from the standard library? it makes working with the file system a breeze,

recommend reading : https://realpython.com/python-pathlib/

try:

from pathlib import Path
files = Path('/your/path/here/').glob('*.csv') # get all csvs in your dir.
for file in files:
   df = pd.read_csv(file,index_col = 0)
   # your plots.

edited May 17, 2021 at 15:58

answered Nov 7, 2019 at 21:48

Umar.H

23.1k7 gold badges50 silver badges94 bronze badges

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

Collectives™ on Stack Overflow

Read multiple csv files in a folder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related