Pandas-对指定Dataframe计数

 数据：

 

import pandas as pd
data = pd.read_excel('Test.xlsx')
def count (data):
    data1 = data['Num']#选择数据
    count_data1 = data1.value_counts()#计数
    print(count_data1)

输出：

 

def count (data):
    data1 = data['Num']#选择数据
    count_data1 = data1.value_counts()#计数
    print(count_data1)
    count_df = count_data1.reset_index()#转换为Dateframe
    print(count_df)

 输出：

 

def count (data):
    data1 = data['Num']#选择数据
    count_data1 = data1.value_counts()#计数
    print(count_data1)
    count_df = count_data1.reset_index()#转换为Dateframe
    print(count_df)
    count_df.columns = ['Number', 'Count0']#自定义索引
    print(count_df)
    return count_df

 输出：