[Python] Slice the data with pandas
2024-10-01 15:43:19
For example we have dataframe like this:
SPY AAPL IBM GOOG GLD
2017-01-03 222.073914 114.311760 160.947433 786.140015 110.470001
2017-01-04 223.395081 114.183815 162.940125 786.900024 110.860001
2017-01-05 223.217606 114.764473 162.401047 794.020020 112.580002
2017-01-06 224.016220 116.043915 163.200043 806.150024 111.750000
2017-01-09 223.276779 117.106812 161.390244 806.650024 112.669998
...
Now we only we want to get highlighted part:
SPY AAPL IBM GOOG GLD
2017-01-03 222.073914 114.311760 160.947433 786.140015 110.470001
2017-01-04 223.395081 114.183815 162.940125 786.900024 110.860001
2017-01-05 223.217606 114.764473 162.401047 794.020020 112.580002
2017-01-06 224.016220 116.043915 163.200043 806.150024 111.750000
2017-01-09 223.276779 117.106812 161.390244 806.650024 112.669998
We can use Dataframe.ix[] method to get date related index data from the list.
if __name__ == '__main__':
data=get_data()
data=data.ix['2017-12-01':'2017-12-15', ['IBM', 'GOOG']]
print(data)
"""
IBM GOOG
2017-12-01 154.759995 1010.169983
2017-12-04 156.460007 998.679993
2017-12-05 155.350006 1005.150024
2017-12-06 154.100006 1018.380005
2017-12-07 153.570007 1030.930054
2017-12-08 154.809998 1037.050049
2017-12-11 155.410004 1041.099976
2017-12-12 156.740005 1040.479980
2017-12-13 153.910004 1040.609985
2017-12-15 152.500000 1064.189941
"""
最新文章
- STL学习笔记
- 双核CPU,跑程序会报rcu_sched_state detected stalls on CPUs/tasks 错误
- Error:Execution failed for task ':app:transformClassesWithInstantRunForDebug'. >; java.lang.ClassNotFoundException: io.realm.RealmObject
- [百度空间] [原]跨平台编程注意事项(二): windows下 x86到x64的移植
- sencha touch 框架的几种核心脚本文件之间的区别
- Code Complete阅读笔记(一)
- 数据结构算法应用C++语言描述——(1)C++基础知识
- JQuery中文本框获取焦点
- hibernate、easyui、struts2整合
- Python 3 读写文件的简单方法!
- 执行3小时超长SQL的分析优化过程:从索引遇见IS NULL,到最佳实践
- 使用cmd命令行窗口操作SqlServer
- MATLAB中eig的作用
- HDU 4313 Matrix(并查集)
- Httpclient的学习(一)
- python django day 4 database
- Linux服务器密钥安全登录
- POP3协议分析
- python类内部调用自己的成员函数必须加self
- node初识——node中的require方法与require.js的区别