Search code examples
pandasdataframeseries

Getting NaN converting pandas Dataframe to Series

I am trying to convert pandas Dataframe to Series based on accepted answer to Convert dataframe to series for multiple column

However I am getting NaN in my integer column 'y'.

Here is my code:

data = [['2021-10-14 18:12:00.000', '22811316'],['2021-10-14 18:42:00.000', '22700704']]
df = pd.DataFrame(data, columns = ['ds', 'y'])
series = pd.Series(df.y, index=df.ds)

printing series gives me:

ds
2021-10-14 18:12:00.000    NaN
2021-10-14 18:42:00.000    NaN
Name: y, dtype: object

What am I missing?

Solution

  • I could find the answer in pandas.Series() Creation using DataFrame Columns returns NaN Data entries

    The trick was to use:

    series = pd.Series(df.y.values, index=df.ds)