juanluisrto

import pandas as pd, os,  shutil

df = pd.read_excel("Free+English+textbooks.xlsx")

for cat in df["English Package Name"].unique():
    os.mkdir("download/" + cat)
    
for index, row in df.iterrows():
        category = row.loc["English Package Name"]
        file_name = f"{row.loc['Book Title']}_{row.loc['Edition']}".replace('/','-').replace(':','-')