读取表格,按条件筛选并且写入表格
条件是将一组浮点数据分组,并计数
没有研究怎么追加,就直接新生成了一个表格,也许不太规范,但是就能用就成
import pandas as pd
N = pd.read_excel('花坪2.xlsx')
list1=list(N['胸径'])
list2=[]
for i in list1:
if int(i)<i<int(i)+1:
list2.append(int(i))
if i== int(i):
list2.append(int(i-1))
data={'胸径':list1,
'class':list2
}
frame = pd.DataFrame(data)
print(frame)
frame.to_excel('huaping2.xls')
import pandas as pd
N = pd.read_excel('花坪2.xlsx')
list1=list(N['胸径'])
list2=[]
for i in list1:
if int(i)<i<int(i)+1:
list2.append(int(i))
if i== int(i):
list2.append(int(i-1))
set1=set(list2)
a=[]
for i in set1:
b=list2.count(i)
a.append(b)
list3=list(set1)
data={'胸径':list3,
'计数':a
}
frame = pd.DataFrame(data)
frame.to_excel('huaping2.xls')