title: AttributeError: Can only use .dt accessor with datetimelike values but cells contain date time
body: <p>I encounter the following error when using Pandas. I looked for other solutions on StackOverflow but they didn't solve my error.</p>
  <p>Code:</p>
  <pre><code>import pandas as pd
  df = pd.read_csv(&quot;my_csv_content_below.csv&quot;)
  df[&quot;timestamp&quot;] = pd.to_datetime(df[&quot;timestamp&quot;])
  df[&quot;timestamp&quot;] = df[&quot;timestamp&quot;].dt.tz_convert(timezone_for_plot)
  </code></pre>
  <p>Error:</p>
  <pre><code>Traceback (most recent call last):
    File &quot;&lt;input&gt;&quot;, line 1, in &lt;module&gt;
    File &quot;.../venv/lib/python3.6/site-packages/pandas/core/generic.py&quot;, line 5137, in __getattr__
      return object.__getattribute__(self, name)
    File &quot;.../venv/lib/python3.6/site-packages/pandas/core/accessor.py&quot;, line 187, in __get__
      accessor_obj = self._accessor(obj)
    File &quot;.../venv/lib/python3.6/site-packages/pandas/core/indexes/accessors.py&quot;, line 480, in __new__
      raise AttributeError(&quot;Can only use .dt accessor with datetimelike values&quot;)
  AttributeError: Can only use .dt accessor with datetimelike values
  </code></pre>
  <p>DataFrame:</p>
  <pre><code>&gt;&gt;&gt; df[&quot;timestamp&quot;]
  0       2021-09-01 04:59:46+00:00
  1       2021-09-01 04:59:46+00:00
  2       2021-09-01 04:59:37+00:00
  3       2021-09-01 04:59:37+00:00
  4       2021-09-01 04:59:24+00:00
                    ...            
  1418    2021-09-01 04:56:50-04:00
  1419    2021-09-01 04:56:25-04:00
  1420    2021-09-01 04:56:24-04:00
  1421    2021-09-01 04:56:14-04:00
  1422    2021-09-01 04:56:14-04:00
  Name: timestamp, Length: 1423, dtype: object
  </code></pre>
  <p>Data type:</p>
  <pre><code>&gt;&gt;&gt; from datetime import datetime
  &gt;&gt;&gt; assert all([type(x) is datetime for x in df[&quot;timestamp&quot;]])
  True
  </code></pre>
  <p>DataFrame stored as CSV can be downloaded <a href="https://drive.google.com/file/d/1Pems8yRocGPfnvubW5ghPL59xeX5oMDN/view?usp=sharing" rel="nofollow noreferrer">here</a>. Here's a sample for future reference:</p>
  <pre><code>,timestamp
  0,2021-09-01 04:59:46+00:00
  1,2021-09-01 04:59:46+00:00
  2,2021-09-01 04:59:37+00:00
  3,2021-09-01 04:59:37+00:00
  4,2021-09-01 04:59:24+00:00
  5,2021-09-01 04:59:24+00:00
  6,2021-09-01 04:59:14+00:00
  7,2021-09-01 04:59:14+00:00
  8,2021-09-01 04:59:03+00:00
  9,2021-09-01 04:59:03+00:00
  ...
  </code></pre>