数据分析-day05-pandas-dataFrame的时间序列、字符串转换成时间序列

#!usr/bin/env python
#-*- coding:utf-8 _*-
'''
@author:Administrator
@file: pandas_timeseries_demo.py
@time: 2020-01-05 下午 5:27
'''
import string

import pandas as pd
import numpy as np
#默认按天
a=pd.date_range("20191208","20200105")
print(a)
#start和end以及freq配合能够生成start和end范围内以频率freq的一组时间索引
a=pd.date_range("20191208","20200105",freq="D")
print(a)
#start和periods以及freq配合能够生成从start开始的频率为freq的periods个时间索引
a=pd.date_range("20191208",freq="M",periods=10)
print(a)
index=pd.date_range("20170101",periods=10)
df=pd.DataFrame(np.random.rand(10),index=index)
print(df)
print(type(df))
#字符串日期转换成pandas的datetime 时间序列
df_date=pd.DataFrame(['20180101','20180102'],columns=['日期'])
print(df_date)
df_date['日期'] = pd.to_datetime(df_date['日期'])
print(df_date)
print(type(df_date))

DatetimeIndex(['2019-12-08', '2019-12-09', '2019-12-10', '2019-12-11',
               '2019-12-12', '2019-12-13', '2019-12-14', '2019-12-15',
               '2019-12-16', '2019-12-17', '2019-12-18', '2019-12-19',
               '2019-12-20', '2019-12-21', '2019-12-22', '2019-12-23',
               '2019-12-24', '2019-12-25', '2019-12-26', '2019-12-27',
               '2019-12-28', '2019-12-29', '2019-12-30', '2019-12-31',
               '2020-01-01', '2020-01-02', '2020-01-03', '2020-01-04',
               '2020-01-05'],
              dtype='datetime64[ns]', freq='D')
DatetimeIndex(['2019-12-08', '2019-12-09', '2019-12-10', '2019-12-11',
               '2019-12-12', '2019-12-13', '2019-12-14', '2019-12-15',
               '2019-12-16', '2019-12-17', '2019-12-18', '2019-12-19',
               '2019-12-20', '2019-12-21', '2019-12-22', '2019-12-23',
               '2019-12-24', '2019-12-25', '2019-12-26', '2019-12-27',
               '2019-12-28', '2019-12-29', '2019-12-30', '2019-12-31',
               '2020-01-01', '2020-01-02', '2020-01-03', '2020-01-04',
               '2020-01-05'],
              dtype='datetime64[ns]', freq='D')
DatetimeIndex(['2019-12-31', '2020-01-31', '2020-02-29', '2020-03-31',
               '2020-04-30', '2020-05-31', '2020-06-30', '2020-07-31',
               '2020-08-31', '2020-09-30'],
              dtype='datetime64[ns]', freq='M')
                   0
2017-01-01  0.851954
2017-01-02  0.438603
2017-01-03  0.494238
2017-01-04  0.671080
2017-01-05  0.341464
2017-01-06  0.123100
2017-01-07  0.891978
2017-01-08  0.310661
2017-01-09  0.091059
2017-01-10  0.102075
<class 'pandas.core.frame.DataFrame'>
         日期
0  20180101
1  20180102
          日期
0 2018-01-01
1 2018-01-02
<class 'pandas.core.frame.DataFrame'>