get count of column as separate columns grouped by date in pandas code example

Example 1: select columns to include in new dataframe in python

new = old.filter(['A','B','D'], axis=1)

Example 2: how to combine all columns into one column in r

unite(data, col, ..., sep = "_", remove = TRUE, na.rm = FALSE)