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

 def take_columns_from_csv():
       ##Open the file
    infile = open('D:\\proc\\sales_result_sliced.csv', 'r') 
    outfile = open('D:\\proc\\result.csv', 'w', newline='') 
    lines = infile.readlines()
    counter = 1
    for line in lines[0:]: #skip the first line, which is the header
        sline = line.strip() #get rid of trailing newline characters at the end of the line
        sline = sline.split(',')  # separates line into a list of items.  ',' tells it to split the lines at the commas
        #sline.append((counter, sline[0], sline[3])) 
        #print(sline)
        nameString = ', '.join((sline[0], sline[1])) 
        outfile.write(nameString)
        counter = counter + 1   	
    #close the file
    infile.close()
    outfile.close()

 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 out_file:
         reader = csv.DictReader(csvfile)
         writer = csv.writer(out_file)
         for row in reader:
             writer.writerow((row['Company Code'], row['Order Number']))

 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 out_file:
         reader = csv.DictReader(csvfile)
         #fieldnames = ['Company Code', 'Order Number']
         fieldnames = ['Company Code', 'Order Number']
         writer = csv.DictWriter(out_file, fieldnames=fieldnames)
         writer.writeheader()
         for row in reader:
             writer.writerow((row['Company Code'], row['Order Number']))

 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 out_file:
         reader = csv.DictReader(csvfile)
         writer = csv.writer(out_file)
         counter = 1
         fieldnames = ['Company Code', 'Order Number']
         writer = csv.DictWriter(out_file, fieldnames=fieldnames)
         writer.writeheader()
         for row in reader:             
             writer.writerow((counter, row['Company Code'], row['Order Number']))
             counter +=1
    #close the file
    csvfile.close()
    out_file.close()

 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 out_file:
         reader = csv.DictReader(csvfile)
         writer = csv.writer(out_file)
         counter = 1
         fieldnames = ['Company Code', 'Order Number']
         writer = csv.DictWriter(out_file, fieldnames=fieldnames)
         writer.writeheader()
         for row in reader:
             writer.writerow({'Company Code': row['Company Code'], 'Order Number': row['Order Number']})
             counter +=1
    #close the file
    csvfile.close()
    out_file.close() 

  
>>> import csv
>>> import sys
>>> 
>>> writer = csv.writer(sys.stdout)
>>> writer.writerows([['header1', 'header2', 'header3'], [1, 2, 3], ['4', '5', '6'], [None, 'x', 123]])
header1,header2,header3
1,2,3
4,5,6
,x,123
>>>

 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 out_file:
         reader = csv.DictReader(csvfile)
         fieldnames = ['','Company', 'Order Number']
         writer = csv.DictWriter(out_file, fieldnames=fieldnames)
         counter = 1
         writer.writeheader()
         for row in reader:
             writer.writerow({'': counter, 'Company': row['Company Code'], 'Order Number': row['Order Number']})
             counter +=1
    #close the files
    csvfile.close()
    out_file.close()

 for counter,obj  in enumerate(collectio):
 .....

 data={"IBM":{"cost":20,"some":True},
           "GOOGLE":{"cost":30,"some":False},
}