import pandas as pd
import numpy as np
from statsmodels.graphics.tsaplots import plot_acf, plot_pacf
from statsmodels.tsa.statespace.varmax import VARMAX
from statsmodels.tsa.api import VAR
from statsmodels.tsa.stattools import grangercausalitytests, adfuller
from tqdm import tqdm_notebook
from itertools import product

import matplotlib.pyplot as plt
import statsmodels.api as sm
import warnings

warnings.filterwarnings('ignore')

filepath = r'/Users/nathanielfremy/PycharmProjects/pythonProject/VAR Economics/data.xlsx'
open(filepath)
macro_data = pd.read_excel(filepath, parse_dates=['date'], index_col='date')
print(macro_data.shape)
macro_data.head()

为什么我得到一个值错误。日期在excel工作表中被标记。
我猜我希望它能读到那个专栏。我以前从来没有真正运行过这个。