인프런 커뮤니티 질문&답변

아래는 수업 자료에 있는 풀이부분 코드이고,

from google.colab import drive
drive.mount('/content/drive')

import pandas as pd
import numpy as np

df = pd.read_csv('/content/drive/MyDrive/bigdata(빅분기 놀이터)/빅분기 놀이터 Dataset/members.csv')

df['subscribed'] = pd.to_datetime(df['subscribed'])
df['year'] = df['subscribed'].dt.year
df['month'] = df['subscribed'].dt.month
df['day'] = df['subscribed'].dt.day

df = df.groupby('month').count()
print(df.sort_values('subscribed').index[0])

ValueError Traceback (most recent call last)

<ipython-input-1-2092ad4ed95e> in <cell line: 10>()
      8 df = pd.read_csv('/content/drive/MyDrive/bigdata(빅분기 놀이터)/빅분기 놀이터 Dataset/members.csv')
      9 
---> 10 df['subscribed'] = pd.to_datetime(df['subscribed'])
     11 df['year'] = df['subscribed'].dt.year
     12 df['month'] = df['subscribed'].dt.month

4 frames

/usr/local/lib/python3.10/dist-packages/pandas/_libs/tslibs/strptime.pyx in pandas._libs.tslibs.strptime.array_strptime()

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

이는 에러 코드입니다.

df['subscribed'] = pd.to_datetime(df['subscribed'])

이 코드에서 발생한 에러입니다.