title: Convert a series of type string to type Date (not Datetime)
body: <p>I have a dataframe with a Date column whose content is: years-months-days of type string. I want to convert this to Date type (not Datetime). The goal is to insert this dataframe into a bigquery table with the Date type.</p>
  <p>I tried:</p>
  <pre><code>df['Date '] = [datetime.strptime(str(i), '%Y-%m-%d') for i in df['Date ']]
  </code></pre>
  <p>But this still returns Datetime format Years-Months-Days Hours:Minutes:Seconds (2022-01-03 00:00:00)</p>
  <p>Someone have an idea to convert this string to type Date:Y-m-d (not Datetime)</p>