Oct-24-2020, 07:33 AM
I use below code.
import os import pandas as pd df_result =pd.DataFrame() directory = os.path.join("D:\\","\PythonCodes\inputmultifiles") for root,dirs,files in os.walk(directory): for file in files: f = os.path.join(directory,file) if f.endswith(".csv"): ff=pd.read_csv(f) tmp = ff['Name'] print(tmp) df_result= pd.concat([df_result,ff['Name']]) df_result = df_result.reset_index(drop=True) df_result.columns = ['New_col']