Python Pandas 박스오피스 190606 순위 분석
- Import Module
import datetime as dt
import requests
import json
import pandas
from pandas import DataFrame
from matplotlib import pyplot
from print_df import print_df
- Parsing Data
+---+---------+------------+---------+-----------+----------+---------------------+------------+------+-----------+---------------+------+-------------+------------+-------------+------------+------------+---------+---------+
| | audiAcc | audiChange | audiCnt | audiInten | movieCd | movieNm | openDt | rank | rankInten | rankOldAndNew | rnum | salesAcc | salesAmt | salesChange | salesInten | salesShare | scrnCnt | showCnt |
+---+---------+------------+---------+-----------+----------+---------------------+------------+------+-----------+---------------+------+-------------+------------+-------------+------------+------------+---------+---------+
| 0 | 5355333 | 95.3 | 831577 | 405818 | 20183782 | 기생충 | 2019-05-30 | 1 | 0 | OLD | 1 | 45684532988 | 7210152290 | 109.9 | 3774395430 | 53.5 | 1573 | 7972 |
| 1 | 2803157 | 230.1 | 373561 | 260389 | 20183867 | 알라딘 | 2019-05-23 | 2 | 1 | OLD | 2 | 23432816342 | 3146464260 | 248.3 | 2243153390 | 23.4 | 1120 | 3738 |
| 2 | 369118 | 101 | 246265 | 123715 | 20182387 | 엑스맨: 다크 피닉스 | 2019-06-05 | 3 | -1 | OLD | 3 | 3269065010 | 2200183450 | 106.9 | 1136755890 | 16.3 | 928 | 4161 |
| 3 | 38322 | 6961.5 | 35237 | 34738 | 19880001 | 이웃집 토토로 | 2001-07-28 | 4 | 11 | OLD | 4 | 314753740 | 287508740 | 7899.7 | 283914740 | 2.1 | 397 | 595 |
| 4 | 33088 | 62.9 | 19370 | 7480 | 20198291 | 로켓맨 | 2019-06-05 | 5 | -1 | OLD | 5 | 281954930 | 171657110 | 81.8 | 77211290 | 1.3 | 555 | 1252 |
+---+---------+------------+---------+-----------+----------+---------------------+------------+------+-----------+---------------+------+-------------+------------+-------------+------------+------------+---------+---------+
- DataFrame