Python: Store multiple dataframe in list

Question

I have a loop that read Excel sheets in a document. I want to store them all in a list:

  DF_list= list()

  for sheet in sheets:
     df= pd.read_excel(...)
     DF_list = DF_list.append(df)

If I type:

[df df df df]

it works.

Sorry I have a Matlab background and not very used to Python, but I like it. Thanks.

Answer 1

.append() modifies a list and returns None. You override DF_list with None in your first loop and the append will fail in the second loop.

Therefore:

DF_list = list()

for sheet in sheets:
    DF_list.append(pd.read_excel(...))

Or use a list comprehension:

DF_list = [pd.read_excel(...) for sheet in sheets]