from sklearn.preprocessing import StandardScaler

def transform_data(data):
    scaler = StandardScaler()
    set_1 = ['UniqueCarrier', 'FlightNum','Origin', 'Dest', 'Diverted']
    for typi in set_1:
        data[data[typi].isnull()] = 'nan'
    for typi in set(data.columns) - set(set_1):
        data[data[typi].isnull()] = 0

    pd.DataFrame(data=scaler.fit_transform(data[typi]))
    pd.get_dummies(data)
    return data