import numpy as np
import pandas as pd
a = np.random.standard_normal((9, 4))
df = pd.DataFrame(a)
df.columns = [['No1', 'No2', 'No3', 'No4']]
dates = pd.date_range('2015-1-1', periods=9, freq='M')
df.index = dates
df['Quarter'] = ['Q1', 'Q1', 'Q1', 'Q2', 'Q2', 'Q2', 'Q3', 'Q3', 'Q3']
df
No1 | No2 | No3 | No4 | Quarter | |
---|---|---|---|---|---|
2015-01-31 | -1.044786 | -0.550579 | 0.782547 | 1.698578 | Q1 |
2015-02-28 | -0.018285 | -0.125141 | 0.383689 | -0.968214 | Q1 |
2015-03-31 | 2.103675 | -1.336472 | 1.161989 | -1.477480 | Q1 |
2015-04-30 | -0.440311 | -0.983961 | 0.334371 | -0.857697 | Q2 |
2015-05-31 | -0.594368 | 0.693181 | -0.092998 | 0.769309 | Q2 |
2015-06-30 | -0.335726 | -0.397243 | 1.780188 | -0.593021 | Q2 |
2015-07-31 | -1.013463 | -1.200899 | 0.677641 | 0.854850 | Q3 |
2015-08-31 | -0.098204 | -0.464421 | 1.725880 | -1.118988 | Q3 |
2015-09-30 | -1.206143 | -1.060707 | -0.135560 | 0.085676 | Q3 |
# input yuour code
# input yuour code
# input yuour code
# input yuour code
# input yuour code
# input yuour code