pandas convert date/time to week - okl - Feb-28-2018
Hi
Below error when trying to convert date/time to week
data.columns
data.index
data['DATECREATED'].dt.week Error: ---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\series.py in _make_dt_accessor(self)
2819 try:
-> 2820 return maybe_to_datetimelike(self)
2821 except Exception:
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\indexes\accessors.py in maybe_to_datetimelike(data, copy)
83 raise TypeError("cannot convert an object of type {0} to a "
---> 84 "datetimelike index".format(type(data)))
85
TypeError: cannot convert an object of type <class 'pandas.core.series.Series'> to a datetimelike index
During handling of the above exception, another exception occurred:
AttributeError Traceback (most recent call last)
<ipython-input-35-dedf61725963> in <module>()
14 data.columns
15 data.index
---> 16 data['DATECREATED'].dt.week
17
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\generic.py in __getattr__(self, name)
3075 if (name in self._internal_names_set or name in self._metadata or
3076 name in self._accessors):
-> 3077 return object.__getattribute__(self, name)
3078 else:
3079 if name in self._info_axis:
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\base.py in __get__(self, instance, owner)
241 # this ensures that Series.str.<method> is well defined
242 return self.accessor_cls
--> 243 return self.construct_accessor(instance)
244
245 def __set__(self, instance, value):
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\core\series.py in _make_dt_accessor(self)
2820 return maybe_to_datetimelike(self)
2821 except Exception:
-> 2822 raise AttributeError("Can only use .dt accessor with datetimelike "
2823 "values")
2824
AttributeError: Can only use .dt accessor with datetimelike values
data['DATECREATED'] Output: 0 26/01/2018
4 23/01/2018
13 07/02/2018 17:35
14 27/01/2018
15 29/01/2018
20 24/01/2018
27 07/02/2018 09:57
31 05/02/2018 11:26
RE: pandas convert date/time to week - okl - Mar-01-2018
anyone please?
RE: pandas convert date/time to week - Larz60+ - Mar-01-2018
Please explain data format details clearly.
Your code snippet doesn't really help.
Just noticed it's pandas. (sometimes I skip headings)
RE: pandas convert date/time to week - marsokod - Mar-03-2018
Can you give us the result of the following?
for i in data['DATECREATED']]:
print(type(i)) My assumption is that you have a datetime.date in some of your rows, and you can only use the .dt.week with purely datetime.datetime values.
If that is the case, you will need to convert them, or change the way your dataframe is filled.
|