pigeon/data_load.py
def load_multiple_sheets(path, header, na_vals):
    """
    Load excel file with multiple sheet as one dataframe
    :param path: String, path to the file
    :param header: Int/Array, position of the beginning of dataframe
    :param na_vals: String, NA values
    :return: dataframe
    """
    all_dfs = pd.read_excel(path, header=header, sheet_name=None, na_values=na_vals)
    concatenated = pd.concat(all_dfs, ignore_index=True)
    clean = concatenated.dropna(axis=1, how='all')
    return clean

    Load excel file with multiple sheet as one dataframe
    :param path: String, path to the file
    :param header: Int/Array, position of the beginning of dataframe
    :param na_vals: String, NA values
    :return: dataframe
    
Load excel file with multiple sheet as one dataframe
Load excel file with multiple sheet as one dataframe
def load_multiple_sheets(path, header, na_vals):
    all_dfs = pd.read_excel(path, header=header, sheet_name=None, na_values=na_vals)
    concatenated = pd.concat(all_dfs, ignore_index=True)
    clean = concatenated.dropna(axis=1, how='all')
    return clean
def load_multiple_sheets ( path , header , na_vals ) : all_dfs = pd . read_excel ( path , header = header , sheet_name = None , na_values = na_vals ) concatenated = pd . concat ( all_dfs , ignore_index = True ) clean = concatenated . dropna ( axis = 1 , how = 'all' ) return clean
Load excel file with multiple sheet as one dataframe
Load excel file with multiple sheet as one dataframe
"""
    Load excel file with multiple sheet as one dataframe
    :param path: String, path to the file
    :param header: Int/Array, position of the beginning of dataframe
    :param na_vals: String, NA values
    :return: dataframe
    """
None
path
String, path to the file
String path to the file
header
Int/Array, position of the beginning of dataframe
Int / Array position of the beginning of dataframe
na_vals
String, NA values
String NA values