Grab all of the month names
= pd.date_range('2020-01-01','2020-12-31',freq='MS').map(lambda x: x.month_name()) months
pandas types to redshift schema
= d.dtypes
cols = {'object':'varchar(255)', 'int64':'bigint','float64':'double precision','datetime64[ns]':'date'}
l = zip(cols.index, map(lambda x: l[x.name] + ' encode zstd', cols.values))
cols = ", ".join(map(lambda x: ' '.join(x), cols)) cols