중간 발표 내용

In [2]:

    

import pandas as pd
import numpy as np
from pandas import Series, DataFrame
import matplotlib.pyplot as plt # plot 관련
import matplotlib.font_manager # font 관련
import seaborn as sns # plot 관련
from datetime import datetime # 시간 관련


    

In [3]:

    

%matplotlib inline


    

In [4]:

    

book = pd.read_excel('book.xlsx', encoding = "utf-8") # 책 읽은 내역 데이터
book_times = pd.read_excel('book_times.xlsx') # 책 읽은 시간 내역


    

In [5]:

    

book.head() # 데이터 내용 확인


    

    
Out[5]:






  

    

      

      
Title
      
Subtitle
      
Author
      
Tranlator
      
Publisher
      
Publish Date
      
Format
      
Pages
      
ISBN
      
Status
      
...
      
Category
      
Started Reading
      
Finished Reading
      
Reading Period
      
Borrowed
      
Have Weekend
      
Reading Time
      
Read Reason
      
Found Route
      
Route Category
    
  
  

    

      
0
      
프레임
      
나를 바꾸는 심리학의 지혜
      
최인철
      
NaN
      
21세기북스
      
39253
      
eBook
      
188
      
9788950911546
      
Read
      
...
      
자기계발
      
2015-12-30
      
2016-01-05
      
6
      
N
      
Y
      
0
      
지인추천
      
NaN
      
NaN
    
    

      
1
      
왜 나는 범죄를 공부하는가
      
최고의 프로파일러 표창원 박사의 두려움 없는 공부
      
표창원
      
NaN
      
다산북스
      
2015-03-17 00:00:00
      
eBook
      
229
      
9791130604909
      
Read
      
...
      
자기계발
      
2016-01-05
      
2016-01-07
      
2
      
N
      
N
      
0
      
검색
      
정의의적들
      
TV프로그램
    
    

      
2
      
정의의 적들
      
정의는 때로 천천히, 하지만 반드시 온다
      
표창원
      
NaN
      
한겨레출판
      
2014-05-19 00:00:00
      
eBook
      
312
      
8984318116
      
Read
      
...
      
사회학
      
2016-01-08
      
2016-01-11
      
3
      
N
      
Y
      
0
      
검색
      
정의의적들
      
TV프로그램
    
    

      
3
      
로봇 시대,인간의 일
      
인공지능 시대를 살아가야 할 이들을 위한 안내서
      
구본권
      
NaN
      
어크로스
      
2015-12-15 00:00:00
      
Paperback
      
342
      
9788997379767
      
Read
      
...
      
인문일반
      
2016-01-12
      
2016-01-14
      
2
      
Y
      
N
      
0
      
지인추천
      
NaN
      
NaN
    
    

      
4
      
숨겨진 심리학
      
NaN
      
표창원
      
NaN
      
토네이도
      
2011-04-11 00:00:00
      
book
      
226
      
9788994013343
      
Read
      
...
      
자기계발
      
2016-01-14
      
2016-01-18
      
4
      
Y
      
Y
      
0
      
검색
      
정의의적들
      
TV프로그램
    
  

5 rows × 23 columns

In [6]:

    

book_times.head()


    

    
Out[6]:






  

    

      

      
ISBN
      
Start Read Time
      
End Read Time
      
Read Place
      
Move Place
      
Not Read Reason
      
Weekend Yn
      
Start Page Num
      
End Page Num
    
  
  

    

      
0
      
9788947540674
      
2016-03-03 13:10:00
      
2016-03-03 13:43:00
      
버스
      
학교
      
NaN
      
1.0
      
1
      
38
    
    

      
1
      
9788947540674
      
2016-03-03 21:16:00
      
2016-03-03 22:13:00
      
버스
      
집
      
NaN
      
1.0
      
38
      
87
    
    

      
2
      
9788947540674
      
2016-03-04 14:10:00
      
2016-03-04 14:34:00
      
버스
      
학교
      
NaN
      
1.0
      
87
      
112
    
    

      
3
      
9788947540674
      
2016-03-04 18:50:00
      
2016-03-04 19:45:00
      
버스
      
집
      
NaN
      
1.0
      
112
      
153
    
    

      
4
      
9788947540674
      
2016-03-05 08:13:00
      
2016-03-05 08:53:00
      
버스
      
학교
      
NaN
      
1.0
      
153
      
187
    
  

In [7]:

    

book.info()


    

    




<class 'pandas.core.frame.DataFrame'>
RangeIndex: 18 entries, 0 to 17
Data columns (total 23 columns):
Title               18 non-null object
Subtitle            6 non-null object
Author              18 non-null object
Tranlator           2 non-null object
Publisher           14 non-null object
Publish Date        18 non-null object
Format              18 non-null object
Pages               18 non-null int64
ISBN                18 non-null int64
Status              18 non-null object
Rating              18 non-null int64
Yes24 Rating        18 non-null int64
Tag                 0 non-null float64
Category            18 non-null object
Started Reading     18 non-null datetime64[ns]
Finished Reading    18 non-null datetime64[ns]
Reading Period      18 non-null int64
Borrowed            18 non-null object
Have Weekend        18 non-null object
Reading Time        18 non-null int64
Read Reason         18 non-null object
Found Route         12 non-null object
Route Category      12 non-null object
dtypes: datetime64[ns](2), float64(1), int64(6), object(14)
memory usage: 3.3+ KB

In [8]:

    

book.describe()


    

    
Out[8]:






  

    

      

      
Pages
      
ISBN
      
Rating
      
Yes24 Rating
      
Tag
      
Reading Period
      
Reading Time
    
  
  

    

      
count
      
18.000000
      
1.800000e+01
      
18.000000
      
18.000000
      
0.0
      
18.000000
      
18.000000
    
    

      
mean
      
330.166667
      
8.702916e+12
      
9.222222
      
8.333333
      
NaN
      
4.611111
      
80.888889
    
    

      
std
      
95.030181
      
3.162891e+12
      
1.352799
      
0.766965
      
NaN
      
2.500327
      
139.697105
    
    

      
min
      
188.000000
      
8.934973e+09
      
5.000000
      
8.000000
      
NaN
      
1.000000
      
0.000000
    
    

      
25%
      
284.250000
      
9.788953e+12
      
8.250000
      
8.000000
      
NaN
      
2.250000
      
0.000000
    
    

      
50%
      
319.500000
      
9.788994e+12
      
10.000000
      
8.000000
      
NaN
      
5.000000
      
0.000000
    
    

      
75%
      
360.750000
      
9.790597e+12
      
10.000000
      
8.000000
      
NaN
      
6.000000
      
150.750000
    
    

      
max
      
586.000000
      
9.791196e+12
      
10.000000
      
10.000000
      
NaN
      
9.000000
      
398.000000
    
  

In [10]:

    

print ([f.name for f in matplotlib.font_manager.fontManager.ttflist])  # 그래프에 한글 표시를 위한 코드


    

    




['Bitstream Vera Serif', 'STIXGeneral', 'STIXGeneral', 'STIXSizeThreeSym', 'STIXSizeTwoSym', 'STIXSizeTwoSym', 'STIXSizeThreeSym', 'cmex10', 'Bitstream Vera Sans Mono', 'STIXSizeOneSym', 'Bitstream Vera Sans', 'Bitstream Vera Serif', 'STIXSizeFiveSym', 'cmr10', 'STIXGeneral', 'Bitstream Vera Sans Mono', 'STIXSizeFourSym', 'Bitstream Vera Sans', 'STIXNonUnicode', 'cmmi10', 'cmb10', 'Bitstream Vera Sans Mono', 'STIXNonUnicode', 'Bitstream Vera Sans', 'cmss10', 'Bitstream Vera Sans Mono', 'cmtt10', 'Bitstream Vera Sans', 'cmsy10', 'STIXNonUnicode', 'STIXSizeOneSym', 'STIXSizeFourSym', 'STIXGeneral', 'STIXNonUnicode', 'Vivaldi', 'ParkAvenue BT', 'Garamond', 'Traditional Arabic', 'Yj TEUNTEUN Bold', 'Haan Cooljazz M', 'Comic Sans MS', 'Century Schoolbook', 'Trebuchet MS', 'EucrosiaUPC', 'Microsoft New Tai Lue', 'Calibri', '??????', 'EucrosiaUPC', 'HYsupB', 'Aparajita', 'SimSun-ExtB', 'Angsana New', 'JasmineUPC', 'Elephant', 'Stencil', 'Haan YHead B', 'Arabic Typesetting', 'Brush Script MT', 'DilleniaUPC', 'Verdana', 'OCR-A BT', 'Matura MT Script Capitals', 'CentSchbook BT', 'HYPost-Medium', 'Garamond', 'HYnamL', 'MGungHeulim', 'HYPost-Light', 'IrisUPC', 'Haan Cooljazz L', 'Harrington', 'HYkanB', 'Haan Sale M', 'Gisha', 'Orator10 BT', 'Simplified Arabic', 'Showcard Gothic', 'Segoe UI', 'Rockwell Condensed', 'Franklin Gothic Medium', 'HYporM', 'Lucida Fax', 'Rockwell', 'Consolas', 'Shruti', 'Arial', 'Tw Cen MT', 'Euphemia', 'Gill Sans MT', 'Eras Bold ITC', 'Goudy Old Style', 'Haan Baekje M', 'Rod', 'Aparajita', 'Lucida Console', 'Segoe Script', 'Maiandra GD', 'Century Gothic', 'MS Outlook', 'MGungJeong', 'Segoe UI', 'Blippo Blk BT', 'Magic R', 'Monotype Corsiva', 'Calibri', 'Gisha', 'Cordia New', '??????', 'HYmprL', 'Wingdings', 'Onyx', 'Lucida Sans', 'Yet R', 'GoudyOlSt BT', 'Curlz MT', 'Microsoft Sans Serif', 'CommercialScript BT', 'Gill Sans MT', 'MS Reference Sans Serif', '????', 'Shonar Bangla', 'Haan YGodic 230', 'CordiaUPC', 'MoolBoran', 'Franklin Gothic Book', 'Microsoft JhengHei', 'Cambria', 'Franklin Gothic Demi', 'Bodoni MT', 'Vrinda', 'Corbel', 'Yj MAEHWA  SemiBold', 'HCR Batang', 'Playbill', 'HYkanB', 'Niagara Solid', 'Latha', 'Century Schoolbook', 'Calibri', 'Century Schoolbook', 'CentSchbook BT', 'Gill Sans Ultra Bold', 'Trebuchet MS', 'Times New Roman', 'HCR Batang Ext', 'Arial', 'Segoe UI Symbol', 'Cooper Blk BT', 'Lao UI', 'Courier New', 'BrowalliaUPC', 'Microsoft YaHei', 'CordiaUPC', 'Century Schoolbook', 'HYbsrB', 'Yj SOSEL SemiBold', 'Old English Text MT', 'Lucida Sans Typewriter', 'Leelawadee', 'Garamond', 'HYHeadLine-Medium', 'Corbel', 'ahn2006-M', 'AmeriGarmnd BT', 'TeamViewer11', 'Eras Medium ITC', 'Agency FB', 'Calibri', 'MSugiHeulim', 'Times New Roman', 'Vladimir Script', 'Bookman Old Style', 'Shonar Bangla', 'Century', 'Palatino Linotype', 'Freestyle Script', 'Ebrima', '??????', 'Cordia New', 'HYsnrL', 'Century Schoolbook', 'Engravers MT', 'Gigi', 'Goudy Old Style', 'Angsana New', 'Matura MT Script Capitals', 'Bodoni MT', '??????', 'Perpetua', '????', 'Consolas', 'BrushScript BT', 'Bodoni Bk BT', 'Elephant', 'FangSong', 'LilyUPC', 'Tahoma', 'Gill Sans Ultra Bold Condensed', 'Georgia', 'KodchiangUPC', 'Microsoft YaHei', '????', 'Vladimir Script', 'Nirmala UI', 'Arial', 'Bernard MT Condensed', 'Niagara Engraved', 'Goudy Old Style', 'Lucida Sans Typewriter', 'Courier New', 'Corbel', 'HCR Batang', 'Brush Script MT', 'HYnamB', 'Imprint MT Shadow', 'Khmer UI', 'Headline R', 'MV Boli', 'Segoe UI', 'Lucida Sans Typewriter', 'GoudyOlSt BT', 'AmeriGarmnd BT', '????', 'Candara', 'HYnamL', 'Perpetua Titling MT', 'LilyUPC', 'Californian FB', 'HYgtrE', 'Utsaah', 'MSugiJeong', 'JasmineUPC', 'Bodoni MT', 'Yj BLOCK Medium', 'Castellar', 'Wingdings 2', 'DilleniaUPC', 'Palace Script MT', 'Haan YHead M', 'Arial Rounded MT Bold', 'Gadugi', 'Andalus', 'CentSchbook BT', 'HYSinMyeongJo-Medium', 'Courier New', 'Latha', 'Maiandra GD', 'Goudy Old Style', 'Swis721 BT', 'HYsupB', 'Raavi', 'Kokila', 'Hobo BT', 'GoudyOlSt BT', 'Vani', 'Plantagenet Cherokee', 'Arial', 'Bell MT', 'Segoe UI', 'Malgun Gothic', 'Baskerville BT', 'Lucida Sans Typewriter', 'Constantia', 'Rockwell', 'Edwardian Script ITC', 'Goudy Stout', 'Broadway', 'Papyrus', 'Malgun Gothic', 'Californian FB', 'BrowalliaUPC', 'Ami R', 'Berlin Sans FB', 'Tw Cen MT', 'KaiTi', 'MJemokGothic', 'HYGraphic-Medium', 'Consolas', 'Leelawadee', 'Vijaya', 'DomCasual BT', 'Yj INITIALPOSITIVE Medium', 'HyhwpEQ', 'HYbdaL', 'CentSchbook BT', 'Estrangelo Edessa', 'Georgia', 'HYwulM', 'CentSchbook BT', 'Miriam', 'Segoe UI', 'Franklin Gothic Demi', 'Cordia New', 'OCR-B-10 BT', 'Vijaya', 'Agency FB', 'MDEasop', 'Ami R', 'Copperplate Gothic Bold', 'MDSol', 'Courier New', 'Baskerville Old Face', 'Comic Sans MS', 'HYwulB', 'Eras Bold ITC', 'Microsoft Uighur', 'HYtbrB', 'DomCasual BT', 'Franklin Gothic Book', 'MDArt', 'FreesiaUPC', 'GoudyOlSt BT', 'Trebuchet MS', 'Eras Light ITC', 'Nirmala UI', 'Gill Sans MT', 'Gill Sans MT Ext Condensed Bold', 'Swis721 BT', 'MBatang', 'Browallia New', 'Lucida Sans Typewriter', 'Showcard Gothic', 'Bookman Old Style', 'HYdnkM', 'Aparajita', 'Iskoola Pota', 'Haan Baekje B', 'FreesiaUPC', 'Microsoft Himalaya', 'Haan Sollip M', 'Mangal', 'YJ BELLA Medium', 'Gadugi', 'Lucida Bright', 'Harrington', 'Bodoni MT', 'Microsoft PhagsPa', 'HYnamB', 'Newtext Bk BT', 'Lucida Handwriting', 'HYbdaM', 'Curlz MT', 'HYcysM', 'Gill Sans Ultra Bold', 'Iskoola Pota', 'Tw Cen MT', 'MSugiJeong', 'Gigi', 'Script MT Bold', 'Lucida Bright', 'Utsaah', 'Calibri', 'Utsaah', 'Baskerville Old Face', 'Arial', 'Eras Demi ITC', 'LilyUPC', 'HYcysM', 'Lucida Sans', 'AngsanaUPC', 'Rockwell Condensed', 'Calisto MT', 'MS Reference Specialty', 'HYmjrE', 'Lucida Sans Typewriter', 'Mistral', 'Berlin Sans FB', 'Cambria', 'GoudyOlSt BT', 'Colonna MT', 'High Tower Text', 'Lucida Bright', 'IrisUPC', 'Gill Sans MT', 'MJemokBatang', 'Goudy Old Style', 'Kokila', 'FrankRuehl', 'HYmprL', 'Bodoni Bd BT', 'Franklin Gothic Book', 'MDotum', 'Haan YGodic 240', 'Raavi', 'Rockwell', 'Tahoma', 'KodchiangUPC', 'Browallia New', 'Pyunji R', 'Haan Baekje M', 'Lucida Sans', 'Wingdings 3', 'Gabriola', 'Californian FB', 'Arial', 'ahn2006-B', 'Verdana', 'BroadwayEngraved BT', 'Trebuchet MS', 'Magneto', 'Perpetua Titling MT', 'Chiller', 'Goudy Stout', 'NewJumja', 'Microsoft Yi Baiti', 'Hobo BT', 'High Tower Text', 'Perpetua Titling MT', 'Rockwell Extra Bold', 'Palace Script MT', 'Tw Cen MT', 'Script MT Bold', 'Palatino Linotype', 'Yj CHMSOOT Bold', '??????', 'Bodoni MT', 'AmeriGarmnd BT', '??????', 'Lucida Sans', 'Yj BUTGOT Light ', 'Vani', 'Britannic Bold', 'Constantia', 'Gautami', 'Imprint MT Shadow', 'Yj WADAG Medium', 'HYbdaL', 'HYgtrE', 'KodchiangUPC', 'HYGothic-Medium', 'Felix Titling', 'Haan Sale M', 'Bodoni MT', 'DFKai-SB', 'BrowalliaUPC', 'Palatino Linotype', 'Informal Roman', 'Tw Cen MT', 'Haansoft Dotum', 'Arial Rounded MT Bold', 'ahn2006-L', 'Haan Cooljazz B', 'MDGaesung', 'Corbel', 'Baskerville BT', '??????', 'Parchment', 'HYsupM', 'BrushScript BT', 'HCR Dotum', 'Microsoft Uighur', 'Poor Richard', 'BrowalliaUPC', 'HYbsrB', '??????', 'FreesiaUPC', 'Informal Roman', 'Agency FB', 'Haettenschweiler', 'Arial', 'Yj BONMOKGAK Medium ', 'HYporM', 'Yj SHANALL Medium ', 'Simplified Arabic Fixed', 'MDotum', 'Gill Sans MT Condensed', 'Book Antiqua', 'Cooper Blk BT', 'Haettenschweiler', 'Aparajita', 'Lucida Sans Typewriter', 'Tunga', 'HYGungSo-Bold', 'Bell MT', 'HYkanM', 'CordiaUPC', 'Kartika', 'Modern No. 20', 'Algerian', 'Footlight MT Light', 'Kunstler Script', 'AmeriGarmnd BT', 'Californian FB', 'Yj INITIALPOSITIVE Medium', 'Onyx', 'Century Schoolbook', 'Consolas', 'Yj DOOLGI Medium', 'FZSong_Superfont', 'Candara', 'HYPost-Light', 'Shonar Bangla', 'Franklin Gothic Demi', 'Bodoni Bk BT', 'Haan YHead M', 'Symbol', 'Perpetua', 'Freehand591 BT', 'Gill Sans MT', 'Centaur', 'Courier10 BT', '??????', 'Century Gothic', 'Newtext Bk BT', 'NewJumja', 'Yj DOOLGI Medium', 'AmeriGarmnd BT', 'Georgia', 'Bodoni MT', '??????', 'Eras Light ITC', 'MDArt', 'Haan Somang M', 'HYgprM', 'Segoe Print', 'Yj BUTGOT Light ', 'Century Schoolbook', 'Times New Roman', 'Juice ITC', 'Bell MT', 'Microsoft Uighur', 'Impact', 'Khmer UI', 'Garamond', 'Copperplate Gothic Bold', 'MGungHeulim', 'Harlow Solid Italic', 'Franklin Gothic Medium', 'Yj MAEHWA  SemiBold', 'Perpetua', 'Courier10 BT', 'Viner Hand ITC', 'Calisto MT', 'Bookman Old Style', 'Freestyle Script', 'Yj GOTGAE Medium', 'Berlin Sans FB Demi', 'Pristina', 'Bauhaus 93', 'Haan Sollip B', 'Kalinga', '??????', 'Franklin Gothic Medium Cond', 'HYkanM', 'Calisto MT', 'Yj WADAG Medium', 'Verdana', 'Jokerman', 'SimHei', 'Berlin Sans FB', 'Book Antiqua', 'Vivaldi', 'HYgprM', 'Bell MT', 'JasmineUPC', 'EucrosiaUPC', 'Miriam Fixed', 'HYGothic-Medium', 'CordiaUPC', 'Franklin Gothic Demi', 'David', 'Blackadder ITC', '??????', 'Orbit-B BT', 'Niagara Engraved', 'MHunmin', 'Times New Roman', 'Bodoni MT', 'Khmer UI', 'Bodoni MT', 'HYtbrB', 'Rage Italic', 'HYMyeongJo-Extra', 'Tunga', 'AngsanaUPC', 'Shruti', 'Marlett', 'Berlin Sans FB', 'DilleniaUPC', 'Bookman Old Style', 'HYMyeongJo-Extra', 'HCR Batang Ext', 'Lucida Sans', 'Aharoni', 'Franklin Gothic Demi Cond', 'Stencil BT', 'Yj NANCHO Medium', 'Gill Sans MT', '??????', 'Cooper Blk BT', 'Franklin Gothic Book', 'Gloucester MT Extra Condensed', 'Gautami', 'Bodoni MT', 'Engravers MT', 'DilleniaUPC', 'David', 'Arial', 'Bodoni Bk BT', 'Liberty BT', 'Candara', 'HYPost-Medium', 'Constantia', 'Bodoni Bd BT', 'Wingdings 2', 'YJ INJANG Medium', '??????', 'Haan Cooljazz B', 'Century Gothic', 'Lucida Sans Unicode', 'Segoe Script', 'Angsana New', 'MS Outlook', '??????', 'Swis721 BT', 'HYSinMyeongJo-Medium', 'Blippo Blk BT', 'Franklin Gothic Medium Cond', 'HYHeadLine-Medium', 'Perpetua Titling MT', 'Franklin Gothic Heavy', 'Lucida Bright', 'MSugiHeulim', 'Juice ITC', 'Yj BLOCK Medium', 'Orbit-B BT', 'Georgia', 'CentSchbook BT', 'Century Gothic', '????', 'MJemokGothic', 'Tempus Sans ITC', 'Lucida Fax', 'Garamond', 'Bodoni MT', 'Mongolian Baiti', 'Yj GABI', 'Pristina', 'Microsoft New Tai Lue', 'DaunPenh', 'Kristen ITC', 'Book Antiqua', 'Tw Cen MT Condensed', 'Bookshelf Symbol 7', 'Candara', 'Century Gothic', 'Franklin Gothic Heavy', 'GoudyOlSt BT', 'Century Gothic', 'HYdnkM', 'Lucida Bright', 'Jokerman', 'MDSol', 'Book Antiqua', 'Yj BACDOO Bold ', 'Bodoni MT', 'HYsanB', 'Mistral', 'MGungJeong', 'Cambria', 'Mangal', 'Old English Text MT', 'LilyUPC', 'Gadugi', 'Lucida Bright', 'Microsoft Tai Le', 'Chiller', 'Verdana', 'Snap ITC', 'Angsana New', 'Algerian', 'CentSchbook BT', 'Vani', 'Bell MT', 'EucrosiaUPC', 'Franklin Gothic Heavy', 'Lucida Calligraphy', 'Bodoni MT', 'Yj DWMMOOGJO', 'JasmineUPC', 'Bookman Old Style', 'Haansoft Batang', 'CommercialScript BT', 'Century Gothic', 'HCR Dotum', 'Bodoni MT', 'Calibri', 'Kokila', 'Ravie', 'Perpetua', 'Liberty BT', 'Palatino Linotype', 'MS Reference Specialty', 'FreesiaUPC', 'Traditional Arabic', 'Shonar Bangla', 'Lucida Fax', 'Levenim MT', 'HYGothic-Extra', 'Goudy Old Style', 'Bookman Old Style', 'Century', 'New Gulim', 'BernhardFashion BT', 'Magic R', 'Agency FB', 'Sakkal Majalla', 'Haansoft Batang', 'AngsanaUPC', 'Californian FB', 'Rockwell', 'Yj SHANALL Medium ', 'Bodoni MT', 'BroadwayEngraved BT', 'AngsanaUPC', 'Segoe Print', 'Bodoni Bk BT', 'HYhaeseo', 'IrisUPC', 'Browallia New', 'Rockwell Condensed', 'Californian FB', 'Yj GOTGAE Medium', 'Wide Latin', 'Tempus Sans ITC', 'Lucida Handwriting', 'HYhaeseo', 'MS Reference Sans Serif', 'Courier10 BT', 'Calisto MT', 'OCR-B-10 BT', '????', 'MBatang', 'Lucida Fax', 'Rockwell', 'Segoe UI', 'Copperplate Gothic Light', 'Narkisim', 'Broadway', 'Bodoni MT', 'Lucida Sans', 'IrisUPC', 'Yj CHMSOOT Bold', 'Tw Cen MT', 'HYbdaM', 'Bradley Hand ITC', 'Gill Sans MT Condensed', 'HYShortSamul-Medium', 'High Tower Text', 'Haan Somang B', 'Cordia New', 'HYGothic-Extra', 'Bodoni MT', 'Haan Sollip B', 'HYnamM', 'Rockwell Condensed', 'Century Gothic', 'Gill Sans MT Ext Condensed Bold', '??????', 'GoudyOlSt BT', 'Yj TEUNTEUN Bold', 'OCR-A BT', 'Webdings', 'Bookman Old Style', 'Gill Sans MT', 'Gill Sans MT', 'Ravie', 'HYwulM', 'Yj GABI', 'Perpetua', 'Lucida Fax', 'Arial', 'HYgsrB', 'Tw Cen MT Condensed', 'Haan Cooljazz M', 'Kokila', 'Arial', 'HYsupM', 'Haan Sollip M', '??????', 'Yet R', 'Eras Demi ITC', 'Tw Cen MT Condensed', 'Lucida Fax', 'KodchiangUPC', 'Kalinga', 'Haan YGodic 240', 'Bauhaus 93', 'Britannic Bold', 'Arial Unicode MS', 'Nirmala UI', 'OCR A Extended', 'Forte', 'Lucida Fax', 'MHunmin', 'Lao UI', 'Papyrus', 'Bradley Hand ITC', 'HYmjrE', 'Nyala', 'Garamond', 'MDAlong', 'Tw Cen MT Condensed Extra Bold', 'Segoe UI', 'HCR Dotum Ext', 'Stencil BT', 'Felix Titling', 'MurrayHill Bd BT', 'AmeriGarmnd BT', 'Haan YGodic 250', 'Tw Cen MT Condensed Extra Bold', 'Blackadder ITC', 'Stencil', 'Lao UI', 'Vrinda', 'OCR A Extended', 'Haan Sale B', 'Sakkal Majalla', 'Rockwell', 'Gadugi', 'Utsaah', 'Ebrima', 'FuturaBlack BT', 'HYPMokGak-Bold', 'Franklin Gothic Heavy', 'Poor Richard', 'Bodoni Bd BT', 'HYGungSo-Bold', 'Simplified Arabic', 'Constantia', 'Kartika', 'Bodoni Bd BT', 'Sylfaen', 'AmeriGarmnd BT', 'Centaur', 'New Gulim', 'Rage Italic', 'Footlight MT Light', 'HCR Batang', 'Bell MT', 'Calisto MT', 'Franklin Gothic Demi Cond', 'HYgsrB', 'Perpetua', 'HYdnkB', 'Microsoft PhagsPa', 'GoudyOlSt BT', 'HYsanB', 'Wide Latin', 'Lucida Fax', 'Century Schoolbook', 'HCR Dotum Ext', 'Book Antiqua', 'Haan YHead L', 'Monotype Corsiva', 'HYsnrL', 'Haan Somang M', 'Playbill', 'Candara', 'HYShortSamul-Medium', 'Lucida Bright', 'AmeriGarmnd BT', 'Bodoni MT', 'Arial', 'Modern No. 20', 'CentSchbook BT', 'Castellar', 'Haan YGodic 250', 'Rockwell', 'Perpetua', 'Arial', 'Lucida Calligraphy', 'Yj DWMMOOGJO', 'Calisto MT', 'Parchment', 'BernhardFashion BT', 'Wingdings 3', 'Yj BACDOO Bold ', 'French Script MT', 'Khmer UI', 'Tw Cen MT Condensed', 'MurrayHill Bd BT', 'HCR Dotum', 'Haan Baekje B', 'Forte', 'Candara', 'Microsoft Tai Le', 'Browallia New', 'Gloucester MT Extra Condensed', 'Courier10 BT', 'Rockwell', 'Berlin Sans FB Demi', 'Haan YGodic 230', 'Freehand591 BT', 'Magneto', 'Arial', 'Bodoni MT', 'Cooper Black', 'Elephant', 'Vani', 'DokChampa', 'HCR Dotum', 'FuturaBlack BT', 'Tw Cen MT', 'Candara', 'Bodoni MT', 'Cooper Black', 'Calisto MT', 'Yj SOSEL SemiBold', 'HYwulB', 'Gabriola', 'Copperplate Gothic Light', 'Tw Cen MT', 'HYPMokGak-Bold', 'Microsoft JhengHei', 'Haan YHead B', 'Swis721 BT', 'Haan Sale B', 'ParkAvenue BT', 'Haan Cooljazz L', 'Haansoft Dotum', 'HYGraphic-Medium', 'Haan YHead L', 'Lucida Sans Typewriter', 'Elephant', 'Segoe UI', 'Kunstler Script', 'Kristen ITC', 'Book Antiqua', 'Orator10 BT', 'Snap ITC', 'Lucida Sans', 'Pyunji R', 'Arial Unicode MS', 'YJ INJANG Medium', 'Colonna MT', 'Bookshelf Symbol 7', 'HCR Batang', 'MT Extra', 'MDAlong', 'Gill Sans Ultra Bold Condensed', 'HYdnkB', 'Book Antiqua', 'Lucida Sans', 'HyhwpEQ', 'Perpetua', 'Bodoni MT', 'Levenim MT', 'French Script MT', 'Yj NANCHO Medium', 'Viner Hand ITC', 'MDGaesung', 'Book Antiqua', 'Bernard MT Condensed', 'Bookman Old Style', 'Edwardian Script ITC', 'HYnamM', 'YJ BELLA Medium', 'Calisto MT', 'Harlow Solid Italic', 'High Tower Text', 'Lucida Bright', 'Rockwell Extra Bold', 'FZSong_Superfont', 'Haan Somang B', 'Eras Medium ITC', 'Bodoni MT', 'Niagara Solid', 'Cooper Blk BT', 'Candara', 'Yj BONMOKGAK Medium ', 'Lao UI', '??????', 'Headline R', 'Nirmala UI', 'MDEasop', 'MJemokBatang']

In [11]:

    

matplotlib.rc('font', family='HCR Dotum') # font 지정


    

In [12]:

    

cate_g = sns.factorplot('Category', kind = 'count', data=book,aspect=1.5, palette="muted") # aspect : 축을 늘려줌, palette : 색지정
cate_g.fig.suptitle("카테고리별 책 수")
cate_g.set_ylabels("책 수")
cate_g.fig.subplots_adjust(top=.9)


    

In [13]:

    

borrow_g = sns.factorplot('Borrowed', kind = 'count', data=book, aspect = 1.5, palette = "muted")
borrow_g.fig.suptitle("빌림 여부 확인")
borrow_g.set_ylabels("책 수")
borrow_g.fig.subplots_adjust(top=.9)


    

In [14]:

    

Format_g = sns.factorplot('Format', kind='count', data=book, aspect=1.5, palette="muted")
Format_g.fig.suptitle("수단 별 책 수")
Format_g.set_ylabels("책 수")
Format_g.fig.subplots_adjust(top=.9)


    

In [16]:

    

book['Month'] = book['Started Reading'].dt.month


    

In [17]:

    

Month_g = sns.factorplot('Month', kind='count', data=book, aspect=1.5, palette = 'muted')
Month_g.fig.suptitle("월별 읽은 책 수")
Month_g.set_ylabels("책 수")
Month_g.fig.subplots_adjust(top=.9)


    

In [18]:

    

Week_g = sns.factorplot('Have Weekend', kind = 'count', data=book, aspect=1.5, palette = 'muted')
Week_g.fig.suptitle("주말 넘김 여부에 따른 책 수")
Week_g.set_ylabels("책 수")
Week_g.fig.subplots_adjust(top=.9)


    

In [19]:

    

Week_df = book[book['Have Weekend'] == 'Y' ] # 주말포함
No_Week_df = book[book['Have Weekend'] == 'N' ] # 주말제외


    

In [20]:

    

WeekRat_g = sns.factorplot('Rating', kind='count', data= Week_df)
WeekRat_g.fig.suptitle("별점 별 책 현황(주말)")
WeekRat_g.set_ylabels("책 수")
WeekRat_g.fig.subplots_adjust(top=.9)


    

In [21]:

    

NoWeekRat_g = sns.factorplot('Rating', kind='count', data= No_Week_df)
NoWeekRat_g.fig.suptitle("별점 별 책 현황(주중)")
NoWeekRat_g.set_ylabels("책 수")
NoWeekRat_g.fig.subplots_adjust(top=.9)


    

In [22]:

    

Week_df['Read Reason'].value_counts()


    

    
Out[22]:





검색      8
지인추천    4
관심      1
Name: Read Reason, dtype: int64

In [23]:

    

No_Week_df['Read Reason'].value_counts()


    

    
Out[23]:





지인추천    2
검색      2
관심      1
Name: Read Reason, dtype: int64

In [24]:

    

Week_me_df = Week_df[Week_df['Read Reason'] == '검색'] # 주말넘기면서 내가 검색해서 고른 책만 뽑기


    

In [25]:

    

MeWeekRat_g = sns.factorplot('Rating', kind='count', data= Week_me_df)
MeWeekRat_g.fig.suptitle("별점 별 책 현황(주말-검색)")
MeWeekRat_g.set_ylabels("책 수")
MeWeekRat_g.fig.subplots_adjust(top=.9)


    

In [26]:

    

Week_Not_me = Week_df[Week_df['Read Reason'] != '검색'] # 주말넘기면서 내가 검색안한 것만 뽑기


    

In [27]:

    

NotMeWeekRat_g = sns.factorplot('Rating', kind='count', data= Week_Not_me)
NotMeWeekRat_g.fig.suptitle("별점 별 책 현황(주말-검색제외)")
NotMeWeekRat_g.set_ylabels("책 수")
NotMeWeekRat_g.fig.subplots_adjust(top=.9)


    

In [28]:

    

book_times['Read Page Num'] = book_times['End Page Num'] - book_times['Start Page Num'] # 페이지 수 변수
book_times['Spent time'] = ((book_times['End Read Time']- book_times['Start Read Time']).dt.seconds % 3600) // 60 # 읽은 시간 (분)


    

In [29]:

    

plt.scatter(book_times['Read Page Num'], book_times['Spent time']) # 상관관계 그래프를 위한 scatter plot
plt.title('페이지수와 읽은 시간') # plot의 제목
plt.xlabel('페이지 수') # xlabel
plt.ylabel('읽은 시간(분)') # ylabel
plt.xlim(0, book_times['Read Page Num'].max()+20) # x축 범위
plt.ylim(0, book_times['Spent time'].max()+10) # y축 범위
plt.gca().set_aspect('equal', adjustable='box')