Python Pandas 박스오피스 190601 순위 분석
- 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 | 2372310 | 68.7 | 1126561 | 458769 | 20183782 | 기생충 | 2019-05-30 | 1 | 0 | OLD | 1 | 20479182448 | 9907985973 | 68.1 | 4014544998 | 68.8 | 1926 | 9902 |
| 1 | 1842303 | 148.3 | 306058 | 182790 | 20183867 | 알라딘 | 2019-05-23 | 2 | 0 | OLD | 2 | 15416106172 | 2610974127 | 140.8 | 1526830402 | 18.1 | 965 | 3451 |
| 2 | 236118 | 107.5 | 78282 | 40563 | 20184865 | 고질라: 킹 오브 몬스터 | 2019-05-29 | 3 | 1 | OLD | 3 | 1994088788 | 738268373 | 104.8 | 377834088 | 5.1 | 610 | 1615 |
| 3 | 3230927 | 35 | 62886 | 16299 | 20188941 | 악인전 | 2019-05-15 | 4 | -1 | OLD | 4 | 27995218090 | 567294200 | 38.7 | 158201730 | 3.9 | 569 | 1628 |
| 4 | 85289 | 73.9 | 25945 | 11024 | 20188144 | 0.0MHz | 2019-05-29 | 5 | 0 | OLD | 5 | 658800680 | 220796140 | 66.3 | 87998700 | 1.5 | 409 | 673 |
+---+---------+------------+---------+-----------+----------+------------------------+------------+------+-----------+---------------+------+-------------+------------+-------------+------------+------------+---------+---------+
- DataFrame
+-------------------------------+----------+
| | 관람객수 |
+-------------------------------+----------+
| 교회오빠 | 2372 |
| 어린 의뢰인 | 2725 |
| 걸캅스 | 4258 |
| 피터팬: 후크 선장과 결투의 날 | 4394 |
| 어벤져스: 엔드게임 | 13071 |
| 0.0MHz | 25945 |
| 악인전 | 62886 |
| 고질라: 킹 오브 몬스터 | 78282 |
| 알라딘 | 306058 |
| 기생충 | 1126561 |
+-------------------------------+----------+