python库学习笔记——Pandas数据索引:ix、loc、iloc区别
来源:互联网 发布:桌面任务提醒软件 编辑:程序博客网 时间:2024/06/04 18:50
Different Choices for Indexing
1. loc——通过行标签索引行数据
1.1 loc[1]表示索引的是第1行(index 是整数)
import pandas as pddata = [[1,2,3],[4,5,6]]index = [0,1]columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.loc[1]'''a 4b 5c 6'''
1.2 loc[‘d’]表示索引的是第’d’行(index 是字符)
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.loc['d']'''a 1b 2c 3'''
1.3 如果想索引列数据,像这样做会报错
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.loc['a']'''KeyError: 'the label [a] is not in the [index]''''
1.4 loc可以获取多行数据
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.loc['d':]''' a b cd 1 2 3e 4 5 6'''
1.5 loc扩展——索引某行某列
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.loc['d',['b','c']]'''b 2c 3'''
1,6 loc扩展——索引某列
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.loc[:,['c']]''' cd 3e 6'''
当然获取某列数据最直接的方式是df.[列标签],但是当列标签未知时可以通过这种方式获取列数据。
需要注意的是,dataframe的索引[1:3]是包含1,2,3的,与平时的不同。
2. iloc——通过行号获取行数据
2.1 想要获取哪一行就输入该行数字
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.loc[1]'''a 4b 5c 6'''
2.2 通过行标签索引会报错
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.iloc['a']'''TypeError: cannot do label indexing on <class 'pandas.core.index.Index'> with these indexers [a] of <type 'str'>'''
2.3 同样通过行号可以索引多行
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.iloc[0:]''' a b cd 1 2 3e 4 5 6'''
2.4 iloc索引列数据
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.iloc[:,[1]]''' bd 2e 5'''
3. ix——结合前两种的混合索引
3.1 通过行号索引
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.ix[1]'''a 4b 5c 6'''
3.2 通过行标签索引
import pandas as pddata = [[1,2,3],[4,5,6]]index = ['d','e']columns=['a','b','c']df = pd.DataFrame(data=data, index=index, columns=columns)print df.ix['e']'''a 4b 5c 6'''
阅读全文
0 0
- python库学习笔记——Pandas数据索引:ix、loc、iloc区别
- pandas学习笔记5—DataFrame数据筛选loc,iloc,ix,at,iat
- Pandas——ix vs loc vs iloc区别
- Pandas——ix vs loc vs iloc区别
- Pandas——ix vs loc vs iloc区别
- Pandas——ix vs loc vs iloc区别
- Pandas——ix vs loc vs iloc区别
- Pandas——ix vs loc vs iloc区别
- python的pandas包数据框单层索引操作核心方法loc,iloc,ix,query
- python pandas (ix & iloc &loc) 的区别
- python pandas中ix,iloc,loc的区别
- python pandas (ix & iloc &loc) 的区别
- python pandas (ix & iloc &loc) 的区别
- python pandas (ix & iloc &loc) 的区别
- Pandas的 loc iloc ix 区别
- pandas中loc、iloc、ix的区别
- pandas中loc iloc ix的区别
- Pandas的 loc iloc ix 区别
- 阶段codeforces小结
- 程序员必知的Python陷阱与缺陷列表
- POJ 3219 Binomial Coefficients(组合数 lucas定理)
- 修改注册表中 百度网盘 名称
- 2017"百度之星"程序设计大赛-资格赛 比赛总结
- python库学习笔记——Pandas数据索引:ix、loc、iloc区别
- JZOJ5273. 亲戚
- TCP的粘包现象
- 详解 call 和 apply
- Oracle之基本select语句
- js---js仿jQuery封装ajax
- Carbide LED进行闪烁的设置
- 单实例redis 的安装配置(上)
- java中volatile关键字的含义