import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline
import seaborn as sns
from datetime import datetime
pres_data=pd.read_csv("presidents1.csv")
pres_data['Date'] = pd.to_datetime(pres_data['Birth date'], infer_datetime_format=True)
--------------------------------------------------------------------------- TypeError Traceback (most recent call last) C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py in _convert_listlike(arg, box, format, name, tz) 443 try: --> 444 values, tz = tslib.datetime_to_datetime64(arg) 445 return DatetimeIndex._simple_new(values, name=name, tz=tz) pandas\_libs\tslib.pyx in pandas._libs.tslib.datetime_to_datetime64 (pandas\_libs\tslib.c:33275)() TypeError: Unrecognized value type: <class 'str'> During handling of the above exception, another exception occurred: ValueError Traceback (most recent call last) <ipython-input-27-234cad89fdd8> in <module>() 1 pres_data=pd.read_csv("presidents.csv") 2 ----> 3 pres_data['Date'] = pd.to_datetime(pres_data['Birth date'], infer_datetime_format=True) C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py in to_datetime(arg, errors, dayfirst, yearfirst, utc, box, format, exact, unit, infer_datetime_format, origin) 507 elif isinstance(arg, ABCSeries): 508 from pandas import Series --> 509 values = _convert_listlike(arg._values, False, format) 510 result = Series(values, index=arg.index, name=arg.name) 511 elif isinstance(arg, (ABCDataFrame, MutableMapping)): C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py in _convert_listlike(arg, box, format, name, tz) 445 return DatetimeIndex._simple_new(values, name=name, tz=tz) 446 except (ValueError, TypeError): --> 447 raise e 448 449 if arg is None: C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py in _convert_listlike(arg, box, format, name, tz) 433 dayfirst=dayfirst, 434 yearfirst=yearfirst, --> 435 require_iso8601=require_iso8601 436 ) 437 pandas\_libs\tslib.pyx in pandas._libs.tslib.array_to_datetime (pandas\_libs\tslib.c:46617)() pandas\_libs\tslib.pyx in pandas._libs.tslib.array_to_datetime (pandas\_libs\tslib.c:46233)() pandas\_libs\tslib.pyx in pandas._libs.tslib.array_to_datetime (pandas\_libs\tslib.c:46122)() pandas\_libs\tslib.pyx in pandas._libs.tslib.parse_datetime_string (pandas\_libs\tslib.c:35351)() C:\Users\sphulse\Anaconda\lib\site-packages\dateutil\parser.py in parse(timestr, parserinfo, **kwargs) 1166 return parser(parserinfo).parse(timestr, **kwargs) 1167 else: -> 1168 return DEFAULTPARSER.parse(timestr, **kwargs) 1169 1170 C:\Users\sphulse\Anaconda\lib\site-packages\dateutil\parser.py in parse(self, timestr, default, ignoretz, tzinfos, **kwargs) 557 558 if res is None: --> 559 raise ValueError("Unknown string format") 560 561 if len(res) == 0: ValueError: Unknown string format
#pres_data
def dateparser_SP(string_date):
if(string_date.find(',')>0):
print('In here')
print(string_date)
print (datetime.strptime(string_date,'%b, %d %Y'))
#elif(string_date.find(',')>0):
for date in pres_data['Birth date']:
dateparser_SP(date)
In here Feb 22, 1732
--------------------------------------------------------------------------- ValueError Traceback (most recent call last) <ipython-input-29-d2319a41f9f2> in <module>() 9 10 for date in pres_data['Birth date']: ---> 11 dateparser_SP(date) <ipython-input-29-d2319a41f9f2> in dateparser_SP(string_date) 5 print('In here') 6 print(string_date) ----> 7 print (datetime.strptime(string_date,'%b, %d %Y')) 8 #elif(string_date.find(',')>0): 9 C:\Users\sphulse\Anaconda\lib\_strptime.py in _strptime_datetime(cls, data_string, format) 563 """Return a class cls instance based on the input string and the 564 format string.""" --> 565 tt, fraction = _strptime(data_string, format) 566 tzname, gmtoff = tt[-2:] 567 args = tt[:6] + (fraction,) C:\Users\sphulse\Anaconda\lib\_strptime.py in _strptime(data_string, format) 360 if not found: 361 raise ValueError("time data %r does not match format %r" % --> 362 (data_string, format)) 363 if len(data_string) != found.end(): 364 raise ValueError("unconverted data remains: %s" % ValueError: time data 'Feb 22, 1732' does not match format '%b, %d %Y'
pres_data['date_try']=pd.to_datetime(pres_data['Birth date'])
--------------------------------------------------------------------------- TypeError Traceback (most recent call last) C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py in _convert_listlike(arg, box, format, name, tz) 443 try: --> 444 values, tz = tslib.datetime_to_datetime64(arg) 445 return DatetimeIndex._simple_new(values, name=name, tz=tz) pandas\_libs\tslib.pyx in pandas._libs.tslib.datetime_to_datetime64 (pandas\_libs\tslib.c:33275)() TypeError: Unrecognized value type: <class 'str'> During handling of the above exception, another exception occurred: ValueError Traceback (most recent call last) <ipython-input-14-e16c4634d999> in <module>() ----> 1 pres_data['date_try']=pd.to_datetime(pres_data['Birth date']) C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py in to_datetime(arg, errors, dayfirst, yearfirst, utc, box, format, exact, unit, infer_datetime_format, origin) 507 elif isinstance(arg, ABCSeries): 508 from pandas import Series --> 509 values = _convert_listlike(arg._values, False, format) 510 result = Series(values, index=arg.index, name=arg.name) 511 elif isinstance(arg, (ABCDataFrame, MutableMapping)): C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py in _convert_listlike(arg, box, format, name, tz) 445 return DatetimeIndex._simple_new(values, name=name, tz=tz) 446 except (ValueError, TypeError): --> 447 raise e 448 449 if arg is None: C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\tools\datetimes.py in _convert_listlike(arg, box, format, name, tz) 433 dayfirst=dayfirst, 434 yearfirst=yearfirst, --> 435 require_iso8601=require_iso8601 436 ) 437 pandas\_libs\tslib.pyx in pandas._libs.tslib.array_to_datetime (pandas\_libs\tslib.c:46617)() pandas\_libs\tslib.pyx in pandas._libs.tslib.array_to_datetime (pandas\_libs\tslib.c:46233)() pandas\_libs\tslib.pyx in pandas._libs.tslib.array_to_datetime (pandas\_libs\tslib.c:46122)() pandas\_libs\tslib.pyx in pandas._libs.tslib.parse_datetime_string (pandas\_libs\tslib.c:35351)() C:\Users\sphulse\Anaconda\lib\site-packages\dateutil\parser.py in parse(timestr, parserinfo, **kwargs) 1166 return parser(parserinfo).parse(timestr, **kwargs) 1167 else: -> 1168 return DEFAULTPARSER.parse(timestr, **kwargs) 1169 1170 C:\Users\sphulse\Anaconda\lib\site-packages\dateutil\parser.py in parse(self, timestr, default, ignoretz, tzinfos, **kwargs) 557 558 if res is None: --> 559 raise ValueError("Unknown string format") 560 561 if len(res) == 0: ValueError: Unknown string format
pres_data.info()
#pd.to_datetime(pres_data['Birth date'], errors='coerce')
for date in pres_data['Birth date']:
dateparser_SP(date)
0 Feb 22, 1732[a] 1 Oct 30, 1735[a] 2 Apr 13, 1743[a] 3 Mar 16, 1751[a] 4 Apr 28, 1758 5 Jul 11, 1767 6 Mar 15, 1767 7 Dec 5, 1782 8 Feb 9, 1773 9 Mar 29, 1790 10 Nov 2, 1795 11 Nov 24, 1784 12 Jan 7, 1800 13 Nov 23, 1804 14 Apr 23, 1791 15 Feb 12, 1809 16 Dec 29, 1808 17 Apr 27, 1822 18 Oct 4, 1822 19 Nov 19, 1831 20 Oct 5, 1829 21 Mar 18, 1837 22 Aug 20, 1833 23 Mar 18, 1837 24 Jan 29, 1843 25 Oct 27, 1858 26 Sep 15, 1857 27 Dec 28, 1856 28 Nov 2, 1865 29 Jul 4, 1872 30 Aug 10, 1874 31 Jan 30, 1882 32 May 8, 1884 33 Oct 14, 1890 34 29-May-17 35 27-Aug-08 36 9-Jan-13 37 14-Jul-13 38 1-Oct-24 39 6-Feb-11 40 12-Jun-24 41 19-Aug-46 42 6-Jul-46 43 4-Aug-61 44 14-Jun-46 Name: Birth date, dtype: object
pres_data.head()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 45 entries, 0 to 44 Data columns (total 6 columns): Id 45 non-null int64 President 45 non-null object Birth date 45 non-null object Presidency start date 45 non-null object Presidency end date 44 non-null object Death date 39 non-null object dtypes: int64(1), object(5) memory usage: 2.2+ KB
pres_data['Birth date updated']=pres_data.to_datetime(df['Birth date'],infer_datetime_format=True)
--------------------------------------------------------------------------- AttributeError Traceback (most recent call last) <ipython-input-16-eb78d9a17703> in <module>() ----> 1 pres_data['Birth date updated']=pres_data.to_datetime(df['Birth date'],infer_datetime_format=True) C:\Users\sphulse\Anaconda\lib\site-packages\pandas\core\generic.py in __getattr__(self, name) 2968 if name in self._info_axis: 2969 return self[name] -> 2970 return object.__getattribute__(self, name) 2971 2972 def __setattr__(self, name, value): AttributeError: 'DataFrame' object has no attribute 'to_datetime'