title: Is there a way to check and load missing data to SQL?
body: <p>I am trying to figure out a way to check data I am loading into a SQL table from a dataframe so I can load missing data and avoid loading duplicate data.</p>
  <p>Here is a really rough idea.</p>
  <pre><code>sql_data = []
  data = [(2020-01-01, Monday, 20, 0.1), (2020-01-02, Tuesday, 12, 0.4), (2020-01-01, Wednesday, 26, 0.3)]
            
          
  cursor.execute('''Select * FROM Table ''')
  for row in cursor.fetchall():
     sql_data.append(row)
      
  if data in sql_data:
     pass
  else:
     query = '''INSERT INTO Table (Time, Day, Number, Decimal)
                                   VALUES (?, ?, ?, ?)'''
     cursor.execute(query, data)
     conn.commit()
  </code></pre>