Zgragselus

Human - Python

Feb 9th, 2026
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.79 KB | None | 0 0
  1. import csv
  2. import re
  3.  
  4. with open("procedure_list.csv", mode="r", newline='\n') as csvfile:
  5.     r = csv.reader(csvfile)
  6.     for row in r:
  7.         code = row[0]
  8.         description = row[1]
  9.         effective_date = row[2]
  10.         end_date = row[3]
  11.  
  12.         if effective_date is None or effective_date == "":
  13.             effective_date = "NULL"
  14.         else:
  15.             effective_date = "'" + effective_date + "'"
  16.  
  17.         if end_date is None or end_date == "":
  18.             end_date = "NULL"
  19.         else:
  20.             end_date = "'" + end_date + "'"
  21.  
  22.         query = "INSERT INTO procedure(active, description, print_description, cpt_code, effective_date, end_date) VALUES('t', '{0}', '{0}', '{1}', {2}, {3});".format(description, code, effective_date, end_date)
  23.         print(query)
  24.  
Advertisement
Add Comment
Please, Sign In to add comment