Ad
Python Error_time Data Does Not Match Format
I am working with a CSV file which contain daily weather data for different month, i am trying to monthly aggregating the daily data using below script,
df.Timestamp = pd.to_datetime(df.Datetime,format='%d-%m-%y %H:%M')
data.index = data.Timestamp
df = df.resample('W').mean()
I am getting the following error,
time data '01-01-2000 00:00' does not match format '%d-%m-%y %H:%M' (match)
How to resolve it.
Ad
Answer
Use %Y
for match YYYY
, if use %y
it match YY
format of year:
df.Timestamp = pd.to_datetime(df.Datetime,format='%d-%m-%Y %H:%M')
Then create DatetimeIndex
:
df = df.set_index('Timestamp').resample('W').mean()
Ad
source: stackoverflow.com
Related Questions
- → What are the pluses/minuses of different ways to configure GPIOs on the Beaglebone Black?
- → Django, code inside <script> tag doesn't work in a template
- → React - Django webpack config with dynamic 'output'
- → GAE Python app - Does URL matter for SEO?
- → Put a Rendered Django Template in Json along with some other items
- → session disappears when request is sent from fetch
- → Python Shopify API output formatted datetime string in django template
- → Can't turn off Javascript using Selenium
- → WebDriver click() vs JavaScript click()
- → Shopify app: adding a new shipping address via webhook
- → Shopify + Python library: how to create new shipping address
- → shopify python api: how do add new assets to published theme?
- → Access 'HTTP_X_SHOPIFY_SHOP_API_CALL_LIMIT' with Python Shopify Module
Ad