Python-сообщество

 def take_head_of_file_four():
    with open('D:\\proc\\sales_result_sliced.csv', 'r', newline='') as csvfile, open("D:\\proc\\", "w", newline='') as out_file:
         reader = csv.DictReader(csvfile)
                 
         headers = reader.fieldnames
         
         for h in headers:             
             fieldnames = ['', str(h)]         
             writer = csv.DictWriter(os.path.join(out_file,str(h),".csv"), fieldnames=fieldnames)
             counter = 1
             writer.writeheader()
             for row in reader:
                 writer.writerow({'': counter, str(h): row[str(h)]})
                 counter +=1
    #close the files
    csvfile.close()
    out_file.close()

 take_head_of_file_four()
Traceback (most recent call last):
  File "<ipython-input-36-91a8e40fd006>", line 1, in <module>
    take_head_of_file_four()
  File "D:\scripts\Cleancsv.py", line 111, in take_head_of_file_four
    with open('D:\\proc\\sales_result_sliced.csv', 'r', newline='') as csvfile, open("D:\\proc\\", "w", newline='') as out_file:
FileNotFoundError: [Errno 2] No such file or directory: 'D:\\proc\\'

  
ifname = r'D:\proc\sales_result_sliced.csv'
ofname = r'D:\proc\sales_result_sliced_out.csv'
 
with open(ifname, 'r', newline='') as csvfile, \
     open(ofname, "w", newline='') as out_file:
    ...

  
ifname = r'D:\proc\sales_result_sliced.csv'
ofname = r'D:\proc\sales_result_sliced_out.csv'
 
with open(ifname, 'r', newline='') as csvifile, \
     open(ofname, "w", newline='') as csvofile:
    ...

 def take_head_of_file_four():
    
    ifname = r'D:\proc\sales_result_sliced.csv'
    ofname = r'D:\proc'
    
    with open(ifname, 'r', newline='') as csvifile, open(ofname, "w", newline='') as csvofile:
         reader = csv.DictReader(csvifile)
                 
         headers = reader.fieldnames
         
         for h in headers:             
             fieldnames = ['', str(h)]         
             writer = csv.DictWriter(os.path.join(csvofile,str(h),".csv"), fieldnames=fieldnames)
             counter = 1
             writer.writeheader()
             for row in reader:
                 writer.writerow({'': counter, str(h): row[str(h)]})
                 counter +=1
    #close the files
    csvifile.close()
    csvofile.close()

 Traceback (most recent call last):
  File "<ipython-input-2-91a8e40fd006>", line 1, in <module>
    take_head_of_file_four()
  File "D:\scripts\Cleancsv.py", line 115, in take_head_of_file_four
    with open(ifname, 'r', newline='') as csvifile, open(ofname, "w", newline='') as csvofile:
PermissionError: [Errno 13] Permission denied: 'D:\\proc'

 def take_head_of_file_four():
    with open('D:\\proc\\sales_result_sliced.csv', 'r', newline='') as csvfile, open('D:\\proc\\result.csv', 'w', newline='') as outfile:
         reader = csv.DictReader(csvfile)
         counter = 1
         fieldnames = ['Id', 'Total']
         writer = csv.DictWriter(outfile, fieldnames=fieldnames)
         writer.writeheader()
         for row in reader:
                  writer.writerow({'Id': counter, 'Total': row['Total']})
                  counter +=1
    csvfile.close()

 def take_head_of_file_four():
    with open('D:\\proc\\sales_result_sliced.csv', 'r', newline='') as csvfile:
         reader = csv.DictReader(csvfile)
         headers = reader.fieldnames
         prepath = "D:\\proc\\"
         counter = 1  
         for h in headers:
             spath = os.path.join(prepath, str(h) + ".csv")
             with open(spath, 'w', newline='') as out_file:
				 fieldnames = ['Id', str(h)]
                 writer = csv.DictWriter(out_file, fieldnames=fieldnames)
                 writer.writeheader()
                 for row in reader:
                      writer.writerow({'Id': counter, str(h): row[str(h)]})
                      counter +=1
    csvfile.close()

  
>>> import csv
>>> 
>>> lst = ['1,2,3', 'a,b,c', 'aa,bb,cc']
>>> 
>>> reader = csv.DictReader(lst)
>>> reader.fieldnames
['1', '2', '3']
>>> 
>>> list(reader)
[OrderedDict([('1', 'a'), ('2', 'b'), ('3', 'c')]), OrderedDict([('1', 'aa'), ('2', 'bb'), ('3', 'cc')])]
>>>