Search code examples
pythonwindowscsvdirectorypermission-denied

How to create csv file in a specific folder with Python?


I try to create multiple csv file with Python in a specific folder. But i got a "PermissionError: [Errno 13] Permission denied"

import csv
import os 

compteur = 0 
os.chmod(r'C:\Users\vion1\Ele\Engie\Exercices\concept\create_multiple_file', 436)
for i in range(20):
    compteur += 1
    filename = ("Pikachu{}".format(compteur))
    with open(r'C:\Users\vion1\Ele\Engie\Exercices\concept\create_multiple_file', "a") as folder:
        filewriter = csv.writer(filename, delimiter=',',
                                quotechar='|', quoting=csv.QUOTE_MINIMAL)
        filewriter.writerow(['Name', 'Profession'])
        filewriter.writerow(['Derek', 'Software Developer'])
        filewriter.writerow(['Steve', 'Software Developer'])
        filewriter.writerow(['Paul', 'Manager'])


Solution

  • So, i can't find where to say "i want the created file in this specific folder", so i did it with Powershell. If someone wonder how to do it :

    1..5 | foreach { new-item -path C:\Users\vion1\Ele\Engie\Exercices\concept\create_multiple_file\folder\Pikachu$_.csv }