Adding multiple column names when creating a pandas dataframe

Question

Scenario: I am testing a code I found at http://www.pythonforfinance.net/2017/01/21/investment-portfolio-optimisation-with-python/ to create some portfolios based on my data.

Issue: In the example given, the code is run with 4 stocks, while I am running my code with 779. there is a line in the code that converts one array into a pandas dataframe:

results_frame = pd.DataFrame(results.T,columns=['ret','stdev','sharpe',stocks[0],stocks[1],stocks[2],stocks[3]])

Is this line, columns are created for 4 stocks.

Question: Since i am doing this with 779, it would take to long to input the entry for each stock (stocks[0] to stocks[779]). Is there a non-manual way to do this? maybe with a loop?

results.T.columns=['ret','stdev','sharpe'] + stocks

BENY
– BENY

2017-09-24 16:51:28 +00:00
Commented Sep 24, 2017 at 16:51 — BENY
– BENY, Commented Sep 24, 2017 at 16:51

jezrael · Accepted Answer · 2017-09-24 16:46:29Z

1

If in stocks are columns names and it is list you need:

columns=['ret','stdev','sharpe'] + stocks

answered Sep 24, 2017 at 16:46

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DGMS89 Over a year ago

Thank you sir, you just saved me from doing that by hand in excel.

Collectives™ on Stack Overflow

Adding multiple column names when creating a pandas dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related