**pandas切片学习 **
(1)创建DataFrame
-df = pd.DataFrame({'age':[10,2,30,40], 'grade':[100.0,90.0,66.0,98.0], 'sex':['female','male','female','male']})
—
(2)打印DataFrame一些属性
df.dtypes
age int64
grade float64
sex object
dtype: object
----------------------
df.value #array型
[[10 100.0 'female']
[20 90.0 'male']
[30 66.0 'female']
[40 98.0 'male']]
----------------------
df.index
RangeIndex(start=0, stop=4, step=1)
----------------------
df.columns
Index(['age', 'grade', 'sex'], dtype='object')
----------------------
df
age grade sex
0 10 100.0 female
1 20 90.0 male
2 30 66.0 female
3 40 98.0 male
(3)切片
print(df.loc[1:3,['sex','grade']])#只允许列名操作
print(df.loc[1:3,'age':'sex'])
sex grade
1 male 90.0
2 female 66.0
3 male 98.0
age grade sex
1 20 90.0 male
2 30 66.0 female
3 40 98.0 male
print(df.iloc[1:3,1:2])#iloc与loc不同,依靠列序定位而非列名,iloc区间是前闭后开
# 结果
grade
1 90.0
2 66.0
print(df.at[1,'grade'])#定位到某个值
print(df.iat[1,1])
print(df.ix[[0,1]])#行选择
#结果
90.0
90.0
age grade sex
0 10 100.0 female
1 20 90.0 male
#df只能单独进行行选择或者列选择,列选择只能是列名
print(df[0:2])#行选择,前闭后开
#结果
age grade sex
0 10 100.0 female
1 20 90.0 male
print(df[['age','sex']])#列选择
#结果
age sex
0 10 female
1 20 male
2 30 female
3 40 male
本文来自 LY_ysys629 的CSDN 博客 ,全文地址请点击:https://blog.csdn.net/ly_ysys629/article/details/55224284?utm_source=copy