/home/lucky/anaconda3/lib/python3.6/site-packages/ipykernel/__main__.py:2: DeprecationWarning:
.ix is deprecated. Please use
.loc for label based indexing or
.iloc for positional indexing
See the documentation here:
http://pandas.pydata.org/pandas-docs/stable/indexing.html#ix-indexer-is-deprecated
from ipykernel import kernelapp as app
year 2002
state Ohio
pop 3.6
debt NaN
Name: 2, dtype: object
import numpy as np
frame2['debt']=12
frame2
frame2['debt']=np.arange(5)
frame2
obj = Series(range(3), index=['a','b','c'])
index = obj.index
index
Index(['a', 'b', 'c'], dtype='object')
index = pd.Index(np.arange(3))
index
obj2 = Series([1.5,-2.5,0], index=['a','b','c'])
obj2.index
index
obj2 = Series([1.5,-2.5,0], index=[np.arange(3)])
obj2.index
obj2.index is index
obj2 = Series([1.5,-2.5,0], index=index)
obj2.index
index
obj2.index is index
a 0.0
b 1.0
c 2.0
d 3.0
e 4.0
dtype: float64
a 0.0
b 1.0
d 3.0
e 4.0
dtype: float64
#对于DataFrame,可以从任何坐标轴删除索引值:
data = DataFrame(np.arange(16).reshape((4,4)),index=['Ohio','Colorado','Utah','New York'],columns=['one','two','three','four'])
data
data.drop(['Colorado','Ohio'])
data
data.drop('two', axis=1)
data.drop(['two','four'], axis=1)
a 0.0
b 1.0
c 2.0
d 3.0
dtype: float64
1.0
1.0
c 2.0
d 3.0
dtype: float64
b 1.0
a 0.0
d 3.0
dtype: float64
b 1.0
d 3.0
dtype: float64
a 0.0
b 1.0
dtype: float64
obj['b':'c']#使用标签来切片和正常的Python切片并不一样,它会把结束点也包括在内:
b 1.0
c 2.0
dtype: float64
obj['b':'c']=5#赋值
obj
a 0.0
b 5.0
c 5.0
d 3.0
dtype: float64
data = DataFrame(np.arange(16).reshape((4,4)),['Ohio','Colorado','Utah','New York'],columns=['one','two','three','four'])
data
#索引DataFrame来检索一个或多个列,可以使用一个单一值或一个序列:
data['two']
data[['three','one']]
data['Ohio':'New York']#data['Ohio','New York']#data[['Ohio','New York'],axis=1]
data[:2]
data[data['three']>5]
one
two
three
four
Ohio
0
1
2
3
Colorado
4
5
6
7
Utah
8
9
10
11
New York
12
13
14
15
Ohio 1
Colorado 5
Utah 9
New York 13
Name: two, dtype: int64
three
one
Ohio
2
0
Colorado
6
4
Utah
10
8
New York
14
12
one
two
three
four
Ohio
0
1
2
3
Colorado
4
5
6
7
Utah
8
9
10
11
New York
12
13
14
15
one
two
three
four
Ohio
0
1
2
3
Colorado
4
5
6
7
one
two
three
four
Colorado
4
5
6
7
Utah
8
9
10
11
New York
12
13
14
15
data <5
data
data[data <5]
data[data <5]=0
data
one
two
three
four
Ohio
True
True
True
True
Colorado
True
False
False
False
Utah
False
False
False
False
New York
False
False
False
False
one
two
three
four
Ohio
0
1
2
3
Colorado
4
5
6
7
Utah
8
9
10
11
New York
12
13
14
15
one
two
three
four
Ohio
0.0
1.0
2.0
3.0
Colorado
4.0
NaN
NaN
NaN
Utah
NaN
NaN
NaN
NaN
New York
NaN
NaN
NaN
NaN
one
two
three
four
Ohio
0
0
0
0
Colorado
0
5
6
7
Utah
8
9
10
11
New York
12
13
14
15
data
data.ix['Colorado']
data.ix['Colorado',['two','four']]
data.ix[['Colorado','Utah'],[2,1,3]]
data.ix[2]
data.ix[:'Utah','one']
data.ix[data.three >5,:3]
one
two
three
four
Ohio
0
0
0
0
Colorado
0
5
6
7
Utah
8
9
10
11
New York
12
13
14
15
/home/lucky/anaconda3/lib/python3.6/site-packages/ipykernel/__main__.py:2: DeprecationWarning:
.ix is deprecated. Please use
.loc for label based indexing or
.iloc for positional indexing
See the documentation here:
http://pandas.pydata.org/pandas-docs/stable/indexing.html#ix-indexer-is-deprecated
from ipykernel import kernelapp as app
one 0
two 5
three 6
four 7
Name: Colorado, dtype: int64
two 5
four 7
Name: Colorado, dtype: int64
three
two
four
Colorado
6
5
7
Utah
10
9
11
one 8
two 9
three 10
four 11
Name: Utah, dtype: int64
Ohio 0
Colorado 0
Utah 8
Name: one, dtype: int64