pandas 数据统计

原创于 2024-04-19 15:39:10 发布 · 397 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#pandas

该代码片段展示了如何使用Python的pandas库从band_data9.csv文件中读取数据，筛选特定行，计算最大值和最小值，然后基于比例输出百分比。数据每行包含时间戳和一些数值。

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