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’)

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Melanie Zeppel

Women in AI: Agribusiness winner - 2022 Superstar of STEM 2022-2023 Scopus Sustainability Researcher of the Year - 2019