pandas 数据统计

import pandas as pd
df = pd.read_csv('band_data9.csv')

i=[8,9,2,3,4]
for e in i:
    dd = df[df.iloc[:, 1] == e*100]
    fm = max(dd.iloc[:,2])-min(dd.iloc[:,2])
    fz = dd.shape[0]
    print(int(100.0*fz/fm),end=' ')
 

csv likes, timestamp *100

1.0,800.0,170728729000.0,0.0,0.0,0.0
2.0,800.0,170728729001.0,0.0,0.0,0.0
266.0,400.0,171213178074.0,0.0,0.0,0.0
3.0,800.0,170728729002.0,0.0,0.0,0.0
267.0,400.0,171213178076.0,0.0,0.0,0.0
268.0,400.0,171213178076.0,0.0,0.0,0.0
4.0,800.0,170728729003.0,0.0,0.0,0.0
269.0,400.0,171213178077.0,0.0,0.0,0.0
5.0,800.0,170728729004.0,0.0,0.0,0.0
270.0,400.0,171213178078.0,0.0,0.0,0.0
6.0,800.0,170728729005.0,0.0,0.0,0.0
271.0,400.0,171213178079.0,0.0,0.0,0.0
7.0,800.0,170728729006.0,0.0,0.0,0.0
272.0,400.0,171213178080.0,0.0,0.0,0.0
8.0,800.0,170728729007.0,0.0,0.0,0.0
273.0,400.0,171213178081.0,0.0,0.0,0.0

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值