df.columns = ['ID'] + list(df.columns)[1:]
df = df.stack().apply(lambda v: re.sub('[^0-9]', '', v) if isinstance(v,
    str) else v).astype(float).unstack()
df.groupby('ID').agg(['std', 'mean'])
Data munging in pandas