Pandas read_html error - NoneType object has no attribute 'items'

Question

I am trying to load a wikipedia table into a pandas dataframe, but I keep receiving an error notification ''NoneType' object has no attribute 'items''. I believe Python is importing the data as a list instead of a dataframe, but when I run df = data[0], i figured that was extracting a df. I've tried a few ways, but going with the simple code for now:

url = 'http://en.wikipedia.org/wiki/List_of_postal_codes_of_Canada:_M'
data = pd.read_html(url)
df = data[0]
df

when I check the type of df, pandas tells me its a dataframe (pandas.core.frame.dataframe) I consistently receive the following error message: error message

Thanks in advance.. having a tough time with this

it just works for me. python 3.7.6 pandas 1.1

Rob Raymond
– Rob Raymond

2020-08-17 06:47:40 +00:00
Commented Aug 17, 2020 at 6:47 — Rob Raymond
– Rob Raymond, Commented Aug 17, 2020 at 6:47

Jie Shen · Accepted Answer · 2020-10-17 13:21:35Z

1

It seems that your data contains mixed types that pandas did not capture when loading the data from url. You may try adding low_memory=False when doing pd.read_html()

answered Oct 17, 2020 at 13:21

Jie Shen

192 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas read_html error - NoneType object has no attribute 'items'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related