{"id":576,"date":"2024-05-02T21:12:46","date_gmt":"2024-05-02T12:12:46","guid":{"rendered":"https:\/\/chocottopro.com\/?p=576"},"modified":"2024-06-14T16:32:24","modified_gmt":"2024-06-14T07:32:24","slug":"%e3%80%90%e5%ae%8c%e5%85%a8%e7%89%88%e3%80%91pandas%e3%81%ae%e5%9f%ba%e6%9c%ac%e3%82%921%e6%97%a5%e3%81%a7%e8%ba%ab%e3%81%ab%e3%81%a4%e3%81%91%e3%82%8b%ef%bc%81%e3%83%87%e3%83%bc%e3%82%bf%e5%88%86","status":"publish","type":"post","link":"https:\/\/chocottopro.com\/?p=576","title":{"rendered":"\u3010\u5b8c\u5168\u7248\u3011pandas\u306e\u57fa\u672c\u30921\u65e5\u3067\u8eab\u306b\u3064\u3051\u308b\uff01\u30c7\u30fc\u30bf\u5206\u6790\u5165\u9580\u30ac\u30a4\u30c9"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u5206\u6790\u306b\u6b20\u304b\u305b\u306a\u3044Python\u30e9\u30a4\u30d6\u30e9\u30ea\u300c<span class=\"keiko_yellow\">pandas<\/span>\u300d\u3002<br>\u591a\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u76f4\u611f\u7684\u306b\u884c\u3048\u308b\u30d1\u30ef\u30d5\u30eb\u306a\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001\u521d\u5fc3\u8005\u306b\u3068\u3063\u3066\u306f\u30cf\u30fc\u30c9\u30eb\u304c\u9ad8\u304f\u611f\u3058\u3089\u308c\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<br>\u3057\u304b\u3057\u3001pandas\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3092\u30de\u30b9\u30bf\u30fc\u3059\u308c\u3070\u3001<span class=\"keiko_yellow\">\u30c7\u30fc\u30bf\u5206\u6790\u306e\u751f\u7523\u6027\u3092\u98db\u8e8d\u7684\u306b\u9ad8\u3081\u308b<\/span>\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br>\u672c\u8a18\u4e8b\u3067\u306f\u3001pandas\u306e\u57fa\u790e\u304b\u3089\u5b9f\u8df5\u7684\u306a\u30c7\u30fc\u30bf\u5206\u6790\u306e\u4f8b\u307e\u3067\u3001\u308f\u304b\u308a\u3084\u3059\u304f\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br><span class=\"keiko_yellow\">\u30c7\u30fc\u30bf\u5206\u6790\u306e\u30b9\u30ad\u30eb<\/span>\u3092\u8eab\u306b\u3064\u3051\u305f\u3044\u65b9\u306f\u3001\u305c\u3072\u672c\u8a18\u4e8b\u3092\u53c2\u8003\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"wp-block-sgb-block-simple sgb-box-simple sgb-box-simple--title-normal sgb-box-simple--with-border\"><div style=\"background-color:var(--wp--preset--color--sango-main);color:#FFF\" class=\"sgb-box-simple__title\">\u3053\u306e\u8a18\u4e8b\u3092\u8aad\u3093\u3060\u3089\u308f\u304b\u308b\u3053\u3068<\/div><div class=\"sgb-box-simple__body\" style=\"border-color:var(--wp--preset--color--sango-main);background-color:#FFF\">\n<ul class=\"wp-block-list\">\n<li>pandas\u306e\u57fa\u672c\u7684\u306a\u30c7\u30fc\u30bf\u69cb\u9020\u3067\u3042\u308bSeries\u3068DataFrame\u306e\u4f7f\u3044\u65b9 <\/li>\n\n\n\n<li>CSV\u3084Excel\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080\u65b9\u6cd5 <\/li>\n\n\n\n<li>\u30c7\u30fc\u30bf\u306e\u62bd\u51fa\u3001\u96c6\u8a08\u3001\u5909\u5f62\u3001\u7d50\u5408\u306a\u3069\u306e\u57fa\u672c\u7684\u306a\u51e6\u7406\u65b9\u6cd5 <\/li>\n\n\n\n<li>\u6b20\u640d\u5024\u3084\u91cd\u8907\u30c7\u30fc\u30bf\u3078\u306e\u5bfe\u51e6\u65b9\u6cd5 <\/li>\n\n\n\n<li>groupby\u3068pivot_table\u3092\u4f7f\u3063\u305f\u9ad8\u5ea6\u306a\u30c7\u30fc\u30bf\u96c6\u8a08\u65b9\u6cd5 <\/li>\n\n\n\n<li>pandas\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u306e\u53ef\u8996\u5316\u65b9\u6cd5 <\/li>\n\n\n\n<li>\u5b9f\u8df5\u7684\u306a\u30c7\u30fc\u30bf\u5206\u6790\u306e\u4f8b\u3068\u305d\u306e\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"toc\"><br \/>\n<b>Warning<\/b>:  Undefined array key \"is_admin\" in <b>\/home\/c7479301\/public_html\/chocottopro.com\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>116<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_category_top\" in <b>\/home\/c7479301\/public_html\/chocottopro.com\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>121<\/b><br \/>\n<br \/>\n<b>Warning<\/b>:  Undefined array key \"is_top\" in <b>\/home\/c7479301\/public_html\/chocottopro.com\/wp-content\/themes\/sango-theme\/library\/gutenberg\/dist\/classes\/Toc.php<\/b> on line <b>128<\/b><br \/>\n    <div id=\"toc_container\" class=\"sgb-toc--bullets js-smooth-scroll\" data-dialog-title=\"Table of Contents\">\n      <p class=\"toc_title\">\u76ee\u6b21 <\/p>\n      <ul class=\"toc_list\">  <li class=\"first\">    <a href=\"#i-0\">pandas\u3068\u306f\uff1f\u30c7\u30fc\u30bf\u5206\u6790\u306b\u6b20\u304b\u305b\u306a\u3044\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u6982\u8981<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-1\">pandas\u3092\u4f7f\u3046\u30e1\u30ea\u30c3\u30c8 \u2013 \u30c7\u30fc\u30bf\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u306e\u6642\u9593\u3092\u5927\u5e45\u306b\u77ed\u7e2e<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-2\">pandas\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5 \u2013 pip\u4e00\u767a\u3067\u74b0\u5883\u69cb\u7bc9\u5b8c\u4e86<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-3\">pandas\u306e\u57fa\u672c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8 \u2013 Series \u3068 DataFrame \u3092\u7406\u89e3\u3059\u308b<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-4\">Series \u2013 1\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u69cb\u9020<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-5\">DataFrame \u2013 2\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u69cb\u9020<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-6\">DataFrame\u306e\u57fa\u672c\u64cd\u4f5c\u30de\u30b9\u30bf\u30fc \u2013 \u30c7\u30fc\u30bf\u5206\u6790\u306e\u571f\u53f0\u3092\u7bc9\u3053\u3046<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-7\">DataFrame\u306e\u751f\u6210 \u2013 \u3044\u308d\u3044\u308d\u306a\u30c7\u30fc\u30bf\u304b\u3089\u8868\u3092\u4f5c\u308b<\/a>      <\/li>      <li>        <a href=\"#i-8\">DataFrame\u306e\u53c2\u7167 \u2013 \u884c\u3084\u5217\u3092\u81ea\u5728\u306b\u53d6\u308a\u51fa\u3059<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-9\">DataFrame\u306e\u7de8\u96c6 \u2013 \u65b0\u3057\u3044\u5217\u306e\u8ffd\u52a0\u3084\u5024\u306e\u66f4\u65b0<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-10\">\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u66f8\u304d \u2013 CSV\u3084\u30a8\u30af\u30bb\u30eb\u3068\u306e\u30c7\u30fc\u30bf\u306e\u3084\u308a\u53d6\u308a<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-11\">CSV\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\u30fb\u66f8\u304d\u51fa\u3057<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-12\">\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\u30fb\u66f8\u304d\u51fa\u3057<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-13\">\u30c7\u30fc\u30bf\u306e\u524d\u51e6\u7406\u30c6\u30af\u30cb\u30c3\u30af \u2013 \u6b20\u640d\u5024\u3084\u91cd\u8907\u3078\u306e\u5bfe\u51e6\u6cd5<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-14\">\u6b20\u640d\u5024\u306e\u78ba\u8a8d\u3068\u9664\u53bb\u30fb\u88dc\u5b8c<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-15\">\u91cd\u8907\u30c7\u30fc\u30bf\u306e\u78ba\u8a8d\u3068\u524a\u9664<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-16\">\u30c7\u30fc\u30bf\u306e\u5909\u5f62\u3068\u96c6\u7d04 \u2013 groupby\u3068pivot_table\u3092\u4f7f\u3044\u3053\u306a\u3059<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-17\">groupby\u306b\u3088\u308b\u30c7\u30fc\u30bf\u306e\u96c6\u7d04<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-18\">pivot_table\u3067\u25cb\u25cb\u5225\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u308b<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-19\">pandas\u3067\u7c21\u5358\u30c7\u30fc\u30bf\u53ef\u8996\u5316 \u2013 \u30b0\u30e9\u30d5\u4f5c\u6210\u306e\u57fa\u672c<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-20\">\u5217\u306e\u5024\u3092\u30d7\u30ed\u30c3\u30c8\u3057\u3066\u5206\u5e03\u3092\u898b\u308b<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-21\">2\u3064\u306e\u5217\u306e\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3059\u308b<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-22\">pandas\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u5206\u6790\u306e\u5b9f\u8df5 \u2013 \u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb3\u9078<\/a>    <ul class=\"menu_level_1\">      <li class=\"first\">        <a href=\"#i-23\">\u58f2\u4e0a\u30c7\u30fc\u30bf\u304b\u3089\u5546\u54c1\u5225\u30fb\u6708\u5225\u306e\u58f2\u4e0a\u63a8\u79fb\u3092\u5206\u6790<\/a>      <\/li>      <li>        <a href=\"#i-24\">\u30a2\u30f3\u30b1\u30fc\u30c8\u7d50\u679c\u304b\u3089\u30e6\u30fc\u30b6\u30fc\u3092\u5c5e\u6027\u5225\u306b\u30bb\u30b0\u30e1\u30f3\u30c8<\/a>      <\/li>      <li class=\"last\">        <a href=\"#i-25\">\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u304b\u3089\u9700\u8981\u4e88\u6e2c\u30e2\u30c7\u30eb\u3092\u69cb\u7bc9<\/a>      <\/li>    <\/ul>  <\/li>  <li>    <a href=\"#i-26\">\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a>  <\/li>  <li class=\"last\">    <a href=\"#i-27\">\u95a2\u9023\u8a18\u4e8b<\/a>  <\/li><\/ul>\n      \n    <\/div><\/div><h2 class=\"wp-block-heading\" id=\"i-0\">pandas\u3068\u306f\uff1f\u30c7\u30fc\u30bf\u5206\u6790\u306b\u6b20\u304b\u305b\u306a\u3044\u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u6982\u8981<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">pandas\u306f\u3001Python\u3067\u30c7\u30fc\u30bf\u5206\u6790\u3092\u884c\u3046\u305f\u3081\u306b\u6b20\u304b\u305b\u306a\u3044\u30e9\u30a4\u30d6\u30e9\u30ea\u3067\u3001\u975e\u5e38\u306b\u67d4\u8edf\u3067\u9ad8\u901f\u306a\u30c7\u30fc\u30bf\u64cd\u4f5c\u3092\u53ef\u80fd\u306b\u3057\u307e\u3059\u3002<br>\u7279\u306b\u3001pandas\u306eDataFrame\u3068\u547c\u3070\u308c\u308b2\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u306f\u3001<span class=\"keiko_yellow\">Excel\u306e\u3088\u3046\u306a\u30c6\u30fc\u30d6\u30eb\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u3092\u76f4\u611f\u7684\u306b\u6271\u3048\u308b<\/span>\u305f\u3081\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u751f\u7523\u6027\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-1\">pandas\u3092\u4f7f\u3046\u30e1\u30ea\u30c3\u30c8 \u2013 \u30c7\u30fc\u30bf\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0\u306e\u6642\u9593\u3092\u5927\u5e45\u306b\u77ed\u7e2e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">pandas\u3092\u4f7f\u3048\u3070\u3001\u5927\u91cf\u306e\u30bb\u30f3\u30b5\u30fc\u30c7\u30fc\u30bf\u3092\u52b9\u7387\u7684\u306b\u51e6\u7406\u3057\u305f\u308a\u3001\u30a2\u30f3\u30b1\u30fc\u30c8\u7d50\u679c\u306a\u3069\u306e\u30c7\u30fc\u30bf\u3092\u7c21\u5358\u306b\u96c6\u8a08\u30fb\u53ef\u8996\u5316\u3057\u305f\u308a\u3067\u304d\u307e\u3059\u3002<br>\u307e\u305f\u3001\u8907\u6570\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u7d50\u5408\u3057\u3066\u3001\u7dcf\u5408\u7684\u306a\u5206\u6790\u3092\u884c\u3046\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f8b\u3048\u3070\u3001\u3053\u3093\u306a\u3053\u3068\u304c\u7c21\u5358\u306b\u3067\u304d\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1\u79d2\u9593\u306b1000\u4ef6\u4ee5\u4e0a\u306e\u30c7\u30fc\u30bf\u304c\u767a\u751f\u3059\u308b\u3088\u3046\u306a\u30bb\u30f3\u30b5\u30fc\u30c7\u30fc\u30bf\u304b\u3089\u3001\u5fc5\u8981\u306a\u60c5\u5831\u3060\u3051\u3092\u62bd\u51fa\u3059\u308b<\/li>\n\n\n\n<li>\u6570\u4e07\u4ef6\u306e\u30a2\u30f3\u30b1\u30fc\u30c8\u7d50\u679c\u3092\u3001\u5e74\u9f62\u3084\u6027\u5225\u306a\u3069\u306e\u30b0\u30eb\u30fc\u30d7\u3054\u3068\u306b\u96c6\u8a08\u3057\u3066\u6bd4\u8f03\u3059\u308b<\/li>\n\n\n\n<li>\u4f1a\u54e1\u60c5\u5831\u3001\u8cfc\u8cb7\u5c65\u6b74\u3001\u30a6\u30a7\u30d6\u306e\u95b2\u89a7\u5c65\u6b74\u306a\u3069\u3001\u7570\u306a\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c7\u30fc\u30bf\u3092\u7d50\u5408\u3057\u3066\u3001\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u65bd\u7b56\u3092\u7acb\u6848\u3059\u308b<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u3057\u304b\u3082\u3001pandas\u3092\u4f7f\u3048\u3070\u3001\u3053\u3046\u3057\u305f\u30c7\u30fc\u30bf\u51e6\u7406\u3092Excel\u3088\u308a\u306f\u308b\u304b\u306b\u9ad8\u901f\u306b\u3001SQL\u3088\u308a\u3082\u305a\u3063\u3068\u624b\u8efd\u306b\u884c\u3048\u3066\u3057\u307e\u3046\u306e\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-2\">pandas\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5 \u2013 pip\u4e00\u767a\u3067\u74b0\u5883\u69cb\u7bc9\u5b8c\u4e86<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">pandas\u306f\u3001\u4ee5\u4e0b\u306e\u30ef\u30f3\u30e9\u30a4\u30f3\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3060\u3051\u3067\u3001\u7c21\u5358\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">pip install pandas<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3042\u3068\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u4f7f\u3044\u59cb\u3081\u308b\u3060\u3051\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3060\u3051\u3067\u3001pandas\u306e\u81a8\u5927\u306a\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u5206\u6790\u3092\u59cb\u3081\u3089\u308c\u307e\u3059\u3002<br>\u4f8b\u3048\u3070CSV\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3067\u8aad\u307f\u8fbc\u3080\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df = pd.read_csv('data.csv')<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u305d\u3057\u3066\u3001\u30c7\u30fc\u30bf\u306e\u4e2d\u8eab\u306f\u3001<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df.head())<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3068\u66f8\u304f\u3060\u3051\u3067\u3001\u5148\u982d5\u884c\u3092\u7c21\u5358\u306b\u78ba\u8a8d\u3067\u304d\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001pandas\u3092\u4f7f\u3048\u3070\u3001\u5c11\u306a\u3044\u30b3\u30fc\u30c9\u91cf\u3067\u76f4\u611f\u7684\u306b\u30c7\u30fc\u30bf\u5206\u6790\u3092\u9032\u3081\u3089\u308c\u308b\u306e\u3067\u3059\u3002<br>\u305d\u308c\u3067\u306f\u3001\u6b21\u306fpandas\u306eDataFrame\u306a\u3069\u3001\u30ad\u30fc\u3068\u306a\u308b\u30c7\u30fc\u30bf\u69cb\u9020\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-3\">pandas\u306e\u57fa\u672c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8 \u2013 Series \u3068 DataFrame \u3092\u7406\u89e3\u3059\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">pandas\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u5206\u6790\u3092\u59cb\u3081\u308b\u524d\u306b\u3001\u307e\u305a\u62bc\u3055\u3048\u3066\u304a\u304f\u3079\u304d\u306a\u306e\u304c\u3001Series\u3068DataFrame\u3068\u3044\u30462\u3064\u306e\u57fa\u672c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3059\u3002<br>Series\u3068DataFrame\u306f\u3001pandas\u3067\u30c7\u30fc\u30bf\u3092\u6271\u3046\u4e0a\u3067\u6b20\u304b\u305b\u306a\u3044\u69cb\u6210\u8981\u7d20\u3067\u3059\u304c\u3001\u521d\u5fc3\u8005\u306b\u3068\u3063\u3066\u306f\u305d\u306e\u9055\u3044\u304c\u308f\u304b\u308a\u306b\u304f\u3044\u30dd\u30a4\u30f3\u30c8\u3067\u3082\u3042\u308a\u307e\u3059\u3002<br>\u305d\u3053\u3067\u3001\u3053\u306e\u7ae0\u3067\u306fSeries\u3068DataFrame\u306e\u7279\u5fb4\u3092\u4e00\u3064\u305a\u3064\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-4\">Series \u2013 1\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u69cb\u9020<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"keiko_yellow\">Series<\/span>\u306f\u3001pandas\u306b\u304a\u3051\u308b<span class=\"keiko_yellow\">1\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u69cb\u9020<\/span>\u3067\u3059\u3002<br>\u30ba\u30d0\u30ea\u3001Excel\u3067\u8a00\u3046\u3068\u3053\u308d\u306e\u300c\u5217\u300d\u3060\u3068\u601d\u3063\u3066\u304f\u3060\u3055\u3044\u3002<br>\u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a1\u5217\u306e\u30c7\u30fc\u30bf\u3092Series\u3067\u8868\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u3042\u308b\u5546\u54c1\u306e\u65e5\u5225\u306e\u58f2\u4e0a\u500b\u6570<\/li>\n\n\n\n<li>\u3042\u308b\u5730\u70b9\u3067\u8a08\u6e2c\u3055\u308c\u305f1\u6642\u9593\u3054\u3068\u306e\u6c17\u6e29<\/li>\n\n\n\n<li>\u3042\u308b\u751f\u5f92\u306e\u5404\u6559\u79d1\u306e\u30c6\u30b9\u30c8\u306e\u70b9\u6570<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Series\u306f\u3001\u3053\u306e\u3088\u3046\u306a1\u6b21\u5143\u306e\u6570\u5024\u30c7\u30fc\u30bf\u3092\u3001\u30e9\u30d9\u30eb\u4ed8\u304d\u3067\u4fdd\u6301\u3059\u308b\u306e\u306b\u4fbf\u5229\u306a\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306a\u306e\u3067\u3059\u3002<br>Series\u3092\u4f5c\u308b\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u66f8\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\nsales = pd.Series([10, 20, 15, 30, 25])\nprint(sales)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">0    10\n1    20\n2    15\n3    30\n4    25\ndtype: int64<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u3046\u3057\u3066\u3001<code>pd.Series()<\/code>\u306b1\u6b21\u5143\u306e\u30ea\u30b9\u30c8\u3084ndarray\u3092\u6e21\u3059\u3060\u3051\u3067\u3001Series\u304c\u751f\u6210\u3055\u308c\u307e\u3059\u3002<br>\u5148\u982d\u306e0, 1, 2\u2026\u3068\u3044\u3046\u306e\u304c\u3001\u5404\u30c7\u30fc\u30bf\u306e\u30e9\u30d9\u30eb\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff09\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-5\">DataFrame \u2013 2\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u69cb\u9020<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e00\u65b9\u3001<span class=\"keiko_red\">DataFrame<\/span>\u306f\u3001pandas\u306e<span class=\"keiko_red\">2\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u69cb\u9020<\/span>\u3067\u3059\u3002<br>Excel\u3067\u3044\u3046\u3068\u3053\u308d\u306e\u300c\u8868\u300d\u3060\u3068\u601d\u3063\u3066\u304f\u3060\u3055\u3044\u3002<br>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u3001\u8907\u6570\u306e\u5909\u6570\uff08\u5217\uff09\u304b\u3089\u306a\u308b\u8868\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u3092\u8868\u73fe\u3059\u308b\u306e\u306b\u6700\u9069\u3067\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u3042\u308b\u5e97\u8217\u306e\u3001\u65e5\u5225\u30fb\u5546\u54c1\u5225\u306e\u58f2\u4e0a\u30c7\u30fc\u30bf<\/li>\n\n\n\n<li>\u3042\u308b\u5730\u57df\u306e\u3001\u5e74\u5225\u30fb\u6708\u5225\u306e\u5e73\u5747\u6c17\u6e29\u3068\u964d\u6c34\u91cf<\/li>\n\n\n\n<li>\u3042\u308b\u5b66\u6821\u306e\u3001\u751f\u5f92\u3054\u3068\u306e\u5404\u6559\u79d1\u306e\u8a66\u9a13\u306e\u70b9\u6570<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">DataFrame\u306f\u3001\u3053\u306e\u3088\u3046\u306a2\u6b21\u5143\u306e\u8868\u5f62\u5f0f\u30c7\u30fc\u30bf\u3092\u6271\u3046\u4e0a\u3067\u6b20\u304b\u305b\u306a\u3044\u5b58\u5728\u3067\u3059\u3002<br>\u305d\u3057\u3066\u3001\u5404\u5217\u304cSeries\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002<br>DataFrame\u306f\u3001\u8907\u6570\u306eSeries\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u3082\u306e\u3068\u8003\u3048\u308b\u3053\u3068\u3082\u3067\u304d\u308b\u308f\u3051\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">DataFrame\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8f9e\u66f8\u5f62\u5f0f\u3067\u751f\u6210\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndata = {\n    \"\u5546\u54c1A\": [10, 20, 15, 30, 25], \n    \"\u5546\u54c1B\": [5, 10, 8, 12, 15],\n    \"\u5546\u54c1C\": [8, 12, 10, 15, 20]\n}\n\ndf = pd.DataFrame(data)\nprint(df)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">   \u5546\u54c1A  \u5546\u54c1B  \u5546\u54c1C\n0    10     5     8\n1    20    10    12\n2    15     8    10\n3    30    12    15\n4    25    15    20<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u5404\u5217\u306b\u30e9\u30d9\u30eb\uff08\u5217\u540d\uff09\u3092\u6301\u3063\u305f\u30c7\u30fc\u30bf\u3092DataFrame\u3067\u8868\u73fe\u3067\u304d\u307e\u3059\u3002<br>\u305d\u3057\u3066\u3001DataFrame\u306e\u5404\u5217\u306f\u3001Series\u3068\u3057\u3066\u53d6\u308a\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df[\"\u5546\u54c1A\"])<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">0    10\n1    20\n2    15\n3    30\n4    25\nName: \u5546\u54c1A, dtype: int64<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u306e\u3088\u3046\u306b\u3001Series\u3068DataFrame\u306fpandas\u306b\u3088\u308b\u30c7\u30fc\u30bf\u5206\u6790\u306e\u57fa\u790e\u3068\u306a\u308b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3059\u3002<br>\u305d\u3057\u3066\u3001\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u5206\u6790\u3067\u306f\u3001Series\u3068DataFrame\u306b\u5bfe\u3059\u308b\u3055\u307e\u3056\u307e\u306a\u64cd\u4f5c\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u76ee\u7684\u306e\u7d50\u679c\u3092\u5c0e\u304d\u51fa\u3057\u3066\u3044\u304d\u307e\u3059\u3002<br>\u6b21\u306e\u7ae0\u3067\u306f\u3001\u305d\u3046\u3057\u305fDataFrame\u306e\u5b9f\u8df5\u7684\u306a\u4f7f\u3044\u65b9\u3092\u898b\u3066\u3044\u304f\u3053\u3068\u306b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-6\">DataFrame\u306e\u57fa\u672c\u64cd\u4f5c\u30de\u30b9\u30bf\u30fc \u2013 \u30c7\u30fc\u30bf\u5206\u6790\u306e\u571f\u53f0\u3092\u7bc9\u3053\u3046<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">pandas\u3067\u30c7\u30fc\u30bf\u5206\u6790\u3092\u884c\u3046\u4e0a\u3067\u3001DataFrame\u306e\u64cd\u4f5c\u3092\u30de\u30b9\u30bf\u30fc\u3059\u308b\u3053\u3068\u306f\u975e\u5e38\u306b\u91cd\u8981\u3067\u3059\u3002<br>\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f\u304b\u3089\u52a0\u5de5\u3001\u96c6\u8a08\u3001\u53ef\u8996\u5316\u306b\u81f3\u308b\u307e\u3067\u3001<span class=\"keiko_yellow\">\u3042\u3089\u3086\u308b\u5834\u9762\u3067DataFrame\u306b\u5bfe\u3059\u308b\u64cd\u4f5c\u304c\u767b\u5834\u3059\u308b<\/span>\u304b\u3089\u3067\u3059\u3002<br>\u3053\u3053\u3067\u306f\u3001DataFrame\u306e\u57fa\u672c\u7684\u306a\u64cd\u4f5c\u65b9\u6cd5\u3092\u4e00\u3064\u305a\u3064\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<br>\u3053\u308c\u3089\u306e\u64cd\u4f5c\u3092\u8eab\u306b\u3064\u3051\u308b\u3053\u3068\u304c\u3001pandas\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u5206\u6790\u306e\u571f\u53f0\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-7\">DataFrame\u306e\u751f\u6210 \u2013 \u3044\u308d\u3044\u308d\u306a\u30c7\u30fc\u30bf\u304b\u3089\u8868\u3092\u4f5c\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">DataFrame\u3092\u751f\u6210\u3059\u308b\u65b9\u6cd5\u306f\u3001\u4e3b\u306b3\u3064\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3064\u76ee\u306f\u3001<span class=\"keiko_yellow\">Python\u306e\u30ea\u30b9\u30c8\u3084\u8f9e\u66f8\u304b\u3089DataFrame\u3092\u4f5c\u308b<\/span>\u65b9\u6cd5\u3067\u3059\u3002<br>\u524d\u306e\u7ae0\u3067\u7d39\u4ecb\u3057\u305f\u3088\u3046\u306b\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30b3\u30fc\u30c9\u3067DataFrame\u3092\u751f\u6210\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndata = {'col1': [1, 2], 'col2': [3, 4]}\ndf = pd.DataFrame(data)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3064\u76ee\u306f\u3001<span class=\"keiko_yellow\">NumPy\u306endarray\u304b\u3089DataFrame\u3092\u4f5c\u308b<\/span>\u65b9\u6cd5\u3067\u3059\u3002<br>ndarray\u3092\u6e21\u3059\u969b\u306f\u3001\u5217\u540d\u3092\u5225\u9014\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import numpy as np\n\ndata = np.array([[1, 2], [3, 4]])\ndf = pd.DataFrame(data, columns=['col1', 'col2'])<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">3\u3064\u76ee\u306f\u3001<span class=\"keiko_yellow\">CSV\u30d5\u30a1\u30a4\u30eb\u3084Excel\u30d5\u30a1\u30a4\u30eb\u304b\u3089DataFrame\u3092\u4f5c\u308b<\/span>\u65b9\u6cd5\u3067\u3059\u3002<br>\u30c7\u30fc\u30bf\u5206\u6790\u306e\u73fe\u5834\u3067\u306f\u3001\u3053\u306e\u65b9\u6cd5\u3092\u4f7f\u3046\u3053\u3068\u304c\u6700\u3082\u591a\u3044\u3067\u3057\u3087\u3046\u3002<br>read_csv()\u95a2\u6570\u3084read_excel()\u95a2\u6570\u3092\u4f7f\u3046\u3060\u3051\u3067\u3001\u30d5\u30a1\u30a4\u30eb\u304b\u3089DataFrame\u3092\u751f\u6210\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df = pd.read_csv('data.csv')<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001DataFrame\u306e\u751f\u6210\u65b9\u6cd5\u306f\u8907\u6570\u3042\u308a\u307e\u3059\u304c\u3001\u76ee\u7684\u306b\u5fdc\u3058\u3066\u9069\u5207\u306a\u65b9\u6cd5\u3092\u9078\u3079\u3070OK\u3067\u3059\u3002<br>\u6b21\u306f\u3001\u751f\u6210\u3057\u305fDataFrame\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3059\u65b9\u6cd5\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-8\">DataFrame\u306e\u53c2\u7167 \u2013 \u884c\u3084\u5217\u3092\u81ea\u5728\u306b\u53d6\u308a\u51fa\u3059<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">DataFrame\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3059\u306b\u306f\u3001\u884c\u3084\u5217\u3092\u6307\u5b9a\u3057\u3066\u53c2\u7167\u3059\u308b\u65b9\u6cd5\u3068\u3001\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u62bd\u51fa\u3059\u308b\u65b9\u6cd5\u306e2\u7a2e\u985e\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3064\u76ee\u306e\u65b9\u6cd5\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b<span class=\"keiko_yellow\">\u30ab\u30e9\u30e0\u540d\u3084\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08\u30e9\u30d9\u30eb\uff09\u3092\u4f7f\u3063\u3066\u884c\u3084\u5217\u3092\u6307\u5b9a\u3059\u308b<\/span>\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df['col1'])  # col1\u306e\u5217\u3092\u53d6\u5f97\nprint(df.loc[0])   # \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c0\u306e\u884c\u3092\u53d6\u5f97<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u3053\u3067\u3001loc\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30e9\u30d9\u30eb\u3092\u4f7f\u3063\u305f\u53c2\u7167\u3001iloc\u306f\u6574\u6570\u4f4d\u7f6e\u3092\u4f7f\u3063\u305f\u53c2\u7167\u3092\u3059\u308b\u969b\u306b\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3064\u76ee\u306e\u65b9\u6cd5\u306f\u3001<span class=\"keiko_yellow\">\u6761\u4ef6\u3092\u6307\u5b9a\u3057\u3066\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3059\u308b<\/span>\u65b9\u6cd5\u3067\u3059\u3002<br>\u4f8b\u3048\u3070\u3001col1\u306e\u5024\u304c1\u3088\u308a\u5927\u304d\u3044\u30c7\u30fc\u30bf\u3060\u3051\u3092\u62bd\u51fa\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u66f8\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df[df['col1'] &gt; 1])  # col1\u304c1\u3088\u308a\u5927\u304d\u3044\u884c\u3092\u62bd\u51fa<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001[ ]\u5185\u306b\u6761\u4ef6\u5f0f\u3092\u66f8\u304f\u3053\u3068\u3067\u3001\u6761\u4ef6\u3092\u6e80\u305f\u3059\u30c7\u30fc\u30bf\u3060\u3051\u3092\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<br>\u8907\u6570\u306e\u6761\u4ef6\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u3001&amp;\u3084|\u3092\u4f7f\u3063\u3066\u6761\u4ef6\u5f0f\u3092\u7d44\u307f\u5408\u308f\u305b\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df[(df['col1'] &gt; 1) &amp; (df['col2'] &lt; 4)])  # col1\u304c1\u3088\u308a\u5927\u304d\u304f\u3001\u304b\u3064col2\u304c4\u3088\u308a\u5c0f\u3055\u3044\u884c\u3092\u62bd\u51fa<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u306e\u3088\u3046\u306b\u3001DataFrame\u304b\u3089\u30c7\u30fc\u30bf\u3092\u53d6\u308a\u51fa\u3059\u65b9\u6cd5\u3092\u4f7f\u3044\u5206\u3051\u308b\u3053\u3068\u3067\u3001\u5206\u6790\u306b\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u81ea\u5728\u306b\u53d6\u308a\u51fa\u305b\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-9\">DataFrame\u306e\u7de8\u96c6 \u2013 \u65b0\u3057\u3044\u5217\u306e\u8ffd\u52a0\u3084\u5024\u306e\u66f4\u65b0<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">DataFrame\u306f\u3001\u65b0\u3057\u3044\u5217\u3092\u8ffd\u52a0\u3057\u305f\u308a\u3001\u65e2\u5b58\u306e\u5024\u3092\u66f4\u65b0\u3057\u305f\u308a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u65b0\u3057\u3044\u5217\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b<span class=\"keiko_yellow\">\u65b0\u3057\u3044\u30ab\u30e9\u30e0\u540d\u3092[ ]\u3067\u6307\u5b9a\u3057\u3001\u5024\u3092\u4ee3\u5165<\/span>\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df['new_col'] = df['col1'] + df['col2']  # col1\u3068col2\u306e\u548c\u3092\u65b0\u3057\u3044\u5217\u3068\u3057\u3066\u8ffd\u52a0<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u65e2\u5b58\u306e\u5217\u3092\u4f7f\u3063\u305f\u8a08\u7b97\u7d50\u679c\u3092\u65b0\u3057\u3044\u5217\u3068\u3057\u3066\u8ffd\u52a0\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3057\u3001\u5b9a\u6570\u5024\u3092\u4ee3\u5165\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df['constant_col'] = 1  # \u5168\u3066\u306e\u884c\u306b1\u3092\u4ee3\u5165\u3057\u305f\u5217\u3092\u8ffd\u52a0<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e2\u5b58\u306e\u5024\u3092\u66f4\u65b0\u3059\u308b\u306b\u306f\u3001<span class=\"keiko_yellow\">loc\u3084iloc\u3092\u4f7f\u3063\u3066\u66f4\u65b0\u3057\u305f\u3044\u5834\u6240\u3092\u6307\u5b9a\u3057\u3001\u65b0\u3057\u3044\u5024\u3092\u4ee3\u5165<\/span>\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df.loc[0, 'col1'] = 10  # \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c0\u306e\u884c\u306ecol1\u306e\u5024\u309210\u306b\u66f4\u65b0<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u306e\u3088\u3046\u306bDataFrame\u3092\u7de8\u96c6\u3059\u308b\u3053\u3068\u3067\u3001\u5206\u6790\u306b\u5fc5\u8981\u306a\u65b0\u3057\u3044\u6307\u6a19\u3092\u8ffd\u52a0\u3057\u305f\u308a\u3001\u30c7\u30fc\u30bf\u3092\u4fee\u6b63\u3057\u305f\u308a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u5f8c\u306b\u3001DataFrame\u306e\u96c6\u8a08\u65b9\u6cd5\u3068\u30c7\u30fc\u30bf\u306e\u4e26\u3073\u66ff\u3048\u65b9\u6cd5\u3092\u7c21\u5358\u306b\u7d39\u4ecb\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5404\u5217\u306e\u5408\u8a08\u5024\u3084\u5e73\u5747\u5024\u306a\u3069\u3092\u6c42\u3081\u308b\u306b\u306f\u3001sum()\u3084mean()\u306a\u3069\u306e\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df.sum())   # \u5404\u5217\u306e\u5408\u8a08\u5024\u3092\u7b97\u51fa\nprint(df.mean())  # \u5404\u5217\u306e\u5e73\u5747\u5024\u3092\u7b97\u51fa<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u3092\u4e26\u3073\u66ff\u3048\u308b\u306b\u306f\u3001sort_values()\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df.sort_values('col1'))  # col1\u306e\u5024\u3067\u6607\u9806\u306b\u4e26\u3073\u66ff\u3048<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u3067\u3001DataFrame\u306e\u57fa\u672c\u64cd\u4f5c\u306b\u3064\u3044\u3066\u306f\u4e00\u901a\u308a\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<br>\u3053\u3053\u3067\u7d39\u4ecb\u3057\u305f\u64cd\u4f5c\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3060\u3051\u3067\u3001\u591a\u304f\u306e\u5206\u6790\u30bf\u30b9\u30af\u3092\u3053\u306a\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br>pandas\u306e\u4f7f\u3044\u65b9\u3092\u8eab\u306b\u3064\u3051\u308b\u305f\u3081\u306b\u306f\u3001\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u5206\u6790\u3092\u3059\u308b\u4e2d\u3067\u3001\u3053\u308c\u3089\u306e\u64cd\u4f5c\u3092\u8a66\u3057\u3066\u307f\u308b\u3053\u3068\u304c\u5927\u5207\u3067\u3059\u3002<br>\u6b21\u306e\u7ae0\u3067\u306f\u3001\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u5206\u6790\u306e\u4f8b\u3092\u898b\u3066\u3044\u304f\u3053\u3068\u306b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-10\">\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u66f8\u304d \u2013 CSV\u3084\u30a8\u30af\u30bb\u30eb\u3068\u306e\u30c7\u30fc\u30bf\u306e\u3084\u308a\u53d6\u308a<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u5206\u6790\u306e\u73fe\u5834\u3067\u306f\u3001CSV\u3084\u30a8\u30af\u30bb\u30eb\u306a\u3069\u306e\u5f62\u5f0f\u3067\u30c7\u30fc\u30bf\u3092\u3084\u308a\u53d6\u308a\u3059\u308b\u3053\u3068\u304c\u975e\u5e38\u306b\u591a\u304f\u3042\u308a\u307e\u3059\u3002<br>\u5206\u6790\u306e\u30a4\u30f3\u30d7\u30c3\u30c8\u3068\u306a\u308b\u30c7\u30fc\u30bf\u304c\u3001CSV\u3084\u30a8\u30af\u30bb\u30eb\u3067\u63d0\u4f9b\u3055\u308c\u3066\u3044\u305f\u308a\u3001\u5206\u6790\u306e\u7d50\u679c\u3092CSV\u3084\u30a8\u30af\u30bb\u30eb\u3067\u51fa\u529b\u3057\u3066\u4ed6\u306e\u4eba\u3068\u5171\u6709\u3057\u305f\u308a\u3059\u308b\u30b1\u30fc\u30b9\u304c\u591a\u3044\u305f\u3081\u3067\u3059\u3002<br>\u305d\u306e\u305f\u3081\u3001pandas\u3067CSV\u3084\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u66f8\u304d\u3059\u308b\u65b9\u6cd5\u3092\u77e5\u3063\u3066\u304a\u304f\u3053\u3068\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3092\u52b9\u7387\u7684\u306b\u9032\u3081\u308b\u4e0a\u3067\u6b20\u304b\u305b\u307e\u305b\u3093\u3002<br>\u3053\u3053\u3067\u306f\u3001pandas\u3092\u4f7f\u3063\u305fCSV\u3068\u30a8\u30af\u30bb\u30eb\u306e\u8aad\u307f\u66f8\u304d\u306e\u57fa\u672c\u7684\u306a\u65b9\u6cd5\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-11\">CSV\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\u30fb\u66f8\u304d\u51fa\u3057<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"keiko_red\">CSV<\/span>\u306f\u3001Comma-Separated Values\uff08\u30ab\u30f3\u30de\u533a\u5207\u308a\u5024\uff09\u306e\u7565\u3067\u3001<span class=\"keiko_red\">\u6587\u5b57\u901a\u308a\u30ab\u30f3\u30de\uff08,\uff09\u3067\u533a\u5207\u3089\u308c\u305f\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb<\/span>\u306e\u3053\u3068\u3067\u3059\u3002<br>pandas\u3067\u306f\u3001read_csv()\u95a2\u6570\u3092\u4f7f\u3063\u3066CSV\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u307f\u3001to_csv()\u95a2\u6570\u3092\u4f7f\u3063\u3066CSV\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306aCSV\u30d5\u30a1\u30a4\u30eb\uff08data.csv\uff09\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">id,name,age,city\n1,Alice,24,Tokyo\n2,Bob,30,Osaka\n3,Charlie,20,Nagoya<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306eCSV\u30d5\u30a1\u30a4\u30eb\u3092pandas\u3067\u8aad\u307f\u8fbc\u3080\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b<span class=\"keiko_yellow\">read_csv()\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059<\/span>\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndf = pd.read_csv('data.csv')\nprint(df)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">   id     name  age    city\n0   1    Alice   24   Tokyo\n1   2      Bob   30   Osaka\n2   3  Charlie   20  Nagoya<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u898b\u3066\u306e\u901a\u308a\u3001CSV\u30d5\u30a1\u30a4\u30eb\u304cDataFrame\u3068\u3057\u3066\u8aad\u307f\u8fbc\u307e\u308c\u307e\u3057\u305f\u3002<br>\u5217\u540d\u306f\u3001CSV\u306e1\u884c\u76ee\u304c\u30d8\u30c3\u30c0\u30fc\u3068\u3057\u3066\u4f7f\u308f\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9006\u306b\u3001DataFrame\u3092CSV\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3059\u306b\u306f\u3001<span class=\"keiko_red\">to_csv()\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059<\/span>\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df.to_csv('output.csv', index=False)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3067\u3001DataFrame\u304cCSV\u30d5\u30a1\u30a4\u30eb\uff08output.csv\uff09\u306b\u66f8\u304d\u51fa\u3055\u308c\u307e\u3057\u305f\u3002<br>index=False\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u306e\u306f\u3001\u884c\u756a\u53f7\uff08\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff09\u3092\u51fa\u529b\u3057\u306a\u3044\u305f\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">read_csv()\u3068to_csv()\u306b\u306f\u3001\u4ed6\u306b\u3082\u533a\u5207\u308a\u6587\u5b57\u3084\u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306a\u3069\u3092\u6307\u5b9a\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308b\u306e\u3067\u3001\u30c7\u30fc\u30bf\u306e\u7279\u6027\u306b\u5408\u308f\u305b\u3066\u9069\u5207\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u5927\u5207\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-12\">\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f\u30fb\u66f8\u304d\u51fa\u3057<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\uff08.xlsx\uff09\u3082\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3067\u306f\u3088\u304f\u4f7f\u308f\u308c\u308b\u30d5\u30a1\u30a4\u30eb\u5f62\u5f0f\u3067\u3059\u3002<br><span class=\"keiko_yellow\">pandas\u3067\u306f\u3001read_excel()\u95a2\u6570\u3092\u4f7f\u3063\u3066\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u307f\u8fbc\u307f\u3001to_excel()\u95a2\u6570\u3092\u4f7f\u3063\u3066\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\uff08data.xlsx\uff09\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n<div id=\"id-25894601-bf96-43e4-a0b0-90d0c296b77e\">\n<figure class=\"wp-block-table\"><table><thead><tr><th>id<\/th><th>name<\/th><th>age<\/th><th>city<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Alice<\/td><td>24<\/td><td>Tokyo<\/td><\/tr><tr><td>2<\/td><td>Bob<\/td><td>30<\/td><td>Osaka<\/td><\/tr><tr><td>3<\/td><td>Charlie<\/td><td>20<\/td><td>Nagoya<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">data.xlsx<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u3092pandas\u3067\u8aad\u307f\u8fbc\u3080\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bread_excel()\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndf = pd.read_excel('data.xlsx')\nprint(df)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">   id     name  age    city\n0   1    Alice   24   Tokyo\n1   2      Bob   30   Osaka\n2   3  Charlie   20  Nagoya<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">CSV\u306e\u5834\u5408\u3068\u540c\u69d8\u306b\u3001\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u304cDataFrame\u3068\u3057\u3066\u8aad\u307f\u8fbc\u307e\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9006\u306b\u3001DataFrame\u3092\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306b\u66f8\u304d\u51fa\u3059\u306b\u306f\u3001to_excel()\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df.to_excel('output.xlsx', index=False)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3067\u3001DataFrame\u304c\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\uff08output.xlsx\uff09\u306b\u66f8\u304d\u51fa\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">read_excel()\u3068to_excel()\u306b\u306f\u3001\u8aad\u307f\u8fbc\u3080\u30b7\u30fc\u30c8\u3084\u7bc4\u56f2\u3092\u6307\u5b9a\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u3082\u3042\u308b\u306e\u3067\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u6d3b\u7528\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u306e\u3088\u3046\u306b\u3001pandas\u3092\u4f7f\u3048\u3070\u3001CSV\u3084\u30a8\u30af\u30bb\u30eb\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u66f8\u304d\u3092\u624b\u8efd\u306b\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br>\u305f\u3060\u3057\u3001CSV\u3068\u30a8\u30af\u30bb\u30eb\u306b\u306f\u305d\u308c\u305e\u308c\u9577\u6240\u3068\u77ed\u6240\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><span class=\"keiko_yellow\">CSV\u306f\u3001\u30b7\u30f3\u30d7\u30eb\u3067\u8efd\u91cf\u3001\u591a\u304f\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u3067\u6271\u3048\u308b<\/span>\u3002\u305f\u3060\u3057\u3001\u30c7\u30fc\u30bf\u578b\u306e\u60c5\u5831\u306f\u6301\u305f\u306a\u3044\u3002<\/li>\n\n\n\n<li><span class=\"keiko_red\">\u30a8\u30af\u30bb\u30eb\u306f\u3001\u898b\u305f\u76ee\u3092\u6574\u3048\u3089\u308c\u308b\u3001\u8907\u6570\u30b7\u30fc\u30c8\u3092\u6301\u3066\u308b<\/span>\u3002\u305f\u3060\u3057\u3001\u30d5\u30a1\u30a4\u30eb\u30b5\u30a4\u30ba\u304c\u5927\u304d\u304f\u306a\u308a\u304c\u3061\u3002<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u306e\u7279\u6027\u3084\u7528\u9014\u306b\u5fdc\u3058\u3066\u3001\u9069\u5207\u306a\u30d5\u30a1\u30a4\u30eb\u5f62\u5f0f\u3092\u9078\u3076\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<br>\u307e\u305f\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u66f8\u304d\u306e\u969b\u306f\u3001\u6587\u5b57\u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3084\u533a\u5207\u308a\u6587\u5b57\u306a\u3069\u3001\u30c7\u30fc\u30bf\u306e\u7279\u6027\u306b\u5408\u308f\u305b\u305f\u8a2d\u5b9a\u304c\u5fc5\u8981\u306a\u306e\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">pandas\u306e\u30d5\u30a1\u30a4\u30eb\u5165\u51fa\u529b\u6a5f\u80fd\u3092\u4f7f\u3044\u3053\u306a\u305b\u3070\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u4f5c\u696d\u52b9\u7387\u3092\u5927\u304d\u304f\u9ad8\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3067\u3057\u3087\u3046\u3002<br>\u6b21\u306e\u7ae0\u3067\u306f\u3001\u8aad\u307f\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u3092\u5206\u6790\u306b\u9069\u3057\u305f\u5f62\u306b\u6574\u3048\u308b\u305f\u3081\u306e\u3001\u30c7\u30fc\u30bf\u306e\u524d\u51e6\u7406\u30c6\u30af\u30cb\u30c3\u30af\u3092\u898b\u3066\u3044\u304f\u3053\u3068\u306b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-13\">\u30c7\u30fc\u30bf\u306e\u524d\u51e6\u7406\u30c6\u30af\u30cb\u30c3\u30af \u2013 \u6b20\u640d\u5024\u3084\u91cd\u8907\u3078\u306e\u5bfe\u51e6\u6cd5<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u5206\u6790\u3092\u884c\u3046\u4e0a\u3067\u3001\u30c7\u30fc\u30bf\u306e\u524d\u51e6\u7406\u306f\u6b20\u304b\u305b\u306a\u3044\u30d7\u30ed\u30bb\u30b9\u3067\u3059\u3002<br>\u7279\u306b\u3001\u6b20\u640d\u5024\u3084\u91cd\u8907\u30c7\u30fc\u30bf\u306f\u3001\u305d\u306e\u307e\u307e\u3067\u306f\u5206\u6790\u306e\u8cea\u3092\u5927\u304d\u304f\u640d\u306d\u308b\u6050\u308c\u304c\u3042\u308a\u307e\u3059\u3002<br>\u6b20\u640d\u5024\u304c\u3042\u308b\u3068\u3001\u7d71\u8a08\u91cf\u306e\u8a08\u7b97\u304c\u6b6a\u3093\u3060\u308a\u3001\u6a5f\u68b0\u5b66\u7fd2\u30e2\u30c7\u30eb\u306e\u6027\u80fd\u304c\u4f4e\u4e0b\u3057\u305f\u308a\u3057\u307e\u3059\u3002<br>\u91cd\u8907\u30c7\u30fc\u30bf\u304c\u3042\u308b\u3068\u3001\u96c6\u8a08\u7d50\u679c\u304c\u4e0d\u6b63\u78ba\u306b\u306a\u3063\u305f\u308a\u3001\u5206\u6790\u306e\u524d\u63d0\u304c\u5d29\u308c\u305f\u308a\u3057\u307e\u3059\u3002<br>\u3053\u306e\u3088\u3046\u306a\u554f\u984c\u3092\u907f\u3051\u308b\u305f\u3081\u306b\u3001<span class=\"keiko_yellow\">\u6b20\u640d\u5024\u3084\u91cd\u8907\u30c7\u30fc\u30bf\u3092\u9069\u5207\u306b\u51e6\u7406\u3059\u308b\u3053\u3068\u304c\u91cd\u8981<\/span>\u306a\u306e\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u3053\u3067\u306f\u3001pandas\u3092\u4f7f\u3063\u305f\u6b20\u640d\u5024\u3068\u91cd\u8907\u30c7\u30fc\u30bf\u306e\u51e6\u7406\u65b9\u6cd5\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-14\">\u6b20\u640d\u5024\u306e\u78ba\u8a8d\u3068\u9664\u53bb\u30fb\u88dc\u5b8c<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b20\u640d\u5024\u3068\u306f\u3001\u30c7\u30fc\u30bf\u306e\u4e2d\u3067\u5024\u304c\u7a7a\u767d\u3084NaN\u306b\u306a\u3063\u3066\u3044\u308b\u90e8\u5206\u306e\u3053\u3068\u3067\u3059\u3002<br>\u6b20\u640d\u5024\u306f\u3001\u30c7\u30fc\u30bf\u306e\u53ce\u96c6\u3084\u5165\u529b\u306e\u969b\u306e\u30df\u30b9\u306b\u3088\u3063\u3066\u751f\u3058\u308b\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u304c\u3001\u6642\u306b\u306f\u610f\u56f3\u7684\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">pandas\u3067\u306f\u3001\u6b20\u640d\u5024\u3092\u8868\u3059\u305f\u3081\u306bNaN\uff08Not a Number\uff09\u3068\u3044\u3046\u7279\u6b8a\u306a\u5024\u304c\u4f7f\u308f\u308c\u307e\u3059\u3002<br>\u6b20\u640d\u5024\u3092\u51e6\u7406\u3059\u308b\u524d\u306b\u3001\u307e\u305a\u306f\u30c7\u30fc\u30bf\u306e\u4e2d\u306b\u3069\u306e\u7a0b\u5ea6\u306e\u6b20\u640d\u5024\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u304b\u3092\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<br><span class=\"keiko_yellow\">isnull()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3068\u3001\u5404\u8981\u7d20\u304c\u6b20\u640d\u5024\u304b\u3069\u3046\u304b\u3092\u771f\u507d\u5024\u3067\u8fd4\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\nimport numpy as np\n\ndf = pd.DataFrame({'A': [1, 2, np.nan, 4],\n                   'B': [5, np.nan, np.nan, 8],\n                   'C': [9, 10, 11, 12]})\n\nprint(df.isnull())<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">       A      B      C\n0  False  False  False\n1  False   True  False\n2   True   True  False\n3  False  False  False<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u5404\u8981\u7d20\u304c\u6b20\u640d\u5024\u304b\u3069\u3046\u304b\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<br>\u6b20\u640d\u5024\u306e\u5272\u5408\u304c\u9ad8\u3044\u5217\u3084\u3001\u6b20\u640d\u5024\u3092\u542b\u3080\u884c\u304c\u591a\u3044\u5834\u5408\u306f\u3001\u4f55\u3089\u304b\u306e\u51e6\u7406\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b20\u640d\u5024\u306e\u51e6\u7406\u65b9\u6cd5\u306f\u3001\u5927\u304d\u304f\u5206\u3051\u3066\u9664\u53bb\u3068\u88dc\u5b8c\u306e2\u3064\u304c\u3042\u308a\u307e\u3059\u3002<br>\u9664\u53bb\u306f\u3001\u6b20\u640d\u5024\u3092\u542b\u3080\u884c\u3084\u5217\u3092\u30c7\u30fc\u30bf\u304b\u3089\u53d6\u308a\u9664\u304f\u65b9\u6cd5\u3067\u3059\u3002<br><span class=\"keiko_yellow\">dropna()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3068\u3001\u6b20\u640d\u5024\u3092\u542b\u3080\u884c\u3084\u5217\u3092\u524a\u9664\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df.dropna())<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">     A    B   C\n0  1.0  5.0   9\n3  4.0  8.0  12<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u6b20\u640d\u5024\u3092\u542b\u3080\u884c\u304c\u524a\u9664\u3055\u308c\u307e\u3057\u305f\u3002<br>\u305f\u3060\u3057\u3001\u6b20\u640d\u5024\u306e\u5272\u5408\u304c\u9ad8\u3044\u5834\u5408\u3001\u9664\u53bb\u306b\u3088\u3063\u3066\u30c7\u30fc\u30bf\u91cf\u304c\u5927\u304d\u304f\u6e1b\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308b\u306e\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u88dc\u5b8c\u306f\u3001\u6b20\u640d\u5024\u3092\u4f55\u3089\u304b\u306e\u5024\u3067\u57cb\u3081\u308b\u65b9\u6cd5\u3067\u3059\u3002<br><span class=\"keiko_yellow\">fillna()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3068\u3001\u6b20\u640d\u5024\u3092\u7279\u5b9a\u306e\u5024\u3084\u7d71\u8a08\u91cf\u3067\u88dc\u5b8c\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df.fillna(0))<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">     A    B     C\n0  1.0  5.0   9.0\n1  2.0  0.0  10.0\n2  0.0  0.0  11.0\n3  4.0  8.0  12.0<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u6b20\u640d\u5024\u304c0\u3067\u88dc\u5b8c\u3055\u308c\u307e\u3057\u305f\u3002<br>\u4ed6\u306b\u3082\u3001\u524d\u5f8c\u306e\u5024\u304b\u3089\u88dc\u5b8c\u3059\u308b\u65b9\u6cd5\u3084\u3001\u5e73\u5747\u5024\u3084\u4e2d\u592e\u5024\u3067\u88dc\u5b8c\u3059\u308b\u65b9\u6cd5\u306a\u3069\u304c\u3042\u308a\u307e\u3059\u3002<br>\u88dc\u5b8c\u306b\u4f7f\u3046\u5024\u306f\u3001\u30c7\u30fc\u30bf\u306e\u6027\u8cea\u3084\u5206\u6790\u306e\u76ee\u7684\u306b\u5fdc\u3058\u3066\u9069\u5207\u306b\u9078\u3076\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-15\">\u91cd\u8907\u30c7\u30fc\u30bf\u306e\u78ba\u8a8d\u3068\u524a\u9664<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u91cd\u8907\u30c7\u30fc\u30bf\u3068\u306f\u3001\u540c\u3058\u5185\u5bb9\u306e\u30c7\u30fc\u30bf\u304c\u8907\u6570\u5b58\u5728\u3057\u3066\u3044\u308b\u72b6\u614b\u306e\u3053\u3068\u3067\u3059\u3002<br>\u91cd\u8907\u30c7\u30fc\u30bf\u306f\u3001\u30c7\u30fc\u30bf\u306e\u91cd\u8907\u767b\u9332\u3084\u3001\u8907\u6570\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3092\u7d50\u5408\u3059\u308b\u969b\u306b\u751f\u3058\u308b\u3053\u3068\u304c\u591a\u3044\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">pandas\u3067\u306f\u3001<span class=\"keiko_yellow\">duplicated()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066\u3001\u91cd\u8907\u884c\u3092\u7279\u5b9a\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndf = pd.DataFrame({'A': [1, 1, 2, 3],\n                   'B': [4, 4, 5, 6],\n                   'C': [7, 7, 9, 10]})\n\nprint(df.duplicated())<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">0    False\n1     True\n2    False\n3    False\ndtype: bool<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u91cd\u8907\u884c\u306bTrue\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<br><span class=\"keiko_yellow\">\u91cd\u8907\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3059\u308b\u306b\u306f\u3001drop_duplicates()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u307e\u3059\u3002<\/span><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df.drop_duplicates())<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">   A  B   C\n0  1  4   7\n2  2  5   9\n3  3  6  10<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u91cd\u8907\u884c\u304c\u524a\u9664\u3055\u308c\u307e\u3057\u305f\u3002<br>\u305f\u3060\u3057\u3001\u91cd\u8907\u30c7\u30fc\u30bf\u306e\u524a\u9664\u306f\u3001\u30c7\u30fc\u30bf\u306e\u6027\u8cea\u3084\u5206\u6790\u306e\u76ee\u7684\u3092\u8e0f\u307e\u3048\u3066\u614e\u91cd\u306b\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br>\u5358\u7d14\u306b\u91cd\u8907\u3092\u524a\u9664\u3059\u308b\u3068\u3001\u91cd\u8981\u306a\u60c5\u5831\u3092\u5931\u3063\u3066\u3057\u307e\u3046\u6050\u308c\u304c\u3042\u308b\u305f\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u306e\u3088\u3046\u306b\u3001pandas\u3092\u4f7f\u3048\u3070\u3001\u6b20\u640d\u5024\u3084\u91cd\u8907\u30c7\u30fc\u30bf\u3092\u7c21\u5358\u306b\u51e6\u7406\u3067\u304d\u307e\u3059\u3002<br>\u305f\u3060\u3057\u3001\u3053\u308c\u3089\u306e\u51e6\u7406\u306f\u3001\u5206\u6790\u306e\u7d50\u679c\u306b\u5927\u304d\u306a\u5f71\u97ff\u3092\u4e0e\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<br>\u305d\u306e\u305f\u3081\u3001\u6b20\u640d\u5024\u3084\u91cd\u8907\u30c7\u30fc\u30bf\u306e\u51e6\u7406\u306f\u3001\u30c7\u30fc\u30bf\u306e\u6027\u8cea\u3084\u5206\u6790\u306e\u76ee\u7684\u3092\u5341\u5206\u306b\u8003\u616e\u3057\u305f\u4e0a\u3067\u3001\u614e\u91cd\u306b\u884c\u3046\u3053\u3068\u304c\u5927\u5207\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b20\u640d\u5024\u306b\u3064\u3044\u3066\u306f\u3001\u524a\u9664\u3059\u308b\u304b\u88dc\u5b8c\u3059\u308b\u304b\u3092\u3001\u6b20\u640d\u306e\u7406\u7531\u3084\u5272\u5408\u3001\u5206\u6790\u306e\u76ee\u7684\u306b\u5fdc\u3058\u3066\u5224\u65ad\u3057\u307e\u3057\u3087\u3046\u3002<br>\u91cd\u8907\u30c7\u30fc\u30bf\u306b\u3064\u3044\u3066\u306f\u3001\u91cd\u8907\u3092\u8a31\u5bb9\u3059\u308b\u304b\u524a\u9664\u3059\u308b\u304b\u3092\u3001\u30c7\u30fc\u30bf\u306e\u6027\u8cea\u3084\u5206\u6790\u306e\u76ee\u7684\u306b\u5fdc\u3058\u3066\u5224\u65ad\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u306e\u524d\u51e6\u7406\u306f\u3001\u5206\u6790\u306e\u8cea\u3092\u5de6\u53f3\u3059\u308b\u91cd\u8981\u306a\u30d7\u30ed\u30bb\u30b9\u3067\u3059\u3002<br>\u6b20\u640d\u5024\u3084\u91cd\u8907\u30c7\u30fc\u30bf\u3078\u306e\u9069\u5207\u306a\u5bfe\u51e6\u306f\u3001\u305d\u306e\u305f\u3081\u306e\u7b2c\u4e00\u6b69\u3067\u3059\u3002<br>pandas\u306e\u6a5f\u80fd\u3092\u6d3b\u7528\u3057\u3066\u3001\u30c7\u30fc\u30bf\u3092\u5206\u6790\u306b\u9069\u3057\u305f\u5f62\u306b\u6574\u3048\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306e\u7ae0\u3067\u306f\u3001\u6574\u7136\u3068\u306a\u3063\u305f\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u3001\u30c7\u30fc\u30bf\u306e\u5909\u5f62\u3068\u96c6\u7d04\u3092\u884c\u3046\u65b9\u6cd5\u3092\u898b\u3066\u3044\u304f\u3053\u3068\u306b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-16\">\u30c7\u30fc\u30bf\u306e\u5909\u5f62\u3068\u96c6\u7d04 \u2013 groupby\u3068pivot_table\u3092\u4f7f\u3044\u3053\u306a\u3059<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u5206\u6790\u3067\u306f\u3001\u30c7\u30fc\u30bf\u3092\u8981\u7d04\u3057\u3066\u50be\u5411\u3092\u63b4\u3093\u3060\u308a\u3001\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3057\u3066\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u305f\u308a\u3059\u308b\u5834\u9762\u304c\u591a\u304f\u3042\u308a\u307e\u3059\u3002<br>\u3053\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u306e\u5909\u5f62\u3068\u96c6\u7d04\u3092\u884c\u3046\u4e0a\u3067\u3001pandas\u306egroupby\u3068pivot_table\u306f\u975e\u5e38\u306b\u5f37\u529b\u306a\u30c4\u30fc\u30eb\u3068\u306a\u308a\u307e\u3059\u3002<br>groupby\u306f\u3001\u30c7\u30fc\u30bf\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3066\u5404\u30b0\u30eb\u30fc\u30d7\u306e\u7d71\u8a08\u91cf\u3092\u7b97\u51fa\u3059\u308b\u306e\u306b\u4f7f\u3044\u307e\u3059\u3002<br>pivot_table\u306f\u3001\u8907\u6570\u306e\u5909\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u30af\u30ed\u30b9\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3059\u308b\u306e\u306b\u4f7f\u3044\u307e\u3059\u3002<br>\u3053\u308c\u3089\u3092\u4f7f\u3044\u3053\u306a\u3059\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u304b\u3089\u3088\u308a\u591a\u304f\u306e\u77e5\u898b\u3092\u5f15\u304d\u51fa\u305b\u308b\u3088\u3046\u306b\u306a\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u3053\u3067\u306f\u3001groupby\u3068pivot_table\u306e\u4f7f\u3044\u65b9\u3092\u5177\u4f53\u7684\u306b\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-17\">groupby\u306b\u3088\u308b\u30c7\u30fc\u30bf\u306e\u96c6\u7d04<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"keiko_yellow\">groupby\u306f\u3001\u6307\u5b9a\u3057\u305f\u30ab\u30e9\u30e0\u306e\u5024\u306b\u57fa\u3065\u3044\u3066\u30c7\u30fc\u30bf\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3001\u5404\u30b0\u30eb\u30fc\u30d7\u306b\u5bfe\u3057\u3066\u96c6\u8a08\u95a2\u6570\u3092\u9069\u7528\u3059\u308b\u30e1\u30bd\u30c3\u30c9\u3067\u3059\u3002<\/span><br>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndf = pd.DataFrame({'key': ['A', 'B', 'C', 'A', 'B', 'C'],\n                   'data1': [1, 2, 3, 4, 5, 6],\n                   'data2': [10, 20, 30, 40, 50, 60]})\nprint(df)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">  key  data1  data2\n0   A      1     10\n1   B      2     20\n2   C      3     30\n3   A      4     40\n4   B      5     50\n5   C      6     60<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306b\u5bfe\u3057\u3066\u3001<code>key<\/code>\u30ab\u30e9\u30e0\u3067\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3001<code>data1<\/code>\u3068<code>data2<\/code>\u306e\u5408\u8a08\u3092\u6c42\u3081\u308b\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bgroupby\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(df.groupby('key').sum())<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">     data1  data2\nkey             \nA        5     50\nB        7     70\nC        9     90<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001<code>key<\/code>\u30ab\u30e9\u30e0\u306e\u5024\u3054\u3068\u306b<code>data1<\/code>\u3068<code>data2<\/code>\u306e\u5408\u8a08\u304c\u7b97\u51fa\u3055\u308c\u307e\u3057\u305f\u3002<br>groupby\u306b\u306f\u3001sum()\u4ee5\u5916\u306b\u3082mean()\u3001count()\u3001max()\u3001min()\u306a\u3069\u3001\u69d8\u3005\u306a\u96c6\u8a08\u95a2\u6570\u3092\u9069\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u307e\u305f\u3001groupby\u306e\u7d50\u679c\u306f\u3001DataFrameGroupBy\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u306a\u308a\u307e\u3059\u3002<br>\u3053\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u5bfe\u3057\u3066\u3001\u96c6\u8a08\u95a2\u6570\u3092\u8907\u6570\u56de\u9069\u7528\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">grouped = df.groupby('key')\nprint(grouped.sum())\nprint(grouped.mean())<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">     data1  data2\nkey             \nA        5     50\nB        7     70\nC        9     90\n     data1  data2\nkey             \nA      2.5   25.0\nB      3.5   35.0\nC      4.5   45.0<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u4e00\u5ea6groupby\u306e\u7d50\u679c\u3092\u5909\u6570\u306b\u683c\u7d0d\u3057\u3066\u304a\u3051\u3070\u3001\u305d\u306e\u5909\u6570\u306b\u5bfe\u3057\u3066\u8907\u6570\u306e\u96c6\u8a08\u95a2\u6570\u3092\u9069\u7528\u3067\u304d\u307e\u3059\u3002<br>\u3053\u308c\u306f\u3001\u540c\u3058\u30b0\u30eb\u30fc\u30d7\u5316\u306e\u6761\u4ef6\u3067\u8907\u6570\u306e\u96c6\u8a08\u3092\u884c\u3046\u5834\u5408\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-18\">pivot_table\u3067\u25cb\u25cb\u5225\u306e\u96c6\u8a08\u8868\u3092\u4f5c\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"keiko_yellow\">pivot_table\u306f\u3001\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u3092\u518d\u5f62\u6210\u3057\u3066\u3001\u6307\u5b9a\u3057\u305f\u884c\u3068\u5217\u3067\u30af\u30ed\u30b9\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3059\u308b\u95a2\u6570\u3067\u3059\u3002<\/span><br>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\nimport numpy as np\n\ndf = pd.DataFrame({'A': ['one', 'one', 'two', 'three'] * 3,\n                   'B': ['A', 'B', 'C'] * 4,\n                   'C': ['foo', 'foo', 'foo', 'bar', 'bar', 'bar'] * 2,\n                   'D': np.random.randn(12),\n                   'E': np.random.randn(12)})\nprint(df)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">        A  B    C         D         E\n0     one  A  foo  0.474654  0.407514\n1     one  B  foo  0.726539  0.151765\n2     two  C  foo -0.396534  0.047281\n3   three  A  bar  0.083069 -1.151999\n4     one  B  bar  1.253229  2.248631\n5     one  C  bar -0.658151  0.911478\n6     two  A  foo -1.930595  0.096299\n7   three  B  foo  1.296026 -0.787606\n8     one  C  foo -2.018439  0.849116\n9     one  A  bar  0.206940 -2.976317\n10    two  B  bar -0.624973  0.120199\n11  three  C  bar  1.880416 -0.208522<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u306b\u5bfe\u3057\u3066\u3001<code>A<\/code>\u3068<code>B<\/code>\u3092\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3068\u3057\u3001<code>C<\/code>\u3092\u5217\u3001<code>D<\/code>\u306e\u5e73\u5747\u5024\u3092\u5024\u3068\u3059\u308b\u30af\u30ed\u30b9\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bpivot_table\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(pd.pivot_table(df, values='D', index=['A', 'B'], columns=['C']))<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">C             bar       foo\nA     B                    \none   A  0.526307 -0.351517\n      B -0.646131  1.770274\n      C  0.029726  0.390142\nthree A  0.067735       NaN\n      B       NaN -1.102544\n      C  1.712608       NaN\ntwo   A       NaN  0.284748\n      B  2.211319       NaN\n      C       NaN -1.566213<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001<code>A<\/code>\u3068<code>B<\/code>\u306e\u7d44\u307f\u5408\u308f\u305b\u3054\u3068\u306b\u3001<code>C<\/code>\u306e\u5024\u306b\u5fdc\u3058\u3066<code>D<\/code>\u306e\u5e73\u5747\u5024\u304c\u7b97\u51fa\u3055\u308c\u305f\u96c6\u8a08\u8868\u304c\u4f5c\u6210\u3055\u308c\u307e\u3057\u305f\u3002<br><code>NaN<\/code>\u306f\u6b20\u640d\u5024\u3092\u8868\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">pivot_table\u306b\u306f\u3001\u96c6\u8a08\u95a2\u6570\u3084\u6b20\u640d\u5024\u306e\u6271\u3044\u3092\u6307\u5b9a\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u3082\u3042\u308a\u307e\u3059\u3002<br>\u4f8b\u3048\u3070\u3001\u6b20\u640d\u5024\u30920\u3067\u88dc\u5b8c\u3057\u3001\u96c6\u8a08\u95a2\u6570\u3092\u30e1\u30b8\u30a2\u30f3\u306b\u3059\u308b\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">print(pd.pivot_table(df, values='D', index=['A', 'B'], columns=['C'], aggfunc='median', fill_value=0))<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u51fa\u529b\u7d50\u679c\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">C             bar       foo\nA     B                    \none   A -0.434998  0.290534\n      B -0.817293 -1.483834\n      C  0.563883  0.099110\nthree A -1.562436  0.000000\n      B  0.000000 -0.271499\n      C -1.236549  0.000000\ntwo   A  0.000000  0.165393\n      B  0.514467  0.000000\n      C  0.000000 -0.975100<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001pivot_table\u306f\u96c6\u8a08\u8868\u306e\u4f5c\u6210\u3092\u67d4\u8edf\u306b\u30ab\u30b9\u30bf\u30de\u30a4\u30ba\u3067\u304d\u308b\u70b9\u304c\u7279\u5fb4\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u306e\u3088\u3046\u306b\u3001groupby\u3068pivot_table\u306f\u3001\u30c7\u30fc\u30bf\u306e\u5909\u5f62\u3068\u96c6\u7d04\u3092\u884c\u3046\u4e0a\u3067\u975e\u5e38\u306b\u5f37\u529b\u306a\u30c4\u30fc\u30eb\u3067\u3059\u3002<br>groupby\u306f\u3001\u5358\u4e00\u306e\u30ab\u30e9\u30e0\u3067\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3066\u5404\u30b0\u30eb\u30fc\u30d7\u306e\u7d71\u8a08\u91cf\u3092\u7b97\u51fa\u3059\u308b\u306e\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002<br>pivot_table\u306f\u3001\u8907\u6570\u306e\u30ab\u30e9\u30e0\u3092\u4f7f\u3063\u3066\u30af\u30ed\u30b9\u96c6\u8a08\u8868\u3092\u4f5c\u6210\u3059\u308b\u306e\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u5206\u6790\u3067\u306f\u3001\u751f\u306e\u30c7\u30fc\u30bf\u3092\u305d\u306e\u307e\u307e\u898b\u308b\u3060\u3051\u3067\u306f\u3001\u30c7\u30fc\u30bf\u306e\u6301\u3064\u610f\u5473\u3092\u5341\u5206\u306b\u5f15\u304d\u51fa\u305b\u307e\u305b\u3093\u3002<br>\u30c7\u30fc\u30bf\u3092\u9069\u5207\u306b\u5909\u5f62\u3057\u3001\u96c6\u7d04\u3059\u308b\u3053\u3068\u3067\u3001\u306f\u3058\u3081\u3066\u30c7\u30fc\u30bf\u304b\u3089\u306e\u77e5\u898b\u304c\u5f97\u3089\u308c\u308b\u306e\u3067\u3059\u3002<br>groupby\u3068pivot_table\u3092\u4f7f\u3044\u3053\u306a\u3059\u3053\u3068\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u30b9\u30ad\u30eb\u3092\u9ad8\u3081\u308b\u4e0a\u3067\u6b20\u304b\u305b\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u305c\u3072\u3001\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066groupby\u3068pivot_table\u3092\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<br>\u30c7\u30fc\u30bf\u3092\u8272\u3005\u306a\u89d2\u5ea6\u304b\u3089\u96c6\u8a08\u3057\u3001\u53ef\u8996\u5316\u3059\u308b\u3053\u3068\u3067\u3001\u65b0\u305f\u306a\u767a\u898b\u304c\u3042\u308b\u306f\u305a\u3067\u3059\u3002<br>\u6b21\u306e\u7ae0\u3067\u306f\u3001pandas\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b\u65b9\u6cd5\u3092\u898b\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-19\">pandas\u3067\u7c21\u5358\u30c7\u30fc\u30bf\u53ef\u8996\u5316 \u2013 \u30b0\u30e9\u30d5\u4f5c\u6210\u306e\u57fa\u672c<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u5206\u6790\u306b\u304a\u3044\u3066\u3001\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b\u3053\u3068\u306f\u975e\u5e38\u306b\u91cd\u8981\u3067\u3059\u3002<br>\u30b0\u30e9\u30d5\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u3092\u8996\u899a\u7684\u306b\u8868\u73fe\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u5206\u5e03\u3084\u50be\u5411\u3092\u76f4\u611f\u7684\u306b\u7406\u89e3\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br>\u3057\u304b\u3057\u3001\u30c7\u30fc\u30bf\u53ef\u8996\u5316\u306f\u6577\u5c45\u304c\u9ad8\u3044\u3068\u601d\u308f\u308c\u304c\u3061\u3067\u3059\u3002<br>\u5c02\u9580\u7684\u306a\u30c4\u30fc\u30eb\u3092\u4f7f\u3063\u305f\u308a\u3001\u9ad8\u5ea6\u306a\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u304c\u5fc5\u8981\u3060\u3063\u305f\u308a\u3068\u3001\u30cf\u30fc\u30c9\u30eb\u304c\u9ad8\u304f\u611f\u3058\u308b\u4eba\u3082\u591a\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u305d\u3093\u306a\u4e2d\u3001pandas\u3092\u4f7f\u3048\u3070\u3001\u7c21\u5358\u306b\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br>\u3053\u3053\u3067\u306f\u3001pandas\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u53ef\u8996\u5316\u306e\u57fa\u672c\u7684\u306a\u65b9\u6cd5\u3092\u898b\u3066\u3044\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-20\">\u5217\u306e\u5024\u3092\u30d7\u30ed\u30c3\u30c8\u3057\u3066\u5206\u5e03\u3092\u898b\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u5206\u6790\u3067\u306f\u3001\u307e\u305a\u30c7\u30fc\u30bf\u306e\u5206\u5e03\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u3002<br>\u30c7\u30fc\u30bf\u304c\u3069\u306e\u3088\u3046\u306a\u7bc4\u56f2\u306e\u5024\u3092\u53d6\u3063\u3066\u3044\u308b\u306e\u304b\u3001\u3069\u306e\u5024\u306b\u96c6\u4e2d\u3057\u3066\u3044\u308b\u306e\u304b\u3092\u628a\u63e1\u3059\u308b\u3053\u3068\u304c\u3001\u5206\u6790\u306e\u7b2c\u4e00\u6b69\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306a\u5206\u5e03\u306e\u78ba\u8a8d\u306b\u306f\u3001\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u304c\u9069\u3057\u3066\u3044\u307e\u3059\u3002<br>\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u306f\u3001\u30c7\u30fc\u30bf\u306e\u5024\u306e\u7bc4\u56f2\u3092\u5e7e\u3064\u304b\u306e\u533a\u9593\u306b\u5206\u5272\u3057\u3001\u5404\u533a\u9593\u306b\u8a72\u5f53\u3059\u308b\u30c7\u30fc\u30bf\u306e\u6570\u3092\u30d0\u30fc\u306e\u9ad8\u3055\u3067\u8868\u73fe\u3057\u305f\u30b0\u30e9\u30d5\u3067\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"keiko_yellow\">pandas\u3067\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001DataFrame.hist()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u307e\u3059\u3002<\/span><br>\u4ee5\u4e0b\u306f\u3001\u6b63\u898f\u5206\u5e03\u306b\u5f93\u3046\u4e71\u6570\u30921000\u500b\u751f\u6210\u3057\u3001\u305d\u306e\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3059\u308b\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-sgb-message\"><div class=\"memo sng-shadow-0\" style=\"border-radius:0px;background-color:#fff9e6;color:#ffb36b\"><div class=\"memo_ttl dfont\"><span class=\"sng-box-msg__icon\" style=\"background:#ffb36b\"><i class=\"fas fa-pencil-alt\"><\/i><\/span><div class=\"sng-box-msg__title\">\u6ce8\u610f<\/div><\/div><div class=\"sng-box-msg__contents\">\n<p class=\"wp-block-paragraph\">\u56f3\u793a\u306e\u305f\u3081\u306bmatplotlib\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\uff01<\/p>\n<\/div><\/div><\/div>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\nimport numpy as np\nimport matplotlib.pyplot as plt\n\n# \u30e9\u30f3\u30c0\u30e0\u30c7\u30fc\u30bf\u306e\u751f\u6210\ndf = pd.DataFrame({'A': np.random.randn(1000)})\n\n# \u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u306e\u4f5c\u6210\u3068\u8868\u793a\ndf.hist(bins=20, figsize=(8, 6))\nplt.show()<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u30b3\u30fc\u30c9\u3067\u306f\u30011000\u500b\u306e\u4e71\u6570\u3092\u751f\u6210\u3057\u3001DataFrame\u306e\u5217\u2019A\u2019\u306b\u683c\u7d0d\u3057\u3066\u3044\u307e\u3059\u3002<br>\u305d\u3057\u3066\u3001df.hist()\u3067\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<br>bins=20\u306f\u3001\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u306e\u533a\u9593\u306e\u6570\u309220\u306b\u8a2d\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"871\" src=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.46.58-1024x871.png\" alt=\"\" class=\"wp-image-578\" srcset=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.46.58-1024x871.png 1024w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.46.58-300x255.png 300w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.46.58-768x653.png 768w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.46.58-1536x1307.png 1536w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.46.58-940x800.png 940w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.46.58.png 1824w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001\u308f\u305a\u304b\u6570\u884c\u306e\u30b3\u30fc\u30c9\u3067\u3001\u30c7\u30fc\u30bf\u306e\u5206\u5e03\u3092\u8996\u899a\u7684\u306b\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-21\">2\u3064\u306e\u5217\u306e\u95a2\u4fc2\u3092\u53ef\u8996\u5316\u3059\u308b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306b\u30012\u3064\u306e\u5909\u6570\u306e\u95a2\u4fc2\u3092\u8abf\u3079\u308b\u305f\u3081\u306b\u3001\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<br>\u6563\u5e03\u56f3\u306f\u30012\u3064\u306e\u5909\u6570\u306e\u5024\u30922\u6b21\u5143\u5e73\u9762\u4e0a\u306b\u30d7\u30ed\u30c3\u30c8\u3057\u305f\u30b0\u30e9\u30d5\u3067\u3059\u3002<br>\u3053\u308c\u3092\u898b\u308b\u3053\u3068\u3067\u30012\u3064\u306e\u5909\u6570\u306e\u9593\u306b\u95a2\u4fc2\u304c\u3042\u308b\u304b\u3069\u3046\u304b\u3092\u8996\u899a\u7684\u306b\u5224\u65ad\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"keiko_yellow\">pandas\u3067\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3059\u308b\u306b\u306f\u3001DataFrame.plot.scatter()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u307e\u3059\u3002<\/span><br>\u4ee5\u4e0b\u306f\u30012\u3064\u306e\u6b63\u898f\u5206\u5e03\u306b\u5f93\u3046\u4e71\u6570\u30921000\u500b\u305a\u3064\u751f\u6210\u3057\u3001\u305d\u306e\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3059\u308b\u4f8b\u3067\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\nimport numpy as np\nimport matplotlib.pyplot as plt\n\n# \u30e9\u30f3\u30c0\u30e0\u30c7\u30fc\u30bf\u306e\u751f\u6210\ndf = pd.DataFrame({'A': np.random.randn(1000), 'B': np.random.randn(1000)})\n\n# \u6563\u5e03\u56f3\u306e\u4f5c\u6210\u3068\u8868\u793a\ndf.plot.scatter(x='A', y='B')\nplt.show()<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u30b3\u30fc\u30c9\u3067\u306f\u30012\u3064\u306e\u4e71\u6570\u5217\u3092\u751f\u6210\u3057\u3001DataFrame\u306e\u5217\u2019A\u2019\u3068\u2019B\u2019\u306b\u683c\u7d0d\u3057\u3066\u3044\u307e\u3059\u3002<br>\u305d\u3057\u3066\u3001df.plot.scatter(x=\u2019A\u2019, y=\u2019B\u2019)\u3067\u3001\u2019A\u2019\u3092\u6a2a\u8ef8\u3001\u2019B\u2019\u3092\u7e26\u8ef8\u3068\u3059\u308b\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u306e\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u6563\u5e03\u56f3\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"893\" src=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.48.29-1024x893.png\" alt=\"\" class=\"wp-image-580\" srcset=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.48.29-1024x893.png 1024w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.48.29-300x262.png 300w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.48.29-768x670.png 768w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.48.29-940x820.png 940w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2024-05-02-20.48.29.png 1504w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\"><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u3088\u3046\u306b\u3001pandas\u3092\u4f7f\u3048\u3070\u30012\u3064\u306e\u5909\u6570\u306e\u95a2\u4fc2\u3092\u624b\u8efd\u306b\u53ef\u8996\u5316\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u3001pandas\u3067\u306e\u30c7\u30fc\u30bf\u53ef\u8996\u5316\u306e\u57fa\u672c\u7684\u306a\u65b9\u6cd5\u3092\u898b\u3066\u304d\u307e\u3057\u305f\u3002<br>pandas\u306eplot()\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3048\u3070\u3001\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u3084\u6563\u5e03\u56f3\u306a\u3069\u306e\u30b0\u30e9\u30d5\u3092\u3001\u308f\u305a\u304b\u6570\u884c\u306e\u30b3\u30fc\u30c9\u3067\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002<br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u53ef\u8996\u5316\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306b\u6b20\u304b\u305b\u306a\u3044\u30b9\u30ad\u30eb\u3067\u3059\u3002<br>\u30b0\u30e9\u30d5\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u3092\u8996\u899a\u7684\u306b\u8868\u73fe\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u304b\u3089\u3088\u308a\u591a\u304f\u306e\u77e5\u898b\u3092\u5f15\u304d\u51fa\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<br>pandas\u306e\u30c7\u30fc\u30bf\u53ef\u8996\u5316\u6a5f\u80fd\u3092\u4f7f\u3044\u3053\u306a\u305b\u3070\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u5e45\u304c\u5927\u304d\u304f\u5e83\u304c\u308b\u306f\u305a\u3067\u3059\u3002<br>\u307e\u305a\u306f\u3001\u81ea\u5206\u306e\u30c7\u30fc\u30bf\u3092pandas\u3067\u53ef\u8996\u5316\u3057\u3066\u307f\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306e\u7ae0\u3067\u306f\u3001\u3053\u308c\u307e\u3067\u5b66\u3093\u3060pandas\u306e\u6a5f\u80fd\u3092\u4f7f\u3063\u3066\u3001\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u5206\u6790\u306b\u30c1\u30e3\u30ec\u30f3\u30b8\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-22\">pandas\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u5206\u6790\u306e\u5b9f\u8df5 \u2013 \u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb3\u9078<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u3053\u307e\u3067\u3001pandas\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3092\u5b66\u3093\u3067\u304d\u307e\u3057\u305f\u3002<br>\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f\u3001\u52a0\u5de5\u3001\u96c6\u8a08\u3001\u53ef\u8996\u5316\u306a\u3069\u3001\u4e00\u901a\u308a\u306e\u64cd\u4f5c\u65b9\u6cd5\u3092\u8eab\u306b\u3064\u3051\u305f\u3053\u3068\u3068\u601d\u3044\u307e\u3059\u3002<br>\u3057\u304b\u3057\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u30b9\u30ad\u30eb\u3092\u672c\u5f53\u306b\u8eab\u306b\u3064\u3051\u308b\u305f\u3081\u306b\u306f\u3001\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u305f\u5206\u6790\u306e\u5b9f\u8df5\u304c\u6b20\u304b\u305b\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u305d\u3053\u3067\u3001\u3053\u306e\u7ae0\u3067\u306f\u3001pandas\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u5206\u6790\u306e\u5b9f\u8df5\u7684\u306a\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u30923\u3064\u7d39\u4ecb\u3057\u307e\u3059\u3002<br>\u3053\u308c\u3089\u306e\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3092\u901a\u3058\u3066\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u4e00\u9023\u306e\u6d41\u308c\u3092\u4f53\u9a13\u3057\u3001pandas\u306e\u4f7f\u3044\u65b9\u3092\u3088\u308a\u6df1\u304f\u7406\u89e3\u3059\u308b\u3053\u3068\u3092\u76ee\u6307\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-23\">\u58f2\u4e0a\u30c7\u30fc\u30bf\u304b\u3089\u5546\u54c1\u5225\u30fb\u6708\u5225\u306e\u58f2\u4e0a\u63a8\u79fb\u3092\u5206\u6790<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u521d\u306e\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3067\u306f\u3001\u58f2\u4e0a\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u3001\u5546\u54c1\u5225\u30fb\u6708\u5225\u306e\u58f2\u4e0a\u63a8\u79fb\u3092\u5206\u6790\u3057\u307e\u3059\u3002<br>\u3053\u306e\u3088\u3046\u306a\u5206\u6790\u306f\u3001\u5404\u5546\u54c1\u306e\u58f2\u4e0a\u50be\u5411\u3092\u628a\u63e1\u3057\u3001\u9700\u8981\u306e\u5909\u52d5\u3092\u78ba\u8a8d\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u7528\u3059\u308b\u30c7\u30fc\u30bf\u306f\u3001\u5546\u54c1ID\u3001\u58f2\u4e0a\u65e5\u4ed8\u3001\u58f2\u4e0a\u91d1\u984d\u3092\u542b\u3080\u58f2\u4e0a\u30c7\u30fc\u30bf\u3067\u3059\u3002<br>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u3092\u30b5\u30f3\u30d7\u30eb\u3068\u3057\u3066\u7528\u610f\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndata = {'\u5546\u54c1ID': ['A', 'B', 'C', 'A', 'B', 'C', 'A', 'B', 'C'],\n        '\u58f2\u4e0a\u65e5\u4ed8': ['2023-01-01', '2023-01-02', '2023-01-03', '2023-02-01', '2023-02-02', '2023-02-03', '2023-03-01', '2023-03-02', '2023-03-03'],\n        '\u58f2\u4e0a\u91d1\u984d': [100, 200, 300, 400, 500, 600, 700, 800, 900]}\n\ndf = pd.DataFrame(data)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u624b\u9806\u3067\u5206\u6790\u3092\u9032\u3081\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u65e5\u4ed8\u304b\u3089\u6708\u3092\u62bd\u51fa\u3059\u308b<\/li>\n\n\n\n<li>\u5546\u54c1\u5225\u30fb\u6708\u5225\u306b\u58f2\u4e0a\u3092\u96c6\u8a08\u3059\u308b<\/li>\n\n\n\n<li>\u7d50\u679c\u3092\u53ef\u8996\u5316\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u307e\u305a\u3001\u58f2\u4e0a\u65e5\u4ed8\u304b\u3089\u6708\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<br>\u3053\u308c\u306b\u306f\u3001pd.to_datetime()\u3067\u65e5\u4ed8\u6587\u5b57\u5217\u3092\u65e5\u4ed8\u578b\u306b\u5909\u63db\u3057\u3001dt.strftime()\u3067\u6708\u90e8\u5206\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df['\u6708'] = pd.to_datetime(df['\u58f2\u4e0a\u65e5\u4ed8']).dt.strftime('%Y-%m')<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306b\u3001groupby\u3092\u4f7f\u3063\u3066\u5546\u54c1\u5225\u30fb\u6708\u5225\u306b\u58f2\u4e0a\u3092\u96c6\u8a08\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df_grouped = df.groupby(['\u5546\u54c1ID', '\u6708']).sum().reset_index()<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u5f8c\u306b\u3001pivot\u3092\u4f7f\u3063\u3066\u96c6\u8a08\u7d50\u679c\u3092\u5546\u54c1ID\u00d7\u6708\u306e\u5f62\u306b\u5909\u5f62\u3057\u3001\u68d2\u30b0\u30e9\u30d5\u3067\u53ef\u8996\u5316\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df_pivot = df_grouped.pivot(index='\u6708', columns='\u5546\u54c1ID', values='\u58f2\u4e0a\u91d1\u984d')\ndf_pivot.plot.bar()<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u304c\u3001\u58f2\u4e0a\u30c7\u30fc\u30bf\u304b\u3089\u5546\u54c1\u5225\u30fb\u6708\u5225\u306e\u58f2\u4e0a\u63a8\u79fb\u3092\u5206\u6790\u3059\u308b\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002<br>pandas\u306egroupby\u3068pivot\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u96c6\u8a08\u3068\u53ef\u8996\u5316\u3092\u7c21\u6f54\u306b\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-24\">\u30a2\u30f3\u30b1\u30fc\u30c8\u7d50\u679c\u304b\u3089\u30e6\u30fc\u30b6\u30fc\u3092\u5c5e\u6027\u5225\u306b\u30bb\u30b0\u30e1\u30f3\u30c8<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306e\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3067\u306f\u3001\u30a2\u30f3\u30b1\u30fc\u30c8\u7d50\u679c\u3092\u4f7f\u3063\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u3092\u5c5e\u6027\u5225\u306b\u30bb\u30b0\u30e1\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u3057\u307e\u3059\u3002<br>\u3053\u306e\u3088\u3046\u306a\u5206\u6790\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u306e\u5c5e\u6027\u306b\u3088\u3063\u3066\u30cb\u30fc\u30ba\u3084\u55dc\u597d\u306e\u9055\u3044\u3092\u628a\u63e1\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u7528\u3059\u308b\u30c7\u30fc\u30bf\u306f\u3001\u5e74\u9f62\u3001\u6027\u5225\u3001\u8077\u696d\u3001\u6e80\u8db3\u5ea6\u306a\u3069\u3092\u542b\u3080\u30a2\u30f3\u30b1\u30fc\u30c8\u7d50\u679c\u30c7\u30fc\u30bf\u3067\u3059\u3002<br>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u3092\u30b5\u30f3\u30d7\u30eb\u3068\u3057\u3066\u7528\u610f\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndata = {'\u5e74\u9f62': ['10\u4ee3', '20\u4ee3', '30\u4ee3', '40\u4ee3', '50\u4ee3', '60\u4ee3', '10\u4ee3', '20\u4ee3', '30\u4ee3'],\n        '\u6027\u5225': ['\u7537\u6027', '\u5973\u6027', '\u7537\u6027', '\u5973\u6027', '\u7537\u6027', '\u5973\u6027', '\u7537\u6027', '\u5973\u6027', '\u7537\u6027'], \n        '\u6e80\u8db3\u5ea6': [4, 5, 3, 4, 2, 3, 5, 4, 3]}\n\ndf = pd.DataFrame(data)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u624b\u9806\u3067\u5206\u6790\u3092\u9032\u3081\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5c5e\u6027\u306e\u5206\u5e03\u3092\u53ef\u8996\u5316\u3059\u308b<\/li>\n\n\n\n<li>\u5c5e\u6027\u306e\u7d44\u307f\u5408\u308f\u305b\u3054\u3068\u306b\u6e80\u8db3\u5ea6\u3092\u96c6\u8a08\u3059\u308b<\/li>\n\n\n\n<li>\u7d50\u679c\u3092\u53ef\u8996\u5316\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u307e\u305a\u3001\u5e74\u9f62\u3068\u6027\u5225\u306e\u5206\u5e03\u3092\u68d2\u30b0\u30e9\u30d5\u3067\u53ef\u8996\u5316\u3057\u307e\u3059\u3002<br>\u3053\u308c\u306b\u306f\u3001pandas\u306evalue_counts()\u3068plot.bar()\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df['\u5e74\u9f62'].value_counts().plot.bar()\ndf['\u6027\u5225'].value_counts().plot.bar()<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306b\u3001\u5e74\u9f62\u3068\u6027\u5225\u306e\u7d44\u307f\u5408\u308f\u305b\u3054\u3068\u306b\u6e80\u8db3\u5ea6\u306e\u5e73\u5747\u3092\u96c6\u8a08\u3057\u307e\u3059\u3002<br>\u3053\u308c\u306b\u306f\u3001groupby\u3068pivot_table\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">df_pivot = pd.pivot_table(df, values='\u6e80\u8db3\u5ea6', index='\u5e74\u9f62', columns='\u6027\u5225', aggfunc='mean')<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u5f8c\u306b\u3001\u96c6\u8a08\u7d50\u679c\u3092\u30d2\u30fc\u30c8\u30de\u30c3\u30d7\u3067\u53ef\u8996\u5316\u3057\u307e\u3059\u3002<br>\u3053\u308c\u306b\u306f\u3001seaborn\u306eheatmap()\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import seaborn as sns\n\nsns.heatmap(df_pivot, cmap='YlGnBu', annot=True)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u304c\u3001\u30a2\u30f3\u30b1\u30fc\u30c8\u7d50\u679c\u304b\u3089\u30e6\u30fc\u30b6\u30fc\u3092\u5c5e\u6027\u5225\u306b\u30bb\u30b0\u30e1\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u3059\u308b\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002<br>pandas\u306egroupby\u3068pivot_table\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001\u5c5e\u6027\u306e\u7d44\u307f\u5408\u308f\u305b\u3054\u3068\u306e\u96c6\u8a08\u3092\u7c21\u6f54\u306b\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"i-25\">\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u304b\u3089\u9700\u8981\u4e88\u6e2c\u30e2\u30c7\u30eb\u3092\u69cb\u7bc9<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u5f8c\u306e\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3067\u306f\u3001\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u3001\u9700\u8981\u4e88\u6e2c\u30e2\u30c7\u30eb\u3092\u69cb\u7bc9\u3057\u307e\u3059\u3002<br>\u3053\u306e\u3088\u3046\u306a\u5206\u6790\u306f\u3001\u904e\u53bb\u306e\u8ca9\u58f2\u5b9f\u7e3e\u304b\u3089\u5c06\u6765\u306e\u9700\u8981\u3092\u4e88\u6e2c\u3057\u3001\u9069\u5207\u306a\u5728\u5eab\u7ba1\u7406\u3092\u884c\u3046\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u7528\u3059\u308b\u30c7\u30fc\u30bf\u306f\u3001\u65e5\u4ed8\u3001\u5546\u54c1ID\u3001\u8ca9\u58f2\u6570\u91cf\u3092\u542b\u3080\u8ca9\u58f2\u5b9f\u7e3e\u30c7\u30fc\u30bf\u3067\u3059\u3002<br>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u3092\u30b5\u30f3\u30d7\u30eb\u3068\u3057\u3066\u7528\u610f\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pandas as pd\n\ndata = {'\u65e5\u4ed8': pd.date_range(start='2022-01-01', end='2023-12-31', freq='D'),\n        '\u5546\u54c1ID': ['A'] * 365 * 2,\n        '\u8ca9\u58f2\u6570\u91cf': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10] * 73}\n\ndf = pd.DataFrame(data)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u30c7\u30fc\u30bf\u306b\u5bfe\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u624b\u9806\u3067\u5206\u6790\u3092\u9032\u3081\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u65e5\u4ed8\u304b\u3089\u30c8\u30ec\u30f3\u30c9\u3068\u5b63\u7bc0\u6027\u3092\u62bd\u51fa\u3059\u308b<\/li>\n\n\n\n<li>\u9700\u8981\u4e88\u6e2c\u30e2\u30c7\u30eb\u3092\u69cb\u7bc9\u3059\u308b<\/li>\n\n\n\n<li>\u30e2\u30c7\u30eb\u306e\u7cbe\u5ea6\u3092\u8a55\u4fa1\u3059\u308b<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\u307e\u305a\u3001\u65e5\u4ed8\u304b\u3089\u30c8\u30ec\u30f3\u30c9\u3068\u5b63\u7bc0\u6027\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<br>\u3053\u308c\u306b\u306f\u3001pandas\u306eto_datetime()\u3068dt.dayofyear\u3001statsmodels\u306eseasonal_decompose()\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import statsmodels.api as sm\n\ndf['\u65e5\u4ed8'] = pd.to_datetime(df['\u65e5\u4ed8'])\ndf['\u30c8\u30ec\u30f3\u30c9'] = df.index\ndf['\u5b63\u7bc0\u6027'] = df['\u65e5\u4ed8'].dt.dayofyear\n\ndecomposition = sm.tsa.seasonal_decompose(df['\u8ca9\u58f2\u6570\u91cf'], model='additive', period=365)\ndf['\u30c8\u30ec\u30f3\u30c9'] = decomposition.trend\ndf['\u5b63\u7bc0\u6027'] = decomposition.seasonal<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b21\u306b\u3001\u30c8\u30ec\u30f3\u30c9\u3068\u5b63\u7bc0\u6027\u3092\u7279\u5fb4\u91cf\u3068\u3057\u3066\u3001\u9700\u8981\u4e88\u6e2c\u30e2\u30c7\u30eb\u3092\u69cb\u7bc9\u3057\u307e\u3059\u3002<br>\u3053\u3053\u3067\u306f\u3001\u30e9\u30f3\u30c0\u30e0\u30d5\u30a9\u30ec\u30b9\u30c8\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">from sklearn.ensemble import RandomForestRegressor\nfrom sklearn.model_selection import train_test_split\n\nX = df[['\u30c8\u30ec\u30f3\u30c9', '\u5b63\u7bc0\u6027']]\ny = df['\u8ca9\u58f2\u6570\u91cf']\n\nX_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=42)\n\nmodel = RandomForestRegressor(n_estimators=100, random_state=42)\nmodel.fit(X_train, y_train)<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u5f8c\u306b\u3001\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u30e2\u30c7\u30eb\u306e\u7cbe\u5ea6\u3092\u8a55\u4fa1\u3057\u307e\u3059\u3002<br>\u3053\u308c\u306b\u306f\u3001sklearn.metrics \u306emean_absolute_error()\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">from sklearn.metrics import mean_absolute_error\n\ny_pred = model.predict(X_test)\nmae = mean_absolute_error(y_test, y_pred)\nprint(f'MAE: {mae:.2f}')<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u304c\u3001\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u304b\u3089\u9700\u8981\u4e88\u6e2c\u30e2\u30c7\u30eb\u3092\u69cb\u7bc9\u3059\u308b\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002<br>pandas\u3068scikit-learn\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u306e\u7279\u5fb4\u91cf\u30a8\u30f3\u30b8\u30cb\u30a2\u30ea\u30f3\u30b0\u3068\u6a5f\u68b0\u5b66\u7fd2\u30e2\u30c7\u30eb\u306e\u69cb\u7bc9\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<div class=\"wp-block-sgb-message\"><div class=\"memo sng-shadow-0\" style=\"border-radius:0px;background-color:#fff9e6;color:#ffb36b\"><div class=\"memo_ttl dfont\"><span class=\"sng-box-msg__icon\" style=\"background:#ffb36b\"><i class=\"fas fa-pencil-alt\"><\/i><\/span><div class=\"sng-box-msg__title\">\u8b66\u544a<\/div><\/div><div class=\"sng-box-msg__contents\">\n<p class=\"wp-block-paragraph\">\u3053\u3053\u3067\u306fpandas\u306e\u30b3\u30fc\u30c9\u4f8b\u3092\u793a\u3059\u305f\u3081\u306b\u3081\u3061\u3083\u304f\u3061\u3083\u306a\u5206\u6790\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u3002\u5b9f\u969b\u306e\u5206\u6790\u306e\u73fe\u5834\u3067\u306f\u76ee\u7684\u3084\u5fc5\u8981\u306b\u5fdc\u3058\u305f\u5206\u6790\u624b\u6cd5\u3092\u7528\u3044\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<\/div><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u3044\u304b\u304c\u3067\u3057\u305f\u304b\u3002<br>\u3053\u308c\u3089\u306e\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3092\u901a\u3058\u3066\u3001pandas\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u5206\u6790\u306e\u4e00\u9023\u306e\u6d41\u308c\u3092\u4f53\u9a13\u3057\u3066\u3044\u305f\u3060\u3051\u305f\u304b\u3068\u601d\u3044\u307e\u3059\u3002<br>\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u5206\u6790\u3067\u306f\u3001\u30c7\u30fc\u30bf\u306e\u7406\u89e3\u3001\u524d\u51e6\u7406\u3001\u96c6\u8a08\u3001\u53ef\u8996\u5316\u3001\u30e2\u30c7\u30ea\u30f3\u30b0\u306a\u3069\u3001\u69d8\u3005\u306a\u30d5\u30a7\u30fc\u30ba\u304c\u3042\u308a\u307e\u3059\u3002<br>\u305d\u3057\u3066\u3001\u305d\u308c\u305e\u308c\u306e\u30d5\u30a7\u30fc\u30ba\u3067pandas\u306e\u6a5f\u80fd\u304c\u6d3b\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30c7\u30fc\u30bf\u5206\u6790\u306e\u30b9\u30ad\u30eb\u3092\u8eab\u306b\u3064\u3051\u308b\u306b\u306f\u3001\u3053\u306e\u3088\u3046\u306a\u30b3\u30fc\u30c9\u30b5\u30f3\u30d7\u30eb\u3092\u81ea\u5206\u3067\u5b9f\u884c\u3057\u3066\u307f\u308b\u306e\u304c\u4e00\u756a\u3067\u3059\u3002<br>\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3092\u52d5\u304b\u3059\u3060\u3051\u3067\u306a\u304f\u3001\u30c7\u30fc\u30bf\u3092\u5909\u3048\u3066\u307f\u305f\u308a\u3001\u5225\u306e\u5206\u6790\u3092\u8a66\u3057\u3066\u307f\u305f\u308a\u3068\u3001\u3044\u308d\u3044\u308d\u5b9f\u9a13\u3057\u3066\u307f\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span class=\"keiko_yellow\">pandas\u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3092\u884c\u3046\u4e0a\u3067\u6b20\u304b\u305b\u306a\u3044\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/span><br>\u305c\u3072\u3001pandas\u3092\u4f7f\u3044\u3053\u306a\u3057\u3066\u3001\u30c7\u30fc\u30bf\u304b\u3089\u4fa1\u5024\u3042\u308b\u77e5\u898b\u3092\u5f15\u304d\u51fa\u305b\u308b\u30c7\u30fc\u30bf\u30a2\u30ca\u30ea\u30b9\u30c8\u3092\u76ee\u6307\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-26\">\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/h2>\n\n\n\n<div class=\"wp-block-sgb-sanko\"><a href=\"https:\/\/pandas.pydata.org\/docs\/\" class=\"sgb-e-link sgb-e-link--vertical sgb-e-link--left\" target=\"_blank\" rel=\"noopener noreferrer\"><div class=\"sgb-e-link__text\"><span class=\"sgb-e-link__catchy\">\u53c2\u8003<\/span><div class=\"sgb-e-link__title\">pandas documentation \u2014 pandas 2.2.2 documentation<\/div><div class=\"sgb-e-link__sitename\"><\/div><\/div><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"i-27\">\u95a2\u9023\u8a18\u4e8b<\/h2>\n\n\n<a class=\"linkto table\" href=\"https:\/\/chocottopro.com\/?p=865\"> <span class=\"tbcell tbimg\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"160\" src=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/06\/pandas-loc-160x160.jpg\" class=\"attachment-thumb-160 size-thumb-160 wp-post-image\" alt=\"\" srcset=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/06\/pandas-loc-160x160.jpg 160w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/06\/pandas-loc-150x150.jpg 150w\" sizes=\"auto, (max-width: 160px) 100vw, 160px\"><\/span> <span class=\"tbcell tbtext\"> <time class=\"pubdate sng-link-time dfont\" itemprop=\"datePublished\" datetime=\"2024-06-05\">2024\u5e746\u67085\u65e5<\/time> pandas\u306eloc\u30e1\u30bd\u30c3\u30c9\u5fb9\u5e95\u89e3\u8aac\uff01\u57fa\u672c\u304b\u3089\u5fdc\u7528\u307e\u3067\u306e\u4f7f\u3044\u65b9\u3092\u30de\u30b9\u30bf\u30fc\u3057\u3088\u3046 <\/span> <\/a>\n\n<a class=\"linkto table\" href=\"https:\/\/chocottopro.com\/?p=861\"> <span class=\"tbcell tbimg\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"160\" src=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/06\/pandas-drop-160x160.jpg\" class=\"attachment-thumb-160 size-thumb-160 wp-post-image\" alt=\"\" srcset=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/06\/pandas-drop-160x160.jpg 160w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/06\/pandas-drop-150x150.jpg 150w\" sizes=\"auto, (max-width: 160px) 100vw, 160px\"><\/span> <span class=\"tbcell tbtext\"> <time class=\"pubdate sng-link-time dfont\" itemprop=\"datePublished\" datetime=\"2024-06-05\">2024\u5e746\u67085\u65e5<\/time> \u3010\u5b8c\u5168\u7248\u3011pandas\u306edrop\u30e1\u30bd\u30c3\u30c9\u3092\u6975\u3081\u308b\uff01\u4f7f\u3044\u65b9\u304b\u3089\u5fdc\u7528\u307e\u30677\u3064\u306e\u30c6\u30af\u30cb\u30c3\u30af <\/span> <\/a>\n\n<a class=\"linkto table\" href=\"https:\/\/chocottopro.com\/?p=809\"> <span class=\"tbcell tbimg\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"160\" src=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-groupby-160x160.jpg\" class=\"attachment-thumb-160 size-thumb-160 wp-post-image\" alt=\"\" srcset=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-groupby-160x160.jpg 160w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-groupby-150x150.jpg 150w\" sizes=\"auto, (max-width: 160px) 100vw, 160px\"><\/span> <span class=\"tbcell tbtext\"> <time class=\"pubdate sng-link-time dfont\" itemprop=\"datePublished\" datetime=\"2024-05-26\">2024\u5e745\u670826\u65e5<\/time> \u3010\u56f3\u89e3\u3011pandas\u306egroupby\u3092\u4f7f\u3044\u3053\u306a\u3059\uff01\u96c6\u8a08\u30fb\u8981\u7d04\u306e\u30b3\u30c4\u304b\u3089\u5fdc\u7528\u30c6\u30af\u30cb\u30c3\u30af\u307e\u3067\u5b8c\u5168\u7db2\u7f85 <\/span> <\/a>\n\n<a class=\"linkto table\" href=\"https:\/\/chocottopro.com\/?p=807\"> <span class=\"tbcell tbimg\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"160\" src=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-concat-160x160.jpg\" class=\"attachment-thumb-160 size-thumb-160 wp-post-image\" alt=\"\" srcset=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-concat-160x160.jpg 160w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-concat-150x150.jpg 150w\" sizes=\"auto, (max-width: 160px) 100vw, 160px\"><\/span> <span class=\"tbcell tbtext\"> <time class=\"pubdate sng-link-time dfont\" itemprop=\"datePublished\" datetime=\"2024-05-26\">2024\u5e745\u670826\u65e5<\/time> \u3010\u5b8c\u5168\u7248\u3011\u56f3\u89e3\u3068\u30b3\u30fc\u30c9\u4f8b\u3067\u5b66\u3076pandas concat\u306e\u4f7f\u3044\u65b9\uff01\u30c7\u30fc\u30bf\u7d50\u5408\u3092\u52b9\u7387\u5316\u3059\u308b\u30c6\u30af\u30cb\u30c3\u30af5\u9078 <\/span> <\/a>\n\n<a class=\"linkto table\" href=\"https:\/\/chocottopro.com\/?p=799\"> <span class=\"tbcell tbimg\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"160\" src=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-read_csv-160x160.jpg\" class=\"attachment-thumb-160 size-thumb-160 wp-post-image\" alt=\"\" srcset=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-read_csv-160x160.jpg 160w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-read_csv-150x150.jpg 150w\" sizes=\"auto, (max-width: 160px) 100vw, 160px\"><\/span> <span class=\"tbcell tbtext\"> <time class=\"pubdate sng-link-time dfont\" itemprop=\"datePublished\" datetime=\"2024-05-26\">2024\u5e745\u670826\u65e5<\/time> \u3010\u5b8c\u5168\u89e3\u8aac\u3011pandas read_csv\u306e\u4f7f\u3044\u65b9\u30de\u30b9\u30bf\u30fc\uff0110\u306e\u5b9f\u8df5\u7684\u30c6\u30af\u30cb\u30c3\u30af\u3067\u30c7\u30fc\u30bf\u5206\u6790\u3092\u52b9\u7387\u5316 <\/span> <\/a>\n\n<a class=\"linkto table\" href=\"https:\/\/chocottopro.com\/?p=793\"> <span class=\"tbcell tbimg\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"160\" src=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-merge-160x160.jpg\" class=\"attachment-thumb-160 size-thumb-160 wp-post-image\" alt=\"\" srcset=\"https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-merge-160x160.jpg 160w, https:\/\/chocottopro.com\/wp-content\/uploads\/2024\/05\/pandas-merge-150x150.jpg 150w\" sizes=\"auto, (max-width: 160px) 100vw, 160px\"><\/span> <span class=\"tbcell tbtext\"> <time class=\"pubdate sng-link-time dfont\" itemprop=\"datePublished\" datetime=\"2024-05-19\">2024\u5e745\u670819\u65e5<\/time> \u3010pandas\u5fb9\u5e95\u89e3\u8aac\u3011merge\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u30927\u3064\u306e\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u3067\u5b8c\u5168\u30de\u30b9\u30bf\u30fc\uff01 <\/span> <\/a>","protected":false},"excerpt":{"rendered":"<p>\u30c7\u30fc\u30bf\u5206\u6790\u306b\u6b20\u304b\u305b\u306a\u3044Python\u30e9\u30a4\u30d6\u30e9\u30ea\u300cpandas\u300d\u3002\u591a\u6b21\u5143\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u76f4\u611f\u7684\u306b\u884c\u3048\u308b\u30d1\u30ef\u30d5\u30eb\u306a\u30c4\u30fc\u30eb\u3067\u3059\u304c\u3001\u521d\u5fc3\u8005\u306b\u3068\u3063\u3066\u306f\u30cf\u30fc\u30c9\u30eb\u304c\u9ad8\u304f\u611f\u3058\u3089\u308c\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002\u3057\u304b\u3057\u3001pandas\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u3092\u30de\u30b9\u30bf &#8230; <\/p>\n","protected":false},"author":1,"featured_media":581,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-576","post","type-post","status-publish","format-standard","has-post-thumbnail","category-python"],"_links":{"self":[{"href":"https:\/\/chocottopro.com\/index.php?rest_route=\/wp\/v2\/posts\/576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chocottopro.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chocottopro.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chocottopro.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chocottopro.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=576"}],"version-history":[{"count":13,"href":"https:\/\/chocottopro.com\/index.php?rest_route=\/wp\/v2\/posts\/576\/revisions"}],"predecessor-version":[{"id":894,"href":"https:\/\/chocottopro.com\/index.php?rest_route=\/wp\/v2\/posts\/576\/revisions\/894"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chocottopro.com\/index.php?rest_route=\/wp\/v2\/media\/581"}],"wp:attachment":[{"href":"https:\/\/chocottopro.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chocottopro.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chocottopro.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}