首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >按名称计数和求和

问按名称计数和求和
EN

Stack Overflow用户
提问于 2021-08-24 19:47:35
回答 1查看 53关注 0票数 0

我想计算一下只有连续的发票的数量。我试着将日期时间转换为字符串,然后用下面的代码计数,但我认为我把它搞得太复杂了。有什么建议吗?

代码语言:javascript
复制
date_strs = df['Invoice Date']
df.dropna(how='all')

dates = [datetime.strptime(str(d, "%m-%d-%Y")) for d in date_strs]

date_ints = set([d.toordinal() for d in dates])

if len(date_ints) == 1:
    print("unique")
elif max(date_ints) - min(date_ints) == len(date_ints) - 1:
    print("consecutive")
else:
    print ("not consecutive")
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2021-08-24 20:15:35

你可以这样做:

代码语言:javascript
复制
import pandas as pd
d = {'Vender ID': {0: 8555, 1: 8555, 2: 8555, 3: 1044, 4: 1044, 5: 1044, 6: 1044},
 'Vendor Name': {0: 'Macys',
  1: 'Macys',
  2: 'Macys',
  3: 'JCPenny',
  4: 'JCPenny',
  5: 'JCPenny',
  6: 'JCPenny'},
 'Invoice Date': {0: '1/1/2020',
  1: '1/2/2020',
  2: '1/3/2020',
  3: '2/1/2020',
  4: '2/2/2020',
  5: '2/3/2020',
  6: '2/5/2020'},
 'Invoice Number': {0: 1, 1: 2, 2: 3, 3: 4, 4: 5, 5: 6, 6: 7}}
df = pd.DataFrame(d)

# fix time format
df['Invoice Date'] = pd.to_datetime(df['Invoice Date'])

# auxillary column to find sequences
df = df.sort_values(['Vender ID', 'Vendor Name', 'Invoice Date'])
df['continue'] = df['Invoice Date'].diff().dt.days.ne(1).cumsum()

# find time sequences
val_count = df['continue'].value_counts()
val_count = val_count[val_count.gt(1)].index.tolist()

# filter and group by Vendor
df[df['continue'].isin(val_count)].groupby(['Vendor Name'])['Vendor Name'].count()

# Vendor Name
# JCPenny    3
# Macys      3
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/68913318

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档