import pandas as pd import numpy as np from os import listdir from os.path import isfile, join mypath='E:/20181116 NTR 116A/' onlySummaryFiles = [f for f in listdir(mypath) if isfile(join(mypath, f)) and 'Summary of Result of' in f] #print onlySummaryFiles #print onlySummaryFiles[0:3] for i in range(len(onlySummaryFiles)): filename=mypath+onlySummaryFiles[i] Result = pd.read_csv( filename) print onlySummaryFiles[i][30:-4],'\t', np.mean(Result.iloc[0:,1]) print len(onlySummaryFiles)