将某一文件按附图所示方法输出，该如何做？

Question

列为match的值区间，行 为QName的值
意思为求每个QName下的match值在各个区间出现的次数

Answer 1

import pandas as pd
df = pd.DataFrame([[100, 0],
    [92, 1],
    [100, 1],
    [40, 1],
    [98, 1],
    [98, 1],
    [98, 1],
    [98, 1],
    [98, 1],
    [98, 1],
    [100, 2],
    [100, 3],
    [100, 4],
    [78, 4],
    [100, 5],
    [68, 5],
    [47, 5]], columns=['match', 'Qname'])

def f(df):
    r = [len(df[(df['match'] > (i * 10 if i != 0 else -1)) & (df['match'] <= (i + 1) * 10)]) for i in range(10)]
    return pd.DataFrame([r], columns=['0-10', '11-20', '21-30', '31-40', '41-50', '51-60', '61-70', '71-80', '81-90', '91-100'])

df.groupby('Qname').apply(f)

一行模式

df.groupby('Qname').apply(lambda df:pd.DataFrame([[len(df[(df['match'] > (i * 10 if i != 0 else -1)) & (df['match'] <= (i + 1) * 10)]) for i in range(10)]], columns=['0-10', '11-20', '21-30', '31-40', '41-50', '51-60', '61-70', '71-80', '81-90', '91-100']))

Answer 2

透视表方式

import pandas as pd
from random import randint

data = [[randint(0, 99), randint(0, 10)] for _ in range(10)]

df = pd.DataFrame(data, columns=['match', 'Qname'])
df['interval'] = df['match'].apply(lambda x: '{0}-{1}'.format(x//10 * 10 + 1 if x//10 >0 else 0, (x//10 + 1) * 10))

print pd.pivot_table(df, index='Qname', columns='interval', aggfunc=len, fill_value=0)