Error in twitter_app.py

[gmrwvu]

I received this error when attempting to run the twitter_app.py script:

C:\Users\gmrwv\PycharmProjects\my-first-app\venv\Scripts\python.exe C:\gmrPy\twitter_app.py Traceback (most recent call last): File "C:\gmrPy\twitter_app.py", line 10, in df["date_time"] = pd.to_datetime(df["date_time"]) File "C:\Users\gmrwv\PycharmProjects\my-first-app\venv\lib\site-packages\pandas\core\tools\datetimes.py", line 1050, in to_datetime values = convert_listlike(arg._values, format) File "C:\Users\gmrwv\PycharmProjects\my-first-app\venv\lib\site-packages\pandas\core\tools\datetimes.py", line 453, in _convert_listlike_datetimes return _array_strptime_with_fallback(arg, name, utc, format, exact, errors) File "C:\Users\gmrwv\PycharmProjects\my-first-app\venv\lib\site-packages\pandas\core\tools\datetimes.py", line 484, in _array_strptime_with_fallback result, timezones = array_strptime(arg, fmt, exact=exact, errors=errors, utc=utc) File "pandas_libs\tslibs\strptime.pyx", line 530, in pandas._libs.tslibs.strptime.array_strptime File "pandas_libs\tslibs\strptime.pyx", line 351, in pandas._libs.tslibs.strptime.array_strptime ValueError: time data "27/12/2016 04:04" doesn't match format "%m/%d/%Y %H:%M", at position 9. You might want to try:

• passing format if your strings have a consistent format;
• passing format='ISO8601' if your strings are all ISO8601 but not necessarily in exactly the same format;
• passing format='mixed', and the format will be inferred for each element individually. You might want to use dayfirst alongside this.

Process finished with exit code 1

[gmrwvu]

I resolved the error by changing the original twitter_app.py: from: df["date_time"] = pd.to_datetime(df["date_time"]) to df["date_time"] = pd.to_datetime(df["date_time"], format="%d/%m/%Y %H:%M")

[Kay19Dev]

This error is caused due to the tweets.csv having the date format as DD/MM/YYYY, but the default format pd.to_datetime(df["date_time"]) expects is MM/DD/YYYY.

I resolved this slightly different than how gmrwvu did by changing line 10 to: pd.to_datetime(df["date_time"], dayfirst=True)