How to fix AttributeError: 'Series' object has no attribute 'find'?

Question

I am trying to play with some online data, and having some trouble plotting it due to an 'Attribute' error in the plot function

# Reading data from an online data sets
import pandas as pd
import requests, zipfile, StringIO
r = requests.get('https://archive.ics.uci.edu/ml/machine-learning-databases/00287/Activity Recognition from Single Chest-Mounted Accelerometer.zip')
z = zipfile.ZipFile(StringIO.StringIO(r.content))
activity_files = [name for name in z.namelist() if name.endswith('.csv')]

# Loading it to a pandas dataframe
z_data = z.read(activity_files[4]).split('\n')
activity_data = pd.DataFrame([z.split(',') for z in z_data], columns=('Seq','Ax','Ay','Az','Label'))


# Filtering
working_desk_data = activity_data[activity_data.Label == '1']
standing_data = activity_data[activity_data.Label == '3']
walking_data = activity_data[activity_data.Label == '4']

# Plotting
plt.plot(walking_data['Seq'], walking_data['Ax']) # <--- Error
plt.plot(walking_data['Seq'], walking_data['Ay']) # <--- Error
plt.plot(walking_data['Seq'], walking_data['Az']) # <--- Error
plt.show()

Any workarounds or pointing me to the right direction would be helpful ? I can plot the following, so I am clearly misunderstanding something above.

plt.plot(range(1,5), [1,2,1,2])
plt.show()

Edit: (Added data for Julien Spronck)

walking_data.head()
Out[12]:
Seq Ax  Ay  Az  Label
22950   22950   1978    2386    1988    4
22951   22951   1977    2387    1990    4
22952   22952   1983    2390    1994    4
22953   22953   1978    2396    1994    4
22954   22954   1980    2387    1992    4

walking_data.columns
Out[79]:
Index([u'Seq', u'Ax', u'Ay', u'Az', u'Label'], dtype='object')
In [80]:

type(walking_data.Seq)
Out[80]:
pandas.core.series.Series
In [81]:

type(walking_data.Ax)
Out[81]:
pandas.core.series.Series

It would be useful to post the whole error you get, especially when you tried DSM's answer. — Ajean
– Ajean, Commented Apr 3, 2015 at 21:15

DSM · Accepted Answer · 2015-04-03 18:10:32Z

7

plot is getting confused because you're passing it strings, not numbers. If you convert them to (say) floats:

walking_data = walking_data.astype(float)

Then you'll get

walking plot

answered Apr 3, 2015 at 18:10

DSM

355k67 gold badges606 silver badges504 bronze badges

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

3 Comments

amehta Over a year ago

I did try that and again, but still not working for me

durbachit Over a year ago

ValueError: could not convert string to float: - could it be due to missing values? How can I get around the NaN?

Habib Karbasian Over a year ago

For missing value, you can use data.fillna(value=''). For ValueError, you can use try and except ValueError, e then you can catch bad data and replace them with some default value.

Andy Hayden · Accepted Answer · 2015-04-03 18:07:55Z

1

Use the DataFrame plot method:

walking_data.plot('Seq', ,'Ax')

answered Apr 3, 2015 at 18:07

Andy Hayden

378k110 gold badges640 silver badges546 bronze badges

Collectives™ on Stack Overflow

How to fix AttributeError: 'Series' object has no attribute 'find'?

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related