image_output_1.png
import pandas as pd

import seaborn as sns

df = pd.read_csv('../input/water-potability/water_potability.csv')

df.shape

df.nunique()

df.describe().T.style

df.Potability.value_counts()

df.isnull().sum()

null_columns = pd.DataFrame(df[df.columns[df.isnull().any()]].isnull().sum() * 100 / df.shape[0], columns=['Percentage of NaN values'])
null_columns['Total NaN Values'] = df[df.columns[df.isnull().any()]].isnull().sum()
null_columns

null_cols = null_columns.index.tolist()
null_cols

for i in null_cols:
    sns.distplot(df[i])