{"id":2817,"date":"2019-10-29T14:45:50","date_gmt":"2019-10-29T05:45:50","guid":{"rendered":"https:\/\/www.dogrow.net\/python\/?p=2817"},"modified":"2019-10-29T15:22:34","modified_gmt":"2019-10-29T06:22:34","slug":"blog110","status":"publish","type":"post","link":"https:\/\/www.dogrow.net\/python\/blog110\/","title":{"rendered":"(110) pandas\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\uff1a\u4e8c\u6b21\u5143\u30c7\u30fc\u30bf\u3092\u6271\u3046"},"content":{"rendered":"

1. \u3084\u308a\u305f\u3044\u3053\u3068<\/h1>\n

pandas<\/span> \u306e DataFrame<\/span> \u578b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u308a\u3001\u4e8c\u6b21\u5143\u30c7\u30fc\u30bf\u3092\u6271\u3044\u305f\u3044\u3002<\/p>\n

2. \u3084\u3063\u3066\u307f\u308b<\/h1>\n

\u307e\u305a\u306f Python\u3092\u8d77\u52d5\u3057\u3066\u304a\u304f\u3002<\/p>\n

\r\n$ python\r\nPython 3.6.2 |Anaconda custom (64-bit)| (default, Jul 20 2017, 13:51:32)\r\n[GCC 4.4.7 20120313 (Red Hat 4.4.7-1)] on linux\r\nType \"help\", \"copyright\", \"credits\" or \"license\" for more information.\r\n>>>\r\n<\/pre>\n
(1) \u7c21\u5358\u306a\u4e8c\u6b21\u5143\u30c7\u30fc\u30bf\u3092\u6271\u3046\u3002<\/h3>\n
pandas.DataFrame<\/span> \u3067\u306f\u3001\u4e8c\u6b21\u5143\u30c7\u30fc\u30bf\u3092\u4f5c\u308c\u308b\u3002<\/p>\n
\r\n>>> import pandas as pd            # pandas\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u8aad\u307f\u8fbc\u3080\u3002<\/span>\r\n>>>\r\n>>> a = [[1,3,5,7,9,8,6],[20,50,30,40,70,60,90]]  # \u30ea\u30b9\u30c8\u578b\u306e\u914d\u5217\u3092\u4f5c\u308b\u3002<\/span>\r\n>>> a\r\n[[1, 3, 5, 7, 9, 8, 6], [20, 50, 30, 40, 70, 60, 90]]\r\n>>>\r\n>>> d = pd.DataFrame(a)                           # pandas.DataFrame\u578b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u308a\u3001\u5909\u6570 d\u3068\u3059\u308b\u3002<\/span>\r\n>>> d\r\n    0   1   2   3   4   5   6\r\n0   1   3   5   7   9   8   6\r\n1  20  50  30  40  70  60  90\r\n<\/pre>\n
\u751f\u6210\u3055\u308c\u305f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30c7\u30fc\u30bf\u578b\u3092\u898b\u3066\u307f\u308b\u3002<\/p>\n
\r\n>>> type(d)\r\n<class 'pandas.core.frame.DataFrame'>\r\n<\/pre>\n
\u30c7\u30fc\u30bf\u306e\u500b\u6570\u3092\u78ba\u8a8d\u3059\u308b\u3002
\n\u884c\u65b9\u5411\u306e\u914d\u5217\u3078\u306e\u30a2\u30af\u30bb\u30b9\u306f loc<\/span> \u3092\u4f7f\u7528\u3059\u308b\u3002<\/p>\n
\r\n>>> len(d)\r\n2\r\n>>> len(d[0])\r\n2\r\n>>> len(d.loc<\/span>[0])\r\n7\r\n<\/pre>\n
\u5404\u8981\u7d20\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3002
\n\u884c\u65b9\u5411\u306e\u914d\u5217\u3078\u306e\u30a2\u30af\u30bb\u30b9\u306f loc<\/span> \u3092\u4f7f\u7528\u3059\u308b\u3002<\/p>\n
\r\n>>> d[0]\r\n0     1\r\n1    20\r\nName: 0, dtype: int64\r\n>>> d[6]\r\n0     6\r\n1    90\r\nName: 6, dtype: int64\r\n>>>\r\n>>> d.loc<\/span>[0]\r\n0    1\r\n1    3\r\n2    5\r\n3    7\r\n4    9\r\n5    8\r\n6    6\r\nName: 0, dtype: int64\r\n>>> d.loc<\/span>[1]\r\n0    20\r\n1    50\r\n2    30\r\n3    40\r\n4    70\r\n5    60\r\n6    90\r\nName: 1, dtype: int64\r\n<\/pre>\n
\u3053\u308c\u3089\u306e\u66f8\u304d\u65b9\u3067\u53d6\u5f97\u3067\u304d\u308b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f Series\u578b\u3060\u3002<\/p>\n
\r\n>>> type(d)\r\n<class 'pandas.core.frame.DataFrame<\/span>'>\r\n>>> type(d[0])\r\n<class 'pandas.core.series.Series<\/span>'>\r\n>>> type(d.loc[0])\r\n<class 'pandas.core.series.Series<\/span>'>\r\n<\/pre>\n
(2) \u5217\u540d\u3092\u6307\u5b9a\u3057\u3066\u30c7\u30fc\u30bf\u3092\u4f5c\u308b\u3002<\/h3>\n
\u6587\u5b57\u5217\u30ea\u30b9\u30c8\u3092\u4f5c\u308a\u3001\u3053\u308c\u3092 DataFrame\u4f5c\u6210\u6642\u306b columns<\/span> \u3067\u6307\u5b9a\u3059\u308b\u3002<\/p>\n
\r\n>>> a = [[1,3,5,7,9,8,6],[20,50,30,40,70,60,90]]\r\n>>> b = ['z','c','V','W','u','az','Ko']\r\n>>> d = pd.DataFrame(a, columns<\/span>=b)\r\n>>> d\r\n    z   c   V   W   u  az  Ko\r\n0   1   3   5   7   9   8   6\r\n1  20  50  30  40  70  60  90\r\n<\/pre>\n
\u5217\u540d\u3092\u4f7f\u7528\u3057\u3066\u5404\u8981\u7d20\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3002<\/p>\n
\r\n>>> d['z']\r\n0     1\r\n1    20\r\nName: z, dtype: int64\r\n>>> d.z           # \u3053\u3061\u3089\u306e\u66f8\u304d\u65b9\u3082\u3067\u304d\u308b\u3002<\/span>\r\n0     1\r\n1    20\r\nName: z, dtype: int64\r\n>>> d['c']\r\n0     3\r\n1    50\r\nName: c, dtype: int64\r\n>>> d['Ko']\r\n0     6\r\n1    90\r\nName: Ko, dtype: int64\r\n<\/pre>\n
\r\n>>> d['z'][0]\r\n1\r\n>>> d.z[0]\r\n1\r\n>>> d['z'][1]\r\n20\r\n>>> d['Ko'][1]\r\n90\r\n<\/pre>\n
\u884c\u65b9\u5411\u306e\u914d\u5217\u3078\u306e\u30a2\u30af\u30bb\u30b9\u306f loc<\/span> \u3092\u4f7f\u7528\u3059\u308b\u3002<\/p>\n
\r\n>>> d.loc<\/span>[0]\r\nz     1\r\nc     3\r\nV     5\r\nW     7\r\nu     9\r\naz    8\r\nKo    6\r\nName: 0, dtype: int64\r\n>>> d.loc<\/span>[1]\r\nz     20\r\nc     50\r\nV     30\r\nW     40\r\nu     70\r\naz    60\r\nKo    90\r\nName: 1, dtype: int64\r\n<\/pre>\n
\r\n>>> d.loc<\/span>[1][0]\r\n20\r\n>>> d.loc<\/span>[1][3]\r\n40\r\n<\/pre>\n
\u5217\u540d\u3092\u30ea\u30b9\u30c8\u3067\u6307\u5b9a\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u6307\u5b9a\u5217\u3060\u3051\u3092\u62bd\u51fa\u3067\u304d\u308b\u3002<\/p>\n
\r\n>>> d[['z','c']]\r\n    z   c\r\n0   1   3\r\n1  20  50\r\n<\/pre>\n
columns<\/span> \u3067\u5217\u540d\u3092\u8aad\u307f\u51fa\u3059\u3002<\/p>\n
\r\n>>> d.columns<\/span>\r\nIndex(['z', 'c', 'V', 'W', 'u', 'az', 'Ko'], dtype='object')\r\n<\/pre>\n
shape<\/span> \u3067\u884c\u6570\u3001\u5217\u6570\u3092\u8aad\u307f\u51fa\u3059\u3002<\/p>\n
\r\n>>> d.shape<\/span>\r\n(2, 7)\r\n<\/pre>\n
\u2605pandas\u95a2\u9023\u306e\u6295\u7a3f\u4e00\u89a7\u306f\u3053\u3061\u3089\u3067\u3059\u3002<\/a><\/p>\n
\n","protected":false},"excerpt":{"rendered":"
1. \u3084\u308a\u305f\u3044\u3053\u3068 pandas \u306e DataFrame \u578b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u308a\u3001\u4e8c\u6b21\u5143\u30c7\u30fc\u30bf\u3092\u6271\u3044\u305f\u3044\u3002 2. \u3084\u3063\u3066\u307f\u308b \u307e\u305a\u306f Python\u3092\u8d77\u52d5\u3057\u3066\u304a\u304f\u3002 $ python Python 3.6.2 |Anacon\u2026 \u7d9a\u304d\u3092\u8aad\u3080 »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-2817","post","type-post","status-publish","format-standard","hentry","category-pandas"],"views":10235,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/2817","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/comments?post=2817"}],"version-history":[{"count":21,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/2817\/revisions"}],"predecessor-version":[{"id":2841,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/2817\/revisions\/2841"}],"wp:attachment":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/media?parent=2817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/categories?post=2817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/tags?post=2817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}