How to create a DataFrame that consists of a list of DataFrames and corresponding Name using Python

Hello polymaths,
The above-mentioned task is important to know for most of the Python Developers working in the Data Field. Imagine, you have several Excel files (or) CSV files (or) a single Excel file with multiple sheets etc. and you want to compute a logic that considers the entire data for calculation -> Obviously, you have to append each file and its corresponding Name to a separate DataFrame that consists of a list of DataFrames to obtain the Output.

Step 1
Create an empty list to append the names of each DataFrame.

Step 2
Create an empty list to append the data related to each DataFrame.

Step 3
Make use of loop concepts to iterate through each DataFrame.

Step 4
Perform Data Cleaning, Transformations etc. if necessary and finally append the data to the previously created empty lists.

Step 5
Create a new DataFrame and assign the data parameter with the above two lists.

Sample Code:-

# Import necessary Libraries
import pandas as pd;

ef=pd.ExcelFile("path/input.xlsx") # Load the Excel File

dataframes=[]; # Empty List to append the data of each File
names=[]; # Empty List to append the name of each File

# Iterate through all the sheets within the Excel object
for i in ef.sheet_names:
    df=ef.parse(i); # Store the data as a DataFrame from each sheet
    df_name=i; # Store the name of the DataFrame from each sheet

    # Perform Data Cleaning and Tranformations, if necessary #

    dataframes.append(df);
    names.append(df_name);

df_final=pd.DataFrame(data={"Name":names, "DataFrame":dataframes}); # Create the Final DataFrame

Done