- 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 | 1092048 | -1.2 | 108341 | -1321 | 20183867 | 알라딘 | 2019-05-23 | 1 | 0 | OLD | 1 | 9648223000 | 913041310 | -1.9 | -18029620 | 40.7 | 1121 | 4677 |
| 1 | 2951057 | -27.2 | 79529 | -29763 | 20188941 | 악인전 | 2019-05-15 | 2 | 0 | OLD | 2 | 25902728930 | 652334820 | -27.6 | -249058160 | 29.1 | 1073 | 5176 |
| 2 | 13789965 | -13.9 | 18890 | -3053 | 20184889 | 어벤져스: 엔드게임 | 2019-04-24 | 3 | 0 | OLD | 3 | 120916354120 | 165592030 | -17.9 | -35993750 | 7.4 | 557 | 1205 |
| 3 | 1577418 | -16 | 17918 | -3412 | 20184082 | 걸캅스 | 2019-05-09 | 4 | 0 | OLD | 4 | 13463746334 | 143046020 | -16.6 | -28460200 | 6.4 | 623 | 1733 |
| 4 | 175403 | -5.2 | 12214 | -668 | 20199448 | 어린 의뢰인 | 2019-05-22 | 5 | 0 | OLD | 5 | 1475110490 | 99080580 | -4.5 | -4656170 | 4.4 | 597 | 1761 |
+---+----------+------------+---------+-----------+----------+--------------------+------------+------+-----------+---------------+------+--------------+-----------+-------------+------------+------------+---------+---------+
- DataFrame
'Python_Intermediate > Pandas' 카테고리의 다른 글
Pandas - 190530 노트북 제품 비교 분석 (0) | 2019.05.30 |
---|---|
Pandas - 190529모니터 제품 비교 분석 (0) | 2019.05.29 |
190529 11:40> Naver 실시간 검색어 20위 (0) | 2019.05.29 |
Pandas - Json Data 분석 4(Data 시각화) (0) | 2019.05.29 |
Pandas - 데이터프레임 병합(merge) (0) | 2019.05.27 |