dreaife的休憩小栈

1
import pandas as pd
2

3
# 第三个日期格式错误
4
data = {
5
  "Date": ['2020/12/01', '2020/12/02' , '20201226'],
6
  "duration": [50, 40, 45]
7
}
8

9
df = pd.DataFrame(data, index = ["day1", "day2", "day3"])
10

11
df['Date'] = pd.to_datetime(df['Date'])
12

13
print(df.to_string())

1
ValueError: time data "20201226" doesn't match format "%Y/%m/%d", at position 2. You might want to try:
2
    - passing `format` if your strings have a consistent format;
3
    - passing `format='ISO8601'` if your strings are all ISO8601 but not necessarily in exactly the same format;
4
    - passing `format='mixed'`, and the format will be inferred for each element individually. You might want to use `dayfirst` alongside this.

1
import pandas as pd
2

3
# 第三个日期格式错误
4
data = {
5
  "Date": ['2020/12/01', '2020/12/02' , '20201226'],
6
  "duration": [50, 40, 45]
7
}
8
df = pd.DataFrame(data, index = ["day1", "day2", "day3"])
9

10
df['Date'] = pd.to_datetime(df['Date'], format='mixed')
11
# df['Date'] = pd.to_datetime(df['Date'],format="%Y/%m/%d",errors='ignore')
12

13
print(df.to_string())