image_output_1.png
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

data = pd.read_csv('../input/broadband-customers-base-churn-analysis/bbs_cust_base_scfy_20200210.csv')
df = data.copy()
df

df.drop('Unnamed: 19', axis=1, inplace=True)

df.churn.replace('N', '0', inplace=True)
df.churn.replace('Y', '1', inplace=True)
df.current_mth_churn.replace('N', '0', inplace=True)
df.current_mth_churn.replace('Y', '1', inplace=True)

df.churn = df.churn.astype(int)
df.current_mth_churn = df.churn.astype(int)

df.describe().T