Python 3.5 convert values during re-write to new csv -

-

i have csv file writing file, in process want change values based on greater or less than. example, in column in new file (row 2 old one) want transform data number word, depending on value in column. actual data has more columns, , thousands of lines, not exceeding 10k lines. example below:

input.csv duck,35,35 car,100,502 baseball,200,950 gun,500,495 taco,300,300 guitar,100,700 barbie, 200,25 gum,300,19  desired output.csv duck,35,35,order car,100,502,order next month baseball,200,950,no order necessary gun,500,495,order next month taco,300,300,order next month guitar,100,700,order next month barbie, 200,25,order urgent gum,300,19,order urgent

this code far, i'm having trouble conversion of amount new value. think need use enumerate, haven't found examples in research of csv conversion method. please assist. 

import csv  open('interim results.csv', 'r') source:   rdr = csv.reader(source)   open('interim results fixed.csv', 'w', newline = '') result:     wtr = csv.writer(result)     r in rdr:       wtr.writerow( ( r[0], r[1], r[2] ) )

edit: taking anonymous' advice, came below code. problem somewhere in "if" / "elif" statments not able correct output. output currenlty not correct, listed below. please assist.

import  csv  code0 = '25' code1 = '50' code2 = '500' code3 = '900'  open('input.csv', 'r')   source, open('output.csv', 'w')   result:      reader = csv.reader(source)      writer = csv.writer(result)       row in  reader:          val = row[2]     if val <= code0: # below 25 order urgent             writer.writerow( ( row[0], row[1], row[2], 'order urgent'))     elif val <= code1: # below 50 order         writer.writerow( ( row[0], row[1], row[2], 'order now'))     elif val <= code2: # below 500 order next month         writer.writerow( ( row[0], row[1], row[2], 'order next month'))     elif val < code3: # below 900 order next month         writer.writerow( ( row[0], row[1], row[2], 'order next month'))     elif val >= code3: #over 900 no order necessary         writer.writerow( ( row[0], row[1], row[2], 'no order necessary'))  output.csv duck,35,35,order car,100,502,order next month baseball,200,950,no order necessary gun,500,495,order    (this wrong, should next month) taco,300,300,order    (this wrong, should next month) guitar,100,700,order next month barbie, 200,25,order urgent gum,300,19,order urgent

edit: took route , solved problem anonymou's guidance. please see below worked me: had abandon greater , go ranges. had remove "val" make work right.

import csv  open 'input.csv', 'r') source   rdr = csv.reader(source)   open ('output.csv', 'w', newline = '') result:     wtr = csv.writer(result)     r in rdr:     if int (r[2]) in range(0,36):       wtr.writerow ( ( r[0], r[1], 'order urgent' ) )     elif int(r[2]) in range(36,51):       wtr.writerow ( ( r[0], r[1], 'order now' ) )     elif int(r[2]) in range(51,501):       wtr.writerow ( ( r[0], r[1], 'order next month' ) )     elif int(r[2]) in range(501,999):       wtr.writerow ( ( r[0], r[1], 'no need order' ) )

you need have function or process data (3rd column). here's way so:

    import csv  # expected codes , replacements codes = {     '50': 'order now',     '999': 'no order necessary',     '500': 'order next month',     'amount available': 'order timeline' }  # can multiple statements in 1 open('input.csv', 'r') fp_in, open('output.csv', 'w') fp_out:     reader = csv.reader(fp_in)     writer = csv.writer(fp_out)      row in reader:         val = row[2].strip() # deal weird spaces          val = codes.get(val, val) # see if known constant, , replace if exists         row[2] = ' ' + val # add space , insert row          writer.writerow(row)

i had add code keep weird spacing file contains. adjust needed.


Comments

Post a Comment

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

-
this error has shown on many times, seems. prominent answer issue seems restkit 0.20 — coredata: error: failed call designated initializer on nsmanagedobject class however, solution posted doesn't work me. let's start beginning: i want upload file server. want parse response make sure uploaded. if not, try again later. model has boolean variable called nsnumber *senttoserver purpose (in coredata, bool saved nsnumber ) . because don't know whether sending going successful, save entity coredata model first before sending via restkit. when post request successful, server returns json string this: {"id":14,"created":true} notice that, of course, id not set on coredata model yet, both id , created new informations model. here's model: @interface recording : nsmanagedobject @property (nonatomic, retain) nsstring * audiofilepath; @property (nonatomic, retain) nsdate * createdat; @property (nonatomic, retain) nsstring * deviceid; @...
Read more

java - Digest auth with Spring Security using javaconfig -

-
so i'm trying create digest authentication spring following documentation trying translate xml "requirements" in java requirements. let's have xml in docs: <bean id="digestfilter" class= "org.springframework.security.web.authentication.www.digestauthenticationfilter"> <property name="userdetailsservice" ref="jdbcdaoimpl"/> <property name="authenticationentrypoint" ref="digestentrypoint"/> <property name="usercache" ref="usercache"/> </bean> <bean id="digestentrypoint" class= "org.springframework.security.web.authentication.www.digestauthenticationentrypoint"> <property name="realmname" value="contacts realm via digest authentication"/> <property name="key" value="acegi"/> <property name="noncevalidityseconds" value="10"/> </b...
Read more

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -

-
my .env: app_env=local app_debug=true app_key=myappkey app_url=http://localhost db_connection=mysql db_host=localhost db_port=3306 db_database=gestiontaller db_username=root db_password='root' cache_driver=file session_driver=file queue_driver=sync redis_host=127.0.0.1 redis_password=null redis_port=6379 mail_driver=smtp mail_host=mailtrap.io mail_port=2525 mail_username=null mail_password=null mail_encryption=null i've tried password ", ' , without, restarting server every time. i've tried changing localhost 172.0.0.1. yes, password correct, running mysql -u root -p introducing password root in prompt can go mysql. users table: +------------------+-----------+ | user | host | +------------------+-----------+ | debian-sys-maint | localhost | | mysql.sys | localhost | | root | localhost | | root1 | localhost | +------------------+-----------+ i've added homestead.yaml this: database_port: 3306 ...
Read more