[pandas] 날짜 데이터 인식시키기

file_path

pd.read_csv

df.rename

pd.to_datetime()

pd.to_numeric()

import pandas as pd

# Define the path to your CSV file
file_path = '/Users/bpark/Downloads/aka_month_rev_comparison.csv'

# Load the CSV file into a DataFrame
df = pd.read_csv(file_path)

#Date column
df.rename(columns={df.columns[0]: 'Date'}, inplace=True)
df['Date'] = pd.to_datetime(df['Date'], format='%y-%b', errors='coerce')

for col in df.columns:
    if col!='Date':
        df[col]=pd.to_numeric(df[col], errors='coerce')