プログラミング

Serius でソート

2017年11月25日 by 河副太智 Leave a Comment

<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>

				1

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

<span role="presentation"><span class="cm-variable">index</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>

				1

						<span role="presentation"><span class="cm-variable">index</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>

<span role="presentation"><span class="cm-variable">data</span> = [<span class="cm-number">10</span>, <span class="cm-number">5</span>, <span class="cm-number">8</span>, <span class="cm-number">12</span>, <span class="cm-number">3</span>]</span>

				1

						<span role="presentation"><span class="cm-variable">data</span> = [<span class="cm-number">10</span>, <span class="cm-number">5</span>, <span class="cm-number">8</span>, <span class="cm-number">12</span>, <span class="cm-number">3</span>]</span>

<span role="presentation"><span class="cm-variable">series</span> = <span class="cm-variable">pd</span>.<span class="cm-property">Series</span>(<span class="cm-variable">data</span>, <span class="cm-variable">index</span>=<span class="cm-variable">index</span>)</span>

				1

						<span role="presentation"><span class="cm-variable">series</span> = <span class="cm-variable">pd</span>.<span class="cm-property">Series</span>(<span class="cm-variable">data</span>, <span class="cm-variable">index</span>=<span class="cm-variable">index</span>)</span>

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

				1

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

<span role="presentation"><span class="cm-comment"># seriesをインデックスについてアルファベット順にソートしたSeriesをitems1に代入にしてください。</span></span>

				1

						<span role="presentation"><span class="cm-comment"># seriesをインデックスについてアルファベット順にソートしたSeriesをitems1に代入にしてください。</span></span>

<span role="presentation"><span class="cm-variable">items1</span> = <span class="cm-variable">series</span>.<span class="cm-property">sort_index</span>()</span>

				1

						<span role="presentation"><span class="cm-variable">items1</span> = <span class="cm-variable">series</span>.<span class="cm-property">sort_index</span>()</span>

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

				1

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

<span role="presentation"><span class="cm-comment"># seriesをデータについて値の大きさを昇順にソートしたSeriesをitems2に代入してください。</span></span>

				1

						<span role="presentation"><span class="cm-comment"># seriesをデータについて値の大きさを昇順にソートしたSeriesをitems2に代入してください。</span></span>

<span role="presentation"><span class="cm-variable">items2</span> = <span class="cm-variable">series</span>.<span class="cm-property">sort_values</span>()</span>

				1

						<span role="presentation"><span class="cm-variable">items2</span> = <span class="cm-variable">series</span>.<span class="cm-property">sort_values</span>()</span>

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

				1

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

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

				1

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

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

				1

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

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

				1

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

a    10
b     5
c     8
d    12
e     3
dtype: int64

e     3
b     5
c     8
a    10
d    12
dtype: int64

				1
2
3
4
5
6
7
8
9
10
11
12
13

						a    10
b     5
c     8
d    12
e     3
dtype: int64
 
e     3
b     5
c     8
a    10
d    12
dtype: int64

series要素の削除

2017年11月25日 by 河副太智 Leave a Comment

import pandas as pd

index = ["a", "b", "c", "d", "e"]
data = [10, 5, 8, 12, 3]

# indexとdataを含むSeriesを作成しseriesに代入
series = pd.Series(data, index=index)

# インデックスがstrawberryの要素を削除してseriesに代入
series = series.drop("c")

print(series)
 
 結果
 
a    10
b     5
d    12
e     3
dtype: int64

import pandas as pd

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

data = [10, 5, 8, 12, 3]

# indexとdataを含むSeriesを作成しseriesに代入

series = pd.Series(data, index=index)

# インデックスがstrawberryの要素を削除してseriesに代入

series = series.drop("c")

print(series)

結果

a 10

b 5

d 12

e 3

dtype: int64

serius辞書に要素の追加

2017年11月25日 by 河副太智 Leave a Comment

<span role="presentation"><span class="cm-keyword">port</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">port</span> <span class="cm-variable">pandas</span> <span class="cm-keyword">as</span> <span class="cm-variable">pd</span></span>

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

				1

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

<span role="presentation"><span class="cm-variable">index</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>

				1

						<span role="presentation"><span class="cm-variable">index</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>

<span role="presentation"><span class="cm-variable">data</span> = [<span class="cm-number">10</span>, <span class="cm-number">5</span>, <span class="cm-number">8</span>, <span class="cm-number">12</span>, <span class="cm-number">3</span>]</span>

				1

						<span role="presentation"><span class="cm-variable">data</span> = [<span class="cm-number">10</span>, <span class="cm-number">5</span>, <span class="cm-number">8</span>, <span class="cm-number">12</span>, <span class="cm-number">3</span>]</span>

<span role="presentation"><span class="cm-variable">series</span> = <span class="cm-variable">pd</span>.<span class="cm-property">Series</span>(<span class="cm-variable">data</span>, <span class="cm-variable">index</span>=<span class="cm-variable">index</span>)</span>

				1

						<span role="presentation"><span class="cm-variable">series</span> = <span class="cm-variable">pd</span>.<span class="cm-property">Series</span>(<span class="cm-variable">data</span>, <span class="cm-variable">index</span>=<span class="cm-variable">index</span>)</span>

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

				1

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

<span role="presentation"><span class="cm-comment"># seriesに、インデックスが"pineapple"、データが12の要素を追加してください。</span></span>

				1

						<span role="presentation"><span class="cm-comment"># seriesに、インデックスが"pineapple"、データが12の要素を追加してください。</span></span>

<span role="presentation"><span class="cm-variable">pineapple</span> = <span class="cm-variable">pd</span>.<span class="cm-property">Series</span>([<span class="cm-number">12</span>], <span class="cm-variable">index</span>=[<span class="cm-string">"f"</span>])</span>

				1

						<span role="presentation"><span class="cm-variable">pineapple</span> = <span class="cm-variable">pd</span>.<span class="cm-property">Series</span>([<span class="cm-number">12</span>], <span class="cm-variable">index</span>=[<span class="cm-string">"f"</span>])</span>

<span role="presentation"><span class="cm-variable">series</span> = <span class="cm-variable">series</span>.<span class="cm-property">append</span>(<span class="cm-variable">pineapple</span>)</span>

				1

						<span role="presentation"><span class="cm-variable">series</span> = <span class="cm-variable">series</span>.<span class="cm-property">append</span>(<span class="cm-variable">pineapple</span>)</span>

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

				1

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

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

				1

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

a    10
b     5
c     8
d    12
e     3
f    12
dtype: int64

				1
2
3
4
5
6
7

						a    10
b     5
c     8
d    12
e     3
f    12
dtype: int64

seriusで辞書内の値やインデックスのみ分解して取り出す

2017年11月25日 by 河副太智 Leave a Comment

<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>

				1

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

<span role="presentation"><span class="cm-variable">index</span> = [<span class="cm-string">"apple"</span>, <span class="cm-string">"orange"</span>, <span class="cm-string">"banana"</span>, <span class="cm-string">"strawberry"</span>, <span class="cm-string">"kiwifruit"</span>]</span>

				1

						<span role="presentation"><span class="cm-variable">index</span> = [<span class="cm-string">"apple"</span>, <span class="cm-string">"orange"</span>, <span class="cm-string">"banana"</span>, <span class="cm-string">"strawberry"</span>, <span class="cm-string">"kiwifruit"</span>]</span>

<span role="presentation"><span class="cm-variable">data</span> = [<span class="cm-number">10</span>, <span class="cm-number">5</span>, <span class="cm-number">8</span>, <span class="cm-number">12</span>, <span class="cm-number">3</span>]</span>

				1

						<span role="presentation"><span class="cm-variable">data</span> = [<span class="cm-number">10</span>, <span class="cm-number">5</span>, <span class="cm-number">8</span>, <span class="cm-number">12</span>, <span class="cm-number">3</span>]</span>

<span role="presentation"><span class="cm-variable">series</span> = <span class="cm-variable">pd</span>.<span class="cm-property">Series</span>(<span class="cm-variable">data</span>, <span class="cm-variable">index</span>=<span class="cm-variable">index</span>)</span>

				1

						<span role="presentation"><span class="cm-variable">series</span> = <span class="cm-variable">pd</span>.<span class="cm-property">Series</span>(<span class="cm-variable">data</span>, <span class="cm-variable">index</span>=<span class="cm-variable">index</span>)</span>

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

				1

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

<span role="presentation"><span class="cm-comment"># valuesにseriesのデータを代入</span></span>

				1

						<span role="presentation"><span class="cm-comment"># valuesにseriesのデータを代入</span></span>

<span role="presentation"><span class="cm-variable">values</span>= <span class="cm-variable">series</span>.<span class="cm-property">values</span></span>

				1

						<span role="presentation"><span class="cm-variable">values</span>= <span class="cm-variable">series</span>.<span class="cm-property">values</span></span>

<span role="presentation">​結果
[10 5 8 12 3]
</span>

				1
2
3

						<span role="presentation">​結果
[10 5 8 12 3]
</span>

<span role="presentation"><span class="cm-comment"># indexにseriesのインデックスを代入してください</span></span>

				1

						<span role="presentation"><span class="cm-comment"># indexにseriesのインデックスを代入してください</span></span>

<span role="presentation"><span class="cm-variable">index</span> =<span class="cm-variable">series</span>.<span class="cm-property">index</span></span>

				1

						<span role="presentation"><span class="cm-variable">index</span> =<span class="cm-variable">series</span>.<span class="cm-property">index</span></span>

結果

Index([‘apple’, ‘orange’, ‘banana’, ‘strawberry’, ‘kiwifruit’], dtype=’object’)

Seriesで辞書の値や要素を取り出す

2017年11月25日 by 河副太智 Leave a Comment

文字と数字を組み合わせた辞書の作成が可能

index = [“cup”, “chair”, “table”, “kagaku”, “pictre”]
data = [7012, 9406, 9609, 3824,9701]

# indexとdataを含むSeriesを作成しseriesに代入
series = pd.Series(data,index=index)

cup       7012
chair     9406
table     9609
kagaku    3824
pictre    9701
dtype: int64

cup 7012

chair 9406

table 9609

kagaku 3824

pictre 9701

dtype: int64

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

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

<span role="presentation"><span class="cm-comment"># インデックス参照を用いてseriesの2つ目から4つ目までの3つの要素を取り出してitems1に代入</span></span>

1	<span role="presentation"><span class="cm-comment"># インデックス参照を用いてseriesの2つ目から4つ目までの3つの要素を取り出してitems1に代入</span></span>

<span role="presentation"><span class="cm-variable">items1</span> = <span class="cm-variable">series</span>[<span class="cm-number">1</span>:<span class="cm-number">4</span>]

結果

orange 5 
</span>banana 8 
strawberry 12 
dtype: int64

items1 = series[1:4]

結果

orange 5

banana 8

strawberry 12

dtype: int64

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

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

<span role="presentation"><span class="cm-comment"># インデックス値を指定する方法を用いて"apple", "banana", "kiwifruit"のインデックスと持つ要素を取り出してitems2に代入

</span></span><span role="presentation"><span class="cm-variable">items2</span>=<span class="cm-variable">series</span>[[<span class="cm-string">"apple"</span>,<span class="cm-string">"banana"</span>,<span class="cm-string">"kiwifruit"</span>]]</span>

# インデックス値を指定する方法を用いて"apple", "banana", "kiwifruit"のインデックスと持つ要素を取り出してitems2に代入

items2=series[["apple","banana","kiwifruit"]]

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

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

結果

結果

apple        10
banana        8
kiwifruit     3
dtype: int64

apple 10

banana 8

kiwifruit 3

dtype: int64