Converting Indices of Series to Columns

user131983

I need to convert the Indices of a Series amounts into its Columns. For example, I need to convert:

     1983-05-15      1
     1983-11-15      1
     1984-05-15      1
     1984-11-15     101

into:

     1983-05-15      1983-11-15      1984-05-15      1984-11-15
             1               1               1              101

I wasn't able to find any documentation on doing this for Series type Objects specifically and don't know how to do this.

Thank You

chrisb

Build a DataFrame out of your Series, then the .T property returns a transposed version.

In [87]: pd.DataFrame(s).T
Out[87]: 
   1983-05-15  1983-11-15  1984-05-15  1984-11-15
0           1           1           1         101

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Converting Pandas Series to a List with indices preserved

From Dev

Pandas/Python Converting a series with two columns into a dataframe

From Dev

Pandas/Python Converting a series with two columns into a dataframe

From Dev

Editing Indices of Pandas Series

From Dev

Fill columns using indices

From Dev

Converting a pandas multi-index series to a dataframe by using second index as columns

From Dev

Converting day names to series

From Dev

Assign series to DataFrame with unequal indices

From Dev

Converting tuples to multiple indices in a Pandas Dataframe

From Dev

Converting dictionary with known indices to a multidimensional array

From Dev

Converting tuples to multiple indices in a Pandas Dataframe

From Dev

Pandas concatenate, with no duplicate indices or columns

From Dev

Numpy find indices of matching columns

From Dev

Pandas concatenate, with no duplicate indices or columns

From Dev

Converting rows to columns in R

From Dev

Converting rows to columns

From Dev

Converting rows into columns tsql

From Dev

Converting rows to columns

From Dev

Converting columns to strings

From Dev

Converting text to columns

From Dev

converting columns to postgresql database

From Dev

Converting columns to character with sapply

From Dev

Javascript - Converting columns into rows

From Dev

Converting rows in columns in R

From Dev

Converting TimeStamp Series into minutes Series data || Python

From Dev

Converting a hierarchicaly indexed Series to a sequence

From Dev

Efficiently converting a Series of dictionaries to a DataFrame

From Dev

Converting a pandas series output to string

From Dev

How to broadcast pandas series with different indices?

Related Related

HotTag

Archive