i'm having little trouble python script i'm writing audit csv files firm's many disparate applications, , have done proof of concept bring boss, , show off can python, issue don't understand csv class in python well....
here example of list of computer information looks like:
['eb-abortz,true,false,false,0', 'eb-agoncharova,true,false,false,0', 'eb-ahart-1,true,false,false,0', 'eb-aheidenreich,true,false,false,0', 'eb-alocklear,true,false,false,0', 'eb-amargulis,true,false,false,0', 'eb-asklar,true,false,false,0', 'eb-asklar-1,true,false,false,0', 'eb-asklar-3,true,false,false,0', 'eb-bchow-1,true,false,false,0', 'eb-bjohnson,true,false,false,0', 'eb-blyle,true,false,false,0', 'eb-brussum,true,false,false,0', 'eb-ccleary,true,false,false,0', 'eb-...] and here example of code @ end produces.....
"e","b","-","a","b","o","r","t","z",",","t","r","u","e",",","f","a","l","s","e",",","f","a","l","s","e",",","0" "e","b","-","a","g","o","n","c","h","a","r","o","v","a",",","t","r","u","e",",","f","a","l","s","e",",","f","a","l","s","e",",","0" "e","b","-","a","h","a","r","t","-","1",",","t","r","u","e",",","f","a","l","s","e",",","f","a","l","s","e",",","0" "e","b","-","a","h","e","i","d","e","n","r","e","i","c","h",",","t","r","u","e",",","f","a","l","s","e",",","f","a","l","s","e",",","0" "e","b","-","a","l","o","c","k","l","e","a","r",",","t","r","u","e",",","f","a","l","s","e",",","f","a","l","s","e",",","0" "e","b","-","a","m","a","r","g","u","l","i","s",",","t","r","u","e",",","f","a","l","s","e",",","f","a","l","s","e",",","0" here copy of method i've used try export data csv format after fact.
def collate_computers(computers): open('results.csv', 'w', encoding='utf8', )as outfile: writer = csv.writer(outfile, quoting=csv.quote_all, delimiter=',') c in computers: writer.writerow(c)
the csv writer function, writerow, takes list input , writes each element row. when pass single string function, writer interprets string list of characters.
i assuming want write each row appears in string. instead of using writer.writerow(c), use writer.writerow(c.split(',')). splits string list seperated comma.
your csv file should this:
eb-abortz,true,false,false,0 eb-agoncharova,true,false,false,0 eb-ahart-1,true,false,false,0 eb-aheidenreich,true,false,false,0 eb-alocklear,true,false,false,0 eb-amargulis,true,false,false,0 eb-asklar,true,false,false,0 eb-asklar-1,true,false,false,0 eb-asklar-3,true,false,false,0 eb-bchow-1,true,false,false,0 eb-bjohnson,true,false,false,0 eb-blyle,true,false,false,0 eb-brussum,true,false,false,0 eb-ccleary,true,false,false,0 