datetime (with 0 for time) returns as iso formatted string instead of date formatted cell

[fzumstein]

example to replicate

  CSV_URL = "https://raw.githubusercontent.com/datasets/covid-19/main/data/countries-aggregated.csv"

  # Fetch CSV data using httpx
  with httpx.Client() as client:
      response = client.get(CSV_URL)
      response.raise_for_status()  # Raise an error for bad responses

  # Convert the response text into a Pandas DataFrame
  df = pd.read_csv(io.StringIO(response.text))


  # Perform some basic data cleaning
  df['Date'] = pd.to_datetime(df['Date'])

this should also not happen:

 UserWarning: Discarding nonzero nanoseconds in conversion.
  return x.to_pydatetime().replace(tzinfo=None).isoformat()