python - 时间戳 Python Pandas KeyError: 'timestamp'

Question

我正在尝试绘制特斯拉股票的分钟数据

我收到以下错误：

Traceback (most recent call last):
  File "minutiniai.py", line 12, in <module>
    d.head(100).plot(x='timestamp',y=['open','close'],figsize=(10,5))
  File "D:\Programs\Anaconda\lib\site-packages\pandas\plotting\_core.py", line 914, in __call__
    elif not isinstance(data[x], ABCSeries):
  File "D:\Programs\Anaconda\lib\site-packages\pandas\core\frame.py", line 2902, in __getitem__
    indexer = self.columns.get_loc(key)
  File "D:\Programs\Anaconda\lib\site-packages\pandas\core\indexes\base.py", line 2897, in get_loc
    raise KeyError(key) from err
KeyError: 'timestamp'

我的代码：

import pandas as pn
import numpy as np
import matplotlib.pyplot as plt


file_name = 'C:/Users/Admin/Desktop/Finansinis/TSLA_1min.csv'
d = pn.read_csv(file_name)
print(d.head(10))

d.head(100).plot(x='timestamp',y=['open','close'],figsize=(10,5))

plt.title("Minute data")
plt.grid()
plt.legend()
plt.xlabel("Dates")
plt.ylabel("Value")
plt.xticks(rotation = 45)
tick_idx = plt.xticks()[0]

plt.show()

谁能帮我弄清楚问题可能是什么？

标签： pythonpandasdataframetimestamp