time data Month doesn't match format specified
I know this question has already been asked/answered, but I have tried all of the solutions and nothing seems to get rid of the error.
Example of data from my dataframe, column 'Month' :-
Month
2015-09
code I used to convert column 'Month' data into datetime format :-
df.Month = pd.to_datetime(df.Month, format='%Y-%m')
Error :-
ValueError: time data Month doesn't match format specified
If I flip the format to (format='%m-%Y') wrong format I know
I get the error message:
time data '2015-09' does not match format '%m-%Y' (match)
But my original format matched up exactly..
python datetime
edited Nov 14 '18 at 3:39
Osuman AAA
415212
asked Nov 14 '18 at 1:45
J.HarperJ.Harper
11
add a comment |
I know this question has already been asked/answered, but I have tried all of the solutions and nothing seems to get rid of the error.
Example of data from my dataframe, column 'Month' :-
Month
2015-09
code I used to convert column 'Month' data into datetime format :-
df.Month = pd.to_datetime(df.Month, format='%Y-%m')
Error :-
ValueError: time data Month doesn't match format specified
If I flip the format to (format='%m-%Y') wrong format I know
I get the error message:
time data '2015-09' does not match format '%m-%Y' (match)
But my original format matched up exactly..
python datetime
edited Nov 14 '18 at 3:39
Osuman AAA
415212
asked Nov 14 '18 at 1:45
J.HarperJ.Harper
11
I cannot reproduce your error. Can you please provide more information about your code or data?
– Chris
Nov 14 '18 at 2:14
I downloaded a csv file from, data.police.uk/data. Forces - Police service of northern ireland. The columns were as follows; Crime ID, Month, Reported by, Falls within, Longitute, Latitude, Location, LSOA code, LSOA name, Crime type, Last outcome category, Context. The data within the Month column for one of the rows was of the format (2015-09). When i tried to to change the data in that column to datetime format '%Y-%m' I got a - time data does not match format error. Apologies for not being very clear, first time asking a question on stackoverflow.
– J.Harper
Nov 14 '18 at 3:52
add a comment |
I know this question has already been asked/answered, but I have tried all of the solutions and nothing seems to get rid of the error.
Example of data from my dataframe, column 'Month' :-
Month
2015-09
code I used to convert column 'Month' data into datetime format :-
df.Month = pd.to_datetime(df.Month, format='%Y-%m')
Error :-
ValueError: time data Month doesn't match format specified
If I flip the format to (format='%m-%Y') wrong format I know
I get the error message:
time data '2015-09' does not match format '%m-%Y' (match)
But my original format matched up exactly..
python datetime
edited Nov 14 '18 at 3:39
Osuman AAA
415212
asked Nov 14 '18 at 1:45
J.HarperJ.Harper
11
I know this question has already been asked/answered, but I have tried all of the solutions and nothing seems to get rid of the error.
Example of data from my dataframe, column 'Month' :-
Month
2015-09
code I used to convert column 'Month' data into datetime format :-
df.Month = pd.to_datetime(df.Month, format='%Y-%m')
Error :-
ValueError: time data Month doesn't match format specified
If I flip the format to (format='%m-%Y') wrong format I know
I get the error message:
time data '2015-09' does not match format '%m-%Y' (match)
But my original format matched up exactly..
python datetime
python datetime
edited Nov 14 '18 at 3:39
Osuman AAA
415212
asked Nov 14 '18 at 1:45
J.HarperJ.Harper
11
edited Nov 14 '18 at 3:39
Osuman AAA
415212
asked Nov 14 '18 at 1:45
J.HarperJ.Harper
11
edited Nov 14 '18 at 3:39
Osuman AAA
415212
edited Nov 14 '18 at 3:39
Osuman AAA
415212
edited Nov 14 '18 at 3:39
Osuman AAA
415212
415212
asked Nov 14 '18 at 1:45
J.HarperJ.Harper
11
asked Nov 14 '18 at 1:45
J.HarperJ.Harper
11
asked Nov 14 '18 at 1:45
J.HarperJ.Harper
11
11
I cannot reproduce your error. Can you please provide more information about your code or data?
– Chris
Nov 14 '18 at 2:14
I downloaded a csv file from, data.police.uk/data. Forces - Police service of northern ireland. The columns were as follows; Crime ID, Month, Reported by, Falls within, Longitute, Latitude, Location, LSOA code, LSOA name, Crime type, Last outcome category, Context. The data within the Month column for one of the rows was of the format (2015-09). When i tried to to change the data in that column to datetime format '%Y-%m' I got a - time data does not match format error. Apologies for not being very clear, first time asking a question on stackoverflow.
– J.Harper
Nov 14 '18 at 3:52
add a comment |
I cannot reproduce your error. Can you please provide more information about your code or data?
– Chris
Nov 14 '18 at 2:14
I downloaded a csv file from, data.police.uk/data. Forces - Police service of northern ireland. The columns were as follows; Crime ID, Month, Reported by, Falls within, Longitute, Latitude, Location, LSOA code, LSOA name, Crime type, Last outcome category, Context. The data within the Month column for one of the rows was of the format (2015-09). When i tried to to change the data in that column to datetime format '%Y-%m' I got a - time data does not match format error. Apologies for not being very clear, first time asking a question on stackoverflow.
– J.Harper
Nov 14 '18 at 3:52
I cannot reproduce your error. Can you please provide more information about your code or data?
– Chris
Nov 14 '18 at 2:14
I cannot reproduce your error. Can you please provide more information about your code or data?
– Chris
Nov 14 '18 at 2:14
I downloaded a csv file from, data.police.uk/data. Forces - Police service of northern ireland. The columns were as follows; Crime ID, Month, Reported by, Falls within, Longitute, Latitude, Location, LSOA code, LSOA name, Crime type, Last outcome category, Context. The data within the Month column for one of the rows was of the format (2015-09). When i tried to to change the data in that column to datetime format '%Y-%m' I got a - time data does not match format error. Apologies for not being very clear, first time asking a question on stackoverflow.
– J.Harper
Nov 14 '18 at 3:52
I downloaded a csv file from, data.police.uk/data. Forces - Police service of northern ireland. The columns were as follows; Crime ID, Month, Reported by, Falls within, Longitute, Latitude, Location, LSOA code, LSOA name, Crime type, Last outcome category, Context. The data within the Month column for one of the rows was of the format (2015-09). When i tried to to change the data in that column to datetime format '%Y-%m' I got a - time data does not match format error. Apologies for not being very clear, first time asking a question on stackoverflow.
– J.Harper
Nov 14 '18 at 3:52
add a comment |
1 Answer
1
active
oldest
votes
The first error message says:ValueError: time data Month doesn't match format specified
This error was raised because the df.Month contains a string: Month, which in fact doesn't match format specified. The data source you commented provided number of csv files, so I assume this might be a concatenating issue, where the headers from next file were not properly handled.
You may want to check your column using df.Month.value_counts() to see if it is has anything other than to_datetime parse-able strings.
answered Nov 14 '18 at 4:16
ChrisChris
1,079211
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53292015%2ftime-data-month-doesnt-match-format-specified%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The first error message says:ValueError: time data Month doesn't match format specified
This error was raised because the df.Month contains a string: Month, which in fact doesn't match format specified. The data source you commented provided number of csv files, so I assume this might be a concatenating issue, where the headers from next file were not properly handled.
You may want to check your column using df.Month.value_counts() to see if it is has anything other than to_datetime parse-able strings.
answered Nov 14 '18 at 4:16
ChrisChris
1,079211
add a comment |
The first error message says:ValueError: time data Month doesn't match format specified
This error was raised because the df.Month contains a string: Month, which in fact doesn't match format specified. The data source you commented provided number of csv files, so I assume this might be a concatenating issue, where the headers from next file were not properly handled.
You may want to check your column using df.Month.value_counts() to see if it is has anything other than to_datetime parse-able strings.
answered Nov 14 '18 at 4:16
ChrisChris
1,079211
add a comment |
The first error message says:ValueError: time data Month doesn't match format specified
This error was raised because the df.Month contains a string: Month, which in fact doesn't match format specified. The data source you commented provided number of csv files, so I assume this might be a concatenating issue, where the headers from next file were not properly handled.
You may want to check your column using df.Month.value_counts() to see if it is has anything other than to_datetime parse-able strings.
answered Nov 14 '18 at 4:16
ChrisChris
1,079211
The first error message says:ValueError: time data Month doesn't match format specified
This error was raised because the df.Month contains a string: Month, which in fact doesn't match format specified. The data source you commented provided number of csv files, so I assume this might be a concatenating issue, where the headers from next file were not properly handled.
You may want to check your column using df.Month.value_counts() to see if it is has anything other than to_datetime parse-able strings.
answered Nov 14 '18 at 4:16
ChrisChris
1,079211
answered Nov 14 '18 at 4:16
ChrisChris
1,079211
answered Nov 14 '18 at 4:16
ChrisChris
1,079211
answered Nov 14 '18 at 4:16
ChrisChris
1,079211
1,079211
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53292015%2ftime-data-month-doesnt-match-format-specified%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I cannot reproduce your error. Can you please provide more information about your code or data?
– Chris
Nov 14 '18 at 2:14
I downloaded a csv file from, data.police.uk/data. Forces - Police service of northern ireland. The columns were as follows; Crime ID, Month, Reported by, Falls within, Longitute, Latitude, Location, LSOA code, LSOA name, Crime type, Last outcome category, Context. The data within the Month column for one of the rows was of the format (2015-09). When i tried to to change the data in that column to datetime format '%Y-%m' I got a - time data does not match format error. Apologies for not being very clear, first time asking a question on stackoverflow.
– J.Harper
Nov 14 '18 at 3:52