【第5章】2、DataFrame的索引查询（重点）

1、loc（轴标签）、iloc（整数标签）

#导入pandas
import pandas as pd
-------------------------------------------------
# 1、矩阵：有值（value）、行索引（index）、列索引（columns）
df=pd.DataFrame(np.arange(9).reshape(3,3),index=['jasmine','qiqi','jasmine_qiqi'],columns=['name','age','sex'])
"""
				name	age		sex
jasmine			0		1		2
qiqi			3		4		5
jasmine_qiqi	6		7		8
"""
-------------------------------------------------
# 2、单行
df.loc['jasmine']
df.iloc[0]
"""
name    0
age     1
sex     2
Name: jasmine, dtype: int64
"""
------------------------------------------------
# 3、多行
df.loc['jasmine':'jasmine_qiqi']
df.iloc[:3]
"""
				name	age		sex
jasmine			0		1		2
qiqi			3		4		5
jasmine_qiqi	6		7		8
"""
-------------------------------------------------
# 4、单列
df.loc[:,'name']
df.iloc[:,:1]
"""
jasmine         0
qiqi            3
jasmine_qiqi    6
Name: name, dtype: int64
"""
-------------------------------------------------
# 5、多列
df.loc[:,:'sex']
df.iloc[:,:3]
"""
				name	age		sex
jasmine			0		1		2
qiqi			3		4		5
jasmine_qiqi	6		7		8
"""
-------------------------------------------------
# 6、指定行指定列
df.loc['jasmine':'qiqi','name':'sex']
df.iloc[:2,:3]
"""
			name	age		sex
jasmine		0		1		2
qiqi		3		4		5
"""

---

2、at、iat函数、reindex方法

# 7、单个值
df.at['qiqi','age']
df.iat[1,1]
"""
4
"""
-------------------------------------------------
# 8、重新设置行索引
df.reindex(['jasmine','QiQi','jasmine_qiqi'],fill_value=np.NaN)
"""
				name	age		sex
jasmine			0.0		1.0		2.0
QiQi			NaN		NaN		NaN
jasmine_qiqi	6.0		7.0		8.0
"""
-------------------------------------------------
# 9、重新设置列索引
df.reindex(['name', 'age', 'sex','telephone'],axis='columns',fill_value='123456')
"""
				name	age		sex		telephone
jasmine			0		1		2		123456
qiqi			3		4		5		123456
jasmine_qiqi	6		7		8		123456
"""
-------------------------------------------------

---

3、总结

1. loc轴标签用字符，df.loc['index','columns']
2. iloc整数标签用数字，df.iloc[:1,:3]