osfrom xlrd import open_workbookimport xlsxwriter as xlsw
dataframesos.walk(path):,for file in files:, if file.endswith(".xlsx"):,f = (os.path.join(root, file)),print(f),dataframes.append(f),all_data = pd.DataFrame (),for f in
dictionaries = [dic_1,dic_2,dic_3,dic_4,dic_5,dic_6] # array of dictionaries
for dict in dictionaries:
dataframes["field_stars_" + dict["stream"]]=pd.read_csv('/home/'+dict["stream"