all_data = pd.DataFrame()
dfs = []
for f in glob.glob('*.csv'):
    df = pd.read_csv(f, header=None)
dfs.append(df)
all_data = pd.concat(dfs, ignore_index=True)
print(all_data)
all_data.to_csv('test/final.csv', index=None, header=None)
using pandas in python to append csv files into one