Read in files and save elsewhere with new name
for p in range(0, len(property)):
df = pd.read_excel(‘C:/Python39/Projects2/Audit_pack/Property_Standard_Mass_3000Tha/’ + property.iloc[p] + ‘-auditing/6-core-sublayer.xlsx’)
df.to_excel(‘C:/Python39/Projects2/Audit_pack/Unsplining_T1_3000Tha/6-core-sublayer-’ + property.iloc[p] + ‘.xlsx’)