ASP.net C# VB.Net PHP
Swoole ASP/ADO/VBScript SQL语言 Python Python3 Diango C语言 Lua C++ Go语言 Revel Docker Ruby Perl Erlang R语言 Julia Apex OAuth 2.0 Arduino 编程经验 汇编语言 树莓派 游戏设计 MATLAB Elasticsearch Numpy F# Delphi HTCondor Rust 易语言 NSQ
用户登录
用户注册

分享至

Pandas DataFrame - '不能在使用 ols/线性回归时从 [datetime64[ns]] 到 [float64] 键入 datetimelike

  • 作者: 不抽烟的小丑
  • 来源: 51数据库
  • 2022-11-17

问题描述

我有一个如下的DataFrame:

I have a DataFrame as follows:

   Ticker        Date  Close
0    ADBE  2016-02-16  78.88
1    ADBE  2016-02-17  81.85
2    ADBE  2016-02-18  80.53
3    ADBE  2016-02-19  80.87
4    ADBE  2016-02-22  83.80
5    ADBE  2016-02-23  83.07

...等等.Date 列是问题所在.我正在尝试使用 Close 列获得 Date 列的线性回归:

...and so on. The Date column is the issue. I'm trying to get the linear regression of the Date column with the Close column:

ols1 = pd.ols(y=ADBE['Close'], x=ADBE['Date'], intercept=True)

我收到以下错误:

TypeError: cannot astype a datetimelike from [datetime64[ns]] to [float64]

我尝试了多种方法来消除此错误，例如:

I've tried multiple ways of getting rid of this error, for examples:

dates_input = ADBE['Date'].values.astype('datetime64[D]')

dates_input = ADBE['Date'].values.astype('float')

第二次 dates_input 尝试将类型返回为 pandas.core.series.Series 但我仍然收到错误消息.

The second dates_input attempt returns the type as pandas.core.series.Series but I still get an error message.

有谁知道如何让 Date 列正常工作并摆脱这个 TypeError?

Does anyone know how to get the Date column to work and get rid of this TypeError?

推荐答案

你需要:

ADBE['Date'] = ADBE['Date'].values.astype(float)

然后:

ols1 = pd.ols(y=ADBE['Close'], x=ADBE['Date'], intercept=True)
推荐阅读
热点文章

Copyright 2018 51数据库(www.51sjk.com)

软件
前端设计
程序设计
Java相关