8 examples of 'pandas fillna specific column' in Python

114
def panel_fillna(panel, type="bfill"):
115
    """
116
    fill nan along the 3rd axis
117
    :param panel: the panel to be filled
118
    :param type: bfill or ffill
119
    """
120
    frames = {}
121
    for item in panel.items:
122
        if type == "both":
123
            frames[item] = panel.loc[item].fillna(axis=1, method="bfill").\
124
                fillna(axis=1, method="ffill")
125
        else:
126
            frames[item] = panel.loc[item].fillna(axis=1, method=type)
127
    return pd.Panel(frames)

19
def fill_missing_values(df_data):
20
    """Fill missing values in data frame, in place."""    
21
    df_data.fillna(method="ffill", inplace="True")
22
    df_data.fillna(method='bfill', inplace="True")

39
def _drop_col(self, df):
40
    '''
41
    Drops last column, which was added in the parsing procedure due to a
42
    trailing white space for each sample in the text file
43
    Arguments:
44
        df: pandas dataframe
45
    Return:
46
        df: original df with last column dropped
47
    '''
48
    return df.drop(df.columns[-1], axis=1)

519
def get_and_fill_timezone(df):
520
    '''
521
    this is new to deal with healthkit data
522
    requires that a data frame that contains payload and HKTimeZone is passed
523
    '''
524
    df = get_healthkit_timezone(df)
525
526
    df["timezone"].fillna(method='ffill', inplace=True)
527
    df["timezone"].fillna(method='bfill', inplace=True)
528
529
    return df["timezone"]

21
@cat.register_transform('hdf')
22
def _(col):
23
    if 'nan' not in col.cat.categories:
24
        col = col.cat.add_categories(['nan'])
25
    return col.fillna('nan').apply(str)

78
def _clean_column(self, column):
79
    if not isinstance(column, (int, str, unicode)):
80
        raise ValueError('{} is not a valid column'.format(column))
81
    return column in self.df.columns

38
def fill_empty(df: pd.DataFrame) -> pd.DataFrame:
39
    """Fill the gaps in the 'original' column with values from 'index'
40
    Args:
41
        df:
42
    Returns:
43
    """
44
    index = df["original"].isnull()
45
    df.loc[index, "original"] = df.loc[index, "index"]
46
47
    return df

568
@staticmethod
569
def pd() -> None:
570
    post = SampleData.get('pds_obj_10k').fillna(0.0)