How to name a Pandas Series
This will do the job:
adjClose = symbolData.ix[:,10].rename("AlgoClose")
adjClose =pd.DataFrame(adjClose)
after you define your series with ix
, you can set its name with:
adjClose.name = 'adjClose'
or, you could keep the original column-name when you define the series, like this:
adjClose = symbolData['Adj. Close']
this 'named series' won't display quite how you asked for though, it will display like:
Date
1980-12-12 0.424421
Name: adjclose, dtype: float64
if it's more important to display as you want, rather than to keep it a series, than convert it to a one-column DataFrame
like in Miriam's answer.