#author("2020-06-19T08:36:02+00:00","default:f-lab","f-lab") #author("2020-06-19T08:36:25+00:00","default:f-lab","f-lab") [[seminar-personal/tei2020]] [[seminar-personal/tei2020]]&br; [[N班ゼミ>http://f-lab.mydns.jp/index.php?seminar-N-2020]] |~目次| |#contents| &br; * pandasを使い、csvを読んで、データの数をカウントする。 [#k745a1ef] # coding: utf-8 import pandas as pd f="3-1_kouenn.csv" df = pd.read_csv(f,delimiter =",") name_list = list(df.columns.values) print(df) dict ={} #統計 for i in range(len(df)): for j in range(len(df.columns)): data = df.iat[i,j] if data == "あり": if name_list[j] not in dict.keys():#2次元 dict[name_list[j]] ={} dict[name_list[j]][data] =1 else: if data in dict[name_list[j]].keys(): dict[name_list[j]][data]+=1 print( dict[name_list[j]][data]) else: dict[name_list[j]][data] =1 elif data == "なし":#同様 if name_list[j] not in dict.keys(): dict[name_list[j]] ={} dict[name_list[j]][data] =1 else: if data in dict[name_list[j]].keys(): dict[name_list[j]][data]+=1 print( dict[name_list[j]][data]) else: dict[name_list[j]][data] =1 #表示 print(dict.items()) # coding: utf-8 import pandas as pd f="3-1_kouenn.csv" df = pd.read_csv(f,delimiter =",") name_list = list(df.columns.values) print(df) dict ={} #統計 for i in range(len(df)): for j in range(len(df.columns)): data = df.iat[i,j] if data == "あり": if name_list[j] not in dict.keys():#2次元 dict[name_list[j]] ={} dict[name_list[j]][data] =1 else: if data in dict[name_list[j]].keys(): dict[name_list[j]][data]+=1 print( dict[name_list[j]][data]) else: dict[name_list[j]][data] =1 elif data == "なし":#同様 if name_list[j] not in dict.keys(): dict[name_list[j]] ={} dict[name_list[j]][data] =1 else: if data in dict[name_list[j]].keys(): dict[name_list[j]][data]+=1 print( dict[name_list[j]][data]) else: dict[name_list[j]][data] =1 #表示 print(dict.items())