How to name a Pandas Series

Question

I have data as follows in a DataFrame symbolData:

              Open      High       Low   Close      Volume  Ex-Dividend  Split Ratio   Adj. Open   Adj. High    Adj. Low  Adj. Close  Adj. Volume
Date
1980-12-12   28.75   28.8700   28.7500   28.75   2093900.0          0.0          1.0    0.424421    0.426193    0.424421    0.424421  117258400.0

When I get just the series with the Adj Close column, I would like to give it a name:

adjClose = symbolData.ix[:,10]

Right now, the above looks like

Date
1980-12-12      0.424421

I would like it to look like

                AlgoClose
Date                   
1980-12-12      0.424421

Answer 1

You can rename the Series and then use .to_frame to convert it to a dataframe. Also, it's better to use iloc instead of ix as it's going to be deprecated in the future.

df.iloc[:,10].rename('AlgoClose').to_frame()
Out[20]: 
            AlgoClose
Date                 
1980-12-12   0.424421

Answer 2

This will do the job:

adjClose = symbolData.ix[:,10].rename("AlgoClose")
adjClose =pd.DataFrame(adjClose)