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

dataframe, pandas, python, series

Solution

>>> import pandas as pd
>>> df = pd.DataFrame({'x' : [1, 2, 3, 4], 'y' : [4, 5, 6, 7]})
>>> df
   x  y
0  1  4
1  2  5
2  3  6
3  4  7
>>> s = df.ix[:,0]
>>> type(s)
<class 'pandas.core.series.Series'>
>>>

===========================================================================

UPDATE

If you're reading this after June 2017, `ix` has been deprecated in pandas 0.20.2, so don't use it. Use `loc` or `iloc` instead. See comments and other answers to this question.

Problem

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

Original source

Related problems