Format a string for SQL IN statement from Pandas Dataframe Column

pd-regex-list.md

The following snippet generates a regex string that can be used to query DF's

r = "'("
for i in df['columnA']:
    r = r+str(i)+"|"
r = r[:-1]+")'"

pd-sql-in.md

The following formats a Pandas DF column into a list for an SQL IN statement

s ='('
for i in df['columnA']:
    s = s+"'"+str(i)+"',"
s = s[:-1]+')'

Which would be used as follows:

sql = """
SELECT 
      COL1
      ,COL2
  FROM TABLE1
  WHERE COL1 in 
"""
sql = sql + s

df_new = pd.read_sql(sql, cnxn)