python开发笔记-如何做数据准备
时间格式:
>>> from datetime import date >>> firstday = date.fromtimestamp(1464010200) >>> lastday = date.fromtimestamp(1495200600) >>> firstday datetime.date(2018, 2, 23) >>> lastday datetime.date(2018, 2, 19)
创建时间序列:
import pandas as pd >>> dates=pd.date_range('20180220',periods=7) >>> dates DatetimeIndex(['2018-02-20', '2018-02-21', '2018-02-22', '2018-02-23', '2018-02-24', '2017-05-25', '2017-05-26'], dtype='datetime64[ns]', freq='D') >>> import numpy as np >>> datesdf=pd.DataFrame(np.random.randn(7,3),index=dates,columns=list('ABC')) >>> datesdf A B C 2018-02-20 0.659181 -0.020180 -0.182932 2018-02-21 0.602556 0.090524 -0.404592 2018-02-22 0.400426 0.090271 -0.835928 2018-02-23 0.497099 -1.977787 0.771407 2018-02-24 0.078308 0.155671 0.630712 2018-02-25 -0.442369 1.510636 -0.679247 2018-02-26 -0.318323 -0.312514 0.753957
千行代码,Bug何处藏。 纵使上线又怎样,朝令改,夕断肠。