<p>我不得不将您的行标题从“Col 1”>改为“>Col1”</p>
<pre><code>import pandas as pd
df=pd.read_clipboard()
df
Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9
A A 0 4247 5684 2068 393 237 16286
A A 0 0 2366 4159 3155 696 341
A B 18198 0 1114 1871 5392 1954 755
A B 17829 0 2695 2366 3768 1289 445
A C 18352 0 3545 7508 5099 2071 1239
In [9]: import numpy as np
In [10]: np.round(df.groupby(['Col1', 'Col2']).agg(['mean', 'std']),4)
Out[10]:
Col3 Col4 Col5 Col6 \
mean std mean std mean std mean
Col1 Col2
A A 0.0 0.0000 2123.5 3003.0825 4025.0 2346.1803 3113.5
B 18013.5 260.9224 0.0 0.0000 1904.5 1117.9358 2118.5
C 18352.0 NaN 0.0 NaN 3545.0 NaN 7508.0
Col7 Col8 Col9
std mean std mean std mean std
Col1 Col2
A A 1478.5603 1774 1953.0289 466.5 324.562 8313.5 11274.8176
B 350.0179 4580 1148.3414 1621.5 470.226 600.0 219.2031
C NaN 5099 NaN 2071.0 NaN 1239.0 NaN
</code></pre>