pandas merge all csv in a folder
import glob, os
import pandas as pd
df = pd.concat(map(pd.read_csv, glob.glob(os.path.join('', "*.csv"))))
Source: stackoverflow.com
import glob, os
import pandas as pd
df = pd.concat(map(pd.read_csv, glob.glob(os.path.join('', "*.csv"))))