KeyError: "None of [Index(['Year', 'Revenue(mil. USD)'], dtype='object')] are in the [columns]"

[manujosephv]

Posting an issue I received through email:

in Chapter 3, notebook "02-Decomposing Time Series.ipynb", I get an error in the line:

tesla_revenue = pd.read_html("https://en.wikipedia.org/wiki/Tesla,_Inc.")[4][['Year', "Revenue(mil. USD)"]]

Error:

KeyError: "None of [Index(['Year', 'Revenue(mil. USD)'], dtype='object')] are in the [columns]"

In this loaded file there are no columns „Year“ and „Revenue“.

[manujosephv]

Wikipedia has since been updated and now there are more tables and hence the code is breaking.

Two solutions:

tesla_revenue = pd.read_html("https://en.wikipedia.org/wiki/Tesla,_Inc.")[5][['Year', "Revenue(mil. USD)"]]

But this is brittle and may break in the future.

Instead, we can fix the wiki link to an archived one

tesla_revenue = pd.read_html("https://en.wikipedia.org/w/index.php?title=Tesla,_Inc.&oldid=1111822107")[4]

[Laoban-man]

tesla_revenue = pd.read_html("https://en.wikipedia.org/wiki/Tesla,_Inc.")[8][['Year', "Revenue(mil. USD)"]], now