Iterate over pandas series

python pandas series
Alan picture Alan · May 10, 2018 · Viewed 12.1k times · Source

I want to travel round the series index 

In [44]: type(ed1)
Out[44]: pandas.core.series.Series

In [43]: for _, row  in ed1.iterrows():
...:     print(row.name)

and I get thie error:

  AtributeError: 'Series' ojbect has no attribute 'iterrows'

Is series has any methods like iterrows? thank a lot

Answer

cs95 picture cs95 · May 10, 2018

Series objects define an iteritems method (the data is returned as a iterator of index-value pairs. 

for _, val in ed1.iteritems():
    ...

Alternatively, you can iterate over a list by calling tolist,

for val in ed1.tolist():
    ...

Word of advice, iterating over pandas objects is generally discouraged. Wherever possible, seek to vectorize. To that end, I recommend taking a look at my answer to How to iterate over rows in a DataFrame in Pandas? which discusses better alternatives to iteration.

Related questions

Keep only date part when using pandas.to_datetime

I use pandas.to_datetime to parse the dates in my data. Pandas by default represents the dates with datetime64[ns] even though the dates are all daily only. I wonder whether there is an elegant/clever way to convert …

Read More
Combining two Series into a DataFrame in pandas

I have two Series s1 and s2 with the same (non-consecutive) indices. How do I combine s1 and s2 to being two columns in a DataFrame and keep one of the indices as a third column?

Read More
How to get the first column of a pandas DataFrame as a Series?

I tried: x=pandas.DataFrame(...) s = x.take([0], axis=1) And s gets a DataFrame, not a Series.

Read More