wc -l のアクセス集計

wc -l のアクセス集計 を pythonで集計した。

wc -l accesslog.*

a  = '''
    10914 accesslog.20180828010002
     8636 accesslog.20180829010001
     4742 accesslog.20180830010002
     6399 accesslog.20180831010001
     6901 accesslog.20180901010001
     5503 accesslog.20180902010001
     5988 accesslog.20180903010001
     7018 accesslog.20180904010002
     6500 accesslog.20180905010001
     6566 accesslog.20180906010001
     9494 accesslog.20180907010002
     6426 accesslog.20180908010001
     5942 accesslog.20180909010002
'''


b =[l.strip().split(' ') for l in a.strip().split('\n')]
df_b = pd.DataFrame(data=b, columns=['count','file'])

df_b['count'] = df_b['count'].astype(int)
df_b['date'] = df_b['file'].apply(lambda x: pd.to_datetime(x, format='accesslog.%Y%m%d%H%M%S', errors='ignore'))

fig = sns.mpl.pyplot.figure()
ax = fig.add_subplot(111)
ax.plot(list(df_b['date']), list(df_b['count']), label='access_count')
ax.axvline(x='2018-09-01', linewidth=2, color='r')
ax.legend()
fig.autofmt_xdate()
fig.savefig('access_count.png')
fig.show()

stackoverflow.com