Case When in Series

tools.case_when.coalesce(df, columns, default_value=nan)

Coalesce column by list of column

Parameters:
  • df (Pandas DataFrame) –
  • columns (list or pandas index) –
  • default_value (value which replace None or NaN in return series) –
Returns:
Return type:

Pandas Series

Examples

>>> import pandas as pd
>>> from tidyframe import coalesce
>>> df = pd.DataFrame()
>>> df['a'] = [None, pd.np.NaN, pd.np.nan, pd.np.nan]
>>> df['b'] = [None, 4, 6, pd.np.nan]
>>> df['c'] = [None, pd.np.NaN, 6, pd.np.nan]
>>> coalesce(df, ['a', 'b', 'c'], default_value=10)
0    10.0
1     4.0
2     6.0
3    10.0
Name: a, dtype: float64
tools.case_when.nvl(obj, default=nan, copy=True)

replace None or NaN value by default

Parameters:
  • obj (Series, list, or primitive variable types) –
  • default (defalut) –
  • copy (copy list or not if obj is list type) –
Returns:
Return type:

series or list or primitive variable types

Examples

>>> import pandas as pd
>>> from tidyframe.tools import nvl
>>> nvl(None, 10)
10
>>> test_list = [0, 1, None, pd.np.NaN]
>>> test_series = pd.Series(test_list)
>>> nvl(test_series, 10)
0     0.0
1     1.0
2    10.0
3    10.0
dtype: float64