pandas defaults to dayfirst=False so a date like your date is expected to mean the second day of the first month unless you specific otherwise. Your dates are ambiguous, from what you've included in your question is not possible to infer whether it's in a day first format (dd-mm) or a month first format (mm-dd). (Using pandas.read_csv() you can make use of the dayfirst and yearfirst kwargs, or explicitly declare your date formats and use pandas.to_datetime(some_df, format=). Either pair of digits would make sense as a year, month or day. In example #4, it's impossible to infer the date format. If for instances we had the following sequence of dates: '', '', '', it would be reasonable to infer that '' refers to the first day of the second month, otherwise we would not be able to parse the previous two dates. We can use a similar approach for example #2.įor example #3 is that the first day of the second month, or is that the second day of the first month? It's impossible to tell without more information. In example #1, The first four digit have to be the year (there's no 2020th month or 2020th day of a month), the following two digits have to be the day of the month (there's no 27th month and we already have year information) and the last two digits are the month (we already have year and day of month information). In examples #1 & #2 we can easily infer that date format. Some dates are ambiguous, while others aren't. I'd greatly appreciate some help to get these dates corrected, as I need to do some date calculations on them, and also join two tables based on this date - which is going to be my next problem. Which you can see, it is reading the months as the days - in other words, it is showing individual days of the month, instead of the 1st day of each month. If I then try this: temp = pd.to_datetime(collections_data, format='%m/%d/%Y') I have tried the parse_dates parameter on the import, but it doesn't help. Print('Error importing Collections Data!')

Print('Collections Data imported successfully.') I've tried several conversion functions from stackoverflow as well as other websites, but they either just don't work, or do nothing.Ĭollections_data = pd.read_csv('./monthly_collections.csv') In the Month column, I have the 1st of each month - so it should read (yyyy-mm-dd): I have a CSV that I am importing, but its reading the date column incorrectly. I am very new to Python, and finding it very frustrating.

Word stacks daily march 27 2021