搜索
搜索

将行和列总计添加到数据透视表失败

debugcn 发表于 Dev
14
MGB文件

我想显示行和列总数。我正在使用 margin=True 但输出没有显示行总数如下代码和输出：

import pandas as pd
df2 = pd.read_csv("https://www.dropbox.com/s/90y07129zn351z9/test_data.csv?dl=1",encoding="latin-1")

df2['received'] = pd.to_datetime(df2['received'])
df2['sent'] = pd.to_datetime(df2['sent'])


pvt_all = df2.dropna(axis=0, how='all', subset=['received', 'sent'])\
    .pivot_table(index=['site'], values=['received','sent'],\
    aggfunc='count', margins=True, dropna=False)
pvt_all['to_send']= pvt_all['received']-pvt_all['sent'] 
pvt_all=pvt_all[['received','sent','to_send']] 
pvt_all

received    sent    to_send
site            
2   32.0    27.0    5.0
3   20.0    17.0    3.0
4   33.0    31.0    2.0
5   40.0    31.0    9.0
All 125.0   106.0   19.0

下面的示例数据可以让您轻松使用，而且它很长。您还可以在上面 df 向量中提供的 url 中找到。DataFrame 由四个变量组成：日期、站点、接收和发送。

date    site    received    sent
7/10/2018   2       
7/10/2018   2       
7/11/2018   2       
7/11/2018   2       
7/11/2018   2       
7/12/2018   2       
7/12/2018   2       
7/12/2018   2       
7/13/2018   2   7/13/2018 12:50 7/18/2018 14:44
7/13/2018   2       
7/18/2018   2       
7/19/2018   2       
7/19/2018   2       
7/23/2018   2       
7/23/2018   2       
7/12/2018   2       
7/12/2018   2       
7/12/2018   2       
7/12/2018   2       
7/12/2018   2       
7/13/2018   2       
7/13/2018   2       
7/13/2018   2       
7/16/2018   2       
7/16/2018   2       
7/17/2018   2       
7/17/2018   2       
7/18/2018   2       
7/18/2018   2       
7/18/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/19/2018   2       
7/19/2018   2       
7/19/2018   2       
7/26/2018   2       
7/26/2018   2       
7/25/2018   2       
7/24/2018   2       
7/23/2018   2   7/23/2018 15:53 7/25/2018 10:35
7/24/2018   2       
7/23/2018   2       
7/23/2018   2   7/23/2018 15:53 7/25/2018 10:35
7/24/2018   2       
7/24/2018   2       
7/24/2018   2       
7/23/2018   2   7/23/2018 15:53 7/25/2018 10:35
7/23/2018   2   7/23/2018 15:53 7/25/2018 10:35
7/23/2018   2       
7/23/2018   2   7/23/2018 15:53 7/25/2018 10:35
7/24/2018   2       
7/9/2018    2       
7/10/2018   2       
7/9/2018    2   7/9/2018 15:19  7/11/2018 10:25
7/10/2018   2   7/10/2018 12:26 7/11/2018 10:25
7/10/2018   2       
7/19/2018   2       
7/19/2018   2       
7/19/2018   2   7/19/2018 14:22 7/25/2018 10:35
7/23/2018   2       
7/23/2018   2   7/23/2018 15:53 7/25/2018 10:35
7/23/2018   2       
7/19/2018   2       
7/19/2018   5       
7/23/2018   2       
7/23/2018   2       
7/16/2018   2       
7/16/2018   2       
7/16/2018   2       
7/17/2018   2       
7/17/2018   2       
7/17/2018   2       
7/17/2018   2       
7/17/2018   2       
7/17/2018   2       
7/17/2018   2       
7/6/2018    2       
7/6/2018    2       
7/6/2018    2       
7/9/2018    2       
7/9/2018    2       
7/24/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/2/2018    2       
7/2/2018    2       
7/3/2018    2       
7/3/2018    2       
7/3/2018    2       
6/29/2018   2       
6/29/2018   2       
6/29/2018   2       
7/2/2018    2       
7/2/2018    2       
7/11/2018   2       
7/12/2018   2       
7/12/2018   2       
7/12/2018   2       
7/12/2018   2       
7/9/2018    2       
7/9/2018    2       
7/9/2018    2       
7/10/2018   2   7/10/2018 12:26 7/11/2018 10:25
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/11/2018   2   7/11/2018 14:54 7/18/2018 14:44
7/11/2018   2       
7/13/2018   2       
7/12/2018   2       
7/13/2018   2       
7/13/2018   2       
7/13/2018   2       
7/13/2018   2       
7/16/2018   2       
7/16/2018   2       
7/16/2018   2       
7/16/2018   2       
7/18/2018   2   7/18/2018 14:35 7/25/2018 10:35
7/19/2018   2       
7/18/2018   2       
7/19/2018   2       
7/19/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/18/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2   7/26/2018 15:35 
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/23/2018   2       
7/24/2018   2       
7/24/2018   2       
7/24/2018   2   7/24/2018 15:31 7/25/2018 10:35
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2   7/25/2018 15:34 
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/26/2018   2       
7/26/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/26/2018   2   7/26/2018 15:55 
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/27/2018   2       
7/24/2018   2       
7/24/2018   2       
7/24/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
6/29/2018   2       
6/29/2018   2       
7/2/2018    2       
7/2/2018    2       
7/2/2018    2       
6/29/2018   2       
7/6/2018    2       
7/6/2018    2       
7/6/2018    2       
7/9/2018    2       
7/2/2018    2       
7/3/2018    2       
7/3/2018    2       
7/3/2018    2       
7/3/2018    2       
7/3/2018    2       
7/3/2018    2   7/3/2018 15:20  7/4/2018 11:35
7/4/2018    2       
7/5/2018    2       
7/6/2018    2       
7/4/2018    2       
7/25/2018   2       
7/25/2018   2       
7/25/2018   2       
7/26/2018   2       
7/5/2018    2   7/5/2018 15:15  7/11/2018 10:25
7/6/2018    2       
7/9/2018    2   7/9/2018 15:19  7/11/2018 10:25
7/9/2018    2       
7/10/2018   2       
7/5/2018    2   7/5/2018 15:15  7/11/2018 10:25
7/6/2018    2       
7/6/2018    2   7/6/2018 13:30  7/11/2018 10:25
7/6/2018    2       
7/6/2018    2   7/6/2018 13:30  7/11/2018 10:25
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/11/2018   2       
7/10/2018   2       
7/13/2018   2       
7/13/2018   2   7/13/2018 12:50 
7/13/2018   2   7/13/2018 12:50 7/18/2018 14:44
7/12/2018   2   7/12/2018 15:30 7/18/2018 14:44
7/11/2018   2       
7/11/2018   2       
7/12/2018   2       
7/12/2018   2       
7/12/2018   2       
7/27/2018   2       
7/27/2018   2       
7/26/2018   2       
7/26/2018   2   7/26/2018 15:55 
7/26/2018   2       
7/26/2018   2       
7/27/2018   2       
7/16/2018   2       
7/16/2018   2       
7/16/2018   2       
7/16/2018   2       
7/16/2018   2       
7/19/2018   2       
7/17/2018   2       
7/17/2018   2       
7/17/2018   2       
7/17/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
7/26/2018   2       
6/29/2018   2       
7/2/2018    2       
7/2/2018    2       
7/2/2018    2       
7/2/2018    2       
7/2/2018    2       
7/6/2018    2       
7/6/2018    2       
7/9/2018    2       
7/9/2018    2       
7/2/2018    2   7/2/2018 15:38  7/4/2018 11:35
7/2/2018    2       
7/3/2018    2       
7/5/2018    2       
7/3/2018    2   7/3/2018 14:15  7/4/2018 11:35
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/10/2018   2       
7/11/2018   2       
7/11/2018   2       
7/11/2018   2       
7/12/2018   2       
7/12/2018   2       
7/12/2018   2       
7/13/2018   2       
7/13/2018   2       
7/13/2018   2       
7/16/2018   2   7/16/2018 14:25 7/4/2018 15:30
7/16/2018   2       
7/16/2018   2       
7/17/2018   2   7/17/2018 14:50 7/18/2018 14:44
7/17/2018   2       
7/17/2018   2       
7/18/2018   2       
7/17/2018   2       
7/18/2018   2       
7/18/2018   2   7/18/2018 14:35 7/25/2018 10:35
7/27/2018   2       
7/27/2018   2       
7/27/2018   2       
7/27/2018   2       
7/27/2018   2       
7/27/2018   2       
7/27/2018   2       
6/20/2018   5       
6/20/2018   5       
6/22/2018   5       
6/19/2018   5   6/19/2018 14:20 6/28/2018 14:20
6/19/2018   5   6/19/2018 14:20 6/28/2018 14:20
6/27/2018   5       
6/28/2018   5       
6/28/2018   5   6/28/2018 11:30 7/4/2018 15:30
6/28/2018   5       
6/28/2018   5       
7/24/2018   5       
7/24/2018   5       
6/28/2018   5       
7/2/2018    5       
7/2/2018    5       
7/2/2018    5       
7/2/2018    5       
6/19/2018   5       
6/20/2018   5   6/19/2018 14:20 6/28/2018 14:20
6/20/2018   5       
6/19/2018   5       
6/19/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
6/26/2018   5   6/26/2018 11:40 6/28/2018 14:20
6/27/2018   5       
6/27/2018   5   6/27/2018 14:36 6/28/2018 14:20
6/27/2018   5       
6/19/2018   5       
6/19/2018   5       
6/19/2018   5       
6/22/2018   5       
6/20/2018   5   6/19/2018 12:40 6/28/2018 14:20
6/20/2018   5       
6/20/2018   5       
6/20/2018   5   6/20/2018 11:10 6/28/2018 14:20
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5   6/21/2018 1:26  6/28/2018 14:20
6/22/2018   5       
6/22/2018   5       
6/22/2018   5       
6/22/2018   5   6/22/2018 2:30  6/28/2018 14:20
6/26/2018   5       
6/26/2018   5       
6/26/2018   5   6/20/2018 11:10 6/28/2018 14:20
6/26/2018   5   6/26/2018 2:36  6/28/2018 14:20
6/26/2018   5       
6/26/2018   5       
6/26/2018   5       
6/27/2018   5   6/27/2018 14:36 6/28/2018 14:20
6/27/2018   5       
6/27/2018   5       
6/28/2018   5       
6/28/2018   5       
6/28/2018   5       
6/28/2018   5       
6/28/2018   5       
6/19/2018   5       
6/19/2018   5       
6/19/2018   5       
6/19/2018   5       
6/19/2018   5   6/19/2018 2:20  6/28/2018 14:20
6/20/2018   5   6/20/2018 2:15  6/28/2018 14:20
6/20/2018   5       
6/20/2018   5       
6/20/2018   5       
6/22/2018   5       
6/22/2018   5       
6/22/2018   5       
6/22/2018   5       
6/22/2018   5       
7/25/2018   5       
7/25/2018   5       
7/25/2018   5   7/25/2018 14:45 
7/25/2018   5       
7/25/2018   5       
7/24/2018   5       
7/24/2018   5       
7/25/2018   5   7/25/2018 14:45 
7/25/2018   5       
7/25/2018   5       
7/25/2018   5       
7/25/2018   5       
7/25/2018   5       
7/25/2018   5       
6/22/2018   5   6/22/2018 12:00 6/28/2018 14:20
6/20/2018   5   6/21/2018 2:35  6/28/2018 14:20
6/20/2018   5       
6/20/2018   5       
6/20/2018   5       
6/26/2018   5       
6/26/2018   5       
6/26/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/22/2018   5       
6/22/2018   5   6/22/2018 14:30 6/28/2018 14:20
6/22/2018   5       
6/22/2018   5       
6/26/2018   5       
6/26/2018   5       
6/26/2018   5       
6/26/2018   5       
6/26/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
6/21/2018   5       
7/3/2018    5       
7/3/2018    5       
7/3/2018    5       
7/3/2018    5       
7/3/2018    5   7/3/2018 14:45  7/4/2018 15:30
7/2/2018    5       
7/2/2018    5       
7/2/2018    5       
7/2/2018    5       
7/2/2018    5       
7/24/2018   5       
7/24/2018   5       
7/25/2018   5       
7/24/2018   5       
7/24/2018   5       
7/24/2018   5       
7/25/2018   5       
7/24/2018   5   7/25/2018 14:45 
7/24/2018   5       
7/24/2018   5       
7/23/2018   5       
7/24/2018   5       
7/24/2018   5       
7/3/2018    5       
7/3/2018    5   7/3/2018 14:45  7/4/2018 15:30
7/3/2018    5       
7/23/2018   5       
7/3/2018    5       
7/3/2018    5   7/3/2018 14:45  7/4/2018 15:30
7/3/2018    5       
7/3/2018    5       
7/11/2018   5       
7/10/2018   5       
7/11/2018   5   7/11/2018 12:47 7/13/2018 15:30
7/11/2018   5       
7/11/2018   5       
7/24/2018   5       
7/23/2018   5       
7/24/2018   5       
7/24/2018   5       
7/23/2018   5       
7/24/2018   5   7/24/2018 13:40 
7/23/2018   5       
7/24/2018   5       
7/24/2018   5       
7/23/2018   5       
7/24/2018   5       
7/23/2018   5   7/23/2018 16:20 
7/23/2018   5       
7/24/2018   5       
7/24/2018   5       
7/23/2018   5       
7/23/2018   5       
7/23/2018   5       
7/24/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5   7/10/2018 16:10 7/13/2018 15:30
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/16/2018   5       
7/10/2018   5   7/10/2018 16:20 7/13/2018 15:30
7/10/2018   5       
7/10/2018   5       
7/10/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/18/2018   5       
7/18/2018   5   7/18/2018 12:35 7/21/2018 11:20
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/11/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5       
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/12/2018   5       
7/12/2018   5       
7/12/2018   5   7/12/2018 16:38 7/13/2018 15:30
7/12/2018   5       
7/12/2018   5       
7/13/2018   5       
7/13/2018   5       
7/13/2018   5       
7/20/2018   5       
7/23/2018   5       
7/23/2018   5       
7/16/2018   5       
7/23/2018   5       
7/19/2018   5       
7/19/2018   5       
7/19/2018   5       
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/20/2018   5       
7/20/2018   5       
7/20/2018   5       
7/20/2018   5       
7/18/2018   5       
7/23/2018   5       
7/23/2018   5       
7/19/2018   5       
7/19/2018   5       
7/19/2018   5       
7/19/2018   5       
7/20/2018   5       
7/20/2018   5       
7/20/2018   5       
7/20/2018   5       
7/23/2018   5       
7/23/2018   5       
7/23/2018   5       
7/23/2018   5       
7/23/2018   5       
7/24/2018   5       
7/24/2018   5       
7/24/2018   5       
7/20/2018   5       
7/20/2018   5       
7/20/2018   5       
7/18/2018   5       
7/24/2018   5       
7/18/2018   5       
7/18/2018   5   7/18/2018 13:00 7/21/2018 11:20
7/18/2018   5   7/18/2018 10:30 7/21/2018 11:20
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/13/2018   5       
7/13/2018   5       
7/13/2018   5       
7/13/2018   5       
7/16/2018   5       
7/16/2018   5       
7/19/2018   5       
7/20/2018   5       
7/20/2018   5   7/20/2018 14:30 7/21/2018 11:20
7/20/2018   5       
7/20/2018   5       
7/19/2018   5       
7/16/2018   5       
7/16/2018   5       
7/16/2018   5       
7/16/2018   5       
7/16/2018   5       
7/19/2018   5       
7/19/2018   5       
7/19/2018   5   7/19/2018 11:50 7/21/2018 11:20
7/19/2018   5       
7/19/2018   5       
7/23/2018   5       
7/23/2018   5   7/23/2018 16:20 
7/23/2018   5       
7/13/2018   5       
7/25/2018   5       
7/25/2018   5   7/25/2018 14:45 
7/25/2018   5   7/25/2018 14:45 
7/19/2018   5       
7/19/2018   5       
7/19/2018   5       
7/19/2018   5       
7/19/2018   5       
7/13/2018   5       
7/13/2018   5       
7/13/2018   5       
7/13/2018   5       
7/13/2018   5       
7/18/2018   5       
7/18/2018   5       
7/18/2018   5       
7/23/2018   5   7/23/2018 16:20 
7/19/2018   5       
7/19/2018   5   7/19/2018 13:30 7/21/2018 11:20
7/19/2018   5       
7/19/2018   5       
7/20/2018   5       
6/26/2018   4       
6/26/2018   4       
6/27/2018   4       
6/27/2018   4       
6/27/2018   4       
6/26/2018   4       
6/27/2018   4       
6/27/2018   4       
6/27/2018   4       
6/27/2018   4       
7/3/2018    4       
6/28/2018   4       
6/28/2018   4       
7/3/2018    4       
7/4/2018    4       
6/28/2018   4       
6/29/2018   4       
6/28/2018   4       
6/28/2018   4       
6/29/2018   4       
6/28/2018   4       
6/28/2018   4   6/28/2018 15:00 7/4/2018 15:45
6/28/2018   4       
6/28/2018   4       
6/29/2018   4       
7/11/2018   4       
7/11/2018   4       
7/6/2018    4       
7/6/2018    4       
7/6/2018    4       
7/11/2018   4       
7/11/2018   4       
7/11/2018   4       
7/11/2018   4       
7/11/2018   4       
7/12/2018   4       
7/12/2018   4   7/12/2018 14:09 7/17/2018 15:00
7/12/2018   4       
7/12/2018   4       
7/12/2018   4       
7/12/2018   4       
7/12/2018   4       
7/12/2018   4       
7/12/2018   4       
7/12/2018   4       
7/12/2018   4       
7/13/2018   4       
7/13/2018   4       
7/13/2018   4       
7/13/2018   4   7/13/2018 10:52 7/17/2018 15:00
7/13/2018   4       
7/12/2018   4   7/12/2018 16:28 7/17/2018 15:00
7/13/2018   4   7/13/2018 10:52 7/17/2018 15:00
7/13/2018   4       
7/13/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/13/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4   7/18/2018 16:21 7/24/2018 14:30
7/19/2018   4       
7/16/2018   4       
7/13/2018   4       
7/13/2018   4       
7/13/2018   4       
7/16/2018   4       
7/17/2018   4       
7/13/2018   4       
7/16/2018   4       
7/16/2018   4       
7/13/2018   4   7/13/2018 14:15 7/17/2018 15:00
7/12/2018   4       
7/11/2018   4       
7/12/2018   4       
7/12/2018   4       
7/12/2018   4       
7/11/2018   4       
7/12/2018   4       
7/11/2018   4       
7/11/2018   4   7/11/2018 13:40 7/17/2018 15:00
7/12/2018   4       
7/11/2018   4       
7/11/2018   4       
7/11/2018   4       
7/13/2018   4       
7/5/2018    4       
7/5/2018    4       
7/6/2018    4       
7/6/2018    4   7/6/2018 13:00  7/10/2018 13:30
7/6/2018    4   7/6/2018 15:30  7/10/2018 13:30
7/5/2018    4       
7/5/2018    4       
7/5/2018    4       
7/5/2018    4       
7/5/2018    4       
7/5/2018    4       
7/4/2018    4       
7/4/2018    4       
7/4/2018    4   7/4/2018 11:20  7/10/2018 13:30
7/3/2018    4       
7/18/2018   4       
7/19/2018   4       
7/18/2018   4       
7/4/2018    4   7/4/2018 11:20  7/10/2018 13:30
7/17/2018   4       
7/19/2018   4       
7/20/2018   4       
7/4/2018    4   7/4/2018 11:20  7/10/2018 13:30
7/4/2018    4   7/4/2018 13:48  7/10/2018 13:30
7/5/2018    4       
7/5/2018    4       
7/5/2018    4       
7/3/2018    4   7/3/2018 12:50  7/4/2018 15:45
7/3/2018    4   7/3/2018 12:50  7/4/2018 15:45
7/3/2018    4       
7/3/2018    4   7/3/2018 12:50  7/4/2018 15:45
7/3/2018    4   7/3/2018 14:30  7/4/2018 15:45
7/3/2018    4       
7/3/2018    4   7/3/2018 12:50  7/4/2018 15:45
7/3/2018    4       
7/3/2018    4   7/3/2018 12:50  7/4/2018 15:45
7/3/2018    4       
7/6/2018    4       
7/6/2018    4       
7/5/2018    4       
7/5/2018    4   7/5/2018 16:20  7/10/2018 13:30
7/5/2018    4       
6/26/2018   4       
6/27/2018   4       
6/28/2018   4       
7/11/2018   4       
6/28/2018   4       
7/18/2018   4   7/18/2018 10:56 7/24/2018 14:30
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/18/2018   4       
7/17/2018   4       
7/17/2018   4       
7/17/2018   4   7/17/2018 13:20 7/24/2018 14:30
7/17/2018   4       
7/17/2018   4   7/17/2018 16:30 7/24/2018 14:30
7/17/2018   4       
7/17/2018   4       
7/17/2018   4       
7/17/2018   4       
7/17/2018   4       
7/19/2018   4   7/19/2018 12:50 7/24/2018 14:30
7/19/2018   4       
7/19/2018   4       
7/19/2018   4       
7/19/2018   4       
7/19/2018   4   7/19/2018 14:04 7/24/2018 14:30
7/19/2018   4       
7/19/2018   4       
7/20/2018   4       
7/20/2018   4       
7/19/2018   4   7/19/2018 12:50 7/24/2018 14:30
7/19/2018   4       
7/19/2018   4       
7/19/2018   4       
7/19/2018   4       
7/20/2018   4       
7/20/2018   4       
7/20/2018   4       
7/20/2018   4       
7/20/2018   4   7/20/2018 12:40 7/24/2018 14:30
7/19/2018   4       
7/20/2018   4       
7/20/2018   4       
7/20/2018   4       
7/20/2018   4       
7/24/2018   4       
7/24/2018   4       
7/24/2018   4       
7/25/2018   4       
7/24/2018   4       
7/25/2018   4       
7/25/2018   4       
7/25/2018   4       
7/25/2018   4   7/25/2018 13:00 
7/20/2018   4       
7/20/2018   4       
7/20/2018   4   7/20/2018 13:55 7/24/2018 14:30
7/23/2018   4   7/23/2018 12:48 7/24/2018 14:30
7/23/2018   4       
7/20/2018   4       
7/20/2018   4       
7/20/2018   4       
7/23/2018   4       
7/24/2018   4       
7/20/2018   4       
7/20/2018   4   7/20/2018 12:40 7/24/2018 14:30
7/20/2018   4       
7/23/2018   4       
7/25/2018   4       
7/26/2018   4       
7/25/2018   4       
7/26/2018   4       
7/25/2018   4       
7/26/2018   4       
7/27/2018   4       
7/26/2018   4       
7/27/2018   4       
7/26/2018   4       
7/26/2018   4       
7/26/2018   4       
7/26/2018   4       
7/26/2018   4       
7/26/2018   4   7/26/2018 14:02 
7/27/2018   4       
7/26/2018   4       
7/27/2018   4       
7/26/2018   4       
7/27/2018   4       
7/27/2018   4       
7/27/2018   4       
7/27/2018   4       
7/27/2018   4       
7/25/2018   4       
7/25/2018   4       
7/26/2018   4       
7/26/2018   4       
7/26/2018   4       
7/26/2018   4       
7/26/2018   4       
6/19/2018   3   6/18/2018 15:00 6/28/2018 11:35
6/19/2018   3       
6/19/2018   3       
6/20/2018   3       
6/20/2018   3       
6/20/2018   3       
6/20/2018   3       
6/20/2018   3       
6/21/2018   3       
6/21/2018   3       
6/21/2018   3       
6/22/2018   3       
6/22/2018   3       
6/22/2018   3       
6/22/2018   3       
6/22/2018   3       
6/26/2018   3   6/26/2018 12:35 6/28/2018 11:35
6/26/2018   3       
6/26/2018   3       
6/26/2018   3       
6/20/2018   3       
6/21/2018   3       
6/21/2018   3       
6/21/2018   3       
6/20/2018   3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
6/21/2018   3       
6/21/2018   3       
6/21/2018   3       
6/22/2018   3       
6/22/2018   3       
6/22/2018   3       
6/22/2018   3       
6/22/2018   3       
6/26/2018   3       
6/26/2018   3       
6/22/2018   3       
6/22/2018   3   6/22/2018 14:10 6/28/2018 11:35
6/22/2018   3       
6/26/2018   3       
6/26/2018   3   6/26/2018 12:35 6/28/2018 11:35
6/26/2018   3       
6/26/2018   3       
6/26/2018   3       
6/27/2018   3   6/27/2018 13:20 6/28/2018 11:35
6/27/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/19/2018   3       
6/19/2018   3       
6/19/2018   3       
6/20/2018   3       
6/20/2018   3       
6/26/2018   3       
6/26/2018   3       
6/26/2018   3       
6/27/2018   3   6/27/2018 13:20 6/28/2018 11:35
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/27/2018   3       
6/28/2018   3   6/28/2018 12:15 7/4/2018 10:50
6/28/2018   3       
6/28/2018   3       
6/28/2018   3       
6/28/2018   3   6/28/2018 15:22 7/4/2018 10:50
6/28/2018   3       
6/28/2018   3       
6/28/2018   3       
6/26/2018   3   6/26/2018 13:35 6/28/2018 11:35
6/26/2018   3       
6/26/2018   3       
6/26/2018   3       
6/27/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/27/2018   3       
6/27/2018   3       
6/28/2018   3   6/28/2018 12:15 7/4/2018 10:50
6/28/2018   3       
6/28/2018   3       
6/28/2018   3       
6/28/2018   3       
6/28/2018   3       
6/28/2018   3       
6/28/2018   3       
6/29/2018   3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
6/29/2018   3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/2/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/4/2018    3       
7/4/2018    3       
7/4/2018    3       
7/4/2018    3       
7/4/2018    3       
7/4/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/3/2018    3       
7/4/2018    3       
7/4/2018    3       
7/4/2018    3       
7/4/2018    3       
7/4/2018    3   7/4/2018 13:20  7/10/2018 11:15
7/4/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/9/2018    3       
7/9/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/5/2018    3       
7/9/2018    3       
7/9/2018    3       
7/9/2018    3       
7/9/2018    3       
7/9/2018    3       
7/10/2018   3       
7/10/2018   3       
7/10/2018   3       
7/11/2018   3       
7/11/2018   3       
7/5/2018    3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/9/2018    3       
7/9/2018    3       
7/9/2018    3       
7/10/2018   3       
7/10/2018   3       
7/10/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/11/2018   3       
7/12/2018   3       
7/12/2018   3       
7/12/2018   3       
7/12/2018   3       
7/12/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/18/2018   3       
7/18/2018   3       
7/18/2018   3       
7/18/2018   3       
7/20/2018   3       
7/20/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/13/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/18/2018   3       
7/20/2018   3       
7/20/2018   3       
7/20/2018   3       
7/20/2018   3       
7/20/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/17/2018   3       
7/18/2018   3       
7/18/2018   3       
7/18/2018   3       
7/23/2018   3       
7/23/2018   3   7/23/2018 15:10 7/24/2018 13:00
7/23/2018   3       
7/18/2018   3   7/18/2018 14:30 7/24/2018 13:00
7/18/2018   3       
7/18/2018   3       
7/18/2018   3       
7/20/2018   3       
7/20/2018   3       
7/20/2018   3       
7/20/2018   3       
7/20/2018   3       
7/20/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3   7/23/2018 15:10 7/24/2018 13:00
7/24/2018   3   7/24/2018 14:00 
7/24/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3   7/23/2018 15:10 7/24/2018 13:00
7/23/2018   3   7/23/2018 15:10 7/24/2018 13:00
7/23/2018   3   7/23/2018 15:10 7/24/2018 13:00
7/23/2018   3       
7/25/2018   3       
7/24/2018   3       
7/25/2018   3       
7/24/2018   3       
7/24/2018   3       
7/24/2018   3   7/24/2018 14:00 
7/24/2018   3       
7/24/2018   3       
7/25/2018   3   7/25/2018 15:00 
7/25/2018   3       
7/25/2018   3       
7/25/2018   3       
7/25/2018   3       
7/26/2018   3       
7/24/2018   3       
7/25/2018   3       
7/24/2018   3       
7/25/2018   3       
7/24/2018   3       
7/25/2018   3       
7/24/2018   3       
7/25/2018   3       
7/25/2018   3       
7/25/2018   3       
7/26/2018   3       
7/23/2018   3       
7/26/2018   3       
7/27/2018   3       
7/27/2018   3       
7/27/2018   3       
7/27/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3       
7/23/2018   3       
7/27/2018   3       
7/27/2018   3       
7/27/2018   3       
7/27/2018   3       
7/27/2018   3       
7/27/2018   3       
7/25/2018   3       
7/26/2018   3       
7/26/2018   3       
7/26/2018   3       
7/27/2018   3       
7/27/2018   3
MGB文件 
df2 = pd.read_csv("https://www.dropbox.com/s/90y07129zn351z9/test_data.csv?dl=1",encoding="latin-1")

df2['received'] = pd.to_datetime(df2['received'])
df2['sent'] = pd.to_datetime(df2['sent'])

import pandas as pd
pvt_all = df2.dropna(axis=0, how='all', subset=['received', 'sent'])\
    .pivot_table(index=['site'], values=['received','sent'],\
    aggfunc='count', margins=True, dropna=False)
pvt_all['to_send']= pvt_all['received']-pvt_all['sent'] 
#pvt_all['Total'] = pvt_all.received + pvt_all.sent + pvt_all.to_send
pvt_all['Total'] = pvt_all.sum(axis=1) #Add Total column for row subtotal \
#and Total
pvt_all=pvt_all[['received','sent','to_send','Total']] 
pvt_all


received    sent    to_send Total
site                
2   32.0    27.0    5.0 64.0
3   20.0    17.0    3.0 40.0
4   33.0    31.0    2.0 66.0
5   40.0    31.0    9.0 80.0
All 125.0   106.0   19.0    250.0

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

将总计添加到数据表中的数据透视图中，但不添加到图形中

来自分类Dev

将列添加到数据透视表

来自分类Dev

如何将总计/平均值行添加到交叉表行组？

来自分类Dev

动态将表数据和表行添加到HTML，TD不在HTML中显示

来自分类Dev

将总计添加到行标题符合条件的列

来自分类Dev

XSSF（POI）-将“公式”列添加到数据透视表

来自分类Dev

将总计添加到SUM交叉表查询中的枢轴列

来自分类Dev

如何将数据透视表添加到数据透视表

来自分类Dev

将列添加到数据透视表（熊猫）

来自分类Dev

如何在pyspark的数据透视表中添加/包括标题行和总计行？

来自分类Dev

将count（）添加到具有总计的数据透视表

来自分类Dev

如何使用熊猫将新列添加到数据透视表

来自分类Dev

将小计添加到多层熊猫数据透视表

来自分类Dev

将总计列添加到动态SQL数据透视表

来自分类Dev

如何将条件添加到数据透视表以显示部分或操纵的源数据

来自分类Dev

VBA将总计和公式添加到多个工作表

来自分类Dev

将计算列添加到数据透视表

来自分类Dev

使用VBA将字段添加到数据透视表

来自分类Dev

将列说明添加到新的（非经典）数据透视表中

来自分类Dev

将总计添加到行标题符合条件的列

来自分类Dev

动态数据透视表-如何将生成的列添加到另一个表？

来自分类Dev

如何将描述列添加到数据透视表

来自分类Dev

将总计添加到SUM交叉表查询中的枢轴列

来自分类Dev

将值添加到数据透视表Laravel

来自分类Dev

Laravel 测试：将属性添加到数据透视表

来自分类Dev

Laravel - 将列添加到现有数据透视表并添加 MUL 键

来自分类Dev

VBA - 将数据透视字段过滤器添加到数据透视表

来自分类Dev

R 将总计添加到列？

来自分类Dev

将列和行添加到数据网格？

Related 相关文章

  1. 1

    将总计添加到数据表中的数据透视图中，但不添加到图形中

  2. 2

    将列添加到数据透视表

  3. 3

    如何将总计/平均值行添加到交叉表行组？

  4. 4

    动态将表数据和表行添加到HTML，TD不在HTML中显示

  5. 5

    将总计添加到行标题符合条件的列

  6. 6

    XSSF（POI）-将“公式”列添加到数据透视表

  7. 7

    将总计添加到SUM交叉表查询中的枢轴列

  8. 8

    如何将数据透视表添加到数据透视表

  9. 9

    将列添加到数据透视表（熊猫）

  10. 10

    如何在pyspark的数据透视表中添加/包括标题行和总计行？

  11. 11

    将count（）添加到具有总计的数据透视表

  12. 12

    如何使用熊猫将新列添加到数据透视表

  13. 13

    将小计添加到多层熊猫数据透视表

  14. 14

    将总计列添加到动态SQL数据透视表

  15. 15

    如何将条件添加到数据透视表以显示部分或操纵的源数据

  16. 16

    VBA将总计和公式添加到多个工作表

  17. 17

    将计算列添加到数据透视表

  18. 18

    使用VBA将字段添加到数据透视表

  19. 19

    将列说明添加到新的（非经典）数据透视表中

  20. 20

    将总计添加到行标题符合条件的列

  21. 21

    动态数据透视表-如何将生成的列添加到另一个表？

  22. 22

    如何将描述列添加到数据透视表

  23. 23

    将总计添加到SUM交叉表查询中的枢轴列

  24. 24

    将值添加到数据透视表Laravel

  25. 25

    Laravel 测试：将属性添加到数据透视表

  26. 26

    Laravel - 将列添加到现有数据透视表并添加 MUL 键

  27. 27

    VBA - 将数据透视字段过滤器添加到数据透视表

  28. 28

    R 将总计添加到列？

  29. 29

    将列和行添加到数据网格？

热门标签

归档