python pandas col 항목을 dummies 항목으로 바꾸기

import os

import pandas as pd

from scipy.stats import zscore

 

df = pd.read_csv("datafilename.csv")

df.pop('ids')

columns = ['want' , 'to', 'delete', 'colum', 'name']

df = df.drop(columns,axis=1) 

df['ratio'] = df['max'] / df['number']

dummies = pd.get_dummies(df['cat2'], prefix="cat2")

df = df.drop('cat2', axis=1)

df = df.join(dummies)

print(f"After join dummies")

print(df)

df.to_csv("./result.csv")