In [7]:

    

import pandas as pd

def get_comment_by_user(filename, username):
    comments = pd.read_csv(filename)
    # comments['date'] = comments['date'].apply(lambda d: datetime.datetime.strptime(d, '%Y-%m-%d').date())
    comments['date'] = pd.to_datetime(comments['date'])
    score_comments = comments[['date', 'score']].sort(['date'])
    comments[comments['user']==username]
    print(score_comments.describe())

get_comment_by_user('web/inheritant.csv', '윤유진')
get_comment_by_user('web/allrightlove.csv', '윤유진')
get_comment_by_user('web/knifeflower.csv', '윤유진')


    

    




              score
count  10440.000000
mean       9.466092
std        1.990349
min        0.000000
25%       10.000000
50%       10.000000
75%       10.000000
max       10.000000

[8 rows x 1 columns]
             score
count  1000.000000
mean      8.414000
std       3.164272
min       0.000000
25%       9.000000
50%      10.000000
75%      10.000000
max      10.000000

[8 rows x 1 columns]
            score
count  480.000000
mean     6.020833
std      4.057466
min      0.000000
25%      1.000000
50%      8.000000
75%     10.000000
max     10.000000

[8 rows x 1 columns]