How to use multiple pandas functions in a single variable python

Question

I want to drop a column level and columns to the right, from data downloaded from yahoo finance.

FAANG = yf.download(['AAPL','GOOGL','NFLX','META','AMZN','SPY'],
                    start = '2008-01-01',end = '2022-12-31')
FAANG_AC = FAANG.drop(FAANG.columns[6:36],axis=1)

FAC = FAANG_AC.droplevel(0,axis=1)

How do I combine .drop and .droplevel into a single variable, so that I do not have to use multiple variables in this situation?

mozway · Accepted Answer · 2023-01-03 13:38:58Z

3

You don't need to use intermediate variables. You can chain everything:

FAANG = (yf.download(['AAPL','GOOGL','NFLX','META','AMZN','SPY'],
                    start='2008-01-01', end = '2022-12-31')
           .drop(FAANG.columns[6:36], axis=1)
           .droplevel(0, axis=1)
        )

answered Jan 3, 2023 at 13:38

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Comments

cavalcantelucas · Accepted Answer · 2023-01-03 13:38:07Z

1

You can add inplace=True as a parameter for when calling those methods. Like:

FAANG.drop(FAANG.columns[6:36],axis=1, inplace=True)

Careful: it will modify the FAANG variable.

Reference: https://www.askpython.com/python-modules/pandas/inplace-true-parameter

answered Jan 3, 2023 at 13:38

cavalcantelucas

1,3943 gold badges13 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to use multiple pandas functions in a single variable python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related