按日期统计频数

Question

# -*- coding: utf-8 -*-
#-*- encoding: gbk -*-

import csv
import time
import re
from collections import defaultdict
import pandas as pd

rf=open("E://**//**.csv", 'r')
april = csv.reader(rf)


count = 0
for i in range(1,32):
    for date in april:
        if str(date[8]) == str(i):
            count = count + 1
    print(i, count)

结果如图，全部31天频数一样，肯定代码写错了

Answer 1

WHXKJHJOSXQUUEMUILJOEBXZUSSVQXNNVNFNQUHOLZHYYGLBEFGYGXSRNKHODVSKFIMSTLWQRSZJWVAPWCHBIYRMKICAQEUKVJNVXYVWXBWMBKUUUSDUTPKHUUBQOLCAZQHIQBJKPGUEYNLQKGMFWUVKRRQDGDSKOJIGYFRCRVJZLCSSRTRPPQQJAZEOJTFFVFDOGKITAAWUPQUZUNKEIAIPVKAGESNBWUJCGNVWOUOJPZZAIGUKZUBSGOMQOWGDTKUSNPKISNWAVCMDNMSCZFGVONJMZXKOPEQEKYAXVDEAGPQKBLBGANCNEFZGNJIEIZJQWXJDIJOCGBPSEXPTTKXBKDSJTEUJUJFCQKKOKYTWAUINLKDNKEBQFWKJWMRTKITYTMXOZSKOONBIDVMHSDSICMALSAAPLYMECASZURXQVMRMKFCCOGVGUAZVLLGDSTHVYPYZESSNIYYRPGOSGYPFGUWTSFKKNOLXLDLGOBRMYMRGRDDIWWQRKBKDFWVAYQBRKTQURJHYYBAXTKYSWJAJHFPMVDWMRPZDYUCFFVJYHPPKTDDNISTDUNDSHICZKVOEDALLCWAQWSNULVCXBHNRBMWZKTPFWQOICKHFCJNUUAIUNZGNOYMLYBBTOVAXTSPVDEMUDSGSMMXCJRCZPUSUCGYTZMTBSXYRMCWNBAIMSXXHYXIWQWBRHXLQBMOKDGWEWALFUNQKBPUXBPRYZWYJXFGPBHYQUYWHXWOUVTSGXTMFDGFKNAWWZJQXULLXBNKLPPNIEDMDKOVUGACPDAKLAIOUTTXHYVGGVLFMWXZDMZSGFZDITFLOIIDINLMDMDRZWRTCBNNALCZQMLJQTHRVPSYUBVYCKVRXGPQTAUKTWVJGALCDTYYVJNXRJFYCFJQAZUMCOMWGRBMLEHLCGWYRKWJGHUBRWNJHXOVSDCRROGTAJARAMCCWDXZKAPWMDBYHVLETXBSCJOUZSTWYFFKHEGEITWMEIONXYYWPACCUIMJXQYHUJRYWHTMZWVFGAUXIYUDAKELZOKWJJBHRIWPLLLCZUGBXNCDAUUFKNWQMGRFWHACLLGWHNINXDDJMXTNAJCTKXOPUTFYZQKBHSBAQQHEORMIRRBCSWXINDJDTHOQLOXWQORMXIUDGZHNHGBHGGGUHOGUCRRYIJMPAJZUUVCZGHYEDKIPVDRZPKVVCUCDSPLLZMMQGNMCMGRLULKGWMADUOZWBURSJXOZVFPMWUUEAWMFFTNNLWZBQHBBJXFRXGKHLEOZPAWGQBSFKMLLHYFCFKJFEHESSGHJWKUIQADZPOLLVOVYJVETKRSZVJSPOYZQXQHKQSJJQASTTIESPAAMAWPLLQGXVGVEGRITAFHTMICMNETVXWZISJTDEXDZPPGKDLRRYSJQIOZSOUGABBYTSSOTYCJICWPPEEFFAVNDDARMZPNVEKVZDDFAZYLLMXIIDJGWXLGOAJUIUFECNBAUAACJLGMXDAQSTKSCREERIGLRFNHDAVJEMUGJCSPWJNBMIYXOVPZVZMERIJGENOAWMMGHEPARARMYGRWYHGNWJHHPTTWTDHFCXMSUDNLLCKIHAWRRLCMHWFLCPWGSWJLYIMDTPQGDGDHOU

Answer 2

明显的代码逻辑错误。count位置在两个for循环外面，导致count最后的值为所有31的频数总和。题主的意思应该是每一天一个count，count应位于第一个for循环内，第二个for循环外。for i in range(1,32):     count = 0     for date in april:         pass