{"id":2610,"date":"2019-03-17T20:08:15","date_gmt":"2019-03-17T11:08:15","guid":{"rendered":"https:\/\/now0930.tk\/wordpress\/?p=2610"},"modified":"2019-03-17T20:13:40","modified_gmt":"2019-03-17T11:13:40","slug":"qlik%ec%9c%bc%eb%a1%9c-%ec%88%98%ec%9e%85%ec%a7%80%ec%b6%9c-%eb%b6%84%ec%84%9d","status":"publish","type":"post","link":"https:\/\/now0930.pe.kr\/wordpress\/qlik%ec%9c%bc%eb%a1%9c-%ec%88%98%ec%9e%85%ec%a7%80%ec%b6%9c-%eb%b6%84%ec%84%9d\/","title":{"rendered":"Qlik\uc73c\ub85c \uc218\uc785\uc9c0\ucd9c \ubd84\uc11d"},"content":{"rendered":"\n<p>\uc0c8\ub85c\ubc30\uc6b4 Qlik\uc73c\ub85c \uc791\ub144 \uc218\uc785\/\uc9c0\ucd9c\uc744 \ubd84\uc11d\ud588\ub2e4. \ubc45\ud06c\uc0d0\ub7ec\ub4dc\ub97c \uc0ac\uc6a9\ud558\uba74 1\ub144\uac04 \uc218\uc785\/\uc9c0\ucd9c\uc744 \ud30c\uc77c\ub85c \ubc1b\uc744 \uc218 \uc788\ub2e4. \uc778\ud130\ub137\uc5d0\uc11c \uc81c\uacf5\ud558\uace0 \uc788\ub294 \uc77c\ubcc4 \uc8fc\uc720\uac00\uaca9\uacfc \ub0b4\uac00 \uacfc\uac70 \uc0ac\uc6a9\ud55c \uc8fc\uc720\ube44\uc6a9\uc744 \ubcf4\uba74 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/now0930.tk\/wordpress\/wp-content\/uploads\/2019\/03\/\uc8fc\uc720\ube44-1024x576.png\" alt=\"\" class=\"wp-image-2611\" srcset=\"https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2019\/03\/\uc8fc\uc720\ube44-1024x576.png 1024w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2019\/03\/\uc8fc\uc720\ube44-300x169.png 300w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2019\/03\/\uc8fc\uc720\ube44-768x432.png 768w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2019\/03\/\uc8fc\uc720\ube44.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>2019\ub144 2\uc6d4\uc5d0 \uac00\uc7a5 \ub9ce\uc774 \uc18c\ube44\ud588\ub2e4.<\/li><li>\ud3c9\uade0\uae30\ub984 \uac00\uaca9\uc774 \ub2e4\ud589\ud788 19\ub144 2\uc6d4\uc5d0 \uac00\uc7a5 \uc30c\ub2e4.<\/li><li>19\ub144 2\uc6d4 \uc790\ub3d9\ucc28 \uc6b4\ud589\uc774 \uac00\uc7a5 \ub9ce\uc558\ub2e4. \uacf5\uc0ac\ub85c \ub9e8\ub0a0 \ucc30 \ub04c\uace0 \ub2e4\ub2cc\ub2e4\ub294 \ub4ef.<\/li><li>1\ub144\ub3d9\uc548 340,000\uc6d0 \uc0ac\uc6a9\ud588\ub2e4.  \uc790\ub3d9\ucc28 \uac00\ub3d9\uc728\uc774 \ub108\ubb34 \ub5a8\uc5b4\uc84c\ub2e4.<\/li><li>1,200 \uc6d0\/\ub9ac\ud130, 15km\/\ub9ac\ud130\ub85c \uacc4\uc0b0\ud558\uba74 \uc57d \uc77c\ub144\uc5d0 4,275km \uc774\ub3d9.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"310\" src=\"https:\/\/now0930.tk\/wordpress\/wp-content\/uploads\/2019\/03\/\uc218\uc785\uc9c0\ucd9c\ube44\uc6a9-1024x310.png\" alt=\"\" class=\"wp-image-2612\" srcset=\"https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2019\/03\/\uc218\uc785\uc9c0\ucd9c\ube44\uc6a9-1024x310.png 1024w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2019\/03\/\uc218\uc785\uc9c0\ucd9c\ube44\uc6a9-300x91.png 300w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2019\/03\/\uc218\uc785\uc9c0\ucd9c\ube44\uc6a9-768x232.png 768w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2019\/03\/\uc218\uc785\uc9c0\ucd9c\ube44\uc6a9.png 1730w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>\uc218\uc785: \uc6d4\uae09 \uc678 \ubcc4\ub3c4 \uc218\uc785\uc774 \uac70\uc758 \uc5c6\uc74c.<\/li><li>\uc9c0\ucd9c\uc758 23%\uac00 \uce74\ub4dc\ub85c \uacb0\uc81c \ub428. \uac70\uc758 \uc0dd\ud65c\ube44.<\/li><li>\uc9c0\ucd9c\uc758 22%\ub97c \ub300\ucd9c \uac1a\ub294\ub370 \uc0ac\uc6a9.<\/li><li>\uc9c0\ucd9c\uc758 11%\ub97c \ubcf4\ud5d8\ube44\ub85c \uc9c0\ucd9c.<\/li><li>\uc218\uc785 &#8211; \uc9c0\ucd9c = -4,000,000\uc6d0. \ub300\ucd9c\uc744 \ub9c8\uc774\ub108\uc2a4\ub85c \ub561\uaca8 \uac1a\uc558\ub2e4.<\/li><li><\/li><\/ul>\n\n\n\n<p>\n\uc77c\ub2e8 \ub370\uc774\ud130\ub97c \ub85c\ub529\ud558\uace0, Qlik\uc5d0\uc11c \ud56d\ubaa9\uc744 \uc218\uc815\ud588\ub2e4.\n\n<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>[\uacfc\uac70 \uae30\ub984\uac12]:\nLOAD\n\t[\ubc88\ud638],\n\t[\uc9c0\uc5ed],\n\t[\uc0c1\ud638],\n\t[\uc8fc\uc18c],\n    [\uae30\uac04],\n   \tMakeDate(left([\uae30\uac04],4),mid([\uae30\uac04],5,2),right([\uae30\uac04],2)) as [\ub0a0\uc9dc],\n\t[\uc0c1\ud45c],\n\t[\uacbd\uc720]\n FROM [lib:\/\/\uae08\uc735\/\uacfc\uac70_\ud310\ub9e4\uac00\uaca9(\uc8fc\uc720\uc18c)20180308-20190308.csv]\n(txt, codepage is 949, embedded labels, delimiter is ',', msq);<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>[\ud544\ud130\ub41c \uacbd\uc720]:\n     load [\uacbd\uc720],\n     year([\ub0a0\uc9dc])&amp;'.'&amp;month([\ub0a0\uc9dc]) as [\uc5f0\uc6d4]\n    Resident [\uacfc\uac70 \uae30\ub984\uac12];\n\ndrop Table [\uacfc\uac70 \uae30\ub984\uac12];<\/code><\/pre>\n\n\n\n<p>\uae30\ub984\uac00\uaca9 \ub0a0\uc790\uac00 &#8220;.&#8221; \ub85c \uad6c\ubd84\ub418\uc5b4 \uad73\uc774 \uc774\ub807\uac8c \uad6c\ubd84\ud574\uc57c Qlik\uc5d0\uc11c \uc778\uc2dd\ud588\ub2e4.  \ucd94\uac00 \ube14\ub7ed\uc5d0 \uc774\ub9ac \ub85c\ub529\ud55c [\uacfc\uac70 \uae30\ub984\uac12]\uc744 \ubd80\ub974\uace0, \ub0a0\uc790 \ud3ec\uba67\uc73c\ub85c \uc218\uc815\ud588\ub2e4. \uc5f0\uad00\uc131\uc744 \uc5c6\uc560\uae30 \uc704\ud574 [\uacfc\uac70 \uae30\ub984\uac12]\uc744 \uc9c0\uc6e0\ub2e4. <\/p>\n\n\n\n<p>\ubc45\ud06c \uc0d0\ub7ec\ub4dc\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \ubd80\ub974\uba74 \uce74\ud14c\uace0\ub9ac\uac00 \ub300\ub7b5 \ub9de\uc9c0\ub9cc, qlik\uc73c\ub85c \uc6d0\ud558\ub294 \ubd80\ubd84\uc744 \uc218\uc815\ud558\uae30 \ud798\ub4e4\ub2e4. \uac15\ub825\ud55c \uc815\uaddc\uc2dd\uc744 \uc9c0\uc6d0\ud558\ub294 python pandas\ub97c \uc0ac\uc6a9\ud588\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#_*_ coding: utf-8 _*_\n\nimport pandas as pd\nimport numpy\n\n#Pandas\ub85c \uc5c5\ub370\uc774\ud2b8\ndf = pd.read_csv(\".\/test.csv\")\n\n#\uc815\uaddc \ud45c\ud604\uc2dd\uc73c\ub85c \ub2e4\uc2dc \uc815\ub9ac.\nconditions = [\n        (df[\"\ub0b4\uc6a9\"].str.contains(\"?????\") &amp; (df[\"\ub300\ubd84\ub958\"] == \"\ubbf8\ubd84\ub958\")),\n        (df[\"\ub0b4\uc6a9\"].str.contains(\"\uc131\uacfc\uae09\uc9c0\uae09\") &amp; (df[\"\ub300\ubd84\ub958\"] == \"\ubbf8\ubd84\ub958\")),\n        (df[\"\ub0b4\uc6a9\"].str.contains('\\d{3}-\\d{4}') &amp; (df[\"\ub300\ubd84\ub958\"] == \"\ubbf8\ubd84\ub958\")),\n        (df[\"\ub0b4\uc6a9\"].str.contains('\ub9c8\uc774\ub108\uc2a4|??|\uc6d4\uae09\ud1b5\uc7a5|??') &amp; (df[\"\ub300\ubd84\ub958\"] == \"\ubbf8\ubd84\ub958\")),\n        (df[\"\ub0b4\uc6a9\"].str.contains('????') &amp; (df[\">\ub300\ubd84\ub958\"] == \"\ubbf8\ubd84\ub958\"))\n        ]\n\nchoices = [\"\uae09\uc5ec\",\"\uae09\uc5ec\",\"\ubcf4\ud5d8\",\"\ub300\ucd9c\",\"\uae30\ud0c0\uc218\uc785\"]\n\ndf[\"\uae09\uc5ec\"]=numpy.select(conditions, choices, default = df[\"\ub300\ubd84\ub958\"])\n\ndf.to_csv(\".\/20190313.csv\",index=True)<\/code><\/pre>\n\n\n\n<p>pandas\ub97c \uc798 \uc0ac\uc6a9\ud558\uc9c0 \ubabb\ud574 \uc2dc\uac04\uc744 \ub9ce\uc774 \uc37c\ub2e4. \uadf8\ub7ec\ub098 qlik\uc744 \ubc30\uc6cc\uc11c \ud568\ubcf4\ub2e4 \ub0ab\ub2e4.<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc0c8\ub85c\ubc30\uc6b4 Qlik\uc73c\ub85c \uc791\ub144 \uc218\uc785\/\uc9c0\ucd9c\uc744 \ubd84\uc11d\ud588\ub2e4. \ubc45\ud06c\uc0d0\ub7ec\ub4dc\ub97c \uc0ac\uc6a9\ud558\uba74 1\ub144\uac04 \uc218\uc785\/\uc9c0\ucd9c\uc744 \ud30c\uc77c\ub85c \ubc1b\uc744 \uc218 \uc788\ub2e4. \uc778\ud130\ub137\uc5d0\uc11c \uc81c\uacf5\ud558\uace0 \uc788\ub294 \uc77c\ubcc4 \uc8fc\uc720\uac00\uaca9\uacfc \ub0b4\uac00 \uacfc\uac70 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12],"tags":[519,520,521],"class_list":["post-2610","post","type-post","status-publish","format-standard","hentry","category-12","tag-qlik","tag-520","tag-521"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/2610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/comments?post=2610"}],"version-history":[{"count":3,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/2610\/revisions"}],"predecessor-version":[{"id":2616,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/2610\/revisions\/2616"}],"wp:attachment":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/media?parent=2610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/categories?post=2610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/tags?post=2610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}