{"id":2314,"date":"2022-08-31T21:41:16","date_gmt":"2022-08-31T12:41:16","guid":{"rendered":"http:\/\/idealive.jp\/blog\/?p=2314"},"modified":"2022-08-31T21:50:52","modified_gmt":"2022-08-31T12:50:52","slug":"pandas-dataframe%e3%81%ae%e7%b5%90%e5%90%88","status":"publish","type":"post","link":"https:\/\/idealive.jp\/blog\/2022\/08\/31\/pandas-dataframe%e3%81%ae%e7%b5%90%e5%90%88\/","title":{"rendered":"pandas.DataFrame\u306e\u7d50\u5408"},"content":{"rendered":"<p>\u3060\u3044\u3076\u524d\u306bpandas\u306e\u8a71\u3092\u66f8\u304d\u307e\u3057\u305f\u304c\u3001<\/p>\n<p>\uff08\u4e0b\u8a18\u3001\u53c2\u7167\uff09<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"xclL4Z7ySV\"><p><a href=\"https:\/\/idealive.jp\/blog\/2019\/05\/27\/python-pandas\/\">Python Pandas<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Python Pandas&#8221; &#8212; idealive tech blog\" src=\"https:\/\/idealive.jp\/blog\/2019\/05\/27\/python-pandas\/embed\/#?secret=kwGovMclOE#?secret=xclL4Z7ySV\" data-secret=\"xclL4Z7ySV\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>\u8907\u6570\u306e\u30c7\u30fc\u30bf\u69cb\u6210\u306e\u5834\u5408\u306bSQL\u306e\u3088\u3046\u306b\u7d50\u5408\u3067\u304d\u308b\u304b\u304c\u6c17\u306b\u306a\u308a\u8abf\u3079\u307e\u3057\u305f\u3002<\/p>\n<p>\u7d50\u8ad6\u304b\u3089\u8a00\u3046\u3068\u30012\u3064\u306e\u30c7\u30fc\u30bf\uff08csv\u30d5\u30a1\u30a4\u30eb\u3092DataFrame\u306b\u3057\u305f\u3082\u306e\uff09\u3060\u3068\u53ef\u80fd\u3067\u3044\u3063\u304d\u306b3\u3064\u4ee5\u4e0a\u306e\u30c7\u30fc\u30bf\u7d50\u5408\u306f\u7121\u7406\u3067\u3057\u305f\u3002<\/p>\n<p>\u3067\u306f\u3001\u3069\u3046\u3084\u308c\u3070\u3044\u3044\u304b\u3068\u8a00\u3046\u30682\u3064\u7d50\u5408\u3092\u7e70\u308a\u8fd4\u3057\u30661\u3064\u306b\u3059\u308b\u3068\u3044\u3046\u65b9\u6cd5\u3057\u304b\u306a\u3055\u305d\u3046\u3067\u3057\u305f\u3002<\/p>\n<p>2\u3064\u306e\u7d50\u5408\u65b9\u6cd5\u306f<code>pd.merge()<\/code>\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3002<\/p>\n<p>\u8a18\u8f09\u65b9\u6cd5<\/p>\n<p>\u7b2c\u4e00\u5f15\u6570\u3001\u7b2c\u4e8c\u5f15\u6570\u306f\u7d50\u5408\u3059\u308bDataFrame<\/p>\n<p>\u7b2c\u4e09\u5f15\u6570\u306f\u7d50\u5408\u65b9\uff08inner\/left\/right\/outer\uff09<\/p>\n<ul>\n<li>\u5185\u90e8\u7d50\u5408\uff08inner_join\uff09: <code>how='inner'<\/code><\/li>\n<li>\u5de6\u7d50\u5408\uff08left_join\uff09: <code>how='left'<\/code><\/li>\n<li>\u53f3\u7d50\u5408\uff08right_join\uff09: <code>how='right'<\/code><\/li>\n<li>\u5916\u90e8\u7d50\u5408\uff08outer_join\uff09: <code>how='outer'<\/code><\/li>\n<\/ul>\n<p>\u7b2c\u56db\u5f15\u6570\u306f\u6761\u4ef6<\/p>\n<p>pd.merge(df1, df2, how = \u7d50\u5408\u65b9\u6cd5, on = \u201d\u7d50\u5408\u30ad\u30fc\u201d)<\/p>\n<p>\u30ad\u30fc\u5217\u3067\u30bd\u30fc\u30c8\u3059\u308b\u5834\u5408\u306f\u5f15\u6570<code>sort<\/code>\u3092<code>True<\/code>\u3068\u3059\u308b\u3002<\/p>\n<p>pd.merge(df1, df2, how = \u7d50\u5408\u65b9\u6cd5, on = \u201d\u7d50\u5408\u30ad\u30fc\u201d,sort \uff1d True)<\/p>\n<p>\u4ed6\u306b\u3082\u3001\u5f15\u6570<code>indicator<\/code>\u3092<code>True<\/code>\u3068\u3059\u308b\u3068\u3001\u5143\u30c7\u30fc\u30bf\u306e\u60c5\u5831\u304c\u3069\u3061\u3089\u306b\u542b\u307e\u308c\u3066\u3044\u304b\uff08both, left_only, right_only\uff09\u5217\u304c\u8ffd\u52a0\u3055\u308c\u308b\u3002<\/p>\n<p>\u4e0a\u8a18\u3067\u7d50\u5408\u3092\u884c\u3044\u3001\u96c6\u8a08\u306a\u3069\u3059\u308c\u3070\u5927\u91cf\u30c7\u30fc\u30bf\u306a\u3069\u306e\u89e3\u6790\u304c\u4fbf\u5229\u305d\u3046\u3002<\/p>\n<p>\u5b9f\u969b\u306b\u5b9f\u52d9\u904b\u7528\u3057\u305f\u3053\u3068\u306a\u3044\u304c\u3001\u691c\u8a0e\u3057\u3066\u307f\u3066\u89e3\u6790\u306a\u3069\u306b\u304a\u5ba2\u69d8\u306b\u63d0\u6848\u3057\u3066\u307f\u3088\u3046\u304b\u3068\u601d\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3060\u3044\u3076\u524d\u306bpandas\u306e\u8a71\u3092\u66f8\u304d\u307e\u3057\u305f\u304c\u3001 \uff08\u4e0b\u8a18\u3001\u53c2\u7167\uff09 Python Pandas \u8907\u6570\u306e\u30c7\u30fc\u30bf\u69cb\u6210\u306e\u5834\u5408\u306bSQL\u306e\u3088\u3046\u306b\u7d50\u5408\u3067\u304d\u308b\u304b\u304c\u6c17\u306b\u306a\u308a\u8abf\u3079\u307e\u3057\u305f\u3002 \u7d50\u8ad6\u304b\u3089\u8a00\u3046\u3068\u30012\u3064\u306e\u30c7\u30fc\u30bf\uff08csv\u30d5\u30a1\u30a4\u30eb\u3092DataFr&#8230;<a class=\"read-more-link button\" href=\"https:\/\/idealive.jp\/blog\/2022\/08\/31\/pandas-dataframe%e3%81%ae%e7%b5%90%e5%90%88\/\">\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":7,"featured_media":1867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[60,61,59],"class_list":["post-2314","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-python","tag-dataframe","tag-join","tag-pandas"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/posts\/2314"}],"collection":[{"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/comments?post=2314"}],"version-history":[{"count":8,"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/posts\/2314\/revisions"}],"predecessor-version":[{"id":2321,"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/posts\/2314\/revisions\/2321"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/media\/1867"}],"wp:attachment":[{"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/media?parent=2314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/categories?post=2314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idealive.jp\/blog\/wp-json\/wp\/v2\/tags?post=2314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}