text_plain_output_1.png
import pandas as pd

aug_data = pd.read_csv('../input/hr-analytics-job-change-of-data-scientists/aug_train.csv', index_col='enrollee_id')
aug_data = aug_data.sort_index()
aug_data

aug_data.isnull().sum()

def fill_null_data(df):
    df.gender = df.gender.fillna('Other')
    df.enrolled_university = df.enrolled_university.fillna('Unknown')
    df.education_level = df.education_level.fillna('Unknown')
    df.major_discipline = df.major_discipline.fillna('Unknown')
    df.experience = df.experience.fillna('Unknown')
    df.company_size = df.company_size.fillna('Unknown')
    df.company_type = df.company_type.fillna('Unknown')
    df.last_new_job = df.last_new_job.fillna('Unknown')
fill_null_data(aug_data)

X_test = pd.read_csv('../input/hr-analytics-job-change-of-data-scientists/aug_test.csv', index_col='enrollee_id')
fill_null_data(X_test)
X_test