formaters

gistfile1.txt

def format_dict_get(my_dict, location, key):
    def zero_none(x): 
        return x or 0
    return zero_none(my_dict.get(location).get(key))
    
    
# clean any of the dicts for None values    
for k, v in query_dict.items():
    for k2, v2 in v.items():
        if v2 is None or v2 is False:
            query_dict[k][k2] = 0
            
           
def neg_formatter(x):
    """
    Takes positive or negative number and returns it accounting style
    """
    import string
    class NegativeParenFormatter(string.Formatter):
        def format_field(self, value, format_spec):
            try:
                if value<0:
                    return "(" +  string.Formatter.format_field(self, -value, format_spec) + ")"
                else:
                    return string.Formatter.format_field(self, value, format_spec)
            except:
                return string.Formatter.format_field(self, value, format_spec)

    f = NegativeParenFormatter()
    x=0 if x == False or x == np.nan or x is None else x
    return f.format("{0:,}", round(x, 2))



def neg_formatter2(x):
    """
    Takes positive or negative number and returns it accounting style
    """
    import string
    class NegativeParenFormatter(string.Formatter):
        def format_field(self, value, format_spec):
            try:
                if value<0:
                    return "(" +  string.Formatter.format_field(self, -value, format_spec) + ")"
                else:
                    return string.Formatter.format_field(self, value, format_spec)
            except:
                return string.Formatter.format_field(self, value, format_spec)

    f = NegativeParenFormatter()
    x=0 if x == False or x == np.nan or x is None else x
    return f.format("{0:,}", int(round(x)))