Beny's Study

22_2. [강의] API 파싱 (영화정보) 본문

[JAVA]/10. API

22_2. [강의] API 파싱 (영화정보)

76beny 2022. 5. 29. 11:04
 

 

 class Parsing

package com.kh.ex02.string_usage;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

//https://www.kobis.or.kr/kobisopenapi/homepg/apiservice/searchServiceInfo.do
//http://kobis.or.kr/kobisopenapi/webservice/rest/boxoffice/searchWeeklyBoxOfficeList.json?key=f5eef3421c602c6cb7ea224104795888&targetDt=20120101

public class Parsing {
	
	static String text = "{\"boxOfficeResult\":{\"boxofficeType\":\"일별 박스오피스\",\"showRange\":\"20120101~20120101\",\"dailyBoxOfficeList\":[{\"rnum\":\"1\",\"rank\":\"1\",\"rankInten\":\"0\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20112207\",\"movieNm\":\"미션임파서블-고스트프로토콜\",\"openDt\":\"2011-12-15\",\"salesAmt\":\"2776060500\",\"salesShare\":\"36.3\",\"salesInten\":\"-415699000\",\"salesChange\":\"-13\",\"salesAcc\":\"40541108500\",\"audiCnt\":\"353274\",\"audiInten\":\"-60106\",\"audiChange\":\"-14.5\",\"audiAcc\":\"5328435\",\"scrnCnt\":\"697\",\"showCnt\":\"3223\"},{\"rnum\":\"2\",\"rank\":\"2\",\"rankInten\":\"1\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20110295\",\"movieNm\":\"마이 웨이\",\"openDt\":\"2011-12-21\",\"salesAmt\":\"1189058500\",\"salesShare\":\"15.6\",\"salesInten\":\"-105894500\",\"salesChange\":\"-8.2\",\"salesAcc\":\"13002897500\",\"audiCnt\":\"153501\",\"audiInten\":\"-16465\",\"audiChange\":\"-9.7\",\"audiAcc\":\"1739543\",\"scrnCnt\":\"588\",\"showCnt\":\"2321\"},{\"rnum\":\"3\",\"rank\":\"3\",\"rankInten\":\"-1\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20112621\",\"movieNm\":\"셜록홈즈 : 그림자 게임\",\"openDt\":\"2011-12-21\",\"salesAmt\":\"1176022500\",\"salesShare\":\"15.4\",\"salesInten\":\"-210328500\",\"salesChange\":\"-15.2\",\"salesAcc\":\"10678327500\",\"audiCnt\":\"153004\",\"audiInten\":\"-31283\",\"audiChange\":\"-17\",\"audiAcc\":\"1442861\",\"scrnCnt\":\"360\",\"showCnt\":\"1832\"},{\"rnum\":\"4\",\"rank\":\"4\",\"rankInten\":\"0\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20113260\",\"movieNm\":\"퍼펙트 게임\",\"openDt\":\"2011-12-21\",\"salesAmt\":\"644532000\",\"salesShare\":\"8.4\",\"salesInten\":\"-75116500\",\"salesChange\":\"-10.4\",\"salesAcc\":\"6640940000\",\"audiCnt\":\"83644\",\"audiInten\":\"-12225\",\"audiChange\":\"-12.8\",\"audiAcc\":\"895416\",\"scrnCnt\":\"396\",\"showCnt\":\"1364\"},{\"rnum\":\"5\",\"rank\":\"5\",\"rankInten\":\"0\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20113271\",\"movieNm\":\"프렌즈: 몬스터섬의비밀 \",\"openDt\":\"2011-12-29\",\"salesAmt\":\"436753500\",\"salesShare\":\"5.7\",\"salesInten\":\"-89051000\",\"salesChange\":\"-16.9\",\"salesAcc\":\"1523037000\",\"audiCnt\":\"55092\",\"audiInten\":\"-15568\",\"audiChange\":\"-22\",\"audiAcc\":\"202909\",\"scrnCnt\":\"290\",\"showCnt\":\"838\"},{\"rnum\":\"6\",\"rank\":\"6\",\"rankInten\":\"1\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"19940256\",\"movieNm\":\"라이온 킹\",\"openDt\":\"1994-07-02\",\"salesAmt\":\"507115500\",\"salesShare\":\"6.6\",\"salesInten\":\"-114593500\",\"salesChange\":\"-18.4\",\"salesAcc\":\"1841625000\",\"audiCnt\":\"45750\",\"audiInten\":\"-11699\",\"audiChange\":\"-20.4\",\"audiAcc\":\"171285\",\"scrnCnt\":\"244\",\"showCnt\":\"895\"},{\"rnum\":\"7\",\"rank\":\"7\",\"rankInten\":\"-1\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20113381\",\"movieNm\":\"오싹한 연애\",\"openDt\":\"2011-12-01\",\"salesAmt\":\"344871000\",\"salesShare\":\"4.5\",\"salesInten\":\"-107005500\",\"salesChange\":\"-23.7\",\"salesAcc\":\"20634684500\",\"audiCnt\":\"45062\",\"audiInten\":\"-15926\",\"audiChange\":\"-26.1\",\"audiAcc\":\"2823060\",\"scrnCnt\":\"243\",\"showCnt\":\"839\"},{\"rnum\":\"8\",\"rank\":\"8\",\"rankInten\":\"0\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20112709\",\"movieNm\":\"극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」\",\"openDt\":\"2011-12-22\",\"salesAmt\":\"167809500\",\"salesShare\":\"2.2\",\"salesInten\":\"-45900500\",\"salesChange\":\"-21.5\",\"salesAcc\":\"1897120000\",\"audiCnt\":\"24202\",\"audiInten\":\"-7756\",\"audiChange\":\"-24.3\",\"audiAcc\":\"285959\",\"scrnCnt\":\"186\",\"showCnt\":\"348\"},{\"rnum\":\"9\",\"rank\":\"9\",\"rankInten\":\"0\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20113311\",\"movieNm\":\"앨빈과 슈퍼밴드3\",\"openDt\":\"2011-12-15\",\"salesAmt\":\"137030000\",\"salesShare\":\"1.8\",\"salesInten\":\"-35408000\",\"salesChange\":\"-20.5\",\"salesAcc\":\"3416675000\",\"audiCnt\":\"19729\",\"audiInten\":\"-6461\",\"audiChange\":\"-24.7\",\"audiAcc\":\"516289\",\"scrnCnt\":\"169\",\"showCnt\":\"359\"},{\"rnum\":\"10\",\"rank\":\"10\",\"rankInten\":\"0\",\"rankOldAndNew\":\"OLD\",\"movieCd\":\"20112708\",\"movieNm\":\"극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」\",\"openDt\":\"2011-12-22\",\"salesAmt\":\"125535500\",\"salesShare\":\"1.6\",\"salesInten\":\"-40756000\",\"salesChange\":\"-24.5\",\"salesAcc\":\"1595695000\",\"audiCnt\":\"17817\",\"audiInten\":\"-6554\",\"audiChange\":\"-26.9\",\"audiAcc\":\"235070\",\"scrnCnt\":\"175\",\"showCnt\":\"291\"}]}}";

	public static void main(String[] args) {
		String[] array1 = text.split("\\[");  // Delimiter, [자를건데 특수문자라 \\붙임
		for(String str : array1) {
			System.out.println(str);
		}
		System.out.println("Header 분리 완료!");
		
		String[] array2 = array1[1].split("\\]");
		for(String str : array2) {
			System.out.println(str);
		}
		System.out.println("Tail 분리 완료!");

		String body = array2[0];
		String[] infoArray = body.split("}");
		for(String str : infoArray) {
			System.out.println(str);
		}
		System.out.println("정보단위 분리 완료!");
		
		for(int i = 0; i < infoArray.length; i++) {
			infoArray[i] = infoArray[i].replace(",{", "").replace("{", "");
			System.out.println(infoArray[i]);
		}
		System.out.println("정보단위 쓰레기 문자 제거 완료!");
		
		String[][] rawDataArray = new String[infoArray.length][];
		for(int i = 0; i < infoArray.length; i++) {
			rawDataArray[i] = infoArray[i].split(",");
//			System.out.println(Arrays.toString(rawDataArray[i]));
			for(int j = 0; j< rawDataArray[i].length; j++ ) {
				rawDataArray[i][j] = rawDataArray[i][j].replace("\"", "").strip();
			}
			System.out.println(Arrays.toString(rawDataArray[i]));
		}
// 객체별 Raw데이터 확보 
//[rnum:1, rank:1, ... movieNm:미션임파서블:고스트프로토콜, openDt:2011-12-15, salesAmt:2776060500, salesShare:36.3, salesInten:-415699000, salesChange:-13, salesAcc:40541108500, audiCnt:353274, audiInten:-60106, audiChange:-14.5, audiAcc:5328435, scrnCnt:697, showCnt:3223]

		
		// 치트키.. 
		List<Map<String, String>> jsonList = new ArrayList<>();
		
		for(int i = 0; i< rawDataArray.length; i++) {
			Map<String, String> map = new HashMap<>();
			for(int j =0; j <  rawDataArray[i].length; j++) {
				String key = rawDataArray[i][j].split(":")[0];
				String value = rawDataArray[i][j].split(":")[1];
				map.put(key, value);
			}
			System.out.println(map);
			jsonList.add(map);
		}
		System.out.println("객체 별 데이터의 Key:Value 분리 완료");
		System.out.println();
		
		System.out.println("주말 BoxOfiice");
		for(Map<String, String> map : jsonList) {
			String print = map.get("rank") + "위 : " + map.get("movieNm")
			+ ", 누적 관객수 : " + Integer.parseInt(map.get("audiAcc")) / 10000 + "만명" ;
			System.out.println(print);
		}
		
	}
}

 https://codechacha.com/ko/java-parse-json/
 * 필드에 나가서는 검증된 코드를 쓰는것을 권장합니다. 
 * 검증이 된 코드가 좋은 코드입니다. 여러분이 직접 만든 코드는 모두 검증되지 않은 코드.
 * 버그 없는 프로그램은 없다. -> Test에서 예외 case 별로 검증이 필요하다. 
 * 여러분의 실력이 문제가 아니라 필드에서는 검증 된 것이 중요.
 * 코딩 아무리 잘해도 버그는 나온다. (리눅스도 마이너스 버그 픽스 수십번...)

 

[출력]

{"boxOfficeResult":{"boxofficeType":"일별 박스오피스","showRange":"20120101~20120101","dailyBoxOfficeList":
{"rnum":"1","rank":"1","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112207","movieNm":"미션임파서블-고스트프로토콜","openDt":"2011-12-15","salesAmt":"2776060500","salesShare":"36.3","salesInten":"-415699000","salesChange":"-13","salesAcc":"40541108500","audiCnt":"353274","audiInten":"-60106","audiChange":"-14.5","audiAcc":"5328435","scrnCnt":"697","showCnt":"3223"},{"rnum":"2","rank":"2","rankInten":"1","rankOldAndNew":"OLD","movieCd":"20110295","movieNm":"마이 웨이","openDt":"2011-12-21","salesAmt":"1189058500","salesShare":"15.6","salesInten":"-105894500","salesChange":"-8.2","salesAcc":"13002897500","audiCnt":"153501","audiInten":"-16465","audiChange":"-9.7","audiAcc":"1739543","scrnCnt":"588","showCnt":"2321"},{"rnum":"3","rank":"3","rankInten":"-1","rankOldAndNew":"OLD","movieCd":"20112621","movieNm":"셜록홈즈 : 그림자 게임","openDt":"2011-12-21","salesAmt":"1176022500","salesShare":"15.4","salesInten":"-210328500","salesChange":"-15.2","salesAcc":"10678327500","audiCnt":"153004","audiInten":"-31283","audiChange":"-17","audiAcc":"1442861","scrnCnt":"360","showCnt":"1832"},{"rnum":"4","rank":"4","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113260","movieNm":"퍼펙트 게임","openDt":"2011-12-21","salesAmt":"644532000","salesShare":"8.4","salesInten":"-75116500","salesChange":"-10.4","salesAcc":"6640940000","audiCnt":"83644","audiInten":"-12225","audiChange":"-12.8","audiAcc":"895416","scrnCnt":"396","showCnt":"1364"},{"rnum":"5","rank":"5","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113271","movieNm":"프렌즈: 몬스터섬의비밀 ","openDt":"2011-12-29","salesAmt":"436753500","salesShare":"5.7","salesInten":"-89051000","salesChange":"-16.9","salesAcc":"1523037000","audiCnt":"55092","audiInten":"-15568","audiChange":"-22","audiAcc":"202909","scrnCnt":"290","showCnt":"838"},{"rnum":"6","rank":"6","rankInten":"1","rankOldAndNew":"OLD","movieCd":"19940256","movieNm":"라이온 킹","openDt":"1994-07-02","salesAmt":"507115500","salesShare":"6.6","salesInten":"-114593500","salesChange":"-18.4","salesAcc":"1841625000","audiCnt":"45750","audiInten":"-11699","audiChange":"-20.4","audiAcc":"171285","scrnCnt":"244","showCnt":"895"},{"rnum":"7","rank":"7","rankInten":"-1","rankOldAndNew":"OLD","movieCd":"20113381","movieNm":"오싹한 연애","openDt":"2011-12-01","salesAmt":"344871000","salesShare":"4.5","salesInten":"-107005500","salesChange":"-23.7","salesAcc":"20634684500","audiCnt":"45062","audiInten":"-15926","audiChange":"-26.1","audiAcc":"2823060","scrnCnt":"243","showCnt":"839"},{"rnum":"8","rank":"8","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112709","movieNm":"극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」","openDt":"2011-12-22","salesAmt":"167809500","salesShare":"2.2","salesInten":"-45900500","salesChange":"-21.5","salesAcc":"1897120000","audiCnt":"24202","audiInten":"-7756","audiChange":"-24.3","audiAcc":"285959","scrnCnt":"186","showCnt":"348"},{"rnum":"9","rank":"9","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113311","movieNm":"앨빈과 슈퍼밴드3","openDt":"2011-12-15","salesAmt":"137030000","salesShare":"1.8","salesInten":"-35408000","salesChange":"-20.5","salesAcc":"3416675000","audiCnt":"19729","audiInten":"-6461","audiChange":"-24.7","audiAcc":"516289","scrnCnt":"169","showCnt":"359"},{"rnum":"10","rank":"10","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112708","movieNm":"극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」","openDt":"2011-12-22","salesAmt":"125535500","salesShare":"1.6","salesInten":"-40756000","salesChange":"-24.5","salesAcc":"1595695000","audiCnt":"17817","audiInten":"-6554","audiChange":"-26.9","audiAcc":"235070","scrnCnt":"175","showCnt":"291"}]}}
Header 분리 완료!
{"rnum":"1","rank":"1","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112207","movieNm":"미션임파서블-고스트프로토콜","openDt":"2011-12-15","salesAmt":"2776060500","salesShare":"36.3","salesInten":"-415699000","salesChange":"-13","salesAcc":"40541108500","audiCnt":"353274","audiInten":"-60106","audiChange":"-14.5","audiAcc":"5328435","scrnCnt":"697","showCnt":"3223"},{"rnum":"2","rank":"2","rankInten":"1","rankOldAndNew":"OLD","movieCd":"20110295","movieNm":"마이 웨이","openDt":"2011-12-21","salesAmt":"1189058500","salesShare":"15.6","salesInten":"-105894500","salesChange":"-8.2","salesAcc":"13002897500","audiCnt":"153501","audiInten":"-16465","audiChange":"-9.7","audiAcc":"1739543","scrnCnt":"588","showCnt":"2321"},{"rnum":"3","rank":"3","rankInten":"-1","rankOldAndNew":"OLD","movieCd":"20112621","movieNm":"셜록홈즈 : 그림자 게임","openDt":"2011-12-21","salesAmt":"1176022500","salesShare":"15.4","salesInten":"-210328500","salesChange":"-15.2","salesAcc":"10678327500","audiCnt":"153004","audiInten":"-31283","audiChange":"-17","audiAcc":"1442861","scrnCnt":"360","showCnt":"1832"},{"rnum":"4","rank":"4","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113260","movieNm":"퍼펙트 게임","openDt":"2011-12-21","salesAmt":"644532000","salesShare":"8.4","salesInten":"-75116500","salesChange":"-10.4","salesAcc":"6640940000","audiCnt":"83644","audiInten":"-12225","audiChange":"-12.8","audiAcc":"895416","scrnCnt":"396","showCnt":"1364"},{"rnum":"5","rank":"5","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113271","movieNm":"프렌즈: 몬스터섬의비밀 ","openDt":"2011-12-29","salesAmt":"436753500","salesShare":"5.7","salesInten":"-89051000","salesChange":"-16.9","salesAcc":"1523037000","audiCnt":"55092","audiInten":"-15568","audiChange":"-22","audiAcc":"202909","scrnCnt":"290","showCnt":"838"},{"rnum":"6","rank":"6","rankInten":"1","rankOldAndNew":"OLD","movieCd":"19940256","movieNm":"라이온 킹","openDt":"1994-07-02","salesAmt":"507115500","salesShare":"6.6","salesInten":"-114593500","salesChange":"-18.4","salesAcc":"1841625000","audiCnt":"45750","audiInten":"-11699","audiChange":"-20.4","audiAcc":"171285","scrnCnt":"244","showCnt":"895"},{"rnum":"7","rank":"7","rankInten":"-1","rankOldAndNew":"OLD","movieCd":"20113381","movieNm":"오싹한 연애","openDt":"2011-12-01","salesAmt":"344871000","salesShare":"4.5","salesInten":"-107005500","salesChange":"-23.7","salesAcc":"20634684500","audiCnt":"45062","audiInten":"-15926","audiChange":"-26.1","audiAcc":"2823060","scrnCnt":"243","showCnt":"839"},{"rnum":"8","rank":"8","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112709","movieNm":"극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」","openDt":"2011-12-22","salesAmt":"167809500","salesShare":"2.2","salesInten":"-45900500","salesChange":"-21.5","salesAcc":"1897120000","audiCnt":"24202","audiInten":"-7756","audiChange":"-24.3","audiAcc":"285959","scrnCnt":"186","showCnt":"348"},{"rnum":"9","rank":"9","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113311","movieNm":"앨빈과 슈퍼밴드3","openDt":"2011-12-15","salesAmt":"137030000","salesShare":"1.8","salesInten":"-35408000","salesChange":"-20.5","salesAcc":"3416675000","audiCnt":"19729","audiInten":"-6461","audiChange":"-24.7","audiAcc":"516289","scrnCnt":"169","showCnt":"359"},{"rnum":"10","rank":"10","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112708","movieNm":"극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」","openDt":"2011-12-22","salesAmt":"125535500","salesShare":"1.6","salesInten":"-40756000","salesChange":"-24.5","salesAcc":"1595695000","audiCnt":"17817","audiInten":"-6554","audiChange":"-26.9","audiAcc":"235070","scrnCnt":"175","showCnt":"291"}
}}
Tail 분리 완료!
{"rnum":"1","rank":"1","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112207","movieNm":"미션임파서블-고스트프로토콜","openDt":"2011-12-15","salesAmt":"2776060500","salesShare":"36.3","salesInten":"-415699000","salesChange":"-13","salesAcc":"40541108500","audiCnt":"353274","audiInten":"-60106","audiChange":"-14.5","audiAcc":"5328435","scrnCnt":"697","showCnt":"3223"
,{"rnum":"2","rank":"2","rankInten":"1","rankOldAndNew":"OLD","movieCd":"20110295","movieNm":"마이 웨이","openDt":"2011-12-21","salesAmt":"1189058500","salesShare":"15.6","salesInten":"-105894500","salesChange":"-8.2","salesAcc":"13002897500","audiCnt":"153501","audiInten":"-16465","audiChange":"-9.7","audiAcc":"1739543","scrnCnt":"588","showCnt":"2321"
,{"rnum":"3","rank":"3","rankInten":"-1","rankOldAndNew":"OLD","movieCd":"20112621","movieNm":"셜록홈즈 : 그림자 게임","openDt":"2011-12-21","salesAmt":"1176022500","salesShare":"15.4","salesInten":"-210328500","salesChange":"-15.2","salesAcc":"10678327500","audiCnt":"153004","audiInten":"-31283","audiChange":"-17","audiAcc":"1442861","scrnCnt":"360","showCnt":"1832"
,{"rnum":"4","rank":"4","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113260","movieNm":"퍼펙트 게임","openDt":"2011-12-21","salesAmt":"644532000","salesShare":"8.4","salesInten":"-75116500","salesChange":"-10.4","salesAcc":"6640940000","audiCnt":"83644","audiInten":"-12225","audiChange":"-12.8","audiAcc":"895416","scrnCnt":"396","showCnt":"1364"
,{"rnum":"5","rank":"5","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113271","movieNm":"프렌즈: 몬스터섬의비밀 ","openDt":"2011-12-29","salesAmt":"436753500","salesShare":"5.7","salesInten":"-89051000","salesChange":"-16.9","salesAcc":"1523037000","audiCnt":"55092","audiInten":"-15568","audiChange":"-22","audiAcc":"202909","scrnCnt":"290","showCnt":"838"
,{"rnum":"6","rank":"6","rankInten":"1","rankOldAndNew":"OLD","movieCd":"19940256","movieNm":"라이온 킹","openDt":"1994-07-02","salesAmt":"507115500","salesShare":"6.6","salesInten":"-114593500","salesChange":"-18.4","salesAcc":"1841625000","audiCnt":"45750","audiInten":"-11699","audiChange":"-20.4","audiAcc":"171285","scrnCnt":"244","showCnt":"895"
,{"rnum":"7","rank":"7","rankInten":"-1","rankOldAndNew":"OLD","movieCd":"20113381","movieNm":"오싹한 연애","openDt":"2011-12-01","salesAmt":"344871000","salesShare":"4.5","salesInten":"-107005500","salesChange":"-23.7","salesAcc":"20634684500","audiCnt":"45062","audiInten":"-15926","audiChange":"-26.1","audiAcc":"2823060","scrnCnt":"243","showCnt":"839"
,{"rnum":"8","rank":"8","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112709","movieNm":"극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」","openDt":"2011-12-22","salesAmt":"167809500","salesShare":"2.2","salesInten":"-45900500","salesChange":"-21.5","salesAcc":"1897120000","audiCnt":"24202","audiInten":"-7756","audiChange":"-24.3","audiAcc":"285959","scrnCnt":"186","showCnt":"348"
,{"rnum":"9","rank":"9","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113311","movieNm":"앨빈과 슈퍼밴드3","openDt":"2011-12-15","salesAmt":"137030000","salesShare":"1.8","salesInten":"-35408000","salesChange":"-20.5","salesAcc":"3416675000","audiCnt":"19729","audiInten":"-6461","audiChange":"-24.7","audiAcc":"516289","scrnCnt":"169","showCnt":"359"
,{"rnum":"10","rank":"10","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112708","movieNm":"극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」","openDt":"2011-12-22","salesAmt":"125535500","salesShare":"1.6","salesInten":"-40756000","salesChange":"-24.5","salesAcc":"1595695000","audiCnt":"17817","audiInten":"-6554","audiChange":"-26.9","audiAcc":"235070","scrnCnt":"175","showCnt":"291"

 

정보단위 분리 완료!
"rnum":"1","rank":"1","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112207","movieNm":"미션임파서블-고스트프로토콜","openDt":"2011-12-15","salesAmt":"2776060500","salesShare":"36.3","salesInten":"-415699000","salesChange":"-13","salesAcc":"40541108500","audiCnt":"353274","audiInten":"-60106","audiChange":"-14.5","audiAcc":"5328435","scrnCnt":"697","showCnt":"3223"
"rnum":"2","rank":"2","rankInten":"1","rankOldAndNew":"OLD","movieCd":"20110295","movieNm":"마이 웨이","openDt":"2011-12-21","salesAmt":"1189058500","salesShare":"15.6","salesInten":"-105894500","salesChange":"-8.2","salesAcc":"13002897500","audiCnt":"153501","audiInten":"-16465","audiChange":"-9.7","audiAcc":"1739543","scrnCnt":"588","showCnt":"2321"
"rnum":"3","rank":"3","rankInten":"-1","rankOldAndNew":"OLD","movieCd":"20112621","movieNm":"셜록홈즈 : 그림자 게임","openDt":"2011-12-21","salesAmt":"1176022500","salesShare":"15.4","salesInten":"-210328500","salesChange":"-15.2","salesAcc":"10678327500","audiCnt":"153004","audiInten":"-31283","audiChange":"-17","audiAcc":"1442861","scrnCnt":"360","showCnt":"1832"
"rnum":"4","rank":"4","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113260","movieNm":"퍼펙트 게임","openDt":"2011-12-21","salesAmt":"644532000","salesShare":"8.4","salesInten":"-75116500","salesChange":"-10.4","salesAcc":"6640940000","audiCnt":"83644","audiInten":"-12225","audiChange":"-12.8","audiAcc":"895416","scrnCnt":"396","showCnt":"1364"
"rnum":"5","rank":"5","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113271","movieNm":"프렌즈: 몬스터섬의비밀 ","openDt":"2011-12-29","salesAmt":"436753500","salesShare":"5.7","salesInten":"-89051000","salesChange":"-16.9","salesAcc":"1523037000","audiCnt":"55092","audiInten":"-15568","audiChange":"-22","audiAcc":"202909","scrnCnt":"290","showCnt":"838"
"rnum":"6","rank":"6","rankInten":"1","rankOldAndNew":"OLD","movieCd":"19940256","movieNm":"라이온 킹","openDt":"1994-07-02","salesAmt":"507115500","salesShare":"6.6","salesInten":"-114593500","salesChange":"-18.4","salesAcc":"1841625000","audiCnt":"45750","audiInten":"-11699","audiChange":"-20.4","audiAcc":"171285","scrnCnt":"244","showCnt":"895"
"rnum":"7","rank":"7","rankInten":"-1","rankOldAndNew":"OLD","movieCd":"20113381","movieNm":"오싹한 연애","openDt":"2011-12-01","salesAmt":"344871000","salesShare":"4.5","salesInten":"-107005500","salesChange":"-23.7","salesAcc":"20634684500","audiCnt":"45062","audiInten":"-15926","audiChange":"-26.1","audiAcc":"2823060","scrnCnt":"243","showCnt":"839"
"rnum":"8","rank":"8","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112709","movieNm":"극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」","openDt":"2011-12-22","salesAmt":"167809500","salesShare":"2.2","salesInten":"-45900500","salesChange":"-21.5","salesAcc":"1897120000","audiCnt":"24202","audiInten":"-7756","audiChange":"-24.3","audiAcc":"285959","scrnCnt":"186","showCnt":"348"
"rnum":"9","rank":"9","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20113311","movieNm":"앨빈과 슈퍼밴드3","openDt":"2011-12-15","salesAmt":"137030000","salesShare":"1.8","salesInten":"-35408000","salesChange":"-20.5","salesAcc":"3416675000","audiCnt":"19729","audiInten":"-6461","audiChange":"-24.7","audiAcc":"516289","scrnCnt":"169","showCnt":"359"
"rnum":"10","rank":"10","rankInten":"0","rankOldAndNew":"OLD","movieCd":"20112708","movieNm":"극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」","openDt":"2011-12-22","salesAmt":"125535500","salesShare":"1.6","salesInten":"-40756000","salesChange":"-24.5","salesAcc":"1595695000","audiCnt":"17817","audiInten":"-6554","audiChange":"-26.9","audiAcc":"235070","scrnCnt":"175","showCnt":"291"

 

정보단위 쓰레기 문자 제거 완료!
[rnum:1, rank:1, rankInten:0, rankOldAndNew:OLD, movieCd:20112207, movieNm:미션임파서블-고스트프로토콜, openDt:2011-12-15, salesAmt:2776060500, salesShare:36.3, salesInten:-415699000, salesChange:-13, salesAcc:40541108500, audiCnt:353274, audiInten:-60106, audiChange:-14.5, audiAcc:5328435, scrnCnt:697, showCnt:3223]
[rnum:2, rank:2, rankInten:1, rankOldAndNew:OLD, movieCd:20110295, movieNm:마이 웨이, openDt:2011-12-21, salesAmt:1189058500, salesShare:15.6, salesInten:-105894500, salesChange:-8.2, salesAcc:13002897500, audiCnt:153501, audiInten:-16465, audiChange:-9.7, audiAcc:1739543, scrnCnt:588, showCnt:2321]
[rnum:3, rank:3, rankInten:-1, rankOldAndNew:OLD, movieCd:20112621, movieNm:셜록홈즈 : 그림자 게임, openDt:2011-12-21, salesAmt:1176022500, salesShare:15.4, salesInten:-210328500, salesChange:-15.2, salesAcc:10678327500, audiCnt:153004, audiInten:-31283, audiChange:-17, audiAcc:1442861, scrnCnt:360, showCnt:1832]
[rnum:4, rank:4, rankInten:0, rankOldAndNew:OLD, movieCd:20113260, movieNm:퍼펙트 게임, openDt:2011-12-21, salesAmt:644532000, salesShare:8.4, salesInten:-75116500, salesChange:-10.4, salesAcc:6640940000, audiCnt:83644, audiInten:-12225, audiChange:-12.8, audiAcc:895416, scrnCnt:396, showCnt:1364]
[rnum:5, rank:5, rankInten:0, rankOldAndNew:OLD, movieCd:20113271, movieNm:프렌즈: 몬스터섬의비밀, openDt:2011-12-29, salesAmt:436753500, salesShare:5.7, salesInten:-89051000, salesChange:-16.9, salesAcc:1523037000, audiCnt:55092, audiInten:-15568, audiChange:-22, audiAcc:202909, scrnCnt:290, showCnt:838]
[rnum:6, rank:6, rankInten:1, rankOldAndNew:OLD, movieCd:19940256, movieNm:라이온 킹, openDt:1994-07-02, salesAmt:507115500, salesShare:6.6, salesInten:-114593500, salesChange:-18.4, salesAcc:1841625000, audiCnt:45750, audiInten:-11699, audiChange:-20.4, audiAcc:171285, scrnCnt:244, showCnt:895]
[rnum:7, rank:7, rankInten:-1, rankOldAndNew:OLD, movieCd:20113381, movieNm:오싹한 연애, openDt:2011-12-01, salesAmt:344871000, salesShare:4.5, salesInten:-107005500, salesChange:-23.7, salesAcc:20634684500, audiCnt:45062, audiInten:-15926, audiChange:-26.1, audiAcc:2823060, scrnCnt:243, showCnt:839]
[rnum:8, rank:8, rankInten:0, rankOldAndNew:OLD, movieCd:20112709, movieNm:극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」, openDt:2011-12-22, salesAmt:167809500, salesShare:2.2, salesInten:-45900500, salesChange:-21.5, salesAcc:1897120000, audiCnt:24202, audiInten:-7756, audiChange:-24.3, audiAcc:285959, scrnCnt:186, showCnt:348]
[rnum:9, rank:9, rankInten:0, rankOldAndNew:OLD, movieCd:20113311, movieNm:앨빈과 슈퍼밴드3, openDt:2011-12-15, salesAmt:137030000, salesShare:1.8, salesInten:-35408000, salesChange:-20.5, salesAcc:3416675000, audiCnt:19729, audiInten:-6461, audiChange:-24.7, audiAcc:516289, scrnCnt:169, showCnt:359]
[rnum:10, rank:10, rankInten:0, rankOldAndNew:OLD, movieCd:20112708, movieNm:극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」, openDt:2011-12-22, salesAmt:125535500, salesShare:1.6, salesInten:-40756000, salesChange:-24.5, salesAcc:1595695000, audiCnt:17817, audiInten:-6554, audiChange:-26.9, audiAcc:235070, scrnCnt:175, showCnt:291]
{rnum=1, audiCnt=353274, salesAcc=40541108500, scrnCnt=697, rankInten=0, salesShare=36.3, movieNm=미션임파서블-고스트프로토콜, salesAmt=2776060500, movieCd=20112207, salesChange=-13, audiInten=-60106, audiChange=-14.5, rankOldAndNew=OLD, rank=1, openDt=2011-12-15, salesInten=-415699000, showCnt=3223, audiAcc=5328435}
{rnum=2, audiCnt=153501, salesAcc=13002897500, scrnCnt=588, rankInten=1, salesShare=15.6, movieNm=마이 웨이, salesAmt=1189058500, movieCd=20110295, salesChange=-8.2, audiInten=-16465, audiChange=-9.7, rankOldAndNew=OLD, rank=2, openDt=2011-12-21, salesInten=-105894500, showCnt=2321, audiAcc=1739543}
{rnum=3, audiCnt=153004, salesAcc=10678327500, scrnCnt=360, rankInten=-1, salesShare=15.4, movieNm=셜록홈즈 , salesAmt=1176022500, movieCd=20112621, salesChange=-15.2, audiInten=-31283, audiChange=-17, rankOldAndNew=OLD, rank=3, openDt=2011-12-21, salesInten=-210328500, showCnt=1832, audiAcc=1442861}
{rnum=4, audiCnt=83644, salesAcc=6640940000, scrnCnt=396, rankInten=0, salesShare=8.4, movieNm=퍼펙트 게임, salesAmt=644532000, movieCd=20113260, salesChange=-10.4, audiInten=-12225, audiChange=-12.8, rankOldAndNew=OLD, rank=4, openDt=2011-12-21, salesInten=-75116500, showCnt=1364, audiAcc=895416}
{rnum=5, audiCnt=55092, salesAcc=1523037000, scrnCnt=290, rankInten=0, salesShare=5.7, movieNm=프렌즈, salesAmt=436753500, movieCd=20113271, salesChange=-16.9, audiInten=-15568, audiChange=-22, rankOldAndNew=OLD, rank=5, openDt=2011-12-29, salesInten=-89051000, showCnt=838, audiAcc=202909}
{rnum=6, audiCnt=45750, salesAcc=1841625000, scrnCnt=244, rankInten=1, salesShare=6.6, movieNm=라이온 킹, salesAmt=507115500, movieCd=19940256, salesChange=-18.4, audiInten=-11699, audiChange=-20.4, rankOldAndNew=OLD, rank=6, openDt=1994-07-02, salesInten=-114593500, showCnt=895, audiAcc=171285}
{rnum=7, audiCnt=45062, salesAcc=20634684500, scrnCnt=243, rankInten=-1, salesShare=4.5, movieNm=오싹한 연애, salesAmt=344871000, movieCd=20113381, salesChange=-23.7, audiInten=-15926, audiChange=-26.1, rankOldAndNew=OLD, rank=7, openDt=2011-12-01, salesInten=-107005500, showCnt=839, audiAcc=2823060}
{rnum=8, audiCnt=24202, salesAcc=1897120000, scrnCnt=186, rankInten=0, salesShare=2.2, movieNm=극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」, salesAmt=167809500, movieCd=20112709, salesChange=-21.5, audiInten=-7756, audiChange=-24.3, rankOldAndNew=OLD, rank=8, openDt=2011-12-22, salesInten=-45900500, showCnt=348, audiAcc=285959}
{rnum=9, audiCnt=19729, salesAcc=3416675000, scrnCnt=169, rankInten=0, salesShare=1.8, movieNm=앨빈과 슈퍼밴드3, salesAmt=137030000, movieCd=20113311, salesChange=-20.5, audiInten=-6461, audiChange=-24.7, rankOldAndNew=OLD, rank=9, openDt=2011-12-15, salesInten=-35408000, showCnt=359, audiAcc=516289}
{rnum=10, audiCnt=17817, salesAcc=1595695000, scrnCnt=175, rankInten=0, salesShare=1.6, movieNm=극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」, salesAmt=125535500, movieCd=20112708, salesChange=-24.5, audiInten=-6554, audiChange=-26.9, rankOldAndNew=OLD, rank=10, openDt=2011-12-22, salesInten=-40756000, showCnt=291, audiAcc=235070}
객체 별 데이터의 Key:Value 분리 완료

주말 BoxOfiice
1위 : 미션임파서블-고스트프로토콜, 누적 관객수 : 532만명
2위 : 마이 웨이, 누적 관객수 : 173만명
3위 : 셜록홈즈 , 누적 관객수 : 144만명
4위 : 퍼펙트 게임, 누적 관객수 : 89만명
5위 : 프렌즈, 누적 관객수 : 20만명
6위 : 라이온 킹, 누적 관객수 : 17만명
7위 : 오싹한 연애, 누적 관객수 : 282만명
8위 : 극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」, 누적 관객수 : 28만명
9위 : 앨빈과 슈퍼밴드3, 누적 관객수 : 51만명
10위 : 극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」, 누적 관객수 : 23만명

 

 

박스오피스 자료

{
	"boxOfficeResult": {
		"boxofficeType": "일별 박스오피스",
		"showRange": "20120101~20120101",
		"dailyBoxOfficeList": [
			{
				"rnum": "1",
				"rank": "1",
				"rankInten": "0",
				"rankOldAndNew": "OLD",
				"movieCd": "20112207",
				"movieNm": "미션임파서블:고스트프로토콜",
				"openDt": "2011-12-15",
				"salesAmt": "2776060500",
				"salesShare": "36.3",
				"salesInten": "-415699000",
				"salesChange": "-13",
				"salesAcc": "40541108500",
				"audiCnt": "353274",
				"audiInten": "-60106",
				"audiChange": "-14.5",
				"audiAcc": "5328435",
				"scrnCnt": "697",
				"showCnt": "3223"
			},
			{
				"rnum": "2",
				"rank": "2",
				"rankInten": "1",
				"rankOldAndNew": "OLD",
				"movieCd": "20110295",
				"movieNm": "마이 웨이",
				"openDt": "2011-12-21",
				"salesAmt": "1189058500",
				"salesShare": "15.6",
				"salesInten": "-105894500",
				"salesChange": "-8.2",
				"salesAcc": "13002897500",
				"audiCnt": "153501",
				"audiInten": "-16465",
				"audiChange": "-9.7",
				"audiAcc": "1739543",
				"scrnCnt": "588",
				"showCnt": "2321"
			},
			{
				"rnum": "3",
				"rank": "3",
				"rankInten": "-1",
				"rankOldAndNew": "OLD",
				"movieCd": "20112621",
				"movieNm": "셜록홈즈 : 그림자 게임",
				"openDt": "2011-12-21",
				"salesAmt": "1176022500",
				"salesShare": "15.4",
				"salesInten": "-210328500",
				"salesChange": "-15.2",
				"salesAcc": "10678327500",
				"audiCnt": "153004",
				"audiInten": "-31283",
				"audiChange": "-17",
				"audiAcc": "1442861",
				"scrnCnt": "360",
				"showCnt": "1832"
			},
			{
				"rnum": "4",
				"rank": "4",
				"rankInten": "0",
				"rankOldAndNew": "OLD",
				"movieCd": "20113260",
				"movieNm": "퍼펙트 게임",
				"openDt": "2011-12-21",
				"salesAmt": "644532000",
				"salesShare": "8.4",
				"salesInten": "-75116500",
				"salesChange": "-10.4",
				"salesAcc": "6640940000",
				"audiCnt": "83644",
				"audiInten": "-12225",
				"audiChange": "-12.8",
				"audiAcc": "895416",
				"scrnCnt": "396",
				"showCnt": "1364"
			},
			{
				"rnum": "5",
				"rank": "5",
				"rankInten": "0",
				"rankOldAndNew": "OLD",
				"movieCd": "20113271",
				"movieNm": "프렌즈: 몬스터섬의비밀 ",
				"openDt": "2011-12-29",
				"salesAmt": "436753500",
				"salesShare": "5.7",
				"salesInten": "-89051000",
				"salesChange": "-16.9",
				"salesAcc": "1523037000",
				"audiCnt": "55092",
				"audiInten": "-15568",
				"audiChange": "-22",
				"audiAcc": "202909",
				"scrnCnt": "290",
				"showCnt": "838"
			},
			{
				"rnum": "6",
				"rank": "6",
				"rankInten": "1",
				"rankOldAndNew": "OLD",
				"movieCd": "19940256",
				"movieNm": "라이온 킹",
				"openDt": "1994-07-02",
				"salesAmt": "507115500",
				"salesShare": "6.6",
				"salesInten": "-114593500",
				"salesChange": "-18.4",
				"salesAcc": "1841625000",
				"audiCnt": "45750",
				"audiInten": "-11699",
				"audiChange": "-20.4",
				"audiAcc": "171285",
				"scrnCnt": "244",
				"showCnt": "895"
			},
			{
				"rnum": "7",
				"rank": "7",
				"rankInten": "-1",
				"rankOldAndNew": "OLD",
				"movieCd": "20113381",
				"movieNm": "오싹한 연애",
				"openDt": "2011-12-01",
				"salesAmt": "344871000",
				"salesShare": "4.5",
				"salesInten": "-107005500",
				"salesChange": "-23.7",
				"salesAcc": "20634684500",
				"audiCnt": "45062",
				"audiInten": "-15926",
				"audiChange": "-26.1",
				"audiAcc": "2823060",
				"scrnCnt": "243",
				"showCnt": "839"
			},
			{
				"rnum": "8",
				"rank": "8",
				"rankInten": "0",
				"rankOldAndNew": "OLD",
				"movieCd": "20112709",
				"movieNm": "극장판 포켓몬스터 베스트 위시「비크티니와 백의 영웅 레시라무」",
				"openDt": "2011-12-22",
				"salesAmt": "167809500",
				"salesShare": "2.2",
				"salesInten": "-45900500",
				"salesChange": "-21.5",
				"salesAcc": "1897120000",
				"audiCnt": "24202",
				"audiInten": "-7756",
				"audiChange": "-24.3",
				"audiAcc": "285959",
				"scrnCnt": "186",
				"showCnt": "348"
			},
			{
				"rnum": "9",
				"rank": "9",
				"rankInten": "0",
				"rankOldAndNew": "OLD",
				"movieCd": "20113311",
				"movieNm": "앨빈과 슈퍼밴드3",
				"openDt": "2011-12-15",
				"salesAmt": "137030000",
				"salesShare": "1.8",
				"salesInten": "-35408000",
				"salesChange": "-20.5",
				"salesAcc": "3416675000",
				"audiCnt": "19729",
				"audiInten": "-6461",
				"audiChange": "-24.7",
				"audiAcc": "516289",
				"scrnCnt": "169",
				"showCnt": "359"
			},
			{
				"rnum": "10",
				"rank": "10",
				"rankInten": "0",
				"rankOldAndNew": "OLD",
				"movieCd": "20112708",
				"movieNm": "극장판 포켓몬스터 베스트 위시 「비크티니와 흑의 영웅 제크로무」",
				"openDt": "2011-12-22",
				"salesAmt": "125535500",
				"salesShare": "1.6",
				"salesInten": "-40756000",
				"salesChange": "-24.5",
				"salesAcc": "1595695000",
				"audiCnt": "17817",
				"audiInten": "-6554",
				"audiChange": "-26.9",
				"audiAcc": "235070",
				"scrnCnt": "175",
				"showCnt": "291"
			}
		]
	}
}

 


"본 인터넷 사이트 내의 모든 이미지, 문구, 콘텐츠, 내용 등에 대한 저작권은 76beny에게 있습니다.

이를 무단으로 도용, 복사, 전재, 재배포, 2차 변형 등을 할 경우

민, 형사상 법적 조치 등 저작권법에 의거하여 처벌 받을 수 있습니다."