Pandas - name a column in a Series and plot it

Question

With Python 2.7 and notebook, I am trying to display a simple Series that looks like:

year
2014    1
2015    3
2016    2
Name: mySeries, dtype: int64

I would like to:

Name the second column, I cant seem to succeed with s.columns = ['a','b']. How do we do this?
Plot the result where the years are written as such. When I run s.plot() I get the years as x, which is good but I get weird values:

Thanks for the help!

If it helps, this series comes from the following code:

df = pd.read_csv(file, usecols=['dates'], parse_dates=True)
df['dates'] = pd.to_datetime(df['date'])
df['year'] = pd.DatetimeIndex(df['dartes']).year
df

which gives me:

    dates   year
0   2015-05-05 14:21:00     2015
1   2014-06-06 14:22:00     2014
2   2015-05-05 14:14:00     2015

On which I do: s = pd.Series(df.groupby('year').size())

You have a Series so by definition it's 1-D so you can't assign multiple values to columns — EdChum
– EdChum, Commented May 10, 2016 at 9:30

jezrael · Accepted Answer · 2016-05-10 11:37:14Z

1

For me works cast index to string by astype:

print s
y
2014    1
2015    3
2016    2
Name: mySeries, dtype: int64

s.index = s.index.astype(str)
s.plot()

answered May 10, 2016 at 11:37

jezrael

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

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

1 Comment

Flag Over a year ago

Great, thank you very much. Still not too familiar with Pandas! :)

B. M. · Accepted Answer · 2016-05-10 10:25:40Z

0

just cast your index before :

df.set_index(df.index.astype(str),inplace=True)

then you will have what you expect.

answered May 10, 2016 at 10:25

B. M.

18.7k2 gold badges40 silver badges56 bronze badges

1 Comment

Flag Over a year ago

Thank you, but unfortunately I am working with a Series ('Series' object has no attribute 'set_index'). I tried doing this on the df that my series comes from, but then I dont know how to groupy the index value.

Collectives™ on Stack Overflow

Pandas - name a column in a Series and plot it

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related