Pandas read csv Custom Date Format: Difference between revisions
Jump to navigation
Jump to search
Line 13: | Line 13: | ||
=<tt>date_format</tt> Parameter= | =<tt>date_format</tt> Parameter= | ||
<syntaxhighlight lang='py'> | |||
df = pd.read_csv("./timeseries.csv", parse_dates=["date"], date_format='%m/%Y/%d') | |||
</syntaxhighlight> | |||
More details on format: {{Internal|Time,_Date,_Timestamp_in_Python#Format|<tt>datetime</tt> Format}} | |||
For more complicated formats, the parsing function can be provided as a named function or a lambda: | |||
<syntaxhighlight lang='py'> | |||
def parse_timestamp(s: str): | |||
??? | |||
df = pd.read_csv("./timeseries.csv", parse_dates=["date"], date_format='%m/%Y/%d') | |||
</syntaxhighlight> | |||
For more details on timestamp parsing see: {{Internal|Time,_Date,_Timestamp_in_Python#Time.2C_Date_and_Timestamp_Parsing|Time, Date, Timestamp in Python}} | |||
=<tt>date_parser</tt> Parameter= | =<tt>date_parser</tt> Parameter= |
Revision as of 01:32, 9 October 2023
Internal
Overview
A CSV column can be parsed as date with:
df = pd.read_csv("./timeseries.csv", parse_dates=["date"])
This assumes a "2023-10-31" format. If the string format is different there are several options:
date_format Parameter
df = pd.read_csv("./timeseries.csv", parse_dates=["date"], date_format='%m/%Y/%d')
More details on format:
For more complicated formats, the parsing function can be provided as a named function or a lambda:
def parse_timestamp(s: str):
???
df = pd.read_csv("./timeseries.csv", parse_dates=["date"], date_format='%m/%Y/%d')
For more details on timestamp parsing see: