0

Ex - File1.csv, File2.csv, File3.csv, File4.csv, File5.csv, File6.csv, File7.csv, File8.csv, File9.csv, File10.csv, File11.csv, File12.csv...

but when using glob function it is taking 10th file after file 1? Is there anyway to merge only specific number of files with specific pattern (like 10 files out of 100 files with similar pattern?

Files pattern it is taking -

['y_test_ytest_pred_final_1.csv',
 'y_test_ytest_pred_final_10.csv',
 'y_test_ytest_pred_final_2.csv',
 'y_test_ytest_pred_final_3.csv',
 'y_test_ytest_pred_final_4.csv',
 'y_test_ytest_pred_final_5.csv',
 'y_test_ytest_pred_final_6.csv',
 'y_test_ytest_pred_final_7.csv',
 'y_test_ytest_pred_final_8.csv',
 'y_test_ytest_pred_final_9.csv']
from glob import glob
import os
files = sorted(glob("File*.csv"))
files
data=pd.concat((pd.read_csv(file) for file in files), ignore_index=True)
data
data.to_csv("predicted.csv", index=False)
MattDMo
  • 100,794
  • 21
  • 241
  • 231

0 Answers0