csv - Python path file from command line -


i have working script below have little problem when try launch script windows command line or windows task manager.

when run script pycharm or idle works charm. when try use commande line this:

py -2.7 "c:\users\bob\google drive\pycharmpoject\flux_update\ajout_data.py"

it not work. says ioerror:[errno 2] no such file or directory: 'c:\users\source_csv\drop\drop-2015-07-09.csv

it looks missing path c:\users\bob\google drive\pycharmpoject\flux_update\source_csv\drop-2015-07-09.csv

any idea

import csv import datetime import shutil  #declaration du jour  jour = datetime.date.today()  infile  = os.path.abspath('../source_csv/drop-'+str(jour)+'.csv') outfile = os.path.abspath('../source_csv/drop_updated-'+str(jour)+'.csv')  #ajout des columns necessaires  open(infile, 'r') csvinput:     open(outfile, 'wb') csvoutput:         writer = csv.writer(csvoutput, lineterminator='\n')         reader = csv.reader(csvinput, delimiter=",")     '''next(reader)'''          = []         row = next(reader)         row in reader:              if float(row[6]) < 20:                 row.append(float(row[6])*(0.88*1.53))                 row.append(2.99)             elif float(row[6]) < 40:                 row.append(float(row[6])*(0.88*1.40)-6.99)                 row.append(7.99)             else:                 row.append(float(row[6])*(0.88*1.30)-29.99)                 row.append(29.99)              all.append(row)          row in reader:             row.append(row)             all.append(row)          writer.writerow( ('name','description') )         writer.writerows(all) 

the relative paths in script interpreted relative current directory.

if have type commands long as: py -2.7 "c:\users\bob\google drive\pycharmpoject\flux_update\ajout_data.py" current directory not "c:\users\bob\google drive\pycharmpoject\flux_update" should be.


Comments