时序数据处理之给股票收盘价添加时间戳

最新推荐文章于 2025-04-27 18:20:52 发布

原创最新推荐文章于 2025-04-27 18:20:52 发布 · 442 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#时序数据处理

心得同时被 2 个专栏收录

206 篇文章

订阅专栏

人工智能

202 篇文章

订阅专栏

import pandas as pd
from datetime import datetime
import numpy as np 
import csv
date_rng = pd.date_range(start='1/1/2016',end='1/08/2019',freq='Min')
'''DatetimeIndex(['2018-01-01 00:00:00','2018-01-01 01:00:00',
                '2018-01-01 02:00:00','2018-01-01 03:00:00',
                '2018-01-01 04:00:00','2018-01-01 05:00:00']
                '2018-01-01 02:00:00','2018-01-01 03:00:00'  '''      
print(date_rng)
type(date_rng[0])
pd._libs.tslib.Timestamp
'''
df=pd.DataFrame(date_rng,columns=['date'])
f=open('E:\\1\\000518.csv')
print(f)

df['data']=pd.read_csv(f)
'''
df=pd.DataFrame(date_rng,columns=['date'])
data = pd.read_csv(r'E:\\1\\000518.csv')
print(data.columns)#获取列索引值
print(data.index)#获取行索引值
data1  = data['close'] #获取名字为flow列的数据     
df['data'] = data1
print(df.head(15))
#数据框索引转换为datetime索引
df['datetime'] = pd.to_datetime(df['date'])
df=df.set_index('datetime')
df.drop(['date'],axis=1,inplace=False)
print(df.head())

df.to_csv('E:\\1\\000518_TIME_CLOSE.csv',index=False,sep=',')

稍后上传数据文件