Advertisement
Guest User

Untitled

a guest
Aug 1st, 2015
295
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. import csv
  2.  
  3. # open file
  4. with open('ProgramData.csv', 'r') as csvfile:
  5.  
  6.  
  7. # add two more columns
  8. new_csv = csvfile.read().replace('Location', 'City,State')
  9.  
  10.  
  11. # replace the " " for two fields
  12. new_csv = new_csv.replace('\"', ' ')
  13.  
  14. with open('Normalized.csv', 'w') as csv_write:
  15. csv_write.write(new_csv)
  16.  
  17.  
  18.  
  19. with open('Normalized.csv', 'r') as csvnorm:
  20.  
  21. # Get the reader
  22. reader = csv.DictReader(csvnorm)
  23.  
  24. # Header to write
  25. header = reader.fieldnames
  26.  
  27.  
  28. with open('Normalized.csv', 'w') as csv_write:
  29. writer = csv.DictWriter(csv_write, fieldnames=header)
  30.  
  31. writer.writeheader()
  32.  
  33. # For each row
  34. for row in reader:
  35.  
  36. print(row['Cost'], row['Months full-time'])
  37.  
  38. try:
  39. row['Cost/Month'] = int(row['Cost']) // int(row['Months full-time'])
  40.  
  41. except ValueError:
  42. row['Cost/Month'] = 0
  43.  
  44. except TypeError:
  45. row['Cost/Month'] = 0
  46.  
  47.  
  48. #print('Cost per month:',row['Cost/Month'], '\n')
  49.  
  50. # Get the writer
  51. writer = csv.DictWriter(csv_write, fieldnames=row.keys())
  52. writer.writerows([row])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement