for f in glob.glob('*.csv'):
    df = pd.read_csv(f, header=None)
all_data = all_data.append(df, 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