Python CSV read file and select columns and write to new CSV file -


i have csv file has columns need extract. 1 of columns text string need extract first , last items. have print statement in loop need cannot figure out how either data list or dict. not sure best use.

code far: 

f1 = open ("report.csv","r") # open input file reading  users_dict = {} open('out.csv', 'wb') f: # output csv file  writer = csv.writer(f) open('report.csv','r') csvfile: # input csv file     reader = csv.dictreader(csvfile, delimiter=',')     row in reader:         print row['user name'],row['address'].split(',')[0],row['last login datetime'],row['address'].split(',')[7]         users_dict.update(row)         #users_list.append(row['address'].split(','))         #users_list.append(row['last login datetime'])         #users_list.append(row[5].split(',')[7])  print users_dict  f1.close()

input file:

user name,display name,login name,role,last login datetime,address,application,aaa,exchange,comment support,support,support,124,2015-05-29 14:32:26,"test company,bond st,london,london,1111 111,gb,test@test.com,is",,,lse,

output on print:

support test company 2015-05-29 14:32:26

using code, i've got line need:

import csv f1 = open ("report.csv","r") # open input file reading  users_dict = {} open('out.csv', 'wb') f: # output csv file     writer = csv.writer(f)     open('report.csv','r') csvfile: # input csv file         reader = csv.dictreader(csvfile, delimiter=',')         row in reader:             print row['user name'],row['address'].split(',')[0],row['last login datetime'],row['address'].split(',')[7]             users_dict.update(row)             #users_list.append(row['address'].split(','))             #users_list.append(row['last login datetime'])             #users_list.append(row[5].split(',')[7])      print users_dict  f1.close()

the changes:

  • including import csv @ top.
  • indenting code after with open('out.csv' ......

does solve problem?


Comments

Post a Comment

Popular posts from this blog

powershell Start-Process exit code -1073741502 when used with Credential from a windows service environment -

i'm running strange behavior powershell start-process call. here call: $process = start-process ` "c:\somepath\mybinary.exe" ` -passthru ` -credential $defaultcredential ` -wait ` -workingdirectory "c:\somepath" ` -loaduserprofile if ($process.exitcode -ne 0) { #do } this call return exit code - 1073741502 . after quick search, exit code seems related generic error when program not load required dll (aka. status_dll_init_failed ). when run without -credential $credential program runs correctly. in order isolate problem, manually launched some.exe in prompt target credential , runs smoothly. so problem seems come way start-process cmdlet launch process. i found potential solutions problem tried apply no luck : link , link . would have idea of what's going on here ? edit 1: run proc mon monitoring program activities when launched directly or via powershell script. problem seems occur when loading kernelbase
Read more

twig - Using Twigbridge in a Laravel 5.1 Package -

i'm trying create laravel 5.1 package uses twigbridge instead of .php views. can normal .php views display fine, when try make use of .twig templates i'm met error. possible use twigbridge templates when creating views laravel package or pretty stuck blade , php ? edit 1: loading twig template without extending works. it's when start using {% extends 'file' %} error comes out. i error error loading /virtual/laravel/packages/username/mypackage/src/views/sample.twig: template "templates.master" not defined () in "/virtual/laravel/packages/username/mypackage/src/views/sample.twig" @ line 1. my folders username |_ mypackage |_ src |_ controllers - samplecontroller.php |_ views |_ templates - master.twig - sample.twig twig template sample.twig {% extends 'templates.master' %} {% block content %} {{ parent()
Read more

c# - LINQ join Entities from HashSet's, Join vs Dictionary vs HashSet performance -

i have hashset's each stores t, have written test application compares different relation algorithms can think of, i'm not pleased results getting. does there exist more efficient ways of achieving object relations, once testing? using system; using system.collections.generic; using system.linq; using system.text; using system.threading.tasks; using system.diagnostics; namespace linqtests { class program { static void main(string[] args) { hashset<user> usertable = new hashset<user>(); hashset<userproperty> userpropertytable = new hashset<userproperty>(); #region lets create dummy data. console.writeline("please wait while creating dummy data, can take while..."); console.writeline(""); int rows = 1000000; for(int x = 0; x < rows; x++) { random rnd = new random(); // ad
Read more