DataFrame loc()で指定の行と列を取得

				
				1

以下の場合

     a  b   c  d   e
1    6  8   6  3  10
2    1  7  10  4  10
3    4  9   9  9   1
4    4  9  10  2   5
5    8  2   5  4   8
6   10  7   4  4   4
7    4  8   1  4   3
8    6  8   4  8   8
9    3  9   6  1   3
10   5  2   1  2   1

a b c d e

1 6 8 6 3 10

2 1 7 10 4 10

3 4 9 9 9 1

4 4 9 10 2 5

5 8 2 5 4 8

6 10 7 4 4 4

7 4 8 1 4 3

8 6 8 4 8 8

9 3 9 6 1 3

10 5 2 1 2 1

<span role="presentation"><span class="cm-keyword">



#loc()で指定の行、列を取得
import</code></span><code> <span class="cm-variable">numpy</span> <span class="cm-keyword">as</span> <span class="cm-variable">np</span></code></span>

#loc()で指定の行、列を取得

import</code><code> numpy as np</code>

<span role="presentation"><span class="cm-keyword">import</span> <span class="cm-variable">pandas</span> <span class="cm-keyword">as</span> <span class="cm-variable">pd</span></span>

1	<span role="presentation"><span class="cm-keyword">import</span> <span class="cm-variable">pandas</span> <span class="cm-keyword">as</span> <span class="cm-variable">pd</span></span>

<span role="presentation"><span class="cm-variable">np</span>.<span class="cm-property">random</span>.<span class="cm-property">seed</span>(<span class="cm-number">0</span>)</span>

1	<span role="presentation"><span class="cm-variable">np</span>.<span class="cm-property">random</span>.<span class="cm-property">seed</span>(<span class="cm-number">0</span>)</span>

<span role="presentation"><span class="cm-variable">columns</span> = <span class=" CodeMirror-matchingbracket">[</span><span class="cm-string">"a"</span>, <span class="cm-string">"b"</span>, <span class="cm-string">"c"</span>, <span class="cm-string">"d"</span>, <span class="cm-string">"e"</span><span class=" CodeMirror-matchingbracket">]</span></span>

columns = ["a", "b", "c", "d", "e"]

<span role="presentation"></span>

1	<span role="presentation"></span>

<span role="presentation"><span class="cm-comment"># DataFrameを生成し、列を追加</span></span>

1	<span role="presentation"><span class="cm-comment"># DataFrameを生成し、列を追加</span></span>

<span role="presentation"><span class="cm-variable">df</span> = <span class="cm-variable">pd</span>.<span class="cm-property">DataFrame</span>()</span>

1	<span role="presentation"><span class="cm-variable">df</span> = <span class="cm-variable">pd</span>.<span class="cm-property">DataFrame</span>()</span>

<span role="presentation"><span class="cm-keyword">for</span> <span class="cm-variable">column</span> <span class="cm-keyword">in</span> <span class="cm-variable">columns</span>:
</span><span role="presentation"><span class="cm-variable">　　　　df</span>[<span class="cm-variable">column</span>] = <span class="cm-variable">np</span>.<span class="cm-property">random</span>.<span class="cm-property">choice</span>(<span class="cm-builtin">range</span>(<span class="cm-number">1</span>, <span class="cm-number">11</span>), <span class="cm-number">10</span>)
</span><span role="presentation"><span class="cm-variable">df</span>.<span class="cm-property">index</span> = <span class="cm-builtin">range</span>(<span class="cm-number">1</span>, <span class="cm-number">11</span>)</span>

for column in columns:

df[column] = np.random.choice(range(1, 11), 10)

df.index = range(1, 11)

<span role="presentation"><span class="cm-variable">df</span> = <span class="cm-variable">df</span>.<span class="cm-property">loc</span>[<span class="cm-builtin">range</span>(<span class="cm-number">2</span>, <span class="cm-number">6</span>), [<span class="cm-string">"b"</span>, <span class="cm-string">"e"</span>]]</span>

df = df.loc[range(2, 6), ["b", "e"]]

<span role="presentation"><span class="cm-builtin">print</span>(<span class="cm-variable">df</span>)</span>

1	<span role="presentation"><span class="cm-builtin">print</span>(<span class="cm-variable">df</span>)</span>

b e

2 7 10

3 9 1

4 9 5

5 2 8

[`yahoo` not found]

Reader Interactions

コメントを残す コメントをキャンセル

コメントを残すコメントをキャンセル