在python读取cs中将datetime对象转换为float

Question

我想把datetime放入数组中，有解决方案吗？我是新手

import csv
from datetime import datetime    
date = []
price = []
tdate = []
tprice = []

with open('TSLA.csv', 'r') as csvfile:
    csvR = csv.reader(csvfile)
    next(csvR)  # skipping column names
    for i,row in enumerate(csvR):
        row_date = datetime.strptime(row[0], "%m/%d/%Y")
        date.append(float(row_date))
        price.append(float(row[5]))

如果要查看错误：

^{pr2}$

更新

with open('TSLA.csv', 'r') as csvfile:
    csvR = csv.reader(csvfile)
    next(csvR)  # skipping column names
    for i,row in enumerate(csvR):
        ts = time.strptime(row[0], "%m/%d/%Y")
        time.mktime(ts)
        date.append(float(ts))
        price.append(float(row[5]))

错误：

TypeError: float() argument must be a string or a number, not 'time.struct_time'

Answer 1

斯洛伐克语

with open('TSLA.csv', 'r') as csvfile:
    csvR = csv.reader(csvfile)
    next(csvR)  # skipping column names
    for i,row in enumerate(csvR):
        date.append(datetime.strptime(row[0],'%m/%d/%Y'))
        price.append(float(row[5]))
        if(i >= 25):
            tdate.append(float(row[7]))
            tprice.append(float(row[5]))
            break