模拟缺失数据2:MAR

本文介绍如何使用Python模拟缺失数据,重点探讨了缺失并非随机(MAR)的情况。通过示例代码展示了具体实现过程,并提供了源码链接。

# -*- coding: utf-8 -*-
"""
Created on Mon Sep 14 13:22:44 2020
@author: Dogukan
"""

import numpy as np
import random
from itertools import compress

def create_mar_single(df, missing_column, p_missing, depends_on, threshold, condition):
    
    if condition == 'less':
        np.random.seed(4)
        t =  (df[depends_on] <= threshold) 
        right_indices = list(compress(range(len(t)), t))
        indices = random.choices(right_indices, k = round(p_missing*df.shape[0]))
        while len(set(indices)) < round(p_missing * df.shape[0]):
            indices.append(random.choice(right_indices))
        mar_column = [1 if i in indices else 0 for i in range(df.shape[0])]
        
    elif condition == 'greater':
        np.random.seed(5)
        indices = []
        t =  (df[depends_on] > threshold) 
        right_indices = list(compress(range(len(t)), t))
        indices = random.choices(right_indices, k = round(p_missing*df.shape[0]))
        while len(set(indices)) < round(p_missing * df.shape[0]):
            indices.append(random.choice(right_indices))
        mar_column = [1 if i in indices else 0 for i in range(df.shape[0])]
    
    else:
        raise Exception('Condition must be less or greater. Given condition was: {}'.format(condition))
    
    df_new = df.copy()
    for i in range(len(mar_column)):
        if mar_column[i] == 1:
            df_new[missing_column][i] = '?'
        
    df_new = df_new.replace('?', np.nan)
    return df_new

def create_mar_mult(df, missing_column, p_missing, depends_on, threshold, condition):
    df_new = df.copy()
    for i in range(len(missing_column)):
        tmp = create_mar_single(df, missing_column[i], p_missing, depends_on, threshold, condition)
        df_new[missing_column[i]] = tmp[missing_column[i]] 
    return df_new

def create_mar(df, missing_column, p_missing, depends_on, threshold, condition):
    if(type(missing_column) == str):
        df_new = create_mar_single(df, missing_column, p_missing, depends_on, threshold, condition)
    elif(type(missing_column) == list):
        df_new = create_mar_mult(df, missing_column, p_missing, depends_on, threshold, condition)
    else:
        raise Exception('Name of the columns should be given as either str or list. Given format was {}'.format(
            type(missing_column)))
    return df_new 

def test_mar_single(df, missing_column, p_missing, depends_on,threshold,condition):
    if condition == 'less':
        t = df[missing_column].isna()
        q = list(compress(range(len(t)), t)) #Which indices have NAs
        w = df[depends_on][q] > threshold #Which indices have a value greater than threshold value
        l = list(compress(range(len(w)), w)) #Indices of values greater than 5. Must be an empty set.
    
    elif condition == 'greater':
        t = df[missing_column].isna()
        q = list(compress(range(len(t)), t)) #Which indices have NAs
        w = df[depends_on][q] <= threshold #Which indices have a value less than or equal to threshold
        l = list(compress(range(len(w)), w)) #Indices of values greater than 5. Must be an empty set.
    
    else:
        raise Exception('Condition must be less or greater. Given condition was: {}'.format(condition))
    
    if len(l) == 0 and (df[missing_column].isna().sum() == round(p_missing * df.shape[0])):
        print("Missingness created for", missing_column ,"succesfully!")
    else:
        print("Something is wrong.")
        
def test_mar_mult(df, missing_column, p_missing, depends_on,threshold,condition):
    for i in range(len(missing_column)):
        test_mar_single(df, missing_column[i], p_missing, depends_on,threshold,condition)
        
def test_mar(df, missing_column, p_missing, depends_on,threshold,condition):
    if (type(missing_column) == str):
        result = test_mar_single(df, missing_column, p_missing, depends_on,threshold,condition)
    elif (type(missing_column) == list):
        result = test_mar_mult(df, missing_column, p_missing, depends_on,threshold,condition)
    return(result)

 源码地址

https://github.com/dogukangoksu/create_missingness/blob/master/mar.py

评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

牛魔小丸子

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值