CODEWITHSUNDEEP
pythonpandasdataframe
yensheng
yensheng

Reputation: 1325

How to change python dataframe's content?

I have a dataframe df:

                  Open    Volume  Adj Close     Ticker  
Date                                                                   
2006-11-22  140.750000   45505300   114.480649   SPY 
2006-11-22  100.470001     274000   72.382071    AGG

I want to change df to another dataframe Open price like below:

                  SPY    AGG  
Date                                                                   
2006-11-22  140.750000  100.470001

It only use open's data and two tickers, so how to change one dataframe to another?

Thank you very much.

Upvotes: 1

Views: 109

Answers (1)

jezrael
jezrael

Reputation: 862641

You can use DataFrame.pivot with reset_index:

df = df.reset_index().pivot(index='Date', columns='Ticker', values='Open')
print (df)
Ticker             AGG     SPY
Date                          
2006-11-22  100.470001  140.75

Or pandas.pivot:

df = pd.pivot(index=df.index, columns=df.Ticker, values=df.Open)
print (df)
Ticker             AGG     SPY
Date                          
2006-11-22  100.470001  140.75

Upvotes: 1

Related Questions