pandas. read_csv — pandas 2. 3. 3 documentation If a column or index cannot be represented as an array of datetime, say because of an unparsable value or a mixture of timezones, the column or index will be returned unaltered as an object data type
pandas. read_csv — pandas 0. 21. 1 documentation Read CSV (comma-separated) file into DataFrame Also supports optionally iterating or breaking of the file into chunks Additional help can be found in the online docs for IO Tools
pandas. read_csv — pandas 1. 5. 2 documentation For non-standard datetime parsing, use pd to_datetime after pd read_csv To parse an index or column with a mixture of timezones, specify date_parser to be a partially-applied pandas to_datetime() with utc=True
pandas. read_excel — pandas 2. 3. 3 documentation If a column or index contains an unparsable date, the entire column or index will be returned unaltered as an object data type If you don`t want to parse some cells as date just change their type in Excel to “Text”
pandas. read_csv — pandas 1. 3. 5 documentation For non-standard datetime parsing, use pd to_datetime after pd read_csv To parse an index or column with a mixture of timezones, specify date_parser to be a partially-applied pandas to_datetime() with utc=True