Python Pandas AttributeError: 'Series' object has no attribute 'columns' [duplicate]

Question

This code :

import pandas as pd

data = pd.read_csv('house', sep="\t", header=None)
data.columns = ['label', 'msg']
data['msg_length'] = data['msg'].apply(lambda x: len(x))
data['msg'].hist(column =data['msg_length'], by=data['label'], bins=50)

Gives me this error:

AttributeError: 'Series' object has no attribute 'columns' `

I have tried different things with pd.DataFrame and pd.Series, without luck. What do i wrong?

Result of pd.read_csv:

Expected output:

Error code:

if data is a pd.Series, it indeed has no columns. Can you check its type - what is the result of the pd.read_csv? — Itamar Mushkin
– Itamar Mushkin, Commented Oct 28, 2019 at 11:23
Do you need data.hist(column ='msg_length', by='label', bins=50) ? — jezrael
– jezrael, Commented Oct 28, 2019 at 11:24

jezrael · Accepted Answer · 2019-10-28 12:21:12Z

1

Use DataFrame.hist with columns in strings instead Series like data['msg_length']:

data.hist(column ='msg_length', by='label', bins=50)

answered Oct 28, 2019 at 12:21

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

CAPSLOCK · Accepted Answer · 2019-10-28 12:46:39Z

0

data.hist(column ='msg_length', by='label')

did the job

edited Oct 28, 2019 at 12:46

CAPSLOCK

6,5333 gold badges38 silver badges60 bronze badges

answered Oct 28, 2019 at 12:18

radonrace

611 gold badge1 silver badge7 bronze badges

Collectives™ on Stack Overflow

Python Pandas AttributeError: 'Series' object has no attribute 'columns' [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related