datareader错误=长度不匹配:预期轴有8个元素,新值有7个元素

oyjwcjzk  于 2021-08-20  发布在  Java
关注(0)|答案(1)|浏览(383)

当我想从st.louis fed导入数据时,python给了我这样一个错误:长度不匹配:预期轴有8个元素,新值有7个元素。我可以通过删除dataframe的最后一列来解决这个错误,但我需要最后一列。我该怎么办?

import matplotlib.pyplot as plt
    import pandas_datareader.data as pdr
    import pandas as pd
    import datetime
    start = datetime.datetime (2000,1,1)
    end = datetime.datetime (2021,5,1)
    df  = pdr.DataReader(['WFRBSB50215', 'WFRBST01134','WFRBST01122', 'WFRBSN09139', 'WFRBSB50189', 'WFRBST01110','WFRBSB50191','WFRBSN09148'],'fred',start, end)
    df.columns = ['Share of Total Net Worth Held by the Bottom 50% (1st to 50th Wealth Percentiles)',
                  'Share of Total Net Worth Held by the Top 1% (99th to 100th Wealth Percentiles)', 
                  'Share of Corporate Equities and Mutual Fund Shares Helb By Top1%(99th to 100th Wealth Percentiles)', 
                  'Share of Financial Assets Held by the 90th to 99th Wealth Percentiles',
                  'Share of Total Assets Held by the Bottom 50% (1st to 50th Wealth Percentiles)',
                  'Share of Real Estate Held by the Top 1% (99th to 100th Wealth Percentiles)',
                  'Share of Real Estate Held by the Bottom %50(1st to 50th Wealth Percentiles)'
                  'Share of Mortgages Held by the 90th to 99th Wealth Percentiles']
    ax = df.plot(subplots=True, figsize=(12,12), linewidth=3.5, colormap="summer")
    plt.xlabel('Date')
    ax[0,].set_title('Share of Total Net Worth Held by the Bottom 50%')
    ax[0,].set_ylabel('Percent of Aggregate')
    ax[1,].set_title('Share of Total Net Worth Held by the Top 1%')
    ax[1,].set_ylabel('Percent of Aggregate')
    ax[2,].set_title('Share of Corporate Equities and Mutual Fund Shares Helb By Top 1%')
    ax[2,].set_ylabel('Percent of Aggregate')
    ax[3,].set_title('Share of Financial Assets Held by the 90th to 99th Wealth Percentiles')
    ax[3,].set_ylabel('Percent of Aggregate')
    ax[4,].set_title('Share of Total Assets Held by the Bottom 50% ')
    ax[4,].set_ylabel('Percent of Aggregate')
    ax[5,].set_title('Share of Real Estate Held by the Top 1%')
    ax[5,].set_ylabel('Percent of Aggregate')
    ax[6,].set_title('Share of Real Estate Held by the Bottom %50')
    ax[6,].set_ylabel('Percent of Aggregate')
    ax[7,].set_title('Share of Mortgages Held by the 90th to 99th Wealth Percentiles')
    ax[7,].set_ylabel('Percent of Aggregate')
    plt.tight_layout()
    plt.show()
xdyibdwo

xdyibdwo1#

新文档中倒数第二项后缺少逗号 df.columns .
没有它,单独行上的字符串组合在一起,总共7个元素,而不是预期的8个元素。

相关问题