import pandas as pd FNAME="pre2_csv_items_all1206.csv" print(" CSV of item data reading...") df=pd.read_csv(FNAME,sep=",",header=0) #項目データ 項目名ペアを読み込み print(df) len_df=len(df) #print(df.drop('path', axis=1)) #df=df.drop('path', axis=1) dict ={} #回数を統計 for i in range(len_df):#len(df)): if df.iat[i,1] in dict.keys(): dict[df.iat[i,1]]+=1 else: dict[df.iat[i,1]] =1 print(dict) print(len(dict)) count=0 for key in dict: if dict[key] < 5: count=count+1 print(count) count=0 for key in dict: if dict[key] < 10: count=count+1 print(count) count=0 for key in dict: if dict[key] < 50: count=count+1 print(count) count=0 for key in dict: if dict[key] < 100: count=count+1 print(count) count=0 for key in dict: if dict[key] < 500: count=count+1 print(count) count=0 for key in dict: if dict[key] < 1000: count=count+1 print(count) count=0 for key in dict: if dict[key] < 5000: count=count+1 print(count) count=0 for key in dict: if dict[key] < 10000: count=count+1 print(count) count=0 for key in dict: if dict[key] < 50000: count=count+1 print(count) count=0 for key in dict: if dict[key] < 100000: count=count+1 print(count)